Needs some VBA advice from the gurus
Posted by Mark on January 16, 2002 6:57 AM
I'm trying to assemble an application that will allow me to maintain several jobs that I'm working on. This is my first VBA project, so I'm constantly refering back to this site for ideas & help.
The VBA project is coming along pretty well. I have 10 forms that I've coded correctly (as far as I can tell). Ideally, when I start the app, the form "main" will be displayed.
"Main" basically does two things. First, I have a combobox that will allow me to select which job I need to work on, and also displays the job's name in a text box. Second, It has commandbuttons that open seven other forms. So far, so good. All of the controls work as needed.
The other seven sub forms have two text boxes at the top that I need to display the job's number & name as selected on "main". This has me baffled. Any Ideas??
Also, what needs to be done to compile the VBA project into an application?? When the project gets compiled, what actually happens to the file?? The reason I ask is because my VBA project is already 114meg & I'm about 1/2 complete. I zipped the file & the size dropped to 4.6meg. Can I expect the file size to decrease??
Thanks for being kind enough to lend your expertice to the "small guys". Without the help & advice from this sight, it would be next to impossible for me to even this far.