Search results for query: *

Folks, I have created an application that uses VBA macros in Excel and Word templates to perform actions when a document is opened. This works splendidly and I have no problems. However, I do have a problem when I want to update the AutoOpen code. It is a tricky situation, so I'll explain...

SanYeo, What you are trying to accomplish should be fairly easy. However, I'll need some details in order to help out. I'm assuming that you are going to write the program in VBA, since you've posed the question here. My concern is that VBA must be hosted by an application and can not be a...

HiBoo, I think that code would work to print stand alone modules, which I can do, but I'm looking for something to print class modules. In answer to your question however, you can fill a list box using a function. I'll try to give you some direction from what I know. You'll need to set up...

I'm looking for a way to send all modules to a text file. I can accomplish this pretty easily with documents container for stand-alone modules, but class modules are a different issue. Any suggestions? Also, anyone know of any programs that format VB code from text files to MS Word or HTML...

I'm looking for a way to send all modules to a text file. I can accomplish this pretty easily with documents container for stand-alone modules, but class modules are a different issue. Any suggestions? Also, anyone know of any programs that format VB code from text files to MS Word or HTML...

I'm looking for a way to send all modules to a text file. I can accomplish this pretty easily with documents container for stand-alone modules, but class modules are a different issue. Any suggestions? Also, anyone know of any programs that format VB code from text files to MS Word or HTML...

kgkdfhgkdh, There are a few ways to do this, here's an easy one: Click on your form properties and go to events. Set your form open event to event procedure. Open the code editor. Go outside of your event procedure and put a public dim statement in the declaration section like so. ----...

Alex, I figured it out. There seems to be a few steps one must take in order to make this work. First of all, you've got to go into the database and set up an account (I used the Admin) with Open Exclusive checked in the rights for the database object. Then you have to change the database...

Airon, That depends on the type and amount of data you are allocating to the variable. As a general rule, if a global variable isn't needed, you may want to stick to dimensioning the variable in the module or class module where it is utilized. This ensures that when a particular procedure or...

Beth, Are you trying to make the state and count fields lookup boxes? If that is the case, you won't lose any information so long as you have the same values in the look up tables for State and Country. If you are just trying to change the values for the 4800 records, that can be accomplished...

Alex, Thanks for the input. The specific problem I'm having now is that when trying to open the database programatically with the following code: -------- Dim dbs As Database Dim rst As Recordset Set dbs = OpenDatabase("A:\DocControl.mdb", False, True) Set rst =...

I can't seem to open MS Access .mdb files on write protected media like CD Roms or protected floppies. I'm trying to open them programmatically, but it gives me error messages. I've done just about all I can think about to get them to open, including setting the read only attribute to true in...

Does anyone know of any way I can print *.hlp files along with examples? I find the electronic help really useful, but ineffecient. When I'm working I find that I typically print the help information anyway. So, what I would like to do is print a manual without printing each individual...

I'm trying to write an error trapping routine in VBA for Access 97 and am having a few problems. I want to log the errors in a table titled "ErrorLog". That's no sweat. Now I can easily put the error number, source, and description in the table, but what about the actual module...

I'm writing a two part access application (Client Side/Server Side)and am trying to find a method to keep toolbars updated on the client side without manually importing them from the server side. I would prefer not to use a Toolbars.MDA addin, nor do I want to create a linked toolbars table...