Search results

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

I have a bunch of data and I want to create totals per month. When I use the cross tab it works fine BUT if there is a month with no records it misses the month out rather than reporting Zero. Is there an easy way of including a zero?

Many thanks everyone now sorted - syntax is the worst thing ever. Its like learning another language #lols

can anyone tell me what wrong with the syntax of this please code Me.Filter = ("[DocNo] like " & Chr(34) & "*" & Me.search & "*" & Chr(34) & " " & "OR [DocTitle] like " & Chr(34) & "*" & Me.search & "*" & Chr(34)) And ([Doc Status] like 'Active'" /code regards Adrian

this is basic I know but I have never done it I have a piece of code I want to repeat many times rather than enter in every files / form how/ where do I store it and how do I call it is it a module? if so is public sub / public function the right way? a quick over view of this would be...

Hello, I'm using Access to control .docx documents and I want to copy a document and then add a "DRAFT" watermark into it. I have copied fine but is there a bit of code that can add the water mark?