Top "Ms-access-2010" questions

Microsoft Access 2010 Personal Relational Database Management System.

Can you use a variable for the Field name when using AddNew to a record set?

I'm using a DAO recordset to update a table because of problems enocuntered here. This works fine when I know …

ms-access vba ms-access-2010 recordset
How can I sort the columns in a crosstab query, when the column data is dynamic?

I've been doing a bit of research on this topic and I can't seem either find a workable solution, or …

ms-access sorting ms-access-2010 crosstab
How to simulate UNPIVOT in Access?

UNPIVOT is available in MS SQL-Server 2005, but AFAIK not in MS Access 2010. How can it be implemented with on-board means? …

sql sql-server ms-access ms-access-2010 unpivot
Search as you type with MS Access Combobox

I would like to create a simple search-as-you-type combobox in Microsoft Access as shown in the image below. NB: the …

vba ms-access combobox ms-access-2010
MS Access 2010: "Cannot open any more databases."

While struggling with a single legacy MS Access application I faced this weird error: Cannot open any more databases. The …

sql excel ms-access ms-access-2010
How to open a form at a specific record in Access

I have a form with records for individual people with a button to view/edit a persons clearances. When I …

vba ms-access ms-access-2010 openform
MS Access: Display two columns in combo-box

Embarrassingly simple question but I can't work it out or find the answer via google. Got something like this with …

combobox ms-access-2010
ERROR "The specified field could refer to more than one table in the FROM clause"

I'm using Access 2010. My error seems to be a result of the aliasing. The solutions I've read specify that a …

sql alias ms-access-2010
Data update error with SharePoint 2010 and MS Access 2010

I've encountered a strange error when attempting to update a SharePoint 2010 list that I have linked to via Microsoft Access 2010. …

sharepoint ms-access sharepoint-2010 ms-access-2010
MS Access 2010: "collating sequence not supported with the specified file format"

I recently upgraded to MS Access 2010. When I open a certain .mdb (2000-2003 file format), I am greeted with this …

ms-access ms-access-2010