Stack Overflow
Stack Overflow

Questions tagged [ms-access-2007]

Microsoft Access 2007 - a rapid database application development tool

Microsoft Access 2007, also known as Microsoft Office Access 2007, is a rapid application database development tool.

Microsoft Office Access 2007 reached its end of extended support on October 10, 2017

It commonly uses the Jet or ACE database engine, but is not limited to these.

It is a member of the suite of applications, included in the Professional and higher editions or sold separately. Applications built with Microsoft Access can be distributed to end users with a free runtime version of the application that lets them view databases without needing the full installation of Access.

Please tag your question so others know what version you are using. Tag your question with if your question involves VBA.

Links:

4311 questions
34
votes
4 answers

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

every thing work fine locally but this error occurs when I publish it: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. and stack trace [InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not…
Kyabroudi
  • 539
  • 1
  • 7
  • 22
33
votes
3 answers

Accessing .mdb files through nodejs

I want to Access .mdb files and manipulate like insert / update using nodejs Please suggest a library that would suite the need. Thanks.
Beast
  • 559
  • 1
  • 6
  • 17
25
votes
6 answers

Now() function with time trim

So the function =Now()....is there a way I can use this and only get the date, not the time? or is there just a function for this idea?
Justin
  • 4,222
  • 21
  • 82
  • 144
22
votes
2 answers

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 whether an unbound checkbox on an Access form is checked by the user or not? Can't find the right property. Thanks in advance! UPDATE: I used this…
waanders
  • 8,327
  • 21
  • 66
  • 100
21
votes
2 answers

Is it possible to change the font in the SQL edit window in Access 2007?

It would be nice if there was a right-mouse-click menu on the edit panel to change the font size, but there isn't. Is there a system setting somewhere else that lets me increase the default font size?
Bill
  • 3,646
  • 5
  • 30
  • 45
20
votes
2 answers

A select query selecting a select statement

I don't even know if I am doing this query the right way. There is a Sandwiches table that has some 7 fields and 2 of them are comboboxes (Type and Bread). So I made a query that combines all of the comboboxes values into one query, like…
Tony L.
  • 7,947
  • 5
  • 22
  • 28
20
votes
2 answers

Is there an "On Close" event for MS Access VBA?

Am trying to perform some specific actions, before closing the access database (whenever the database is closed by the user). I know we can use Auto_Close function in Excel VBA to force events before closing the book. Is there a similar function in…
S..
  • 1,222
  • 8
  • 28
  • 49
20
votes
7 answers

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: Part of this database will be importing data from Excel 2007 spreadsheets.
Andrew Scagnelli
  • 1,544
  • 4
  • 18
  • 26
19
votes
5 answers

Check if access table exists

I want to log web site visits' IP, datetime, client and refferer data to access database but I'm planning to log every days log data in separate tables in example logs for 06.06.2010 will be logged in 2010_06_06 named table. When date is changed…
HasanG
  • 11,539
  • 29
  • 95
  • 147
19
votes
12 answers

SendKeys is messing with my NumLock key via VBA code in Access form

I have the following code for an Access form. It appears as if the SendKeys is messing with my NumLock key by toggling it on and off as I open and close the form. For perfectly valid reasons which I don't want to get into, I really do not want to…
user12059
  • 653
  • 2
  • 12
  • 25
18
votes
3 answers

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 listbox by setting the RowSource property with a SQL string. BoundColumn set to value 1. I can retrieve the value of the bound column (of…
waanders
  • 8,327
  • 21
  • 66
  • 100
17
votes
3 answers

How to refer to Excel objects in Access VBA?

What declarations I have to make in order to be able to use Excel objects and constants from my Access 2007 VBA script? Dim wb As Workbook or Set objExcelApp = New Excel.Application or .Borders(xlEdgeBottom)
Pablo
  • 24,270
  • 32
  • 112
  • 196
17
votes
3 answers

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]![FETT Search] FETT List is a table FETT Search is a column in FETT List Can someone explain what the exclamation mark means? Thanks
ChickSentMeHighE
  • 1,676
  • 5
  • 21
  • 29
17
votes
1 answer

VBA: Why must I set focus to control every time?

I am creating a personal Library Inventory system using an Access 2007 database. In code, whenever I reference the .Text property of a form control, whether it be changing the value, or simply checking the value in an IF statement, I get prompted…
Analytic Lunatic
  • 3,619
  • 21
  • 65
  • 112
15
votes
5 answers

C# Inserting Data from a form into an access Database

I started learning about C# and have become stuck with inserting information from textboxes into an Access database when a click button is used. The problem I get is during the adding process. The code executes the Try... Catch part and then returns…
Kentao
  • 187
  • 1
  • 1
  • 11
1
2 3
…
99 100