Search results

Thank you Uncle G and Steve for your responses. With regards to loading into excel first, I'd like to steer away from having to open another program. My ideal solution would be to mail merge directly from Access in to Word. With regards to the PDF link, I followed it to the tee, but to no...

Hi, I have been able to successfully mail merge text and date fields from Access to a Word document. However, I have a hyperlink field which does not appear to merge correctly. In the DB I have edited the hyperlink to have a more convenient name by setting the Text to display option to...

JHB, Thank you VERY much - that has worked a treat. I've check previous versions of my DB and the "[Session Record]" was not in the SQL-string; not sure how or why it appeared :/ Thanks again.

Hi The_Doc_Man, I don't think I'm mapping an excel file. Table 1 (where I'm appending from) has 23 fields Table 2 (Where I'm appending to) has 42 fields (23 of which it has in common with table 1) Both tables have a relationship with Tables A, B and C where they have one field in common.

INSERT INTO [Session Record] ( Reference, PPSStatus, AddSession, AccountNumber, Customer, EmailAddress1, Emailaddress2, StudentNumber, StudentName, StudentCal, TutorNumber, TutorName, Email, TutorCal, [Day], StartTime, FinishTime, Location, ClosedRemarks, OpenRemarks, UnitAmount, TutorRate...

Hi, I'm new to Access (i.e. have limited knowledge and experience). I have an append query in place which has worked previously, but seems to 'have lost its way'. The table I'm appending from has 71 records. When I run the query, the message reads: " You are about to append 21868 row(s)"...