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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
No records when additional field added to RunSQL command.
This works both out of VBA and in Access: query = "SELECT DISTINCTROW Unitholders.[Unitholder ID], Unitholders.[Do Not Mail], Unitholders.FirstName, Unitholders.LastName, Unitholders.[E-mail], Unitholders.[E-mail2], Accounts.[Account Name], Accounts.[Account Type], Accounts.Institution...- mcke1610
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
No records when additional field added to RunSQL command.
Basically the VBA query is creating a table that is later referenced by other queries in Access proper. For the above SELECT query, when I'm in Access, data shows up no problem. When I DoCmd.RunSQL out of VBA on the same query nothing happens. I step through the code and the table doesn't...- mcke1610
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
No records when additional field added to RunSQL command.
It's bizarre. When I copy and paste the query to SQL view and then preview it, all of the data is there. For some reason though the exact same code won't work out of VBA.- mcke1610
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
No records when additional field added to RunSQL command.
The following has no problem gathering records and inserting into a new table. Dim query As String query = "SELECT DISTINCTROW Unitholders.[Unitholder ID], Unitholders.[Do Not Mail], Unitholders.FirstName, Unitholders.LastName, Unitholders.[E-mail], Unitholders.[E-mail2], Accounts.[Account...- mcke1610
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
