Hi,
I wrote this simple code:
I call the sub in this manner:
Please Login or Register to view this content.
I get this error: Run-time-error '3065': Application-defined or object-defined errorPlease Login or Register to view this content.
What is wrong??
Thank you, for any help!
Lloyd
Lloyd
Try putting Date in square brackets in the SQL.
By the way, is Date a date/time field or a text field?
If posting code please use code tags, see here.
Hi Norie,
thank you for your fast reply!
Causes the same error!Please Login or Register to view this content.
Date is a text field!
I found out Date is a reserved word in SQL, so I renamed the attribute to Datum. But thsi also causes the same error!
Lloyd
The reason I suggested the square brackets was because Date is reserved.
Instead of trying to use double quotes try single quotes.
By the way, .Execute is normally used with action queries, eg DELETE, UPDATE etc not SELECT queriesl like you have.Please Login or Register to view this content.
Hmm, this does not help, too.
I wrote a new Sub:
Please Login or Register to view this content.It works.Please Login or Register to view this content.
Lloyd
Lloyd
So the problem was the SELECT query as I kind of mentioned in my last post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks