Help needed in access

[M111CYY]

Im creating a database for my a level, and i need to put a date and day in for some of the entries.
is there a validation code that i can use so that the date and day are updated automatically each day, so will not need typing all the time.
the teacher doesnt help much so im in need of help.
thanks

 

[M111CYY]

Right, a bit more detail.

Im creating a database for a newspaper round.
Customers will require papers each day and when entering the different newspaper info into the database i need to add one each day which wastes memory entering the same data repeatedly.

I was wondering if there was some sort of code, that would be a validation check, that would allow the day and date to update automaically and match the actual day and date.

thanx

 

[Ninja59]

I am currently also doing a database for a level.

There are a number of problems with creating such a validation rule as firstly,i would suggest setting up a input mask so that the date is always in the correct format. Access can do this by using a wizard.

And instead of creating a validation rule for the date create one for the length of the names of papers or something as in mine i have set it up to accept only a company with a maximum name length of 38. To do this be in design view of tables and in validation rule of selected field name and enter: Len([Customer Name])<=38 (38 being the maximum number of chracters).

Solves many problems this and gains more marks, as you have proven that you can use both.

 

[jug]

dont really understand what you're asking, but Date() gives todays date in access. it will update automatically with the system date.

 

[Hellcat]

dont really understand what you're asking, but Date() gives todays date in access. it will update automatically with the system date.

:yeahthat:

If you mean you're sick of typing the date have your form input todays date as default.

 

[M111CYY]

i dont know how to do that. the way ive got it the user has to type the date and day in themselves.
for the day it needs to be typed by user and the date i have this rule
>=Date()