Recent content by Lanason

I have a button on a subform that updates the record in the subform. I also want to change a field in the main form at the same time. from the VBA code on the button in the subform, I have written "me.[frmMAIN]!{MainField] = "NewValue" doesn't work what am I doing wrong??? been going round in...

I currently write my pdfs using VBA to a local server but I want to adjust the one line of code to export to a SharePoint location is this possible? if so how?

Hello Everyone, I'm looking for some simple code to copy a ABC.docx into a ABC.pdf format . . I can do all the paths / filenames etc just need the bit to convert/export/save Thank you in advance

Ah that makes sence

worked fine in the query many thanks

I'm am doing in the form --- let me try in query

I am displaying two filed in a form but they are mutually exclusive so I want which ever has data when I display the fields individually [System] or [Software Name]) I don't get an error when I do this =IIf([Category]="GB",[System],[Software Name]) I get #error when I do this...

Thanks guys so what is the syntax exactly? is it ? GBL_Process = myrec1.Fields(fieldname)

Is it possible to use a variable instead of an actual filed name when getting data from a set of records GBL_Process = myrec1![Subject] where [Subject] is the actual Field name can I do something like FieldName = "1234" then use GBL_Process = myrec1![FieldName] where FieldName is a variable...

I am calling a module with this code in it DoCmd.OpenReport GBL_StDocName, acViewReport, , GBL_stLinkCriteria, acNormal DoCmd.SendObject acReport, GBL_StDocName, acFormatPDF, GBL_MailTo, GBL_MailCC, GBL_MailBcc, GBL_Subject, GBL_MailGreeting & GBL_MailMessage & GBL_MailSignature, True

Morning guys I have a routine that sends scheduled emails. It runs down a list of records (Myrec1) and runs those that need to be run. A parameter is set for selection criteria in a query. Some emails then have a sub routine loop (Myrec2) that then sends personalised emails to selected people...

how do I walk through with F8 ? there are always 31 records to run through what does Debug.Print do and do I insert in my code? you could be right about the ACTION etc but don't think so - may I comment all the commands out to prove this...

the "if else" at the end is me trying to debug it - it doesn't do anything. so to understand from the beginning it starts on the first record and processes round the loop until the last record. On the last record it should process it and then how does the movenext work as its already on the...

I have a routine that opens a form and creates emails and reports based up fields in the form (day of week etc). There are 31 possible reports. The routine has a sub loop in case a certain reports needs to be personalised from each recipient. I have a "call" that writes an audit trail during...

I am actually using rolling 12 months in the output