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!
-
HELP! Struggling with looping thru tables
Can I do that? This is going to be part of an automated process. I am creating a job to run monthly to copy contract numbers from one database to another. You gave me an idea, although I may need more help. Is that oK?? Thanks- Andande
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
HELP! Struggling with looping thru tables
I have 2 tables that I'm trying to loop thru. I grab the contract number from the first table and loop thru the second table to see if I find it there. If not, then move to the next contract number in the first table and find it's match in the second table and so on. Once I find the match, I...- Andande
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Pass parameter from VB form to Access report
In my vb project, I have allowed the users to view several reports thru access.....The reports in Access are tied to parameter queries. The main form in my vb project has a combo box filled with dates. The date selected is the parameter that I want to pass to the queries and reports in access...- Andande
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
Parameter query
I have a query in Access that get's it's info from linked DB2 tables. I'm trying make it a parameter query (different date needed everytime it's run). The problem is that it won't run....I get ODBC-call failed error message every time. Query works fine when I specify a date in the criteria...- Andande
- Thread
- Replies: 0
- Forum: Microsoft: Access Queries and JET SQL
-
Parameter query
I have a query in Access that get's it's info from linked DB2 tables. I'm trying make it a parameter query (different date needed everytime it's run). The problem is that it won't run....I get ODBC-call failed error message every time. Query works fine when I specify a date in the criteria...
