Unanswered: Need help with VB and Macros (and a few other questions)
I have some questions.
1. Does the Access Base window always stay open even if you use a switchboard?... I have found the spot to hide just about everything (including the DB Window) except the MS Access startup window itself.
2. Does anyone have a macro that I can add to a form that will allow me to refresh a lookup list? ... I have an input form (A) with a field that requires another form if a new record tries to be added. I have a link button to the other form (B) on A's form. When you click on the link, B opens up and you can now add the new information. When I click enter, B's table gets updated and a cross link back to A. I need to refresh the look up table for B's field in order to continue without having to completely close A and restart it. I tried using an update query but couldn't get it to work. I need a "refresh button"
3. I like screen resolutions of 1024 by 680, all the other guys like 800 x 600. I created my DB on 1024 and when the 800 x 600 guys pull it up, it is HUGE!!!... Is there some VB or a macro that will keep the database in the proper proportions when opened on different resolution screens.
4. I have 6 forms... 4 for input and 2 for searching. The input screens are very small and this is good. I only want them to show the area of the form and thats it. The other 2 open full screen to allow a good number of records to be displayed. When they open full screen they assume the menu bar of the main access window. I don't want the user to have access to any tool bars/menu bars. I want them to be able to search and return to the main switchboard. How can I make it so that the form opens up full screen and doesn't have any menu/tool bars?
(I have the form opening with a macro using maximize I just need to lose the tool bars)
These are the major problems. Thanks for your help,