Search results

I have added:- DoCmd.RunCommand acCmdSpelling after updating a memo field - if there is a spelling mistake then the box pops up for the corrections. However is there a way of supressing the "spelling complete" message if the spelling is OK?

:banghead: I am creating and saving a pdf version of a report and then opening for viewing In the viewing I can use the "ID" no to link it, but in the Docmd.OuptutTo I can't see where in the syntax I can put the equivalent of "[ID]=" & [ID], can anyone help?? ReportName = "ABC123"...

Final stupid question on my nested loop How do I put a variable into the form name to replace frmABC (as I get this from my data) myrec2 = Forms!?????.Recordset

End If myrec1.MoveNext End If End If Loop End With Close worked - it was about positioning - thanks

thanks buddy I will test on Monday when back:D

don't I need it ?? If I take it out I get "Do without loop"

I have some code below that generates emails for me - it includes a nested loop. Since the Reports definition allows both sent to a pre-defined mail list - or has a nested loop to send a customised report to specific users When I try and run I get error message "Loop without Do" I cant see why...

I have a linked excel spreadsheet to my database but now I want to IMPORT the data into an access table The spreadhseet is linked to queries - what is the correct sequence to replace the linked excel with the new table?

Thank you guys

Thank you guys - I was trying to get away from creating a separate query / report and use a generic report with no parameters hard encoded

I am automatically send a pdf report in an email does anyone know how to send a selection parameter to select just particular record from the report?? DoCmd.SendObject acReport, StDocName, acFormatPDF, MailTo, MailCC, MailBcc, Subject, MailGreeting & MailMessage & MailSignature, True Thanks...

thanks - how do I open a folder ??

Is it possible to open a word document and/or to open a folder from a button in access?? what is the syntax / command pleas

Of course, Silly me, it was in the Form design #Obvious Thanks

I've put in an "if" statement and forced the pdf format which now works ok However the original data form opens in "filtered" mode StDocName = "frmReportsInternal" DoCmd.OpenForm StDocName, acNormal, "", "", , acNormal how can I force to open all records

It works with RTF

still says "the format you are trying to output the current object is not available" strange but true - (access 2010 by the way)

thank you chaps - i will try this tomorrow

here is an odd one ...... this works DoCmd.SendObject acReport, ReportName, acFormatPDF, SendTo, SendCc, SendBcc, Subject, Message, True, "" but this doesn't Dim MailFormat As String MailFormat = myrec![MailFormat] ' MsgBox MailFormat...

thank you now working