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!
Search results for query: *
- Users: PrincipalFuller
- Order by date
-
Display a temporary query
Is it possible to display a query without saving the query? I would like to have a table with three fields: Query Name, Category, SQL And then in VB I want to grab the SQL from the table, run the query, and display the results... without needing to save each and every query that will be...- PrincipalFuller
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Do I need an array?
Thanks for the tips. If I open the second and third table as additional record sets instead of DLookup, I then would need to cycle through the entire table to find the match, correct? Or do I keep opening and closing the record set with a more specific SQL / WHERE. Or is there a way to have...- PrincipalFuller
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Do I need an array?
Current Code (that runs slow): Function VerifyStatuses() Dim stNotPPA Dim stNotOnDistList Dim stChangeToFree Dim stChangeToReduced Dim stChangeToFull Set db = CurrentDb() stFileName = Me![Text0] 'This is the file name to the Excel File. I would rather do it as a CSV if I can get it to work...- PrincipalFuller
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Do I need an array?
Good Morning, I'm somewhat of a novice in regards to VBA programming, but able to figure more things out. I'm writing a student management system for a school in Access, and I am writing a script that will compare three different tables, and make sure data is correct. I'm importing a file...- PrincipalFuller
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
