ms-access

H, I am using Excel 64-bit I have a ms-access database and in this database I have normal ms-access table and some linked table from SQL Server, I have a query that is taking a reference of a linked table, and when I am firing that query from excel vba it is giving me an ODBC connection...

Hi, I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" showing. Note:- I am manually successfully able to refresh ms-access linked table in...

Hello In my code to export a query to Excel, I am trying to adapt the code from Titleist23 https://www.mrexcel.com/forum/excel-questions/584129-disable-access-excel-backup-file-vba.html to save and close the workbook and stops making a backup file. This is my code working fine to export a query...

I have a database that contains purchase order records (JobID, PONumber, description, budget), every so often I get a spreadsheet of invoices that contain InvoiceID, JobID, PONumber, Description, Cost. What I would like is to have a form with instructions at the top, and a subform to a...

I'm hoping someone may be able to help with this I have managed to get the basic's but I'm a bit stuck with the next stage. Currently I have been able to grey out the required fields when the various options are selected from my combo box "Type" I have also been able to get the code to check my...