Search results

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

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

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.

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

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

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

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

I have an Access db with two tables: tblProjects and tblGrants - each Project can have many Grants and each grant includes information on where the money is coming from (a fund) and how much it is and when it is scheduled to be paid. There is now a requirement to migrate this information to a...

I've done my darndest to find some help on this, but without much success. I have a back-end SQL database with a number of front-end applications, each of which has various forms. One of my users is blind and makes use of a particular application, but the feedback her screen-reader provides is...