Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JimConrad48188
- Order by date
-
Tables Accessing Network?
Oops, the picture of the little car in the earlier post is supposed to be the word "Auto" in square brackets! Guess I should have previewed the post before submitting it.- JimConrad48188
- Post #3
- Forum: Microsoft: Access Other topics
-
Tables Accessing Network?
It may be due to the "new" table property "Subdatasheet Name". Apparently if the table you are trying to open has this property set to "[Auto]" (the default), Access searches all your other tables looking for related columns. Open one of your local tables in...- JimConrad48188
- Post #2
- Forum: Microsoft: Access Other topics
-
Current Record in a SubForm
Dim x as Long x = Me.Recordset.AbsolutePosition + 1- JimConrad48188
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Combo Boxes
Add a reference to the combobox to the query the form is based on. In the query, under the "Vendor" column, in the row labeled "criteria", enter [Forms]![formName]![comboboxName]- JimConrad48188
- Post #2
- Forum: Microsoft: Access Other topics
-
Adding Rank Values
You could write your own rank function like the one below. If used in a query, I suggest that you always use a "MakeTable" query, function calls can be strange when you are scrolling around in a "Select" query result table. Note that you must call the function twice in your...- JimConrad48188
- Post #5
- Forum: Microsoft: Access Other topics
