ive been working on an database and i want to add a record so i am using

DoCmd.RunSQL (INSERT INTO Booking " & "(MemberID, CourtID) " & " VALUES (11, 1);)

which works

but when i add the next fields the date and time and i get a 3134 error

DoCmd.RunSQL ("INSERT INTO Booking " & "(MemberID, CourtID, Date, Time) " & " VALUES (11, 1, #25/06/06#, 10:00);")

ive changing the # and ' doing various combinations of the two.

ive searched the internet and this forum for about 2 hours but i cant get it to work.

any help

thanks

If I understand your post, you have named two fields, one "Date" and one "Time". These are 'keywords'. Try changing the field names in the table "Booking" first; example: "courtDATE" and "courtTIME". Define "courtTIME" data type TEXT. Then modify your insert like this:

dim sSQL as string
sSQL="INSERT INTO Booking (MemberID,CourtID,CourtDATE,CourtTIME) "
sSQL=sSQL & "VALUES (11,1,#25/06/06#,'10:00');"
DoCmd.RunSQL sSQL

If you want courtTIME as data type Date/Time, then wrap time in '#':

dim sSQL as string
sSQL="INSERT INTO Booking (MemberID,CourtID,CourtDATE,CourtTIME) "
sSQL=sSQL & "VALUES (11,1,#25/06/06#,#10:00#);"
DoCmd.RunSQL sSQL

This will work fine.
:)

That would be the problem. I would further add, try combining the date and time fields into CourtDateTime and save a column.



mmcdonal

wow that worked thank you very much

you guys are good.