Top "Ms-access" questions

Microsoft Access, also known as Microsoft Office Access, is an application development and database development tool from Microsoft.

How to pass an array to a function in VBA?

I am trying to write a function that accepts an array as an argument. The array can have any number …

arrays function ms-access vba
How do I correctly use "Not Equal" in MS Access?

Objective: The intent of this query is to select all of the distinct values in one column that don't exist …

sql ms-access ms-access-2007
How do I execute multiple SQL Statements in Access' Query Editor?

I have a text file with a few SQL statements in it that I want to run on an Access …

ms-access
Access 2010 VBA query a table and iterate through results

I have a query that I want to execute against a table. With the results I want to do something. …

ms-access vba ms-access-2010
SQL to Query text in access with an apostrophe in it

Please help me with this because I cannot seem to get it right I am trying to query a name(…

sql ms-access
how do you view macro code in access?

I have a Microsoft Access database and there is a macro there. How do I view the code of the …

ms-access
Import an Excel worksheet into Access using VBA

I am attempting to import an Excel spreadsheet into Access using some simple VBA code. The issue I have run …

ms-access vba ms-access-2007
Is it possible to pass parameters programmatically in a Microsoft Access update query?

I have a query that's rather large, joining over a dozen tables, and I want to pull back records based …

vba ms-access parameters ms-access-2010
Retrieve column values of the selected row of a multicolumn Access listbox

How can I retrieve the value of specified column of the selected row in a multicolumn listbox? I populate the …

ms-access ms-access-2007 vba
Setting up an MS-Access DB for multi-user access

We're thinking of "growing" a little MS-Access DB with a few tables, forms and queries for multiple users. (Using a …

ms-access database-design multi-user