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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I setSortOrder for 2 fields on my Access form?
PH, Where in the code would I put that in?- CHPD
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
How do I setSortOrder for 2 fields on my Access form?
How do I use SetSortOrder for 2 fields? I need to sort Last Names first, they sort by First Names.- CHPD
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using option group w/vb code to filter lname, turns data into numbers?
I removed the option group and replaced with the following code: If DCount("strLastName", "tbltest", "strLastName like 'C*'") > 0 Then Me.Filter = "strLastName like 'C*'" Me.FilterOn = True Else MsgBox "No records exist" End If End Sub The code works...- CHPD
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Using option group w/vb code to filter lname, turns data into numbers?
The form I've build contains an option group with vb code to filter through the last name records for end user ease. The code to filter works, however when searching and viewing the data the last name field on some of my data changes to numerics. See code below: Private Sub...- CHPD
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Need help rebuilding database in Access 2002
If I'm reading your post correctly this should help? If you just want to view your data in order you can click on the sort ascending icon on the toolbar. The icon has the letters A & Z with an arrow pointing down. Hope this helps.- CHPD
- Post #2
- Forum: Microsoft: Access Forms
