Insert Record Problems

[Kevin]

I have several queries I run through VBA as querydefs.
Some of them fail to perform the operation if there
currently are no records in the underlying table. Why!? If
I simply, manually insert a record directly into the
table, the next time I execute the same code, everything
works as expected????? This is only a problem the first
time data is put into a table, but I really don't want to
insert bad data on purpose just to get the code to
function as intended. Can anyone explain this?

Thanks!

Kevin

 

[John Vinson]

I have several queries I run through VBA as querydefs.
Some of them fail to perform the operation if there
currently are no records in the underlying table. Why!?

Because either the query SQL or the VBA code is incorrect.

Care to post the code so that we have a chance of seeing in what WAY
they are incorrect?