Search results for query: *

I apologize for not giving you guys more attention, but my primary job function is not a database administrator/programmer, and as this is a side project my main responsibilities sometimes take precedence. As I explained before in a previous post "I haven't had a chance to work on the...

I haven't had a chance to work on the ideas posted here, but the issue I'm having is that I have to hard code in stuff and that limits the number of columns I can have. Example, the number of columns comes back to be six, so I have to put up a total of 12 objects into my report in addition to...

Michael, No, I can count the columns easily simply using a record set based on that particular entry in the database. Based on the "Sequence" value I can count how many of these items are in that sequence and the columns can be set accordingly. I'm having trouble with several...

Where'd you go? thx! Q-

I think if I can automate the 'number of columns' (easy to do with a recordset) value I might be able to leverage your code. I looked at this before but dismissed it as not being usable in my situation. I don't remember exactly why so I'll review your code again. Thanks! I'll get back to...

I have a crosstab query that has different numbers of columns depending on one field in the query, called "Sequence". Depending on the value of Sequence (an integer), there could be anywhere from 3 to 15 columns. I'm trying to create a report from VBA code using DAO to find out how...

Works like a champ! Thanks! thx! Q-

I have this ridicoulous code here: Select Case intStepCount Case 1 S1 Case 2 S2 Case 3 S3 Case 4 S4 Case 5 S5 Case 6...

Ahh, it's in the Report Open section. Thanks... thx! Q-

Speaking of opening a report, is there a way to put the query for the report source into the module of the report? thx! Q-

Plain as day, bro. :) thx! Q-

I guess my confusion is where Access will accept references to collection items, and where it needs hard coded values. I just build all my queries in the query builder and then copy them straight over to VBA code when I need to. thx! Q-

I see what changed, but I don't understand why it was necessary to move [Forms]![frmPQSelDld]![txtSuSiD] outside of the quotes. Can someone fill me in here? thx! Q-

I'm using Access 2002. thx! Q-

Actually, I figured this one out. I'd started another thread and posted the answer there. Answer: You have to use the CreateGroupLevel method. It's in the help file. Easy peasy. thx! Q-

I would like the report to print down, then across. However, I only want one record per column, even if it's only 3 rows (there will be a lot of text in each record). So when one record has finised I want the report to not start another record in the same column, but go to the next column and...

Answer: You have to use the CreateGroupLevel method. It's in the help file. Easy peasy. Someone give me a star! thx! Q-

I'm writing a report by using code (I have my reasons...). The problem I'm running into is that when I try to put a label in acGroupLevel1Header I get the error "Run Time Error '2148': The number you used to refer to the form or report section is invalid." The code in question is...

Ronald, I'm having a similar problem, well, maybe not similar. I'm doing the same thing, writing a report by using code (I have my reasons...). The problem I'm running into is that when I try to put a label in acGroupLevel1Header I get the error "Run Time Error '2148': The number you...

Hmmmm, that stinks. :( Thanks for your help! thx! Q-