Search results for query: *

I'm getting the error 3734 Database has been left in a state by user ADMIN on machine <name> that prevents it from being opened or locked. This occurs inside an event procedure where I am trying to open the same database as the form and insert some records. The user ADMIN's database security...

I figured out the problem. I was using the SET keyword to assign the value of the public variables. For some reason, Access 2002 doesn't like this. When I just said PublicVariable = FormVariable without the SET, it works ok. Thanks for your advice, though. I didn't understand that public...

I put the declarations in a subroutine is standard module and then did a call to this subroutine from the forms open event to initialize the public variables. When I tried to reference the public variables in other events connected to the form, I get a compile error stating &quot;Object...

Why can't my Access 2002 application recognize public variables? I have a couple variables that I want made available to the entire application. I have declared them as Public in the General Declarations section of the startup form for the application. When I try to use a SET to initialize...

Why can't my Access 2002 application recognize public variables? I have a couple variables that I want made available to the entire application. I have declared them as Public in the General Declarations section of the startup form for the application. When I try to use a SET to initialize...