Recent content by SazzleTWG

Many thanks for that, it works perfectly now.

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 SOS, Many thanks for your reply, however I think I have fixed it. I re-linked all of the tables ticking the 'Save Password' box and it seems to have worked! Thanks again

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

Thanks for your reply. On further discussions I have managed to persuade the team I am creating the process for to manually create a new file monthly, reducing the risk of data loss and also making my life easier! :D

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 Alan, Thanks for your reply, it is one spreadsheet which has extra lines added each day rather than a new one being created. I have thought about just linking them but then I would need to add a new link every time a new spreadsheet is added (as there is currently a spreadsheet per...

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

Thank You! This problem has been driving my boss and I nuts for ages! What's strange is the particular query would have no need to be grouped so we're not quite sure how that happened but at least we have an answer now! Many many thanks. :D

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