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
1
vote
1 answer

Runtime Error 3134 Unable to Identify the issue

I am getting a Runtime Error 3134 on the following code based from an onclick event strEnt = "INSERT INTO EntList (EntityID, BusinessUnit, EntityName, Position, Location, Client, Dept, DistKey, Salary, Currency, SQ&A, BillRate, Util%, MeritDate,…
Mr. Finn
  • 99
  • 3
  • 13
1
vote
2 answers

Access Control Using User Rights & Groups

I have a database that is built from the ground up using MS Access 2007 with VBA running all the scripting (SQL, data validation etc) between the forms, reports and the data tables. I am trying to put a user access implementation system on the…
Avagut
  • 924
  • 3
  • 18
  • 34
1
vote
2 answers

No value given for one or more required parameters. during paramatized search

I am trying a paramatized search to prevent sql injection. However the error "No value given for one or more required parameters". comes Dim sql As String Call connect() con.Open() sql = "Select * from Records where…
Ahmed Faizan
  • 446
  • 5
  • 12
  • 22
1
vote
1 answer

Link Table to SQL Server table with Identity Increment column

I am in the process of converting my MS Access application to use link tables to SQL Server, and have run into an issue that I need help with. The issue is with one table with a column that was auto increment when it was in Access, and is now…
Randy Vrabel
  • 31
  • 3
1
vote
2 answers

How to create Count IF Query?

I have data in a table that looks like this: VISIT ID | Surgeon | Surgeon Arrival Before Schedule in Minutes | ... 123 | Dr. A | -45 156 | Dr. A | -25 198 | Dr. A | 32 ... | ... I want to construct a query that will bin…
MCP_infiltrator
  • 3,961
  • 10
  • 45
  • 82
1
vote
2 answers

i can't scroll my form when my listbox has a focus

In Access 2007 form if any of my listboxs has a focus, I can;t scroll my form up or down. To do that I have to move the focus to any other control except the listbox, and by the way all of my listboxs have only 4 items on it with no scroll bar, I…
user1921704
  • 179
  • 3
  • 4
  • 15
1
vote
1 answer

Data not updated correctly

i got 2 forms... Dress_Price is for displaying the data form database ( MS Access 2007 ) another form,Edit_Dress is to edit and update the database.. the code successfully updated the data based on the changes from the form Edit_Dress.. but there…
WaN
  • 91
  • 3
  • 9
1
vote
1 answer

Import Unknown Field Order From Text

I've been assigned the task of importing about 180 csv files into an access 2007 database. These files have been put together over the years and will be put into 1 of 3 folders. I have not set up any data checks or restrictions to these tables…
RoofusEat
  • 99
  • 1
  • 7
1
vote
1 answer

Access Calculated field in form or in table?

What's better for database consistence? A calculated field in a Form or in a Table? e.g I have a Table which has some Date Fields! I want to calculate them so I can to update status. [Start Date][End Date][Status] I have a form to insert "Start…
RooseveltJr
  • 71
  • 1
  • 10
1
vote
2 answers

Access SQL - If TotalPrice is > 30, Discount = 30%

I'm working on an access database at the moment, where I have multiple fields. Product Quantity (Entered by User) Product Price (Retrieved by Database) Total Price (Product Quantity * Product Price) Discount Discount needs to be calculated,…
Ryan Cassidy
  • 29
  • 2
  • 7
1
vote
1 answer

VBA Access Getting Runtime Error 3144 on previously working event

I have an issue that has developed while modifying an update event that previously had been working. I am now getting a Runtime Error 3144, "Syntax error in UPDATE statement." When I go to debug the following line of code is flagged. Set…
Mr. Finn
  • 99
  • 3
  • 13
1
vote
1 answer

Group Header in SQL Query

I have a table like this, ID Description City ---------------------------------- 001 free_text MUL 002 also_free_text ERL 003 another_text MUL 004 whatever_text BER 005 text ERL 006 another …
Gao Wei
  • 79
  • 1
  • 11
1
vote
1 answer

how to hide the subform vertical edge

I have an Access form which consist of many subforms ; the problem is that each subform has unwanted edge as shown in the following pic : i want to hide this edge for each subform to reduce the form space ;i don't know if there any way to remove…
user1921704
  • 179
  • 3
  • 4
  • 15
1
vote
1 answer

Using PivotTable's in Access 2007 with large databases (~200 MB)

I'm trying to use Access to help me summarize scientific data - temperature and humidity over the past 30 years or so. The databases are quite large - approximately 200 megabytes each. The ideal for me would be to use a pivot table to perform the…
Alex
  • 11
  • 1
  • 2
1
vote
1 answer

Getting a Key Violation Error when trying to use an Update String from a form

I have a form that allows people to add new employees but they need to be able to edit or update the existing employees as well. So I added a button to allow them to make changes right on the form, click the update button and the record they were…
Mr. Finn
  • 99
  • 3
  • 13
1 2 3
…
99 100