Search results for query: *

We have an app in the field that uses the Nz() function. Some users are now getting an error using that function. The order of the references somehow gets reset, with OLE Automation now at the bottom, which then causes Nz() to throw an error. There is discussion that this may be because they...

We have an app in Access 2000, and we email an update database. The application pulls in parts that it needs, it has done this for quite some time. Then, because we need to replace a module with global variables, we shut down the app, start up the update mdb, and push objects using...

Hey, a simple question! I can't find or remember the character to allow you to put more than one command on a single line of code. It doesn't seem to be a semicolon or a colon. I last did this many years ago, but it would be helpful at the moment. Example (pretending the character is a colon)...

My overall goal is to programmatically import objects (modules and a form) that are called from the autoexec function (that is called from the autoexec macro). Unfortunately, since they are called from the autoexec function, then once these are loaded into memory, you can't bring in new copies...

Access 2k, WinXP. Due to the fact that we are deploying this worldwide, including very remote sites with SLOW dial-up connections, I am not able to use extra controls, which is why I am so limited in this. So here's a challenge... I am dynamically creating a form that represents crosstab data...

I am trying to have a vb app open one access database, read a table that is a list of modules and forms in another database, then import those objects from a second access database. Even though the objects already exist in the first db, I want to import them, rename the originals, rename the new...

I am trying to have a vb app open one access database, read a table that is a list of modules and forms in another database, then import those objects from a second access database. Even though the objects already exist in the first db, I want to import them, rename the originals, rename the new...

I need to have a VB executable copy several modules and a form from one mdb to another. I need to replace existing objects (or copy them in, delete the old ones, and rename the new ones). I'm thinking I should use RDO at this time, since I believe it's MS's current ODBC wrapper of choice. I'm...

I am working with Access 2000. I would like to test for a previous instance of the database being open. In VB, I could use: If App.Previnstance Then sFormCaption = Me.Caption App.Activate sFormCaption Unload Me End If Is there something comparable in Access? Thank you for your...

Is there a way to set the Z-order in Access forms? I believe VB has a Z-order property. I am working on some complex forms someone has carefully set up, and I am having to modify numerous labels. I want to put things back in the same Z-order (top to bottom), but the only tools I know of are...

Thank you for your time. I have a union query that is quite large. It is a compilation of 5 queries that are largely the same, with small differences in the SELECT, FROM, and WHERE clauses. I have created variables to hold various pieces. For example, the SELECT for each of the 5 subqueries...