Computer

For Online Computer Support, Ask a Computer Technician

Ask a Computer Expert,
Get an Answer ASAP!

Computer

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: 1 month 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 1 month ago
Kris R
Kris R, Computer Hardware Engineer
Category: Computer
Satisfied Customers: 3,156
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 1 month 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 1 month ago
Are you an Access 2016 expert?
Tech Support Specialist: Kris R, Computer Hardware Engineer replied 1 month ago

Opting out for access expert..

Ask Your Own Computer Question
Tech Support Specialist: Richard, Computer Specialist replied 1 month ago
Richard
Richard, Computer Specialist
Category: Computer
Satisfied Customers: 39,583
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 1 month 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 1 month 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 1 month ago
George Sibiya
George Sibiya, Computer Hardware Engineer
Category: Computer
Satisfied Customers: 228
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 1 month 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 1 month 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 1 month 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 1 month ago

I can complete it by Sunday

Ask Your Own Computer Question
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,227 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,115 satisfied customers

Certificate Course In Computer Maintenance

< Previous | Next >

Related Computer Questions
Absolutely nothing!! I've been told that I need a new AOL
Absolutely nothing!! I've been told that I need a new AOL site because my XP computer won't work any more! … read more
Cris
Cris
Desktop Support
Associate Degree
58 satisfied customers
I have a Fujitsu laptop and got an error message of
I have a Fujitsu laptop and got an error message of 00410001 … read more
Ricky Kresslein
Ricky Kresslein
Bachelor\u0027s Degree
456 satisfied customers
I am trying to connect with my web site, I have username and
I am trying to connect with my web site, I have username and password ***** i use to use to signin on wordpress but it says no account, It has been approx 3 years since ive signed in website www.willi… read more
Kris R
Kris R
Computer Hardware Engineer
3,156 satisfied customers
For quite some time my win10 pc has had this problem and I
Hi Pearl, for quite some time my win10 pc has had this problem and I can't work out how to fix it. … read more
Damian Costa
Damian Costa
Owner
Computer Network System Engineer
40 satisfied customers
My email has been out for over a year have forgotten all
my email has been out for over a year have forgotten all pass words … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
468 satisfied customers
Astonishing! A REAL PERSON!! My Live Mail email account
Astonishing! A REAL PERSON!! My Live Mail email account won't let me send a message or reply to one. I've had a number of computer issues recently, and this just started 2 days ago. I have NO IDEA wha… read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
952 satisfied customers
I downloaded a programme slimware Driver update because it
I downloaded a programme slimware Driver update because it told me that I had a number of drivers out of date. Then with it is HP Hokey Suppor. The programme also mentioned Microsoft. It takes for eve… read more
Josh
Josh
It Support Specialist
Associate Degree
5,127 satisfied customers
Just bought Word 2016 for Mac: big trouble with footnotes in
Just bought Word 2016 for Mac: big trouble with footnotes in an important paper. I cannot set the font: Reference-Times 10 superscript, Text- Times 11. Tried everything, just removed both these in Sty… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,109 satisfied customers
Recently got new computer with Win 10. I can print to Pixma
Recently got new computer with Win 10. I can print to Pixma MP240 but cannot scan like on old Vista machine. Anything I can do? … read more
Kris R
Kris R
Computer Hardware Engineer
3,156 satisfied customers
I forgot my password and am entering my email address and it
I forgot my password ***** am entering my email address and it is not being recognized … read more
Aparna Indresh
Aparna Indresh
Engineer
Electronics & communication engineering
20 satisfied customers
Images on display screen flickering intermittently. HP ENVY,
images on display screen flickering intermittently. … read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,109 satisfied customers
I want to watch university of missouri and emporia state
i want to watch university of missouri and emporia state university mens basketball game on 11-20-17 i have already paid … read more
Josh
Josh
It Support Specialist
Associate Degree
5,127 satisfied customers
Cant reset my password i forgot it. Have new phone number
2yrs ago but forgot password ***** downloaded to new computer … read more
Josh
Josh
It Support Specialist
Associate Degree
5,127 satisfied customers
Forgot p. Forgot my passwaord. Kindle
Forgot p JA: What kind of computer do you have? Customer: Forgot my passwaord JA: Have you installed any updates recently? Customer: Kindle JA: Anything else you want the Computer Expert to know befor… read more
Kris R
Kris R
Computer Hardware Engineer
3,156 satisfied customers
Can you give me a phone number where I can get help. Lenovo
can you give me a phone number where I can get help … read more
Josh
Josh
It Support Specialist
Associate Degree
5,127 satisfied customers
I have a Samsung digital camera model WB35F. My flash quit
I have a Samsung digital camera model WB35F. My flash quit working,but the rest of the camera operates just fine. What is the cost to replace that flash mechanism? … read more
Kris R
Kris R
Computer Hardware Engineer
3,156 satisfied customers
Are you a robot or a human? Windows..,but could you tell me
windows..,but could you tell me why I CAN ACCESS MY EMAIL ACCPUNT? … read more
Mr.Med
Mr.Med
902 satisfied customers
Can i change my paypal account from business to individual.
hi can i change my paypal account from business to individual … read more
Mr.Med
Mr.Med
902 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