If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Newbie Access Programer
Hi
I have several years experience with Excel VBA I'm hoping someone can give me a kick start with access VBA example code for the following simplified example: tbl_Fruit has 2 fields: WeekNumber, Fruit (4 varieties) QueryFruit has CountOf Fruit for a specified WeekNumber How would I cycle through many week numbers and output and capture the query result for each? Thanks |
#2
|
|||
|
|||
Newbie Access Programer
If I understand what you are wishing to do, take a look at
http://www.devhut.net/index.php?lang...000011#recsets simply replace the Table1 with your query name. If this isn't what you are looking for, please explain your needs further. -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "David" wrote: Hi I have several years experience with Excel VBA I'm hoping someone can give me a kick start with access VBA example code for the following simplified example: tbl_Fruit has 2 fields: WeekNumber, Fruit (4 varieties) QueryFruit has CountOf Fruit for a specified WeekNumber How would I cycle through many week numbers and output and capture the query result for each? Thanks |
#3
|
|||
|
|||
Newbie Access Programer
With your background, you also need to keep in mind that Excel VBA and Access
VBA are not the same language! Some functions are available in both and some aren't, and some with the same exact name work differently, depending on whether it's Excel or Access. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201005/1 |
Thread Tools | |
Display Modes | |
|
|