Search results

I have a form which I can filter using a combo box. The form is based on a query whicht looks up the criteria for one field in the content of the combo box. This is what is what I use in criteria field to look up the combo box's value: [Forms]![NameOfFormWithComboBox]![ComboBoxName] The combo...

I have a combo box in which you can choose the status of a task (not yet started, in progress, finished). When the status is set to "finished" I want to insert a value that I calculated using a query into another field of the form (I want to use the BeforeUpdate event for this). What I don't...

I am making a hardware & software inventory database. I've got a many-to-many relationship between my PC table and my software table so I can keep track of which software is installed on which PC. I also have a one-to-many relationship between my software table and the license table (the license...

All of my forms are subforms on different tabs of my main form. What I want to do is switch to another tab and open a corresponding record (they are related through a 1:n relationship where the 1-side is the tab I want to switch to). This is what I tried but it doesn't work: Private Sub...

I want to record the date when a record was modified. I did a search on the forums and found this thread. Now I did just as described and put this into the Before Event property of the form (DateChanged is the field that will hold the date): Private Sub Form_BeforeUpdate(Cancel As Integer)...

All of my forms are subforms on different tabs of my main form. What I want to do is switch to another tab and open a corresponding record (they are related through a 1:n relationship where the 1-side is the tab I want to switch to). This is what I tried but it doesn't work: Private Sub...

I am making hardware & software inventory database. All my forms are subforms on different tabs of one main form. What I want to do is use an event procedure to switch to another tab (and thus form) and open up a record corresponding to the currently open record in the current form. I am...

I don't really know whether this belongs into forms, macros or VBA so I'll just post it here. :confused: I am making a hardware & software inventory database. I have got all the data on each PC stored in tblPC which is linked to the Software table in a many-to-many relationship. One of my forms...

I am working on a database to keep track of the hardware and the software inventory of the company I work for. The "main" table is the workplace table which basically only holds the WorkplaceID, WorkplaceName and RoomNumber. It is linked in a one-to-many relation hip to the PC table which holds...

Many-to-many relationship between main form and subform? I am working on a database to keep track of the hardware and the software inventory of the company I work for. I've got a table for the PCs and a table for the software. These two have a many-to-many relationship via another table (b/c a...

I am working on a software and hardware inventory database for my company. I have all the software stored in one table that basically looks like this SoftwareID AutoNumber SoftwareName Text OperatingSystem? Boolean I need a query that only returns the names of all...

Hi, I am working on a database of the inventory of PC-Hardware and Software. The hardware is basically divided into PCs and Displays both of which will have a seperate table. Each PC and each Display should have an InventoryID (which Access will automatically assign) but an InventoryID may only...