Search results

Thanks Paul. Thought it might be something like that, I am in my early 70's and cannot think as quick and logically as I used to do. Added the single quotes around the string strList and all now works fine. Fantastic forum. Kind regards, Syd. :):)

Thanks Paul, I have done that previously and this is the result: UPDATE tblBMFAAchievementsSubPage SET Examiner = BCRO, JEXT WHERE BMFAAchievementDBID = 4 AND BMFAID = 3 ; I am not sure if there is something missing before the 'WHERE' statement. The BCRO and JEXT should be the value that will...

I have created a SQL statement to update a table but I receive an error "Runtime error '3144' Syntax error in UPDATE statement" in the code. I am not sure if the statement is correct, have I missed something?. The SQL statement is; sqlExaminerUPD = "UPDATE tblBMFAAchievementsSubPage SET...

Hi The_Doc_Man, thanks for the reply. I use the "On Got Focus" event of the datasheet text box txbExaminer to trigger the loading of the Multi-Select form. When the form closes the focus is returned to the txbExaminer text box on the datasheet. I am now looking at methods for referencing the...

Yes, The_Doc_Man I am trying to update a selected record in a datasheet from another form when the close button is clicked. Sorry about all the garbage in the first post tried too hard to get all the facts together.

Hi, I hope someone can help me solve this problem with my database. I have tried many approaches without success. I have a database with a main form called “frmMainDB” and on this form is a tabbed control called “TabControl1” with four tabs associated with this control. The problem is on the...

Bring Outlook 'Select Names Dialog' to front when selecting from Access 2010 form Hi, I have written the following code to open the Outlook 2013 'Select Names Dialog' with a command button called 'btnTo' from an Access 2010 form, this code works fine to display the dialogue box but it is...

Hi, I have written an Access database for my local flying club for membership. Within this database is a form which is used to e-mail pre-defined reports to members. On this form is a button called 'btnTo' which is used to open the Outlook address book, the code under the button has worked...

Hi Paul, Thanks for the info, that worked great. Created the required reports for the queries, formatted the report then created the report in PDF and attached the MS Outlook mail. Thanks again, Regards, Syd Champkin.

Hi, Is it possible to format a PDF document created in MS Access i.e. set the document to landscape instead of portrait as in the following code; DoCmd.OutputTo acOutputQuery, "Query Name", acFormatPDF, "Document Name", False This PDF document is attached to an MS Outlook e-mail and sent...