Recent content by Chris Morris

We have a SQL Server back-end and about 30 Access front-end applications. We use one library file to handle common functions which is included in each of the front-end applications. A problem I have is, sometimes in a library function I would like to make use of a DLookup which examines one of...

Thanks for that - it certainly gave me some leads, but it still didn't like it. I've got round it by opening the subform as Hidden, changing its Filter setting to the stCriteria, closing and saving and then running the main report. It's slightly messier than I thought it would be, but it works...

I have a report which is opened using a DoCmd.OpenReport. There's a criteria string which filters the main report - this works fine. There's now a requirement to place a summary subform at the beginning of the report, in the report header. I need that summary to use the same criteria string as...

Thank you for your responses, I'll have another experiment. C

Hoping you can help. I'd like to use DLookup, DCount etc. on a SQL string held within the VBA code itself. Something like: stSQL = "SELECT * From Contacts" MsgBox DCount("Contact_ID", stSQL, "Deceased = False") I'm trying to avoid creating lots of queries.

Hi David, I tried something similar without success, but thanks. Thank you Contractor - that worked a treat. Chris

I have some code that will allow a user to pass to it the name of a report. The code will do various things to that report before presenting it for Preview, opening in Word etc. At one point in the code I would like to refer to some control or property of the report. If I was to include this...

It is indeed open. Regardless of the code I've ended up with, is there any alternative to this? My main requirement is to be able to loop through email addresses from either a static or dynamically filtered query to be able to build up a complete "To" list. Am I approaching this from the wrong...

Sorry - my mistake, I was including that (supposedly) for clarity, instead the code sits without that: Public Function Send_Email(stTo As String, stSubject As String, stBody As String, _ Optional stCC As String = "", Optional stBCC As String = "") Dim rst As DAO.Recordset Dim stToString As...

I have a library function that will allow the user to nominate a query (as one of its arguments) in the calling application which must have an email field. The function will then Do Loop the email field, concatenating it before creating an email and addressing it. The intended functionality is...

OK, so after some digging and playing with the Eval() function, I've settled on this: stBody = Eval("""" & Replace(Replace(Me.TestText, "{", """ & [Forms]![Payments Requested].["), "}", "] & """) & """") With the Me.TestText just being the text box containing: Project ID: {Project_ID} payment

Dear All I would like to create a table containing email templates for use around various applications and interfaces. I would also like the user to be able to create the text for these templates, but as well as the dynamic text. So a user might create a record as such: Email_Template_ID: 1234...

Thank you CJ_London, that was right on the money! Looks like I need to bone up on sub-queries...

I have a table which lists people's passport records - we'd like to keep them all as a historical record, hence the one to many. I would now like a query which finds the last / most recent passport and its associated details. I can perform a Group By query and single out a Max(Expiry_Date), but...

I have a form which will allow the user to review a list of contacts to de-duplicate them. Against each contact record, there are two buttons "Select" and "Remove". The select button lets you say "this is the record to keep" and remove allows your to say "I want to merge this record with the...