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

Opting out for access expert..

Ask Your Own Computer Question
Tech Support Specialist: Richard, Computer Specialist replied 4 months ago
Richard
Richard, Computer Specialist
Category: Computer
Satisfied Customers: 42,364
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 4 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 4 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 4 months ago
George Sibiya
George Sibiya, Computer Hardware Engineer
Category: Computer
Satisfied Customers: 264
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 4 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 4 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 4 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 4 months ago

I can complete it by Sunday

Ask Your Own Computer Question
Was this answer helpful?
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,228 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,167 satisfied customers

Certificate Course In Computer Maintenance

< Previous | Next >

Related Computer Questions
I opened a paypal acct aLONG time ago and haven't used it in
I opened a paypal acct aLONG time ago and haven't used it in over 5 years. How can I use it now? … read more
Kris R
Kris R
Computer Hardware Engineer
4,339 satisfied customers
How can I search a computer for deleted files? Im trying to
Second opinion] How can I search a computer for deleted files? Im trying to recover some files and I dont want to buy any high end software. Is there a way to do it through command line in Windows? I … read more
Russell H.
Russell H.
computer technology consultant
Vocational, Technical or Trade Scho
781 satisfied customers
Having trouble logging in. Must have forgotted, but what is
Having trouble logging in. Must have forgotted, but what is difference between my U. of G. C.L.A., and my " full e-mail address and password'? … read more
Moses C
Moses C
Bsc
419 satisfied customers
Have been having some problems with programs within my
Have been having some problems with programs within my Lenovo. I've lost my Aol Desktop Gold and need to recoup it. How do I go about doing that? … read more
Kamil Anwar
Kamil Anwar
IT Consultant / Systems Engineer
Bachelor\u0027s Degree
444 satisfied customers
I am being denied access to fix windows update-errors.
I am being denied access to fix windows update-errors. Reference #18.15b52d17.1519517241.aa115f55 … read more
Cody
Cody
Computer Science
1,849 satisfied customers
I am trying to reactivate my Skype account which is
hello Andy, I am trying to reactivate my Skype account which is kevinmcc62 but the questions asked took time to look up and now I am told that I have run out of time!! … read more
Kris R
Kris R
Computer Hardware Engineer
4,339 satisfied customers
When I try to print from iPhone, ipad etc I get a message
When I try to print from iPhone, ipad etc I get a message that i printer was not found … read more
Kris R
Kris R
Computer Hardware Engineer
4,339 satisfied customers
I am trying to check out thru paypal of the Haynes web with
I am trying to check out thru paypal of the Haynes web with a purchase. It keeps rejecting me because of some glitch in the PayPal syste … read more
Jinsmn
Jinsmn
Systems Administrator
Diplom
1,260 satisfied customers
I can't get in, my address is - [email protected] I
I can't get in , my address is - ***@******.*** JA: What device or product does this involve? Customer: i messed it up with to many re tries JA: What's the brand and model of your computer? And the Op… read more
Fran
Fran
Associates
5 satisfied customers
I forget my last Gmail password and I don't remember the
Hello, I forget my last Gmail password ***** I don't remember the number I used to open my account, … read more
Richard
Richard
Computer Specialist
42,364 satisfied customers
Have my domain name, TAKE-APARTFRAMINGSQUARE.COM over from
please have my domain name, TAKE-APARTFRAMINGSQUARE.COM over from the registrar godaddy account over from 3dcart to pinnaclecart my account is###-##-####pin is 1800 my phone number is(###) ###-####nam… read more
Josh
Josh
It Support Specialist
Associate Degree
5,145 satisfied customers
I am new to windows and my ace laptop I am trying to get
I am new to windows and my ace laptop I am trying to get some Manuel's … read more
technicalcat
technicalcat
Computer Science
839 satisfied customers
Need to reset password forgot. Dell Laptop Inspiron 14-3452
Dell Laptop Inspiron 14-3452 brand new and has never been used … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
954 satisfied customers
While online, all of the fonts in MSN.com & Hotmail.com,
While online, all of the fonts in MSN.com & Hotmail.com, everything, were suddenly reduced to 9 points or smaller, making them all too hard to read. I don't want or need the update or the newer, small… read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
954 satisfied customers
I got tickets for it but I put wrong email address so now I
I got tickets pat for it but I put wrong email address so now I paid for my ticket and I don't have them … read more
D.Sandlin
D.Sandlin
Support Technician
6,708 satisfied customers
I cannot open some apps. they tell me to ask my system admin
I cannot open some apps. they tell me to ask my system admin to repaiir ..I cannot open help and support. … read more
Richard
Richard
Computer Specialist
42,364 satisfied customers
I have loaded Office 365. But I have a big problem I cannot
Hi Andy. I have loaded Office 365. But I have a big problem I cannot remember my login details for Microsoft. Can you help? … read more
Richard
Richard
Computer Specialist
42,364 satisfied customers
How many scanned papers would an 8gb usb flash drive hold?
How many scanned papers would an 8gb usb flash drive hold? Is this a smart way to save records long term? What format would be best accessible in the long term? PDF? My goal is to scan records and als… read more
Moses C
Moses C
Bsc
419 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