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!
-
Filter a subform from a selected value in another subform
Thanks, lameid. I will try the .Recordsource method. Thanks for your help!- Bigwiggz
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Filter a subform from a selected value in another subform
Hello Everyone, I am new at using VBA but I am trying to filter a subform based on the selected value of another subform. Currently, I have it in a button "btnTestFilterPersonell" but I am noticing 2 things in particular. Private Sub btnTestFilterPersonell_Click() Set db = CurrentDb Set rs =...- Bigwiggz
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
-
Sorting Addresses
I entered the following code in the SQL View as follows ORDER BY Mid(Address, InStr(Address, " ") + 1), and I replaced "Address" with then name of the column "Direccion Completa" which in Spanish means Complete Address. I put this line of code directly after the existing code so it reads as...- Bigwiggz
- Post #3
- Forum: Microsoft: Access Forms
-
Sorting Addresses
Hello, I have an access database and I would like to sort the addresses by Street Name first and by Street Number second such that the addresses will appear as the example below. 12 Leaphart Road 24 Leaphart Road 11 North Lucas Road 79 North Lucas Road 289 Parson Street 297 Parson Street...- Bigwiggz
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
