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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nogarede

    requery not working

    Russ, it works !!! for years i cheated by doing "go to previous record, go to next record" until a colleague gave me this solution and it works. I have a form1 (order/Invoice) with a subform1 (list of articles ordered), I have a button that open a new form2 that display the articles, I...
  2. nogarede

    requery not working

    yes ! you are right, sorry ! you need to refresh form1. Set frmCurrentForm = Forms("Form1") Marc
  3. nogarede

    requery not working

    I had the same problem. The solution is to insert following code in the "on close" event of your Form2 Private Sub Form_Close() Dim frmCurrentForm As Form Set frmCurrentForm = Forms("Form2") frmCurrentForm.Refresh End Sub
  4. nogarede

    Hi, I have a form on it I have a

    simply: Like "*" & [Forms]![nameofyourform]![look up employee] & "*"
  5. nogarede

    How to use a bar code scanner in my access program

    the scanner will send data just as would the keyboard. Depending on the scanner you need a little interface program like BC-Wedge (www.taltech.com) which will make your scanner work just like info where entered on the keyboard (specially if the scanner is on port COM). Once the scanner works...
  6. nogarede

    Linking forms for sort or filter

    from [form 1] you open [form 2] on wich you display specific data. On [form 1] you add a command button that open [form 2]. [form 2] is based on a query. In that query, on the field you want to "select" or "filter" you add in the criteria (example) "Like...
  7. nogarede

    Forms w/ MS Access

    When I have to many fields and subform on a form I use the "tab control" tools when I create the form. It's simple, clear and standard. It allows you to have many pages, sort the fields by subject....very conveniant.
  8. nogarede

    Microsoft Jet Database Error!!!

    you must have had a corruption on your table due to a network problem while working on the database or a pc not shut down properly. Try to repair/compact the file. Try also to create a new file and to reimport all the table/query...etc

Part and Inventory Search

Back
Top