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 strongm 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: NathanStone
- Order by date
-
@ ----> Compile Error - Argument No
do you need the square brackets around the field names in the array? you could try removing square brackets and changing the line ... sql = "SELECT DISTINCT " & A(q) & " FROM qrySoftwareTracking" to sql = "SELECT DISTINCT [" & A(q) & "] FROM...- NathanStone
- Post #8
- Forum: Microsoft: Access Modules (VBA Coding)
-
@ ----> Compile Error - Argument No
you will have problems with both the test ... If .Fields & "('" & A(q) & "')" <> "" Then and the action ... Me.cboITJobNo.AddItem .Fields & "('" & A(q) & "')" try changing both lines to ... If .Fields(A(q)) <> ""...- NathanStone
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
@ ----> Compile Error - Argument No
try this instead ... If .Fields(A(q)) <> "" Then or this ... If .Fields(A(q)).Value <> "" Then- NathanStone
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
