Search results

I'm using the following scheme to track how unique widgets come in and go out. Movement (m) ---------- - id (pk) - move_on - origin_id - destination_id Widget (w) -------- - id (pk) - model_id - serial_number - from_movement_id (fk) - to_movement_id (fk) The receipt form is related to its...

I have a working Access DB application with a fair bit of VBA code. It's meant for a single user on one computer (me) and it's not very large (under 10 MB at this point, although it will get bigger when I start adding photos and perhaps even videos to it). There's no compelling need to migrate...

On my form, the default value of a subform field shows up on the New Entry row, even the row is not being edited. This is not only unsightly, but also misleading and confusing. Is there a way to have the subform's defaults show up only when they're needed (i.e. the new entry row is focused)...

Trying to update a table with a (single) result from another table, I got an "Operation must use an updateable query" with this query: update Service_case s set s.owner_id = (select c.id from contact c where c.contact_name = "foo") where s.device_sn = "bar" Is the problem due to the potential...

In Access 2016, I implemented a cascading combo box in a subform by specifying the row source's criteria as follows [Forms]![My_Main_Form].[Form]![My_Subform].[Form]![My_Subform_Control] This works well for one main form, but doesn't work when the subform is reused by other main forms. Is...