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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by REMark516
-
Reusing DAO variables within one sub procedure.
Richard thanks for the sample code, I was reading more on coding techniques and found an example using action queries that I can use which will simplify a solution for me. The primary driver being that action queries do not have to be constructed using DAO, only Select queries need DAO...- REMark516
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Reusing DAO variables within one sub procedure.
Richard, thank you for the prompt reply. I noticed my inappropriate use of the set sql=nothing after i posted. (My code never compiled that far down to throw an error.) I agree, I sure don't see anywhere i'd ever use logic like this again. (This is for a dart league statistics database) The...- REMark516
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Reusing DAO variables within one sub procedure.
Hi, I'm writing a procedure which has to make multiple queries to the same table multiple times. I'm opening, closing and using set <var>=nothing with each use. I get an error <Compile error: Duplicate declaration in current scope.) the second time I try and open a connection to to perform my...- REMark516
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
