Search results

So any ideas of how the code would look to do this in a module? Passing BldgAbb_ID from a form to a report? Option Compare Database Option Explicit Dim BldgAbb_ID As String Private Sub cmdElev_Click() On Error GoTo cmdElev_Click_Err DoCmd.OpenReport "rptElevators", acViewReport, ""...

Ok I'll take a look thanks.

Because transparent buttons go over images of pumps (etc.) you click on the pump it opens a form with info on it. Each transparent button goes to a specific record for a piece of equip in this common form for each building. example to make it clearer I try to make it simple...... Imagine a...

So the 7 command buttons code on top of the form stay the same for every form. See screen shot.

Like I said before the Command buttons code at the top would remain the same for all 300+ forms. If I needed to change it on one module it would change it for all of them making this easy to change if needed in the future. The 7 command buttons code on top of the form stay the same opening a...

Could be anything just wouldn't want to change all forms. If you have a solution for using one form I'm all ears but I need help with the code as I wouldn't know how to make it all work. So one form or back to the original question how to define the variables so the module would work. Thanks...

The module would be if I ever wanted to change anything with the common command buttons at the top. This would save me having to go to each command button on each of the 300+ forms if I needed to adjust something. If I was to store the location of the command button on the drawing in the table...

Screen Shot. FYI the live web version can't be altered to accommodate what I need as it is out of my hands.

-Basically I have 300+ pictures of mechanical drawings each for a different system, multiple buildings. -Command buttons on the mech. drawing are about 1-50 command buttoms. -All command buttons when selected go to a common form that brings up information on that piece of equip. including...

How about the code for the 7 command buttons anyone have any ideas.

It is nuts I agree. I could bring in the picture from a table but overlay of command buttons in a specific location over a picture how could it be done? The command buttons are in different locations on each form as each diagram of equip. is different. If you could figure that out I would say...

So hopefully this makes sense.. - I would like to use a module because I can't use one form for multiple buildings because each one is different. (Reason...Overlay of command buttons on different mech. pictures for each building) - Each form has 7 command buttons that are exactly the same that...

Not working didn't think this would be so difficult thanks for all the help.

Thanks but I only want an elevator report to show if I select that command button not all the reports. Is there not an easy way to declare the variable for BldgAbb_ID to make this work like it would on a form?

So basically what I want is the on the click events for 7 buttons on each form to refer to the subroutine in the module like this. If I ever need to change the code I can just change it in the module instead of going to over a 100 forms. It work for just opening a form without filtering but when...

Ok I try to explain this the best I can as I am very green with all this. 1. I have a main menu form that you can select a number of buildings (eg.1-100). 2. I then click and open a form called bldgform for that building that a have a textbox with name and control source of BldgAbb_ID for...

Thanks for all the help but I would like to put in a module and make it public as I have multiple forms that would use this code. In the future if the code need to be altered it would be nice just to do it in one spot instead of on multiple forms. The original code for opening the form seemed...

So the control name would be the same as the text box on the report which would be BldgAbb_ID correct? I tried this first but doesn't seem to work. I thought maybe they couldn't have the same name so I changed it.

Put code like your suggestions and below is the error that I got. Code Tags Added by UG Please use Code Tags when posting VBA Code Please read this for further information:- https://www.access-programmers.co.uk/forums/threads/please-use-code-tags-when-posting-vba-code.240420/ Please feel free...

Doesn't seem to work get errors. Trying to pass the value from a form to open a report to the same building.