Search results

I think I came up with something that works... http://www.gamecharmer.com/dl/Connections.zip The form is Switches I basically have a form that starts with the main switch. From there, I have two list boxes that list each attached switch or room (some switches can have multiple connections to...

I decided that I would like to be able to lay my networking structure out in a nice Access Database so I can manage all of the connections easier than an Excel Sheet. I made the following tables Rooms (Room_ID, Room_Name, Room_Phone_ID, Room_Data_ID) PhoneConnections (Phone_ID...

You might need some simple VB Code for this one. If you're dealing with multiple tables on a form, and need a drop-down to work properly, I've found that adding your SQL query to the "On Focus" event of the combo-box is the best bet for loading data after the form is loaded. This also works...

Ok, here's my solution... I didn't want people accidentally (or otherwise) changing any time card records without administrator permission. I added a single field to my table called "TABLE_NAME_lock" and it's a yes or no (checkbox) field. In each form, in the On Current coding section, I...