Re: Date & time

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In addition to the advice John gave you, I'd strongly recommend that you
rename the field in your table named Now. Now is a reserved word, and using
it for your own purposes can lead to all sorts of problems.

For a good discussion on what names to avoid, see what Allen Browne has at
http://www.allenbrowne.com/AppIssueBadWord.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Barcode" <Barcode@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2AA193C5-133B-4F22-A290-D2E2F860BC71@xxxxxxxxxxxxxxxx
Hello

I would like to insert the Date and Time, but when I test this code it
insert only date.
How it is possible to insert in the same filed date + time ?

DoCmd.RunSQL "INSERT INTO Tillgangar ( Anvand, now, Mobiltelefon ) SELECT
1,
Date() , [Mobiltelefon];"


Thank you


.

Relevant Pages

  • Re: calculate headcount
    ... First, rename your field. ... Date is a reserved word, ... shiftstart and shiftend. ...
    (microsoft.public.access.queries)
  • RE: mid function
    ... 'Control' is an Access reserved word, ... Also, where are you putting this code, in a query, or in a form's event? ... Are you trying to rename a field at run time (it's impossible - in any object! ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to DSUM multiple fields
    ... Are you saying you want the sum of the four fields? ... Note that you should rename your field from Date: that's a reserved word, ...
    (microsoft.public.access.forms)
  • Re: time field
    ... Rename your control "txtTime" and try If IsNullThen ... ... "Time" is a reserved word in Access. ...
    (comp.databases.ms-access)