• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Access guru's needed

Pegun

Pegun

Golden Member
Hey everyone,
I'm doing a project where I have an access database of all the fire extinguishers on campus. I want to be able to go around with a handheld and "HanDBase" to change the status once a month of the database. In other words I would want to create a drop down menu for each extinguisher. Would the best way to do this be a query or some other way? I've seen HanDBase used with tabs so that the general information on the extinguisher can be pulled up quickly and then the status changed in a different tab, but I dont have enough expertise in the program at the moment to know exactly how to do this.

Thanks all.
 
One way, in Access, would be to:
- Create a "FormA", put your Drop Down (Combo Control) on it.
- Create a "FormB", that displays all of the info on it that you want to see.
- Create a Macro "OpenDetailForm", that opens "FormB" with a filter (FE=Fire Extingusher) FENum = FormA.Combo.Value
- Open FormA, edit the OnChange event of the Combo control to call the "OpenDetailForm" macro.

- Open FormA and select a value from the list of FE, this should open FormB and display only the details for that FE

There is probably a way to do it all on one form... I just need to play with it some more to make it work.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top