Search results

  1. S

    Mass Email Program

    I am sending out multiple emails to my customers in my customer table manually. As it is time consuming to send to about 100-200 customers daily, I am wondering if it is possible to automate the process in access in such a way that I can load all files from a particular folder and the access...
  2. S

    Event for adding new record

    What is the form event for adding of new records? I want to make some fields disappear to prevent user input when the user enter a new record.
  3. S

    Increasing value of last record by 1 automatically

    How can I increase the value of last record by 1 automatically whenever I enter a new record? I am not using autonumber for my primary key to uniquely identify each customer. I have used Text as the datatype. The format is e.g. CN001 for the 1st customer. Please help.....Thanks!
  4. S

    New to VBA

    Hi, I am using VBA for the first time. I am trying to check for expiry date as I move through each of the records. However I am not sure how to go about doing that. I have only put the codes in the Form load event and I can't seems to find any Form change event or record change event. Appreciate...
  5. S

    Unmatched query without wizard

    How to I find unmatch records between 2 related tables without using the default unmatched query wizard in access?
  6. S

    Count the Distinct items

    Hello all, I am new to this forum. I have this problem where I need to sort the 4 books in the tables below according to the highest quantity of book sold.In this scenario, Book C would be 1st in the table with a total quantity of 8. How do I write a query in access to perform such operation. I...
Back
Top Bottom