Top "Ms-access-2007" questions

Microsoft Access 2007 - a rapid database application development tool

Exclamation Marks in a Query SQL

I'm reading over this query, and I came upon a line where I don't understand heres the line [FETT List]![…

sql ms-access-2007
Is it better to use ADO or DAO in Access 2007?

When creating a new database in Access 2007, should ADO (ActiveX Data Objects) or DAO (Data Access Objects) be used? Edit: …

vba ms-access ms-access-2007
accdb vs mdb. Which is faster/better?

Does anyone have any experience of using Access 2007 with the prior versions of Access (i.e. mdb files). We have …

ms-access ms-access-2007
Trouble with InputBoxes

I'm currently working with InputBoxes in MS Access VBA. I'm examining validation and handling how the user interacts with the …

ms-access vba ms-access-2007
Preventing close buttons from saving records in MS Access

In a Microsoft Access form, whenever the current record changes, any changes in bound controls are silently saved to the …

vba ms-access-2007
How to add a pie chart to my Access report

I have a table that shows "DONE" and "REMAIN" for each "AREA" like below: AREA DONE REMAIN TOTAL AREA1 100 200 300 AREA2 200 300 500 …

ms-access ms-access-2007
"join expression not supported" in Access

I am writing a SQL query with inner join as this select * from (table1 inner join table2 on table1.city = …

ms-access ms-access-2007
Can't resize Access 2007 Navigation Pane

I resized my A2007 Navigation Pane and somehow closed it up so tight (maybe 8 mm) that I can't resize it …

ms-access-2007
Query a table that has spaces in its name

I have a situation, I have a Access table named Gas Flow Rates that I want to add records. When …

c# ms-access-2007 tablename
Best way to read an Excel file into an Access database

What's the "best" way to read (just read) an Excel file from within an Access 2007 application. I only want to …

excel ms-access ms-access-2007 vba office-2007