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
6
votes
2 answers

Opening table shows "Enter parameter value"

I've done something to my Access database, and now when I double-click a table (all Access Objects | Tables) it puts up the "Enter Parameter Value" dialog. The parameter that it is asking for is of the form TableName.ColumnName, and ColumnName is…
Dave
  • 3,429
  • 2
  • 26
  • 29
6
votes
1 answer

Output MS Access Query to Excel with vba

Working with MS Access 2007, I have a query I'd like to run and export the results to a specific workbook in a saved Excel workbook. I have the following code written using DoCmd. First I open the query (this works) and then I try to output the…
RestitutorOrbis
  • 189
  • 1
  • 2
  • 13
6
votes
1 answer

Using @@Identity

I'm wondering how I could get the most recently generated autonumber value from a table in another db. Currently I am doing this: Do Until rsA.EOF 'Inserts new row here (works) Set rs = New ADODB.Recordset rs.Open "SELECT @@Identity"…
user2618908
  • 61
  • 5
6
votes
2 answers

Import Dynamic and Static ranges from Excel in to MS-Access that do not start at cell A1

How might I link a data range from an Excel spreadsheet so that the data in that range appears as a useable table in Access? Linking to an Excel sheet that has data starting at cell A1 is easy enough, but where data in the Excel spreadsheet starts…
Matt Hall
  • 2,412
  • 7
  • 38
  • 62
6
votes
3 answers

delete top 2 in Access

What is the correct syntax for this: delete top 2 * FROM table1 in Microsoft Access? I am trying to delete the first 2 rows, and I don't have an id field. Also, I know it's possible to do: select top 2 * FROM table1, so it's hard to think they…
Sam
  • 3,067
  • 19
  • 53
  • 55
6
votes
1 answer

Can Microsoft Access autocomplete fields?

I'm using Microsoft Access 2007. When I start typing a new record,is there a way to get access to suggest things I've previously typed, to save me time typing the whole word in? For example when I start typing S, it might start suggesting words that…
Tukai Nancy
  • 127
  • 1
  • 4
  • 12
6
votes
4 answers

How to Display data in datagridview from access database

I have the codes below here in displaying data in datagridview from access database. I have different rows but in only display the last row of data in database. I dont know what's wrong in my code. dataGridView1.Columns.Add("UserID", "UserID"); …
bhert
  • 67
  • 1
  • 2
  • 9
6
votes
4 answers

What ORM can I use for Access 2007 - 2010? I'm after WPF binding to the tables etc

I've a legacy database that all sites have, it describes specific content in a number of catagory/subcatagory/child item format. Until now, adding/editing the content is either manual work in the tables OR raw sql Windows Forms tool (I built when I…
Richard Griffiths
  • 758
  • 1
  • 11
  • 23
6
votes
6 answers

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 database tables. This is fine, but I don't want it to happen when a user closes a form, because it is the direct opposite of…
Steven Liekens
  • 13,266
  • 8
  • 59
  • 85
6
votes
2 answers

Multiple UPDATEs in one Access SQL query

I'm trying to make a query like so: UPDATE table1 SET col1 = 'foo', col2 = 'bar'; UPDATE table2 SET hi = 'bye', bye = 'hi'; But when I go to save, Access errors with: Characters found after end of SQL statement After some searching, it would…
Danny Beckett
  • 20,529
  • 24
  • 107
  • 134
6
votes
1 answer

OUTER JOIN result is missing rows, no WHERE clause (Workaround found)

Update at the bottom. I am trying to do a self outer join that, for each record, returns it and all other records occuring later than it, or NULL if it itself is the latest record. This is my sql code: SELECT A.[CR#], A.REGIS_STATUSDATE,…
msender
  • 63
  • 5
6
votes
1 answer

ADODB.Fields error '800a0cc1' Item cannot be found in the collection

I need to create a select box with query data from my Database by using the query technique that I've done it successfully many times. However, today when I created the new select box, the page keep telling me that there're error "ADODB.Fields error…
Alxan
  • 295
  • 2
  • 5
  • 16
6
votes
1 answer

Enabling and disabling controls on a Continuous Subform in Access 2007/2010

I need to enable or disable a control on a continuous subform, dependent on another field. The initial code I wrote by instinct was very similar to what is suggested here, but instead of only disabling those controls which are marked as "child", it…
Sinister Beard
  • 3,570
  • 12
  • 59
  • 95
5
votes
1 answer

Cannot access ODBC DB with MS Access2007

I'm having problems accessing an Oracle database via ODBC in Access and hope someone has some advice. I've spent a fair time trying to find a solution, but nothing useful has come up. I have a connection setup in ODBC that access an Oracle 9…
Bob
  • 327
  • 4
  • 13
5
votes
5 answers

email using Access and VBA without MAPI

I would like to send email from Microsoft Access unattended using VBA. I understand that the built-in method “SendObject” uses MAPI meaning security prompts and something like Outlook configured. Since I want to use the Task Scheduler to kick off…
Knox
  • 2,909
  • 11
  • 37
  • 65
1 2 3
…
99 100