A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Newbie Access Programer



 
 
Thread Tools Display Modes
  #1  
Old May 13th, 2010, 01:55 PM posted to microsoft.public.access.gettingstarted
David
external usenet poster
 
Posts: 1,494
Default 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  
Old May 13th, 2010, 02:06 PM posted to microsoft.public.access.gettingstarted
Daniel Pineault
external usenet poster
 
Posts: 658
Default 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  
Old May 15th, 2010, 12:09 AM posted to microsoft.public.access.gettingstarted
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.