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

Retrieve previous row to subtract from current row by date

I have a table with only 2 fields: NAV_Date and NetAssetValue. NAV_Date is the last day of a quarter. +----------+--------------+ |NAV_Date |NetAssetValue | +----------+--------------+ |12/31/2012| …
Mark C.
  • 6,332
  • 4
  • 35
  • 71
1
vote
3 answers

MS Access 2007 error number: 2950 on Trusted Document?

In my *.mdb file I have a macro with an action that runs TransferText and gives me an Error Number of 2950 which according to Microsoft means that the document is not trusted, as far as I know it is trusted! It's located in the Trust Center Trusted…
leeand00
  • 25,510
  • 39
  • 140
  • 297
1
vote
2 answers

Combine values from n-fields with precedence

I have an example table below: +----+----+------+ |var1|var2|merged| +----+----+------+ |a |b |a | +----+----+------+ | |c |c | +----+----+------+ | |x |x | +----+----+------+ |c |d |c | +----+----+------+ I want…
user3119058
1
vote
1 answer

Combobox Running Code/Query throwing "Recordset is not updateable"

When I click the Combobox, the dropdown list is populated, yet when I try to click on an option it says "Recordset is not updateable".. I have tried to read up on this error yet can't identify the issue behind this. The joins aren't complicated and…
Mark C.
  • 6,332
  • 4
  • 35
  • 71
1
vote
2 answers

Find the end date of a quarter given a date

I have the end dates of each quarter as the PK for a table, and I need to compare a date to see which quarter-ending value would be used in a calculation. The Table looks like: EndingDate Value 12/31/2012 $1,000 For example, given 3/1/2013…
Mark C.
  • 6,332
  • 4
  • 35
  • 71
1
vote
1 answer

Remove a string inside a cell in MS Access

I want to delete a certain string in a cell in MS Access, whether in a column or in the whole table. I know that I can do this using plain old Find and Replace but in this case it is not economical for my thousand-row table. For example, remove…
user3119058
1
vote
2 answers

Saving Access Report

I have the following which opens the SaveAs Dialog box, however it's not actually saving the file when I click save. Dim SaveBox As Object Set SaveBox = Application.FileDialog(msoFileDialogSaveAs) With SaveBox .AllowMultiSelect =…
mrbungle
  • 1,921
  • 1
  • 16
  • 27
1
vote
2 answers

Wrong number of arguments SQL MSACCESS

I am getting an error indicating the wrong number of arguments when I run the following query: SELECT population_postcodes.*, target_postcodes.*, SQR( EXP(population_postcodes.longitude- target_postcodes.longitude, 2) +…
Max F
  • 81
  • 2
  • 8
1
vote
0 answers

Using a SharePoint 2010 Lookup Column with multiple fields causing problems with Access 2007 linked table

I have a SharePoint 2010 list that contains a lookup column with multiple fields (not multi-value but rather when I select item1 it will display item1's name and category). I have this list linked to an Access 2007 table and everything seems to…
Wayne
  • 11
  • 2
1
vote
1 answer

Access Call Macro from Query (Opening a Form) Run-time error '2486': You can't carry out this action at the present time

I have an Access Query that requiers a value to be set in a combo-box within a form in order to work Criteria: Forms![_SelectCustomer]![CmbSelectCustomer] So far so good, however, I would like the query to open, read and close this form…
Chopo87
  • 1,240
  • 4
  • 19
  • 32
1
vote
3 answers

Fail to Append due to Key Violations

This is my first time developing a database and first time using MS Access! I am trying to append 1 new record to a table via a form linked to a query. Private Sub cmdAdjustStock_Click() 'Declare Vars Dim newqty As Long Dim Qty As Control Dim…
N.Balauro
  • 151
  • 1
  • 1
  • 11
1
vote
1 answer

Merge SQL scripts for row condition and table merging

I have these following SQL codes to do clean-up tasks: SELECT the first n-rows from the table that satisfies a condition and put them in a new table. Note that the [source].var='1' varies for different tables. SELECT TOP n * INTO tablen FROM…
user3119058
1
vote
1 answer

VBA program to convert table to ARFF returns "User-defined type not defined"

I found this WEKA table to ARFF file converter VBA script. I know nothing about VBA programming and I just want to use this file to help me in my research. I tried running it into my MS Access 2007 program but a "Compile error" with the message…
user3119058
1
vote
2 answers

VBA Access Requerying a Query that is outside of the current Form Object

I am working on a complicated project in MS Access 2007. I am having some difficulty finding the correct method/Syntax for having a query outside of the open form be requeried. I am still fairly new at the VBA so forgive me if I make mistake or I am…
Mr. Finn
  • 99
  • 3
  • 13
1
vote
3 answers

VBA Access Runtime Error 440 Automation error

I am uncertain what is causing this error and would like some help understanding what mistake I made which caused it as well as help or suggestions on how to correct the issue Below is a section of code that I am getting the error on. The debug…
Mr. Finn
  • 99
  • 3
  • 13
1 2 3
…
99 100