473,324 Members | 2,356 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,324 software developers and data experts.

When I check a box I would like the current date to enter in a box but, I need the da

We have an Access program that our maintenance department uses to enter data about their projects and we have a completion check box. We would like the date to enter in the background when the box is checked. This date would be hidden in the back so only management will see it. We need this date to stay the date the box was originally checked. They tend to enter in earlier dates and we want to verify when it was actually done. We can get the date to enter with the checkbox but, it changes everyday it is opened. I need to know if there is a way to hold that original date.

Thank you,
Apr 3 '15 #1
2 1094
Seth Schrock
2,965 Expert 2GB
Test to see if there is a value in the date field before setting the date.
Apr 3 '15 #2
nico5038
3,080 Expert 2GB
You could use a tblCompleteChecked with the fields:
PlanIdentifier,
DateTimeStamp and
StatusCheckComplete
When the checkmark is clicked you add a record in the OnUpdate event like:
Expand|Select|Wrap|Line Numbers
  1. currentdb.execute "INSERT (PlanIdentifier, DateTimeStamp, StatusCheckComplete) INTO tblCompleteChecked VALUES(" & Me.PlanIdentifier & " , now(), " & Me.CheckmarkField & ")"
  2.  
Thus you have a full record of the values (on and off) of the planstatus.
Finally you could add the userid of the person that entered/changed the checkmark.

Getting the idea ?

Nic;o)
Apr 3 '15 #3

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

Similar topics

7
by: James P. | last post by:
Hello there, In my asp.net page using VB, I have a date text field in mm/dd/yyyy format. When a date is entered, I'd like to validate it to make sure the date is greater than or equal to the...
32
by: paul | last post by:
HI! I keep on getting this error and I have tried different things but I am not sure how to send the expiring date. The error that I am getting in Firefox 1.5 is "Error: expires.toGMTString is...
4
mbolan77
by: mbolan77 | last post by:
Hello... I have a table with a number of fields along with a time stamp column... I am wondering how I can query for only rows inserted on the current date other than manually entering the date...
1
by: prateek | last post by:
Hi all using VB6 with Access how to prevent date enter before the current date. Please give me the syntax / code thanks
4
stormrider
by: stormrider | last post by:
Hi all, I'm trying to implement a Perl structure. My small program will do the followings; Take the birth date of the user as input. (Month's will be input as strings.) Take the current time...
0
by: Shawger Lager | last post by:
Hi, I am new to DB2 (and SQL) and I am having some problems with the current date. I am trying to make sure the date in the table review is not past the current day using a constriant. I have tried...
6
by: trytobreak | last post by:
Hi All, I am a network administrator in a fairly large software company and I would like to write myself a small utility, which would connect (one by one) to all machines on the network and get...
1
by: tmcjunkin | last post by:
I'm trying to back into this project by defining what the user needs to see when they open a form. I'm between beginner and intermediate with vba, but have been using access for years. When the...
3
by: smkdvr588 | last post by:
Not sure if this is the place to find the answer to my need, so hopefully someone can help. I have created a micro enabled Word template and my wish is to have a command button on the document...
1
by: Ulf Malmros | last post by:
I'm trying to get a small webpage to update an access database. There are no problems with the data the user enter but when I try to update the database with current date and time it fails. I'm...
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: 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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.