Date field?
- Thread starter aronw
- Start date
G
GPLT
Guest
Sorry to put this here but I could not find the ("new Post") button.
I have a big problem. I have a database that keeps track of students progress. When a student has finished a subject they get a certificate. This is printed automaticlly. However I can not find out how to make the print operation change the record in the table Issued. The Issued record is a check box, Yes/no. The report is an basic query. If the student has passed and the Issued table is false then display the record. The report reads the query and displays the details to be printed.
I than have to manual go back and click that the student has been Issued a certificate. How do I get the report to change the value to true when the report has priinted the certificates.
Plese help this one a big one..
Thanx Gizard
I have a big problem. I have a database that keeps track of students progress. When a student has finished a subject they get a certificate. This is printed automaticlly. However I can not find out how to make the print operation change the record in the table Issued. The Issued record is a check box, Yes/no. The report is an basic query. If the student has passed and the Issued table is false then display the record. The report reads the query and displays the details to be printed.
I than have to manual go back and click that the student has been Issued a certificate. How do I get the report to change the value to true when the report has priinted the certificates.
Plese help this one a big one..
Thanx Gizard
Tay
likes garlic
- Local time
- Today, 09:42
- Joined
- May 24, 2002
- Messages
- 269
Yeah, Ally is right, use =Date(). But if you use =Now() and set the format to say, Long Date it does only show the date and not time. It works, but is it better to just have =Date()? I presume so, but what difference does it make?...
R
Rich
Guest
On a report =Now() will make no difference, using Now() as the default value for a textbox can have unpedictable results when using Between Date1 And etc. to return records in a query. Unless you actually need to store the time =Date() is OK, providing you don't have missing references of course
David R
I know a few things...
- Local time
- Today, 03:42
- Joined
- Oct 23, 2001
- Messages
- 2,633
GPLT...
The Post New Topic button is at the bottom of every thread, just like this one. It's right next to the Post Reply button that you presumably used to post here.
To address your question, however, look into Update Queries. That will allow you to change the record when you print it.
David R
The Post New Topic button is at the bottom of every thread, just like this one. It's right next to the Post Reply button that you presumably used to post here.
To address your question, however, look into Update Queries. That will allow you to change the record when you print it.
David R
Similar threads
