Search results

  1. A

    Printing Sub-Form

    print Hi Smart or anyone who else that can help. I have ammended Gromits example and have tried to do the view a report like Smart has mentioned. However when I do it - every record is shown on the report not just the filtered records. Please help I can't see how my version differs from...
  2. A

    report from a sub form help

    Hi Can anybody else. Refering to gromits database example http://www.access-programmers.co.uk/forums/showthread.php?t=99353 I am trying to import the subform table into a report. I have tried Dim stDocName as variant stDocName = "Invoice Query" DoCmd.OpenReport stDocName, acPreview...
  3. A

    Search Form Example

    error on report Hi Gromit or anyone else that can help. I have tried creating a report using the code you said but i am also having the same error message as sumone else. error: Sytax error (missing operator) in expression query Why is this? Thanks in advance
  4. A

    Clearing a textbox in a form

    Try this Private Sub "nameofbutton"_Click() Dim intIndex As Integer cylindernumber = "" End Sub I think it should work Andy
  5. A

    Form/Sub Form Help

    Thanks for the reply!! Thanks for the reply!! I really am a novice at this stuff, so sorry to be a pain with my questions. Can I see if i've got this right? So I have my txt box called InvNumber Where do I put the global variable code, can i insert it anywhere in the rest of the code? And I...
  6. A

    Form/Sub Form Help

    Hi I'm really stuck please help. I have a Table (Invoices) including field (Invoice Number) a form (Main Menu Search) with a txt box search on it (txtInvoice_Number) On the form I have a subform (subfrmInvoices) What I want to do is: * User types in text box what Invoice Number is * Clicks...
  7. A

    Help with search box

    Hi I've had a go but am still struggling. Would some body mind filling in the code on the attached database for me. So I could have a look at it and see how it works???
  8. A

    Help with search box

    I'll give it a go but i'm a bit of novice to say the least. Thanks for your help!
  9. A

    Help with search box

    Hi, Wondered if anyone could help me?? Am looking to use the Invoice Number Search from the Main Menu Form in the attached database? So that if a user searches for an invoice number and it is not in the table. The user gets a txt box stating that the Invoice Number "Is not Found!" and is...
Top Bottom