Computer

For Online Computer Support, Ask a Computer Technician

Ask a Computer Expert,
Get an Answer ASAP!

Need help with creating an Access 2016 Form that will

Customer Question
display entry fields representing weeks...
Need help with creating an Access 2016 Form that will display entry fields representing weeks that are specif to a project's timeline. I can send a more detailed explanation of what I'm looking for.
Submitted: 8 months ago.Category: Computer
Show More
Show Less
Ask Your Own Computer Question
Answered in 5 minutes by:
10/13/2017
Tech Support Specialist: Kris R, Computer Hardware Engineer replied 8 months ago
Kris R
Kris R, Computer Hardware Engineer
Category: Computer
Satisfied Customers: 4,548
Experience: IT Manager at Wood Group PSN
Verified

Hi
Sorry for the delay, we are busy and I've just got to your question.
How long has this been happening?
Thanks
Kris

Ask Your Own Computer Question
Customer reply replied 8 months ago
This is an Access database I'm developing to track project resources hours (weekly) for any given project(s) they are assigned to.
Customer reply replied 8 months ago
Are you an Access 2016 expert?
Tech Support Specialist: Kris R, Computer Hardware Engineer replied 8 months ago

Opting out for access expert..

Ask Your Own Computer Question
Tech Support Specialist: Richard, Computer Specialist replied 8 months ago
Richard
Richard, Computer Specialist
Category: Computer
Satisfied Customers: 46,460
Experience: Over 20 years of consulting to the IT industry
Verified

Hi there and welcome

Can you provide me a more detailed explanation of what you require please?

Thank you

Ask Your Own Computer Question
Customer reply replied 8 months ago
I started this Access Database to Track our Project Resource's "committed" hours/week to any given project.
The way it works is the Project X will have a Project_Start_Date and a Project_End_Date. We will call that the "Project Timeline".
The Project Resources assigned to the project will have a number of weekly hours that they will dedicate to the project. I need to have a form where for each Project, we can enter the number of hours for each of the resources assigned to any project, to list only for those weeks within the "Project Timeline".
For example, Big Joey (Project Resource) was assigned to Project XYZ. Project XYZ has a timeline of October 1st, 2017 to December 31st 2017. I need the Entry form to allow me to Enter specific number of hours for each of the weeks within that Project Timeline that Big Joey is committing to working on Project XYZ. IN this example that would be "Week #40 through Week #52" based on the October 1st through December 31st time frame.
To make the form simple (and not look too busy), I would want to have a drop down for each month within that project's timeline (October 2017, November 2017 and December 2017), and as each month is selected, the corresponding weeks for each of those months would show on the form for the weekly hrs (need 4 fields for each of the weeks in each month) to be entered for that particular Resource. These hours entered, would appear on two different reports:
1)ResourcesAssignedByProject Report- Shows all resources for the project and the weeks/hrs they are committing to the project (with a total hrs for the project duration).
2) ResourcesWeekylHoursCommitted Report- Listing all resources and the number of total weekly hours they have committed to projects within any given time frame (Date Entry parameters Start_Date and End Date).Let me know if you would be able to do this and how long. I have already created the main tables and defined the weeks based on dates. I can send you the database for you to look at and let me know if you would be able to take this on and estimated time and cost.
20:49October 12, 2017
Tech Support Specialist: Richard, Computer Specialist replied 8 months ago

Thank you for the explanation.

It is a little complex to what I am use to so I will opt out but with the description now the correct expert can take it up

Ask Your Own Computer Question
Tech Support Specialist: George Sibiya, Computer Hardware Engineer replied 8 months ago
George Sibiya
George Sibiya, Computer Hardware Engineer
Category: Computer
Satisfied Customers: 358
Experience: PhD in Computer Science
Verified

Hi,

Welcome to JustAnswer and thank you for utilizing our services.

I can start working on it over the weekend would that be fine?

Regards,

G

Ask Your Own Computer Question
Customer reply replied 8 months ago
How does this work in terms of how much it will cost? How do I send you the database?
Tech Support Specialist: George Sibiya, Computer Hardware Engineer replied 8 months ago

Hi, you may advice if the offer is acceptable so I can start working on it. My time gets limited during week days

