Category "ms-access"

MS Access to MS Excel export with VBA coding in MS Excel where having issue

Below is my code where I'm trying to export a MS Access query output to an Excel file and then editing the Excel to create a pivot table on a new sheet. The cod

Export query from MS Access to Excel file and make pivot tables in excel file

I am trying to export a MS Access query to an Excel file and then create pivot tables in the excel file based on the data dump extracted to the excel file. My i

How do I determine the MS Access Install path

I have a commandline invocation of MS Access like so: %Programfiles%\Office11\msaccess.exe How can I eliminate the "Office11" part so that the resulting invo

A "progress bar" Form in ms-access will not update when its properties are changed from a loop in a module

I am trying to have a dialog form, or rather a dialog-looking form displayed while importing a big quantity of data in my access database, from a "Document Cont

Convert Access Database to SQL Microsoft DTS - Data Type '130' not in mapping file

I am trying to export a large Access .mdb database to an SQL Server database and have been running into a problem where Microsoft DTS does not recognise the dat

How can I generate a "Social Golfer" matrix for worker seating arrangement?

EDIT: I am looking for an APL function, or MS Access VBA function, which takes as arguments the total number of employees, total number of dinning tables, and n