Search results for query: *

Thank you.

This is an Access 2007 form using the tables mentioned in the initial post. MS Forms 2.0 Object Library is a reference library used to build a form via VBA in this FAQ: http://www.tek-tips.com/faqs.cfm?fid=5757 The FAQ author used that library (among others) to build the form objects...

The FAQ I referred to is [link "http://www.tek-tips.com/faqs.cfm?fid=5757"]here[/url].

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...

MajP, many thanks for the guidance and examples! I will give these a go when I return to work Tuesday. Cheers! Chuck

Thanks for the code MajP. Unfortunately, if I change a rank to something of the same rank (up or down), I run into a problem. For example, if I change something from 2 to 1, and 1 already exists, it reverts to 2. Same thing going the other way. Here's the code: Public changeType As String...

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...

Figured it out. You were on the right track, I just had to plug the added reference in a different spot as follows: Me.NameList.RowSource = Me.NameList.RowSource & " WHERE Active = True AND Left(" & strKeyField & ",1) >= '" & strStart & "' AND Left(" & strKeyField & ",1) <= '" & strEnd & "' "...

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...