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
8
votes
3 answers

Placeholder text in an unfilled (empty) text box on an Access form

How can I add "placeholder" text to a Text Box in an Access form? Before the user has typed anything into the text box I want it to display something like Name: [Please enter the right name] and then when the user enters some value the text box…
JRU
  • 327
  • 2
  • 9
  • 18
8
votes
1 answer

break a long sql vba statement into multiple lines

I am totally new to a VBA atmosphere. I tried to break this line into mulitple lines but I failed. Can someone help me to break this code into multiple lines? DoCmd.RunSQL "UPDATE INDIVIDUAL SET INDIVIDUAL.INDI_FIRSTNAME = '" &…
codious
  • 3,377
  • 6
  • 25
  • 46
8
votes
2 answers

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 AREA3 200 700 900 Now I like to make a report that shows "DONE"…
masoud
  • 855
  • 4
  • 12
  • 34
8
votes
1 answer

Access 2007: Unexpected error (40230)

I am getting an Unexpected error (40230) when trying to access VBA code for the form I have in Access 2007. I tried decompiling, which is how I found out the project is corrupt. I received the following message when I decompiled: "The Visual Basic…
user793468
  • 4,898
  • 23
  • 81
  • 126
8
votes
1 answer

How to get the affected rows in VBA ADO Execute?

The following code errors on the MsgBox cn.RecordsAffected line with: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. How can I successfully get the affected number of rows? This is for an Access…
Danny Beckett
  • 20,529
  • 24
  • 107
  • 134
8
votes
4 answers

Strip out non-numeric characters in SELECT

In an MS Access 2007 project report, I have the following (redacted) query: SELECT SomeCol FROM SomeTable The problem is, that SomeCol apparently contains some invisible characters. For example, I see one result returned as 123456 but SELECT…
Danny Beckett
  • 20,529
  • 24
  • 107
  • 134
8
votes
3 answers

Should I put optional record properties in a separate table?

I have a table of about 1,000 records. Around half of them will utilise a set of fields containing certain characteristics. There's about 10 relevant fields. The other half of the records won't need that information filled in. This table is…
andrewb
  • 5,200
  • 6
  • 36
  • 54
8
votes
1 answer

Why is my VBA for MS Access Buggy?

This is kind of a vague question and hard to explain. I'm trying to code my access database, but the VBA portion is really annoying me. Whenever I type something and hit space, it will automatically redo that space and put me back up against the…
Scotch
  • 3,186
  • 11
  • 35
  • 50
8
votes
3 answers

Version control Access 2007 database and application

I need to version control a Microsoft Access 2007 database and application. Currently everything is contained in a single mdb file. The application includes: Forms VBA code Actual database I would assume I need to separate the database from the…
Jesse Vogt
  • 16,229
  • 16
  • 59
  • 72
7
votes
1 answer

Import an Excel worksheet into Access using VBA

I am attempting to import an Excel spreadsheet into Access using some simple VBA code. The issue I have run into is there are 2 worksheets in the Excel file, and I need the 2nd worksheet to be imported. Is it possible to specify the needed worksheet…
Randal
  • 185
  • 2
  • 2
  • 6
7
votes
3 answers

Text-search in properties Access objects

Is there a way in Access to search for a certain text in object properties and so on? Just not only in the VBA source code. I'm asking this because if I change for example the name of a field in a table I've to check a lot of object properties…
waanders
  • 8,907
  • 22
  • 70
  • 102
7
votes
2 answers

How do I correctly use two Not Exists statements in a where clause using Access SQL VBA?

I have 3 Tables: NotHeard,analyzed,analyzed2. In each of these tables I have two columns named UnitID and Address. What I'm trying to do right now is to select all of the records for the columns UnitID and Address from NotHeard that don't appear in…
Bryan
  • 1,851
  • 11
  • 33
  • 56
7
votes
4 answers

How to make a passthrough / passthru query editable?

In the Microsoft Access 2007 with an SQL Server Backend, we usually take a linked table from the SQL Server as Form.RecordSource of an editable form for a single table data modification. A local query is used for cross tables editions that combines…
jacouh
  • 8,473
  • 5
  • 32
  • 43
7
votes
1 answer

How can I populate textbox through VBA in MS Access?

I have a table RR_info which hold following fields RR_ID, HR_ID, No_of_Beds, Room_Category. Now i want that through VBA code with Form_load event I should populate textboxes for all these table fields. For this I wrote a query which get certain…
Rizwan Safdar
  • 125
  • 2
  • 2
  • 11
7
votes
3 answers

Exporting Recordset to Spreadsheet

Just getting to grips some VBA (this stuff's new to me so bear with us!) From query ContactDetails_SurveySoftOutcomes, I'm trying to first find a list of all the unique values in the DeptName field in that query, hence the rsGroup Dim storing a…
Matt Hall
  • 2,412
  • 7
  • 38
  • 62
1 2 3
…
99 100