Top "Ms-access" questions

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

Using Excel as front end to Access database (with VBA)

I am building a small application for a friend and they'd like to be able to use Excel as the …

excel ms-access vba
Determine whether a Access checkbox is checked or not

Such a simple question, but I cannot find the answer (Google, MS help, SO): How can I check by VBA …

ms-access ms-access-2007
How do you comment an MS-access Query?

How does one add a comment to an MS Access Query, to provide a description of what it does? Once …

ms-access ms-office
How can I get table names from an MS Access Database?

Microsoft SQL Server and MySQL have an INFORMATION_SCHEMA table that I can query. However it does not exist in …

ms-access
VBA shorthand for x=x+1?

Sub btn1_Click() Static value As Integer value = value + 1 MsgBox value End Sub I swear when I was taking a …

vba ms-access
MS Access - execute a saved query by name in VBA

How do I execute a saved query in MS Access 2007 in VBA? I do not want to copy and paste …

sql ms-access vba
VBA check if object is set

I have a global variable that is an instance of my custom class. How do I check if the object …

ms-access vba
Corrupted Access .accdb file: "Unrecognized Database Format"

I'm having a problem. One of my databases on our shared network will not open for any user. It says "…

ms-access ms-access-2010
Determining whether an object is a member of a collection in VBA

How do I determine whether an object is a member of a collection in VBA? Specifically, I need to find …

vba object ms-access collections
where to place CASE WHEN column IS NULL in this query

I'm having some trouble translating an MS Access query to SQL: SELECT id, col1, col2, col3 FROM table1 LEFT OUTER …

sql ms-access null case