Search results

  1. Y

    Filtering form

    How do you filter a form by combo boxes and list boxes? I I have one table and is how 26,000 account numbers. Each account number is grouped by the first 4 digits. Another problem I am having in every month an Excel spreadsheet gets imported to Access. This group of account numbers do not...
  2. Y

    How do you embed a browse file directory?

    Right now I have to go to each user and put in their path to import the spreadsheet into Access. I want to know if anyone knows how to let the user browse or use Windows Explorer to find the spreadsheet in the TransferSpreadsheet action? Here is the code...
  3. Y

    Delete records automatically frm table

    How do you have Access delete records automatically from a temp table?
  4. Y

    Delete records automatically frm table

    How do you have Access delete records automatically from a temp table?
  5. Y

    Checkbox w/ Date Stamp

    I have a main form that has Vendor Number and Vendor Name. Then I created a subform that has the invoices attached to that particular vendor. I did create a checkbox labeled Paid. When a user puts a checkbox in I want Access to put Today's Date in the DatePaid field in the invoice. Another...
  6. Y

    Update query question

    I have three tables. I have Vendor Name table w/ vendor#(p-key), vendor.I have a VendAlias table that has Vendor, Vend#(both fields are p-key). They have a one-to-many relationship. Next , I have an invoice table that has stmtdate, posteddate, transdate, Vendor, Vend#. I want Access to fill...
Back
Top Bottom