Category "ms-access"

MS Access - UPDATE SQL Query Error 3061

I try to update data in a table with text delivered from a InputBox. Private Sub editname_Click() Dim GivenNameTB As String Dim EnterName As String Dim SQl

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