Ask Your Own Computer Question
Customer reply replied 8 months ago
George,I changed the database and the way to capture the data. All that is good. I need now need the report as follows:
Here’s a quick summary:
Tables:
1. Employees=IT Project Resources
2. Work Codes= Project and non-project (support/operational) IT work assignments,
a. Flags/Yes/No: Billable=Project Hours, IT Strategy Project
3. Work Hours= Project and non-Project hours committed (present and future/forecasted) by Resource by day/weekCross tab query:
1. Total_ResourceHoursWeekly- This is the query I would like to have the report built from. The columns are labeled for each week (Week# ***** that yr) and how many hours.
I need to be able to allow to run for a time period (from/to date), by month and by quarter for any given year. I would like run from a simple user interface and be able to run with open for all work codes and project resources, or filter by work code and/or by project resource, and include flags (Project Hours/Billable and IT Strategy).Let me know if you can still do this...and your estimated time/cost to complete.
Tech Support Specialist: George Sibiya, Computer Hardware Engineer replied 8 months ago

I can complete it by Sunday

Ask Your Own Computer Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tech support specialistLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Andy Your Own Question
Andy
Andy
Andy, Computer Consultant
Category: Computer
Satisfied Customers: 5,316
5,316 Satisfied Customers
Experience: 11yr exp, Comp Engg, Internet expert, Web developer, SEO

Andy is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you!

RPAustin, TX

Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill

Bill M.Schenectady, New York

The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you!

FrankCanada

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

< Previous | Next >

Meet the Experts:

Andy

Andy

Computer Consultant

5,316 satisfied customers

11yr exp, Comp Engg, Internet expert, Web developer, SEO

Engineer John C.

Engineer John C.

Computer Science Engineer

3,229 satisfied customers

Computer Science Engineer with 10 years of experience in Computer Support, and Microsoft, A+ and Cisco certified

Ryan H.

Ryan H.

Computer Support Specialist

1,741 satisfied customers

A+ Certified Technician - 10 Years experience working with all types of computer systems.

Jane Lefler

Jane Lefler

Sr Prog Analyst / Technician

2 satisfied customers

Computer Programmer / Technician/ Consultant 16+ years

Frederick S.

Frederick S.

Computer Specialist

7,241 satisfied customers

Computer technician and founder of a home PC repair company.

lifesaver

lifesaver

Computer Software Engineer

4,288 satisfied customers

Engineering degree in Computer science,Microsoft Certified Professional.JA computer expert.

Sudipto

Sudipto

Hardware Engineer

4,252 satisfied customers

Certificate Course In Computer Maintenance

< Previous | Next >

Related Computer Questions
Computer is fine my HP 7610 will not scan to Email. AOL. PC
Computer is fine my HP 7610 will not scan to Email … read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
Just signed up for quicken, downloaded to Windows but can't
Just signed up for quicken, downloaded to Windows but can't open? … read more
Cody
Cody
Computer Science
2,371 satisfied customers
Need to write a macros code on excel. Need to have my excel
need to have my excel to always place columns in chronological order and alphabetical order last time? it is new on my mac. … read more
George Sibiya
George Sibiya
Computer Hardware Engineer
358 satisfied customers
I forgot my password. Logging on. Toshiba C75D-B7260
I had put this pc away, trying to log on used old passwords I thought be it none works. Only hint is teams … read more
Ricky Expert
Ricky Expert
Bachelor\u0027s Degree
1,087 satisfied customers
Help me close my Zoosk account …. My acct is [email protected]
Please help me close my Zoosk account …. My acct is [email protected] yahoo,com ,,,, Thank You .. L.K. Williams …. … read more
Ameen Khan
Ameen Khan
Senior IT Support Specialist
Information Technology Management / Computer Science
31 satisfied customers
Trying to sign into Hulu - but it won't recognize my account
Trying to sign into Hulu - but it won't recognize my account & keeps trying to sign me up … read more
Harry
Harry
1,961 satisfied customers
Mcbroom and im having difficulty reinstalling my printer.
hi pearl my name is ***** ***** and im having difficulty reinstalling my printer … read more
Cody
Cody
Computer Science
2,371 satisfied customers
Can I get someone to call me now at 757.348.0783. Right now
Right now I'm on a iPad but I need assistance with my email accounts. … read more
Bhavik Joshi
Bhavik Joshi
Computer Science and Engineering
894 satisfied customers
I have about $500.00 worth of Itune gift cards on my new
hi there I have about $500.00 worth of Itune gift cards on my new laptop am I able to use them? … read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
With a recent upload to update programs, my sound icon
with a recent upload to update programs, my sound icon disappeared. Now things are too load. … read more
Ricky Expert
Ricky Expert
Bachelor\u0027s Degree
1,087 satisfied customers
I managed to so how delete the Yahoo Mail little diet, so
I managed to so how delete the Yahoo Mail little diet, so now cannot get into my emails. I am 75 & not very computer savy. The mobile on the account is my daughters mobile.we have gone through the pro… read more
John Castle
John Castle
BSC in Computing Network Management and Design
78 satisfied customers
How do I update my account settings, ASUS computer, A10
2 days. I had it with the tech. over the weekend & got it back Mon. I have not tried anything. … read more
Mirza Vaseem
Mirza Vaseem
Bachelor\u0027s Degree
10 satisfied customers
What's max hard drive i can put in thinkpad r50e? X/p
what's max hard drive i can put in thinkpad r50e ? … read more
Satchi
Satchi
Bachelor\u0027s Degree
2,102 satisfied customers
I just want to set up a password for my computer. I am far
I just want to set up a password ***** my computer. … read more
Richard
Richard
Computer Specialist
46,460 satisfied customers
MODERATOR ON MY CHURCH'S GOOGLEGROUPS ACCOUNT AND AM BEING
i AM A MODERATOR ON MY CHURCH'S GOOGLEGROUPS ACCOUNT AND AM BEING DENIED ACCESS. WHAT'S GOING ON? … read more
Richard
Richard
Computer Specialist
46,460 satisfied customers
Need anti virus protection. Samsung 17 inch laptop. What is
need anti virus protection JA: What's the brand and model of your computer? And the Operating System (OS)? Customer: Samsung 17 inch laptop JA: What Operating System (OS) are you running on your 17? C… read more
Satchi
Satchi
Bachelor\u0027s Degree
2,102 satisfied customers
I have forgotten my old face book password. My face book
I have forgotten my old face book password. My face book account is locked.What do I do.? … read more
Richard
Richard
Computer Specialist
46,460 satisfied customers
I need to get rid of the virus that is causing printer
I need to get rid of the virus that is causing printer problems with my computer and printer. How can I get rid of the virus?… read more
Satchi
Satchi
Bachelor\u0027s Degree
2,102 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x