Search results for query: *

Thanks for that tip, but it doesn't work. When the 'into' variable is in the SQL statement, it doesn't populate a declared variable inthe sub. Any other suggestions? Thanks!

I want to use the following SQL to find the maximum id in a table. This works fine, but how do I reference the resultset in my code? I want to be able to use max(uid) in other statements, but I don't know how to get to it... CurrentProject.Connection.Execute "Select max(uid) from [Donor]"...

Hello and thanks for your help. This is a question involving access and ADO. I have a nagging problem with what seems to be a delay between the instant I add a record with ADO and the ability to refresh the informatin into another form. I'll try to describe the steps. From customer_form I...

Hello and thanks for the help! I am running a report from a form with the simple command: DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria There's no problem there. But here's one thing I haven't been able to figure out how to do: I want to pass a comment or a string from the...

I need to regularly delete all rows in a temporary table and rather than use a loop to delete all records is there an Access equivalent to the SQL Server "truncate" command? I've thought about deleting the object and recreating, but I'm hoping there's a command to clear the contents of table...

Hello and thanks in advance for your help. I'm trying to do some data validation in the BefureUpdate event of a form, and when I encounter an error, I want to abort the update, show a message box, and return the user to the form. How do I abort the update within that event?

Perfect - just tried it. Thank you!

I've noticed some unusual things in Access 2002 regarding when Form.BeforeInsert fires off and when Form.BeforeUpdate fires off. I'm trying to do an action immediately before the physical insertion into the access database. While in insert mode, what is happening is... The BEFOREINSERT for...