Search results

I tried to set MS ACCESS to word 2016 reference to "..Open any code module and go to Tools/References and set a Word reference to your installed version..". I can't do that as there's no such reference can be selected. Pls. see the attached file for details. I downloaded them. They are the...

I welcome your example for working out to combine multiple rows of data to one recipient. Thank you again.

Thank you for the suggestion of bookmark, I've not used it. Would you show an exmaple of it. BTW, I've read the article from Microsoft https://support.microsoft.com/en-us/help/211303/how-to-use-mail-merge-to-create-a-list-sorted-by-category-in-word-2000. Can you work it out word merge a...

Hi, I've a mail merge work with MS ACCESS table with the following fields and values Teacher_Name Schedule Jeff Putman 2nd June, 2018 Jeff Putman 12th June, 2018 Jeff Putman 22nd June, 2018 Jeff Putman 30th June, 2018 Carl Trump 1st July, 2018 Carl Trump 11st July, 2018 Carl Trump...

Does anybody have suggestons?

Multi-cells to single cell Hi, I'm working on an excel file in which I apply a VBA to copy multiple cells (LastName, FirstName) & Paste them into a cell (Name) of a new worksheet. However, I have "Run-time error '438'; Object doesn't support this property or method" for the following...

Can't catch up. Do you have an example for this? Best.

Thank you for the suggestions. I'll study them. On the other hand, is the mail merge VBA a MS ACCESS software error? Should Microsoft take immediate appropriate actions for remedies instead of letting its customers working around the problem for alternative solutions?

Yours works fine. However, when I copied your mail merge document "Nomination Form.docx" to another name like "Nomination_Form_Re-Appointment_HCT" and applied the same query. It pops up "Confirm Data Source" again. What's wrong?

I'm working on MS ACCESS tables not EXCEL, is the link above useful for my working settings as well? Regards.

Currently, I did a form for values for "RankCode" selection. I also maintain several queries with each query a specified value for "RankCode". I wanted to maintain a single word form letter file for mail merge with all queries. How can I build the field holders in the form letter and apply...

Thank you for your suggestion. One of the query is shown below SELECT tblProcessTReAppt.TRef, tblTutor.UID, tblTutor.Title, tblTutor.LastName, tblTutor.FirstName, tblTutor.Alias, tblTutor.ClinicAdd1, tblTutor.ClinicAdd2, tblTutor.ClinicAdd3, tblTRank.HDesc, tblTAppt.JobPosition...

Hi, I do a form letter mail merge link a query by setting up a recipient list from Word -> Mailings -> Start Mail Merge -> Step-by-Step by Mail Merge Wizard ... -> recipient list. Then I save the linked table/query form letter. Now, I have several queries which will link this form...

Hi My application needs to do a mailmerge with home address or office address. The condition field is "PostToHome" [Y/N] which determines the mailmerge with either field "HomeAdd" or field "OfficeAdd" values. Is there any suggestions?

Thank you for your suggestion. I've created a new document for it. The result is the same that I cannot mailmerge with that query from VBA.

Does anybody have suggestions on this weird problem? I've updated my application as attached. Thank you in advance.

I use MS ACCESS vba to do mailmerge word documents with the following queries (qryTReapptNomination_HCAP) and (qryTNewNomination_HCAP) separately Run frmReport Re-appointment - > Honorary Clinical Assistant Professor It works fine with qryTReapptNomination_HCAP Its query structure is shown...

I surrender. I use inner join instead. It works perfectly. Thank you.

With the construct above, it runs into the following error Run-time error '3073' Operation must use an updateable query Any further suggestions Thanks in advance.

I'm working a ACCESS VBA to update a table column from another table with a condition. sSQL = "UPDATE tblTutor SET tblTutor.FirstAppt = SELECT ApptDtStart FROM tblProcessTNewAppt WHERE tblProcessTNewAppt.ID = " & !ID CurrentDb.Execute sSQL However, I got the syntax error msg of "Run-time...