473,320 Members | 1,572 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Checklist Time Stamping?

I am creating a checklist for quoting in Access 2000, that will be passed from one department to the next. I need to track the time that each task is checked off, so that we can find areas where lags in quoting process are occurring. I have been able to setup creation dates and modified dates, but I need records for the instance in time in which each operation is completed. Please Help
Aug 10 '10 #1
1 1366
Stewart Ross
2,545 Expert Mod 2GB
Hi Bryan. You don't give us enough detail on how your data is structured to give you full feedback on what you ask. I'd reckon that at minimum you should have 1-many relationships between at least four separate tables: dept and task, task and checklist, checklist and items to check, for example, with additional linking tables to resolve dept-checked-by relationships and so on. Without knowing how you've set up your records how can we advise you?

Anyway, if you need to record the time at which you tick a checkbox you will need a date/time field for each item you want to track the time of, updated using the AfterUpdate event of the checkbox on your userform to the value of the current time - which is available by using the Now() function. Say your checkbox is called item1_check, and you have your date/time field represented by a textbox called item1_time, then in the AfterUpdate event of the item1_check control you would have event code like this:

Expand|Select|Wrap|Line Numbers
  1. Private Sub item1_check_AfterUpdate ()
  2.   If Me!Item1_Check then
  3.     item1_time = now()
  4.   else
  5.     item1_time = null 'clear the time if the checkbox is unticked
  6.   end if
  7. End Sub
This is only an example of one approach you might take. Without knowing more about your application I can't give more of an insight than this at present.

-Stewart
Aug 11 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: ME | last post by:
can someone tell me how to make this first one work??, located here: http://javascript.about.com/library/scripts/blshowdatetime.htm#examplesource This second one, well, dreamweaver eats the code,...
17
by: Eric Lindsay | last post by:
Is learning to write CSS a better use of time than finding and using a package that produces complete web pages? I've moved to a new platform (Macintosh), taking with me about 400 personal web...
0
by: Paul Telco | last post by:
Dad, Nope, never heard of 'Tartiflette'. I suppose it shouldn't be a surprise that there is a French version of Raclette. The website is strange isn't it? On the one hand it is a demonstration...
1
by: Osiris Sawiris | last post by:
Hi to all, I have an application running on 20 workstations with the backend database located on one of these stations. The stations are running Windows 98, ME, and XP. and the application is...
2
by: Rene Ren | last post by:
I can using Environment.TickCount property to get the time elapsed since the system started. but this property using A 32-bit signed integer type, so it's can't count the time more than 24.9 days....
2
by: roni | last post by:
hi. i have a checklist that is his items are created dynamcily. the question is, how can i write "<br"> after the 4 item for example. and in general,how can i write html code between each...
2
by: Incolor | last post by:
Hello All! I have to generate a checklist form as an input form in Access. A paper form is taken out in the field and checked yes, no, OR n/a for each item inspected. The problem I am having is...
0
by: stormey | last post by:
Hi. Our company just bought another company and we are incorporating all there data. I need to write a program in vb 6.0 or vb.net that will open all there pdf's and put a stamp on them. Each...
3
by: Mick | last post by:
Hi Is there a way of independently date and time stamping a record when it is created without relying on the computers own date and time setting? The PC will be standalone and only have...
1
by: Aussie Rules | last post by:
Hi, I have a checklist box with a list of machines that the user can select one or more of. What I want to be able to do, is when the user selects a machine, and list of parts (related to the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.