Recent content by superchrisdub

Hi, I have a database that creates a temporary database in Access 2016, in the current direcory (where the front end db is located), to hold temporary tables. One of the directors of the company sometimes works from home using a Mac with Office 2016 on it. I have heard that Mac puts the db in a...

Thank you, JHB. That did the trick perfectly.

Hi, The filter is applied using the options available when you click the down arrow on a column, e.g. click the down arrow in the column header for Status and select only "Out of Force". At this point, The records are filtered to just show records with a status of "Out Of Force". I want all...

Hi, I have attached a screenshot which should make it clearer. If a user wants to filter on, say, the Status column for just records that are "Out of Force", how can you make the Selected column get a tick for all the filtered records, automatically, rather than the user having to press the...

Hi, I have a form within which there is a subform. The recordsource for the subform is a table with a Selected (Yes/No) column. So if you want a record to be included in the processing then you just put a tick in the Selected column. What I want is, if a user applies a filter to the subform...

Hi, thank you everybody for your informed help. I discovered, via the trial and error method of undoing (using system restore) any recent updates, that the problem was a recent update from Hewlett Packard to my Pavilion laptop. Once I had undone the update the code worked fine. The only...

Hi, I have a Form with a button that causes a copy in pdf format to be attached to an email, awaiting the user to fill in the To: section and any other he chooses, using the following code: DoCmd.SendObject acSendForm, frm.Name, acFormatPDF, "", "", "", _ "New Client Referral"...

Hi, I have a form that has client details on it, searchable by surname. One of the fields is the client’s partner/spouse. If double-clicked this should bring up a new instance of the same form, filtered on the spouse’s unique id. How can I achieve this. I have tried the following: Dim frm as...

Hi, I am having problems with requery not working on forms. Sometimes it works and sometimes it doesn't. I have tried to see a pattern to when it does not work but cannot. It is driving me nuts. I am reasonably new to Access vba but am an experienced programmer. The situation is, the following...