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 Rhinorhino 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 techsup07

  1. techsup07

    not sure how to use GroupSort

    gawd! i'm an idiot! took just a sec to update that which was the easiest thing and right in front of me! it takes someone else to point out the obvious! i can't believe I've spent this time and everyone else's for being shortsighted! it seems I always end up doing it the hard way when all...
  2. techsup07

    not sure how to use GroupSort

    Ok, i'm thinking this won't work with what I have. I am using a calendar form which has to be opened then I generate the Report. The report displays exactly as it does on the form. to make this simple or easy for me to try and explain ... The ADD form where the schedule is entered displays the...
  3. techsup07

    not sure how to use GroupSort

    Hi Max! humh, ok, not sure but I got a Compile Error: Syntax error
  4. techsup07

    not sure how to use GroupSort

    I have the following code in my report module as the report is generated with VBA based on the data on the form. ' Select Case Forms!frmScheduled!grpSort ' Case 1 'Name ' Me.GroupLevel(0).ControlSource = "ScheduleDate" ' Me.GroupLevel(1).ControlSource = "What" ' End...
  5. techsup07

    MoveFirst problem ...

    I apologize as I thought I had answered your question on what I want the code to accomplish ... that being the report Detail Section is to display all the detail items in a specific format. Hence the OnFormat code to accomplish this. Because of the JOIN from the Detail_Inv to the Options table...
  6. techsup07

    MoveFirst problem ...

    ok, it took me several different ways to determine that what's happening is that in the order of the invoices, it came to one that the item is in fact missing the Options table and it won't print the rest of the invoices. How do I still make that invoice print and print the item even though it...
  7. techsup07

    MoveFirst problem ...

    humh, well, i got the 1st page to preview but can't print or preview add'l pages without getting the message. i'm not sure about your questions regarding the blank invoice? each invoice has various types of data, on the JOIN to the Options table though, I did find 2 invoices that each had one...
  8. techsup07

    MoveFirst problem ...

    Hi dhookom, sorry, I don't always know what's too much info or not enough info from lack of experience ... strSQL = "SELECT InvoiceNumber, SortOrder, Category, Items, " & _ "Format " & _ "FROM Details_Inv LEFT JOIN Options " & _ "ON Details_Inv.Item = Options.Items...
  9. techsup07

    MoveFirst problem ...

    now, more interestingly ... i was able to print the 1st page prior that message. But when trying to print or preview the 2nd page, i received Run-time error End of Record. This error was the first, then when trying to see what might be the issue and previewing the report again, am now getting...
  10. techsup07

    MoveFirst problem ...

    Hi, I am confused ... i have a report where the detail section uses a procedure. basically, the part of the code I am getting a Run-Time error '3021'. No Current Record Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim strSQL As String Dim db As DAO.Database...
  11. techsup07

    Suppress Detail section when Null?

    sorry, i do have the (). turns out it did not like 2nd, so i just change the textboxname to secondlevel instead of 2ndlevel and it works great! thank you very very much!!
  12. techsup07

    Suppress Detail section when Null?

    Hi Aceman1, i received a compile error on the [ME!2ndLevel] 2ndLevel is the textboxname of in the Detail section.
  13. techsup07

    Suppress Detail section when Null?

    that doesn't make sense to me as I want data as the current statement is of a Left-outer-join. I want everything in my BOM table and then all the data twhere it matches the BOM table of the components. So some may not have component items. Then the report prints the component items data of the...
  14. techsup07

    Suppress Detail section when Null?

    Sorry for the confusion, i need a code that will suppress the detail section ONLY when there isn't data. Of course I want it to display the detail section when there is data. Biggest reason for wanting to suppress the section when there's no data is because I have lines and the lines show when...
  15. techsup07

    Suppress Detail section when Null?

    Hi there. ok ... how do you do that? the Visible is only Yes or nO?
See more

Part and Inventory Search

Back
Top