Search results

Hi, I am trying to send emails using CDO to an array of recipients loaded from a query. I have made this work using Lotus Notes so i know the first part of my code is correct, and the current code I have works when I input an actual email address. But when I try to add the Array name into the...

Hi all, I am having an issue with an ODBC connection from an Access 2003 database to an SQL Server database. Previously we linked to an .mdb copy of the SQL database as we were unable to set up a read-only connection. We have just managed to find a way of linking which gives us read-only...

Hi all, I am currently trying to create an automated process to import data from several Excel files into Access daily, which I have managed to get working, however due to the ever increasing size of the excel files I need to delete the imported data from Excel after. I have managed to find a...

Hi all, I am working with several identical time and motion spreadsheets that are updated daily and saved in one folder on a shared drive. What I need to do is write some VBA code to run a daily automated process to import the new data from the spreadsheets into a single access table to enable...

Hi all, I have a query that is based on another query and 2 tables. There is a particular memo field (Activity Instruction) which is based on a field in one of the tables. In the table this field is showing correctly, however when I run the query all that appears in that field is a random...