Recent content by shevo

Thanks, I will give it a try.

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

Works perfectly...A thousand thanks to u!:)

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.

Where do I query the field? I found this DLast function. Does it works? Gave me error when I only wanna try to get the value of the last record.

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!

Thanks, it works.

Thanks for the prompt reply, but output textbox which display "Expired" doesn't change as I scroll through each records.

I can't seems to see the change as I scroll through the records. Is there any problem with my code as I need to display the current status for each record in the form as "Expired" or "Not Expired".

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

The is no 1-m relationship. Both table are similar in all fields. They are manually link in the query view by a unique id field. One list is a current list with old records and the other one is with new records therefore I need to check for unmatched to get the new records that is not in the...

Because the administrator in my office never install the wizard option

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

Thank You very much, Bob.

Ok lets say now Title Quantity BookA 2 BookB 1 BookC 5 BookC 3 BookD 1 How do I get BookA 2 BookB 1 BookC 8 BookD 1