Category "ms-access"

Invalid procedure call or argument applying Excel conditional formatting from Access vba

I have read numerous examples where this code works; however, when I try to execute it, it isn't working and I don't see why. Dim xl As Object Set xl = CreateO

MS Access ignores trailing space(s) in primary key validation

I have an Access table with a TEXT primary key. If I use an INSERT statement to add a row where the primary key value is 'PART' and then try to INSERT anoth

Controlling MSG file draft/sent state

I've an Access database that records and saves email on the mailitem_send event. Saved email looks like: I want email to appear like an already sent email, li

Excel cells from Access export look empty but are not (=isblank=FALSE)

My problem is that an Excel spreadsheet (exported from Access as .xls) has cells that look empty, but are not. This is mucking up my calculations & navigati

Entire Union query returns no results if part of it returns no results

I've created the folllowing Union query, which works fine most of the time: SELECT [%$##@_Alias].[Contact ID], [%$##@_Alias].[Mailing Name] FROM (SELECT [Refer

MS Access Form button that allows user to browse/choose file excel , then imports file to a table

In my form access I want to make a button to browse / choose an excel file and import it in format a table in access. This is my code. ' Requires reference to

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

Other Categories