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

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...

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...

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...

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 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?

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?

Morning people of the Access World. I have a need to do a "Mass replace" to remove personal detail from a number of tables. For example:- I want to change all instances of the Name "Joe Smith" to "xyz" I need to do this across all my tables. Does anyone have a routine that can interrogate...

can anyone see whats wrong with this syntax =DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = " & [Report]![rptComplaintCustCAT3]![FAR Number]) this is entered in a report to get round the problem of the memo field being truncated. :banghead:

I have data table with a date field going back 2 years How can I get a count of how many records per week note:- some weeks may have no records and so I need to have a zero value My objective is to do a graph showing all weeks Thanks in advance

I am trying to modify VBA code on a form and for some reason the property sheet is coming up blank - in design mode I get literally nothing, just a big grey box I have exited access and repaired database Anyone seen this and ideas ??

Hmmm looked at various posts in here but can't get me code to work I an trying to filter records based on entered text in a box on the header so if the Doc No or Doc title contain the entered text it filters by it . . where am I going wrong??:banghead: Me.Filter = "[DocNo] like " &...

Hi Guys, I have the code below to open Word and Excel documents - does anyone know how to open Visio and PDF formats? Set oApp = CreateObject(Class:="Excel.Application") 'Create an instance of MS Excel oApp.Visible = True oApp.WorkBooks.Open FileName:=DocName 'Open...

I have a combo box on a form header to select a persons name to filter the data below but cant get the syntax correct - the combo box name is OwnerFilter Me.Filter = "Owner = OwnerFilter" Me.FilterOn = True this doesn't work - any help please

I've done a search but cant find an answer I'm trying to send data to a spread sheet to create a graph etc im using :- ' DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryCrosstab", "S:\Database\myspreadsheet.xlsx", True however when I re-run it creates a new tab - how...

I am trying to produces a monthly graph - however in the raw data there is not data for Feb how to I get it to show JAN FEB MAR APR with 0 for Feb rather than just JAN MAR APR ????