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

change .ribbonname property on open

Context: I have an Access database application that was built in Access 2k. I have a custom ribbon built that I am playing around with, and I also have some user "security" in this app. When a report opens, I want to check the username and switch…
Rebecca Crecelius
  • 31
  • 5
1
vote
3 answers

ODBC Data Sources; can't add MySQL Driver

I want to connect MS Access with MySQL. I installed Xampp for MySQL and now I installed the ODBC driver 5.3. I went to Data Sources and clicked on System-DSN to add the MySQL ODBC 5.3 Driver (like shown in this video…
Ceel
  • 13
  • 1
  • 4
1
vote
3 answers

Inner join 3 tables returns nothing

have 3 tables. CB table CID EC ID Status CType 1001 1001 Active 1540 1004 1001 Active 4 Table M CID EID EC ID EID-CID 1001 1166 1001 1166_1001 1001 1167a 1001 …
sam
  • 935
  • 3
  • 17
  • 29
1
vote
2 answers

Access 'No Records Found' when Records Exist

I have a form in Access 2010 that's used as a search form to filter records matching specific criteria. I transferred information in the backend from one set of tables to another. Now, the filter doesn't work. Even if I leave all the criteria blank…
AxxieD
  • 614
  • 1
  • 7
  • 28
1
vote
0 answers

error 3001 (arguments are of wrong type) when quering Access from Excel

I would like to imort data from a table(Table1) in Access programaticly to Excel. I have two search boxes on a userform (txtCr1 & txtCr2) and a button to execute the code. Each search box corresponds to a field in Table1. I would like to search use…
user3781528
  • 623
  • 6
  • 27
1
vote
1 answer

How to show all items in Listbox that is linked to dropdown

In an Access Userform I have a listbox that is linked to a dropdown field. In the dropdown field the user can choose a country, and the listbox then updates and shows only the records that are relevant to that country. I have described how I get the…
rohrl77
  • 3,277
  • 11
  • 47
  • 73
1
vote
1 answer

If Else Ladder in MS Access SQL query

How can I write an If else Ladder in MS Access SQL query and not in the code using Recordset. I have the conditions like this: SELECT min(ThresholdValue) FROM tbl_Threshold WHERE SpecialityCode = '130' AND SpecialistCode = 'C4535421' AND WeekNum =…
Hemant Sisodia
  • 488
  • 6
  • 23
1
vote
0 answers

Access 2010 - Parent and child forms share the same table

I'm writing a budget database, and while planning out the tables went fine, forms are proving to be trickier. I have a 'transactions' table, and two queries based off it. The tables and column names are below 'people_to_reimburse' : payee_name,…
Henry Swanson
  • 186
  • 13
1
vote
1 answer

Adding Access totals cause report to not run

I am trying to add a few totals (sums and counts) using the wizard to an Access report. When I add them to the report and try to view the report, the report fails. Without the totals the report will display. The only thing I can figure that may be a…
Alex B.
  • 58
  • 7
1
vote
1 answer

Passing date criteria from a form to a query in Access

This should be pretty easy, but it's not working and I know I've done it before. I have a Date field on a form: Property is set to a ShortDate for the date field: I've got some code on the back end to make sure it always gets set to the last day…
Johnny Bones
  • 8,786
  • 7
  • 52
  • 117
1
vote
1 answer

Automatic updating of query shown in a form based on dropdown selection

I thought this was going to be the easiest question ever to solve, but after spending a morning searching for answers, I still can't get it to work. I have a list box showing data for certain countries on a user form that is linked to a query. I…
rohrl77
  • 3,277
  • 11
  • 47
  • 73
1
vote
1 answer

Browse Button for folder not files

I am adding a browse button on an Access 2010 form; it will only allow me to attach files, not folders. Here is the code: Option Compare Database Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _ "GetOpenFileNameA" (pOpenfilename…
autumntiger
  • 105
  • 1
  • 13
1
vote
1 answer

"Data type mismatch in criteria expression"

I'm trying to get data that are equals to and between 2 dates that i type into my textbox! The column of PO_Date is of DateTime. It works perfectly when i hard code the dates into the select statement, for example PO_Date >= #12/6/2013 3:54:15 PM#…
Melissa S. Christ
  • 49
  • 1
  • 5
1
vote
1 answer

Running Access from Command line but not loading it?

I would like to launch a MS Access macro from the command line (it's being run from another tool) to generate an output. Thing is, I'd prefer it if it could supress access from loading it's interface. I just want it to run the macro and shut down.…
wizard_draziw
  • 505
  • 1
  • 5
  • 17
1
vote
1 answer

Adding a column to existing table in access without using any relationship

I am working on a project in ACCESS 2010 that requires me to give a rank to 30000 products based on their sales. I have tried using a query to do the ranking and it takes a long time. (Please find codes at Making the ranking query efficient) I…
Dinesh Sundar
  • 86
  • 6
1 2 3
…
99
100