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!
-
Access 2000 VBA SELECT / WHERE (multiple)
Multiple WHERE arguments. I have seen multiple WHERE values used but I am having problems getting VBA to accept my attempts. Does Acess/VBA support this option? My code looks like this: strSQL = "SELECT * FROM [Recruitment Event History] WHERE Recruitment_Location_ID = " & intLocation...- DWSwaim
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access 2000 VBA
strLocation = qdfstrTemp!Recruitment_Location_Name Did not work but I may have some other coding to do for it. strLocation = DLookup("[Recruitment_Location_Name]","[Recruitment Locations]","[Recruitment_Location_ID] = " & intLocation) worked as is.... Thanks- DWSwaim
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access 2000 VBA
I need to assign a value from a temp query field into a string variable to be used in the sub. Any ideas? Here’s the jist of my code: Set dbsDatabase = CodeDb strSQL = "SELECT Recruitment_Location_Name FROM [Recruitment Locations] WHERE [Recruitment_Location_ID] = intLocation" Set...- DWSwaim
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Access Click Event Listener
Environment: I am working in Access 2002. In the main switchboard I am coding a subroutine for one of the buttons. Among other things, this button activates another form to get user information before proceeding. Problem: Can I code a listener in a subroutine to begin once the OK button on the...- DWSwaim
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
