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:

4371 questions
7
votes
3 answers

Access Subform Source object

What I am trying to achieve is for a combo box (Combo_sf) selection to dictate the form in the subform control (sf_record) I have about 10 forms, their names are in the combo box data. I am new to VBA and am not sure if my approach is right: Private…
Bawn
  • 509
  • 3
  • 13
  • 36
7
votes
5 answers

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 InputBox through pressing the OK or Cancel buttons. Correct me if I'm wrong but InputBoxes can return any data type and by…
Katana24
  • 8,706
  • 19
  • 76
  • 118
7
votes
2 answers

convert int to varchar working for SQL Server and MS-Access

I must create a query compatible for SQL Server and MS-Access. The problem is that in SQL Server I try to convert a number to varchar. In SQL Server I can do the conversion like this: convert(varchar(100), 5) in MS Access : CStr(5). Are there…
Silvia Parfeni
  • 518
  • 1
  • 6
  • 17
7
votes
1 answer

Microsoft Access 2007 -- View Query Used In Report?

I need help navigating Microsoft Access Reports. I am in the Report Designer, and I need to know the which menu selection will enable me to view the Query that was used in the report. I have never used Access before.
Tim
  • 1,197
  • 3
  • 11
  • 7
7
votes
5 answers

PDO: How to access Microsoft Access file on Linux?

I have managed to read data of Microsoft Access file (.accdb) on Windows using PDO but I'm having problem getting to work on Linux (CentOS). I can see modules is installed: [root@rapid host]# php -m | grep PDO PDO PDO_ODBC [root@rapid host]# php -m…
I'll-Be-Back
  • 10,530
  • 37
  • 110
  • 213
7
votes
4 answers

How to remove row that exists in another table?

I have two tables. Main table is "CompleteEmailListJuly11" and the second table is "CurrentCustomersEmailJuly11". I want to delete rows in CompleteEmailListJuly11 table that CurrentCustomersEmailJuly11 has based off email. I've tried this following…
eqiz
  • 1,521
  • 5
  • 29
  • 51
6
votes
1 answer

How to run a MS Access macro from python

I'm trying to run an existing Microsoft Access Macro from a python script. What I currently have is import win32api,time from win32com.client import Dispatch strDbName = 'Exit.mdb' objAccess = Dispatch("Access.Application") objAccess.Visible =…
paldives
  • 125
  • 1
  • 2
  • 8
6
votes
5 answers

Save password for ODBC connection to MS SQL server from MS Access 2007

I am in charge for migrating old Access 2007 project to MS SQL server 2008 Express. The first stage is to move all the data from MS Access database to SQL server while keeping the Access forms and reports at the client. So, the data are now moved,…
Passiday
  • 7,573
  • 8
  • 42
  • 61
6
votes
1 answer

access to oldValue for control in continous form generates error 3251 in beforeUpdate when a checkbox on form is updated

This is one of the stranger issues I have seen in MS Access. I have the following code in a continuous form: Private Sub thisForm_BeforeUpdate(Cancel As Integer) If Not Cancel Then Debug.Print "pre-logging data changes..." ' here we need to…
dmarra
  • 853
  • 8
  • 23
6
votes
4 answers

Assigning a Keyboard shortcut to a button in an Access 2007 form

Say I have a form on which a number of buttons exist. Everything works as it should when the buttons are clicked. How do I go about assigning keyboard shortcuts to my buttons so that Alt+A runs the action of Button A, Alt+B runs the action of button…
Istari
  • 3,843
  • 3
  • 24
  • 21
6
votes
4 answers

How does Access's query editor decide whether to discard my formatting?

Like a lot of developers who are comfortable with SQL syntax I get frustrated when working with Access's query editor. I'm talking about the raw SQL Syntax view, obviously. One of its many annoying properties is that upon saving it will discard my…
hawbsl
  • 15,313
  • 25
  • 73
  • 114
6
votes
3 answers

How to populate the value of a Text Box based on the value in a Combo Box in MS Access 2007?

I have a combo box which is of a lookup type, i.e., I've selected the source to be a column from a table and am storing the selected value in another table. The table which I am looking up has another column and I need the value in this column to be…
CodingInCircles
  • 2,565
  • 11
  • 59
  • 84
6
votes
1 answer

MS Access Form Bound to ADO Disconnected Recordset

I seem to be clueless on this subject. I can attach an ADO recordset to a form, but I am not sure how to handle updates. I don't want to only UpdateBatch, I want to be able to detect what was changed for logging purposes. Can anyone point me in the…
dmaruca
  • 485
  • 2
  • 5
  • 16
6
votes
8 answers

MS Access Application - Convert data storage from Access to SQL Server

Bear in mind here, I am not an Access guru. I am proficient with SQL Server and .Net framework. Here is my situation: A very large MS Access 2007 application was built for my company by a contractor. The application has been split into two tiers BY…
Ronnie Overby
  • 45,287
  • 73
  • 267
  • 346
6
votes
2 answers

Data entry form/subform in a Many-to-Many relationship

I have an Access database with a many-to-many relation. The origin table is called Property and the destination table is called Person. A property can have more than one owner, and a person can own more than one property. I created a join table to…
Techie_Gus
  • 161
  • 1
  • 6
1 2 3
…
99 100