Search results

I have a vba code that displays a table in an email body, but now I have to group accounts so it looks like: CCRT# 1234-01 ACCT# 4567 Trans# | Trans Date | Item | Reference | Amount # | x | x | x | $ CCRT# 1234-01 ACCT# 8970 Trans# | Trans...

Good Day~ I have used the DoCmd.RunCommand acCmdAddFromOutlook, but it does not capture every field value. Can the acCmdAddFromOutlook be ran in a vba code? I want to get one contact's information into the access table. Please advise. Thank you in advance~mjc

Good Day~ I have a form with two listboxes. Each list box is based on a query and changes values when selection is change. Only the first column is visible and there are 3 more columns I get values from to update a table. I need a vba code to get one listbox column values so I can put it in...

Good Day~ I have a class roster and need vba code to print a first day package of forms. I want them to print each person's package then move on to the next person until the roster has printed each person's package. Any help would be appreciated~mjc

Good Day~ How can I search through a table and if the record on a main form has certain words it will save a note in a record on another table Any help would be greatly appreciated~mjc

Good Day~ I want to send an email to each division with a pdf attachment. I have output each division's report into a folder but now I don't know how to send each one to each division's email address and attach each of their report. I want to send one email with pdf to one email address...

Good Day~ I have a listbox on a form, I want to select either one or all divisions and have a command button email each director a report with just their information but also a company roll-up in the body of the email. I would like to use VBA. Any help would be much appreciated.

Good Day~ I have a form that need to calculate actual age of a newborn and premature age of a newborn. I have attached the instructions and I cannot figure out how to make vba do the premature part. Any help would be much appreciated~mjc

I have two fields on the main form and I need a total count of records between the value of the two and then enter the total in a bound field on the main form