Search results

  1. W

    Can't get field to populate after calling qry

    I have a frmScan that has 2 fields. One is a txt.description - control source is tblPrtChoice.Description The second is me.txtscan and is looking for operator input that triggers a qry to run and print a label (quick screen says printing) then returns to the frmScan. The problem is that when it...
  2. W

    Public Function needs to make a decision

    I have a table called tblConfig. I need to make this function (Public Function ExportBatch()) to make a decision based on whether the tblConfig.UseServer is true or false. If True it should run Export-FORM. if False it should run Export-FORMServer. I'm new and not sure what I'm doing wrong...
  3. W

    How to choose a label template to be used as the default in application

    I wrote an app that scans a barcode and prints to a label printer. In the beginning, I want to choose which label template/report I want to use from tblReports and set the choice as default until changed by user. The choice takes place in a frmSetConfig a list box named lstReports that shows...
  4. W

    SQL ODBC Driver

    I have an Access 2007 application that uses the SQL ODBC driver. When setting up the connection to the sql db, there is a check box that says 'Use trusted connection'. If I check that box, package the application, and run on a new (different) WIN10 computer it will not allow the applications...
  5. W

    Can this be done with a query?

    I'm looking for a query to look at the invoiceNo and when it finds two that are =, look at the plu's. If they are = then delete one row and increase the Qty to 2. If there are 3 that are =, just count the first 2 and leave the third row alone. If there are 4 that are = then delete three rows...
  6. W

    Hi, New Guy Here

    Semi good at access, always looking for answers
  7. W

    Count product code in invoice in table

    OK, so I have a table called Pass1 In the tbl I have a field called InvoiceNo and a field called ItemNo and a field called LineNo. Explain: When a customer buys several items, each item is contained under the same InvoiceNo along with a unique LineNo. Example: A customer buys the same item...
Top Bottom