Hi Pat, I've got some sample code for building the parameter query into the VBA, will that be ok on it's own? (are you comfortable with building the recordsets etc if I give a brief description of what's needed?)
Owen --- In [email protected], redpatski <[EMAIL PROTECTED]> wrote: > Thank you. Do you know of any code samples that do this...either > here, in a book or on the Internet? It would help if I could dissect > some similar code. I can't find any examples that match these > requirements. > > --- In [email protected], "owen_group_profile" > <[EMAIL PROTECTED]> wrote: > > Hi, > > > > you need to use the VBA along with a parameter query. > > > > Move through your division name table, at each record storing the > > uniqueID / division name to a variable, and then open/print a query > > based report where the query parameter refers to your stored > variable. > > > > hth, > > Owen > > > > > > > > --- In [email protected], redpatski <[EMAIL PROTECTED]> > wrote: > > > Hello, I have a challenge I'm hoping someone can help me with. I > have > > > one table which has a list of our divisions. Then I have some > code that > > > runs a series of data manipulation queries for a division, > resulting in > > > a report at the end. I want the code to do the same procedures > for each > > > division, processing each of them separately. > > > > > > What is the best way to do this? In other words, I'm passing the > > > division number as criteria for the query, one division at a time. > > > > > > I've tried a number of options but I'm only confusing myself more. > > > Might say I'm getting "loopy". > > > > > > Thanks for the help. Much appreciated, > > > > > > Pat Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
