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!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Quintios

  1. Quintios

    Create Report from VBA Code

    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...
  2. Quintios

    Create Report from VBA Code

    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...
  3. Quintios

    Create Report from VBA Code

    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...
  4. Quintios

    Print One Record Per Column

    Where'd you go? thx! Q-
  5. Quintios

    Create Report from VBA Code

    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...
  6. Quintios

    Create Report from VBA Code

    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...
  7. Quintios

    Put Code On The Same Line

    Works like a champ! Thanks! thx! Q-
  8. Quintios

    Put Code On The Same Line

    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...
  9. Quintios

    Help with Recordset Problem - Syntax?

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

    Help with Recordset Problem - Syntax?

    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-
  11. Quintios

    Help with Recordset Problem - Syntax?

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

    Help with Recordset Problem - Syntax?

    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-
  13. Quintios

    Help with Recordset Problem - Syntax?

    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-
  14. Quintios

    Print One Record Per Column

    I'm using Access 2002. thx! Q-
  15. Quintios

    createcontrol type mismatch

    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-
See more

Part and Inventory Search

Back
Top