Search results

  1. L

    Solved Compile error: ByRef argument type mismatch with STRING INPUT

    Hi all :) I have a production tracking database that creates a new record every time a product is scanned into & out of a warehouse. I need to error-proof the system so a MsgBox pops up when an employee tries to scan a product into a warehouse when it hasn't been scanned out of the previous. I...
  2. L

    Solved VBA Export to Excel Permissions

    Hi all :) I am trying to create a button that, when clicked, opens a file dialog so the user can choose where to have "tbl_Transaction_Master" exported from Access as an Excel spreadsheet. I am getting the following error when I try and export the Excel doc to my desktop (my desktop folder is...
  3. L

    Passing Variable (Long) to SQL WHERE clause in VBA

    Hi all :) I am new to SQL in Access VBA, so I am unsure of some syntax. The code below is producing the following error at the "DoCmd.RunSQL (SQLForceScanOUT)" line: "Syntax error (missing operator) in query expression '[Transaction_ID]=&maxID&'" I imagine it has something to do with my...
  4. L

    String Variable for DLookup Criteria

    Hi all :) I have learned that the syntax for passing a string variable to dlookup criteria argument is the following: DLookup("[field-to-return]","table","[criteria-field]=' " & string-variable & " ' ") . I have tried to use this syntax to obtain "maxID" in the code below, however it returns an...
  5. L

    Solved DLookup Returning Null

    Hi all :) I have worked extensively with Excel VBA, but am having some trouble with VBA in Access, I hope you can help. A user inputs a product's barcode on a form (frm_scan_IN) then I am using a DLookup to return the category for the product ("ProductCategory"), based on the first few...
  6. L

    Solved SQL Select Query in VBA- How to view results

    Hello :) I am new to VBA/ SQL in Access and require some help. I am designing a production tracking database that records the date and time when a product enters a new workstation/warehouse. I would like to run a query through VBA which takes the product serial number that a user scans in and...
  7. L

    Solved Print SQL Select Result in VBA

    Hello :) I am new to VBA/ SQL in Access and require some help. I am designing a production tracking database that records the date and time when a product enters a new workstation/warehouse. I would like to run a query through VBA which takes the product serial number that a user scans in and...
  8. L

    New Member

    Hi all, I am a new member from South Africa. I am quite new to Access but have worked quite extensively with VBA in Excel and I have done some SQL before. :)
Top Bottom