Recent content by YamiMarik777

  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

    delete query - simple but i dnt get it?

    See, I am trying to make a code that imports records into a existing table called tblInvoices from Excel spreadsheet. Then I want Access to delete records automatically from the tblOldInvoices table. I want this to run with a click of a button on my switchboard. This will be done by user every...
  6. Y

    Updating Email address in Customer List

    How do you use that example in a LIKE parameter for criteria. For instance if the letters HP are found in another field in table like HP Services, automatically put in VendNum from Vendor table into that table???
  7. 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...
  8. Y

    Date Stamp for CheckBoxes

    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...
  9. Y

    Update query question

    Thank you for replying. These are things I want Access do. I want the user to be able to check a box off to show the Invoice is Paid and in the datasheet put in Date/Time in the DateModified and TimeModified field. I want to be able to print out a report that shows all invoices paid and...
  10. Y

    Update Query based on a separate Table

    Reply;creating update query I tried your example on mine, but I got an error can't update all records in the update query. My design is this. I have a VendAlias table (this list all different names that a particular vendor appears on each invoice. Then I have an Invoice table(Similar to a...
  11. Y

    Update query question

    Re: Pat Hartman Thank you for the into. I need more explaination of combo. Do you mean create a combo box in report design view??
  12. 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...
See more
Back
Top Bottom