Recent content by Eddie Mason

Many thanks to everyone who has helped me today Kindest regards, Eddie

Thank you I will give it some thought.

Sorry I may have mislled you the table that are deleted are the Payments and Receipts.

They are not big on average about 1,100 KB and at present there are 16 of them. During general use it is always linked to Finance only if I need to look at data from a historical year do I change the link. My problem occurs that if after viewing historical data I forget to update the link, the...

I have a front-end database, “FinCode”, linked to a back-end database, “Finance”. Annually I make a copy of Finance, renaming it to Finance{year). Then delete the records in Finance. Occasionally I need to link to one of the old databases to check the historical data. If I forget to relink back...

Many thanks for your help I have now downloaded a 30 day trial ODBC driver from CData. Regards, Eddie

Hi Thanks for your help but I have tried to download the trial ODBC driver, but it keeps telling me I need to enter a valid email address. Kind regards, Eddie

Has anyone any experience using ODBC to link Xero Accounting Tables in Access? Hoping someone can help. Regards, Eddie

Can I update MySQL tables using Access? Regards Eddie

Hi, I am sorry but due to Data Protection laws I cannot provide a sample database. I have looked at your sample database and I cannot see a date selection only what year that the students are in. In my database I want to select customers that had ordered between defined [after] and [before]...

Hi, I think I need to clarify what I want to achieve. I have a table with about 17,500 records, and have created a form for the user to view them. What I want to do is to let the user filter the information by: [Country] eg. (Canada), [diet] eg. (Vegitarian) and [last ordered]: later than...

I hve just completed a form and I want to offer the user a choice to filter the data by Country, Diet and Date Last purchased before and after. I have managed to get it working using (Me.Filter = "Country like ""*" & Me.FilterField & "*"" And Diet Like ""*" & Me.FilterFieldA & "*"" ") for...

I would like to thank you for the help given with this problem it is very much appreciated. Kind regards Eddie

I'm having to purchase a new computer and I would like to know if I will have any issues running my legacy Access 2002 32 bit programmes on Access 2016 64 bit software. kind regards, Eddie

Hi CJ, What you have given me works absolutely perfectly no more tediously looking through a diary each year. Many thanks for your help I really do appreciate it. Kind regards, Eddie