Stack Overflow
Stack Overflow

Questions tagged [ms-access-2010]

Microsoft Access 2010 Personal Relational Database Management System.

Microsoft Access 2010, also known as Microsoft Office Access 2010, is a rapid application database development tool.

Office 2010 will reach its end of support on October 13, 2020. If you haven't already begun to upgrade your Office 2010 environment, Microsoft recommend you start now. MS Access is a member of the MS Office suite of applications, included in the current Office 365 edition. Applications built with Microsoft Access 2010 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.

MS Access 2010 commonly uses the Jet or ACE database engine, but is not limited to these.

Please tag your question ms-access-2010 so others know what version you are using. Tag your question with access-vba if your question involves MS Access VBA.

Office 2010 end of support roadmap

Microsoft Access 2010 Runtime download

6039 questions
1
vote
1 answer

Get values from 5 columns meeting specific conditions from 2 other columns - SQL query in Access

I am new here. I am using MS-Access and I have a database with several columns. Here is what I have and what I am looking for. A column has a list of names. There are multiple entries for each name. Another column has a list of dates. I should be…
Bee Dee
  • 21
  • 3
1
vote
1 answer

In access 2010, when performing a query based on date, how to have today's date show in the query box

I have a mail merge query in Access 2010 that asks for the date then it bases the records to merge by that date. When I press the query, it prompts a box to put in a date. Most of my queries are based on today's date so I find myself typing in…
George
  • 95
  • 1
  • 10
1
vote
1 answer

ASP error '80004005' when executing an MA Access multi-line query with subqueries with Left Joins

The error is on a classic ASP page, when I am executing a large Access query with subqueries and left joins. Please note that the same ASP code works well with many other queries (smaller ones with no more than one left joins) throughout the same…
Jay S
  • 11
  • 1
1
vote
2 answers

Access Database corrupted?

I have a be database living on a network drive with 10-20 users on front ends at any one time. Lately we have been getting a lot of weird errors. After some research it seems one table in particular on the be is corrupted. I've tried "Compact and…
msiudut
  • 251
  • 1
  • 20
1
vote
1 answer

retrieve the data of the whole row as label by giving one field value of the row a

I'm using MS Access 2010 and I'm facing problem in connecting the text box and the table data. The scenario: I've created a form which contains a textbox named txtPart the control source for the textbox is:PartNumber. Which is a field containing…
Hiranya
  • 27
  • 10
1
vote
1 answer

MS Access 2010 SQL Query Syntax Error due to comma in field

I've been having issues with this code I've written to update a field (txtUOM) in MS Access 2010. Private Sub cboSelector_Change() Dim myItemCode As String Dim QfindUOM As String myItemCode = Me.cboSelector.Column(0) QfindUOM = ("SELECT…
IT Tsoi
  • 125
  • 6
1
vote
1 answer

MS Access using UPDATE statement keeps entering new data

I'm using an UPDATE Statement but whenever I click the Edit button then Update, it's entering a new line but with the same data. My code: Private Sub cmdAdd_Click() 'when we click on button Add there are two options '1. for insert '2. for update If…
User033
  • 11
  • 1
1
vote
1 answer

Control cannot be edited

I have a sale form with a subform , however i cannot choose data from my combo box.I get the following Control cannot be edited , it is bound to autonumber field Item_ID Below is the SQL SELECT [tblStockItem].[Stock_ID], [tblStockItem].[Item_ID]…
user2650277
  • 6,289
  • 17
  • 63
  • 132
1
vote
1 answer

Re-linking Tables in Access Database

First of all - my VB skills are almost non-existent so any suggestion/ideas should be a little more elaborate if possible. Here is the problem I am facing - We have linked database tables and queries in Ms Access 2010. Now a copy of the database has…
JNP
  • 21
  • 1
1
vote
1 answer

how do i insert without inputting all column names with pyodbc execute many?

I am trying to insert my data into my ms access sql connection. How do I write an insert statement where I do not have to input all the column names and "?" values. For example from https://code.google.com/p/pyodbc/wiki/Cursor : Executes the same…
collarblind
  • 4,549
  • 13
  • 31
  • 49
1
vote
1 answer

Measure occurrences in MS Access SQL

I was wondering whether it is possible (and if it is, the way) to perform the following task in Microsoft Access: there are two tables; first one consists of three columns 1) ID 2) tweet text and 3) date. Second table is a single vector of words,…
Demetris
  • 21
  • 1
1
vote
2 answers

append query, skipping duplicate entries (duplicates are not primary key)

I have an append query here. I would like it to update an existing projects table in Access from an Excel spreadsheet. I would like it to ignore duplicates. Each time I run it, it pops an error about that final "Projects.[Measure]". Where did I go…
msiudut
  • 251
  • 1
  • 20
1
vote
0 answers

Access 2010 - Choose a file and import a Excel work sheet to a table Macro or VB

I am trying to make a form where the users of the DB can push a button "add new customers" which will open a file browser where the user selects a Excel file with the same rows as the table Customers. When the user has selected the Excel file, the…
Thomas DK
  • 11
  • 1
1
vote
2 answers

Generating comparison from same table

I'm trying to create a query that shows number of members at a certain period, and the members for a different period with the same organization. This is for generating historical comparisons. Currently I have 2 identical tables to accomplish…
Rob
  • 65
  • 9
1
vote
2 answers

document.customdocumentproperties not being saved

I have searched high and low on stackexchange and other sites (vbaexpress, MSDN, etc...). There is extensive dialog around this, I have tried most of the examples, and still nothing is working. Scenario: User clicks 'Create Report' button in…
user3662334
  • 31
  • 6
1 2 3
…
99 100