Arguement not found error Can't find mistake

Hello experts, I have an Argument not found error showing up when inserting a record in Access using VBA. Not quite sure what argument it is referring too. Any help would be appreciated. I am assuming it is an issue with the quotes but cannot find it.

Please Login or Register  to view this content.

Change that last line to:

Please Login or Register  to view this content.

This isnt guaranteed to fix it but I always use a variable with .Execute and the msgbox will allow you to check that the statement looks right before executing it. If not, that should lead you to the answer.

Well I was originally signing it to a variable and then passing the variable to msgbox to verify the string looked correct and it did. I will try to pass the variable to the execute and test that way. I did it the other way for several tables and it worked just fine so I am stumped.

All this could be done using a query and zero code.

I prefer the code, but yes I could write the query which would be almost identical. There isn't any gain using the query over VBA I don't think and there is a lot more code on the backend besides this one function.

Originally Posted by ranman256

All this could be done using a query and zero code.

have to admit (rightly or wrongly) I always use code if theres anything else to do when the button is pressed, in this case it looks like the SQL is only part of the functionality.

I agree pj, I tend to use code over built in functionality of Access.

This is the output: "INSERT INTO DailyYardWalk (walkDoneBy, time, driversWaiting, overnightParking, personalCars, notes) VALUES('Jon','1:45:03 PM','-1','0','0','Jon');"

I am trying to insert 1, and 0 for a yes/no datatype. Could that be the issue?

I have done that and still get the same error. Here is the output with the quotes removed. "INSERT INTO DailyYardWalk (walkDoneBy, time, driversWaiting, overnightParking, personalCars, notes) VALUES('Jon','1:45:03 PM',-1,0,0,'Jon');"

Ok, everything I have seen states it is a Boolean type leading to -1 and 0. I will try True and false to see and get back with you.

Updated value and still getting same error messaage. "INSERT INTO DailyYardWalk (walkDoneBy, time, driversWaiting, overnightParking, personalCars, notes) VALUES('Jon','2:16:04 PM','True','False','False','Jon');"
I have tried romoving the quotes as well as changing the datatype from string to Boolean.

Dont you need # around the time data?

#2:16:04 PM#

So I found out the issue. I had one of my fields in the table named Time. Time is a reserved word which wouldn't allow the query to run. Sooooooo, the query itself was correct and I just screwed up in the initial DB design. Thanks for all of you help

How did none of us spot that?!?!?!?!?