Help Urgent!!!

[The Frog Meister]

Rite...

Hi guys...

I have just created an access database that you can update through a webpage etc....

I am havong a HUGE problem with inserting an auto date.

Does anyone know how to make access date and time the new record when it is being entered ?????

thanks guys

[The Frog Meister]

HELP PLEASE!!!!!

[wildpitch]

Can't you use the VB commands time() and date()?

[The Frog Meister]

ok.... where do I put them in????

I have tried the good old date() but nothing

[wildpitch]

Good point. You need a couple of hidden fields on the input form. Then when the form is executed, insert them into the DB as you do with the other fields. I seem to remember having grief with the dates on this when I did it a couple of years back. The webserver insisted on entering them in US format, so I had to use "mid" to split the dates when I pulled them back out onto another form, not that hard but a pain in the ass all the same.

[The Frog Meister]

cheers mate



Now imagine that I have a migrain and my brain is fried.... do you think you could explain the exact method pelase THANK YOU


PS The boss will love you if I can pull this one off

[wildpitch]

Not sure if you can attach files here so if not just paste the contents of your "post" form and the script the info is passed to to enter the stuff into the db (the asp / vb script) and I'll see if I can point you in the right direction.

[The Frog Meister]

ok mate cheers. Will do that when I get home later as something has just crpet up


cheers

[fugjostle]

Originally posted by The Frog Meister
Rite...

I have just created an access database that you can update through a webpage etc....

eek !!! don't use Access... u will be hacked in less than 10 seconds !!!

Get a copy of MySQL... its free and very powerful.

---
Fug

[The Frog Meister]

it's on internal servers mate, not publsihed at all and I have found the solution