Search results

OIC... now I understand what you are saying. It is in it's own module, not in the class objects. I still get the same error. Here is my code on the form... followed by the code for the actual function. How and where do I set a reference to the "Microsoft scripting runtime"? Private Sub...

got it... renamed. Now, if you would be so kind, define a standard module. It is in it's own module. In fact, it is the only module I have.

I tried that, but got the compile error, expected variable or procedure, not module.

It would be easier to put it as a sub I think. Can it be in the same sub for my exit button? Like before the If Me.Dirty Then Me.Dirty = False line? I think I would have to pull the end function off though... right?

I believe it does... the page didn't fully load so I didn't see the whole thread. Now on to, where do I put it? Does it get dropped in somewhere in the button on click? Remember, I know nothing about VBA. I must be driving you nuts.

That was an excellent link... I think it will solve most of my issue. I just need some help on how to remove the whole winzip part, I do not need it zipped. Here is what I have for my on click on my exit button. Can I put it in here somehow? I got a bit of help getting to this point, but my...

I am not a programmer... I need my DB to backup on close automatically. Help? -ROMADOZ:confused:

All, I am not a programmer, but I do know access can send reports via email if I can get the code right. I have a training db. I need to send reports out automatically at a set interval as attachments. I am running Office 07 all around. I have my reports tied to a query tied to a combo box...

continued assistance Not sure if I follow. In each type of training, it is broken down again by (in the 1st case) by what job you hold. The table has all the tasks for all the jobs. Here is what it looks like: The PK is an autonumber Job (comes from the Jobs table) Task My next one has...

help I am under the impression that I need 4 tables for the different types of training because they are owned by different entities in my organization, and that they are all constantly changing. I need the owner of eah type to be able to go in and change the training items at will. Once they...

Hello, I am building a database to track training. I have 4 separate groups of training (4 tables). The items on these tables change based on directions from higher. I have a table and corresponding form for personnel. In this table (and form) you choose what job area you are in, from...