I want to create a button or label grid on a form based on two tables:
tblHorizontal (1 - x)
tblVertical (1 - x)
The buttons would be arrayed in a typical grid/matrix format with the number of rows based on the number of records in tblHorizontal, and the number of columns based on the number...
I have a datasheet that displays a ranking column (1 to however many records). When a user changes a particular record's ranking (say from 8 to 2), how can I automatically update the other rankings? (ie old 2 becomes 3, 3 becomes 4, etc)
I have three tables:
1. tblInspections
InspectionID (PK)
Inspector
DateInspected
2. tblInspectionItems
ItemID (PK)
Description
Reference
3. tblResults
ResultID (PK)
InspectionID
ItemID
Result
I want to add a record via a form button such that a new inspection is created adding all inspection...
I have an object group setup like a telephone rolodex (A, B, C, etc) that populates a listbox with names based on the letter chosen. When the form opens, the listbox is populated with names based on a query with particular checkbox criteria indicating the name is active. This works fine...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.