Search results

I prefer to use a class that is global to the project. The class can be populated in any form that has the information and retrieved by any form that needs the information. No need to develop and copy code for concatenating and disassembling and the class structure enforces correct variable name...

Try using the timer event of a hidden form to act as the report timer in preview mode. I've had it in production for about a month now in an application with heavy use and it's working very well. In the report open event a hidden form which has no controls and only a couple of events is opened...

Using Access 2007 VBA, is there a way to pass a disconnected ADODB recordset to a report for its recordsource?

All modules are set to "option explicit". An update had caused a call to routine that had been commented out. Using a non-defined variable always stops the compile in its track with the explicit option. I had thought a non-defined routine would cause the same. Some days I do miss COBOL. The...

Yes, they are the same code. Found the problem, a logic error in another form in the app. Should have prevented the compile.

There are three Access applications in the same directory on the server. All have splash screens that instantiate some classes and get setup parameters. Two of them run fine after compile. Only one fails to fire its events. None are packaged and signed, so I'm not sure it makes sense for that to...

I'm going to have to set this aside for a bit. A production issue just came up in a different system. I'm not understanding why the app was fine with the trusted location on the server until now.

I tend to use server share names for all paths since I can't rely on everyone having the same mapped drives: development code is in MN-Data\ndc\Invision Support\_Gexter Source Code\ data tables are in different files in subfolders under that When it works I move it to a production folder...

Thanks for the quick replies! No, no other code fires until the splash screen opens the the main form. To test to see if anything was happening I commented out all code and put these two lines in each event: Open, Load, Activate, and Current (changing the text as appropriate for each) Dim...

The db is in a trusted directory. Do I need to set a more specific trust?

Using Access 2007 on pc with Windows 7 to edit Access application housed on a Windows server. A splash screen that works fine in the .accdb file does not fire any of its events once the file is converted to .accde. What would cause this? Renders the splash useless since it needs to create...

Somewhat experienced with Access hoping to learn new tricks and gain insight into a few frustrating situations.