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 IamaSherpa 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: TyDeschaine
- Order by date
-
Can you recommend a good book?
Sams SQL in 10 minutes is a great quick reference for understanding the SQL behind all of your queries. It is also a good help for custoimizing the rowsource behind your combo boxes.- TyDeschaine
- Post #5
- Forum: Microsoft: Access Tables and Relationships
-
Limit to List Combo Box
This is a cheap way around the problem, but I agree, there is no reason why access should not allow this. I experienced the same problem. Just set the column width property to .01", 1.3855". This will make the first column so small that the user cannot access or see it.- TyDeschaine
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
relationship-tables: recordset pulls ID# instead of title
If you are using Visual Basic you can find the title using the DLookup function. Using the following code, place your fieldnames into my [] examples. The "TitleVar"variable will contain the value that you need Dim TitleVar, IDNumberVar IDNumberVar = [IDNumberField]'Place the name of...- TyDeschaine
- Post #2
- Forum: Microsoft: Access Tables and Relationships
