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

SQL: IF statement Access 2010

I have trying to write a query in Access 2010. I have a table: Table name is power. I have trying to write IF statement: Select IIf(power.gain_type = 'D', power.gain_max + 2.15) If gain_type equals D, then gain_max sum 2.15 For example: 14.8 +…
Juronis
  • 495
  • 4
  • 8
  • 18
8
votes
1 answer

Cannot Open Database Created with Access 2010 in Access 2007 Even With SP2

A database created with one of the new sort orders will not open in Access 2007 even with Service Pack 2 (SP2) installed.
Fionnuala
  • 90,370
  • 7
  • 114
  • 152
8
votes
2 answers

error 2115 on combobox selection

I have a combobox on a form and I'm trying to programmatically select one of the items in the combobox after I've run my SQL query on the access database. I use the following code to iterate over the items and set the selected item: 'Make the…
Alan
  • 822
  • 1
  • 16
  • 39
8
votes
3 answers

How to Continuously Develop and Deploy an Access 2010 Database Application

I've been developing an Access 2010 Database Application, let's call it Skill.accdb. I'm at the stage where I want to start deploying it so users can start using it and continue developing at the same time. I've been reading…
Martin F
  • 590
  • 7
  • 28
8
votes
3 answers

How can i introduce multiple conditions in LIKE operator for MS Access SQL

I would like to know, if there is any way, how to achieve something like this in access sql. select * from my_table where column_name like ('ABC%', 'MOP%'); I tried use this: https://stackoverflow.com/a/1387797/1784053 but this seems not to work in…
Kajiyama
  • 3,393
  • 8
  • 26
  • 38
8
votes
2 answers

How to configure Squirrel SQL client to work with MS Access

I'm struggling to get Squirrel SQL to connect to MS Access database (just a normal one, no password): I create an Alias and use Driver: JBDC ODBC bridge (There is a tick in front of this driver) I don't know what to put in URL -------- I use: Path…
Harry Duong
  • 407
  • 6
  • 14
8
votes
3 answers

How can I investigate and resolve an (apparent) Access database corruption?

I have an Microsoft Access 2010 database application with split front end and backend which has started to behave oddly, and I've exhausted all the options I know for investigating and resolving the problem. 32-bit Access 2010 running on Windows…
ColeValleyGirl
  • 577
  • 15
  • 40
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
3 answers

How can I sort the columns in a crosstab query, when the column data is dynamic?

I've been doing a bit of research on this topic and I can't seem either find a workable solution, or one that is explained well enough for me to implement. If you've ever created a crosstab query in Access, you are aware that by default Access…
RLH
  • 15,230
  • 22
  • 98
  • 182
8
votes
2 answers

How to insert ADO Recordset into MS Access Table

PROBLEM I want to insert the current recordset row into a MS Access table. I am currently getting this error Syntax error (missing operator) in query expression 'rs[columnname]' CODE Here is my current code, I am trying to grab all the columns and…
zach
  • 1,281
  • 7
  • 27
  • 41
8
votes
6 answers

MS Access 2010: "Cannot open any more databases."

While struggling with a single legacy MS Access application I faced this weird error: Cannot open any more databases. The application makes extensive use of UNION sql statements. So this seems to cause access hitting the limit of 2048 open tables.…
Christian
  • 13,285
  • 2
  • 32
  • 49
8
votes
3 answers

MS Access: Display two columns in combo-box

Embarrassingly simple question but I can't work it out or find the answer via google. Got something like this with two colums But when selected it only displays one column, making the information much harder to read/ understand. Tried changing…
user137263
  • 747
  • 5
  • 11
  • 25
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
3 answers

Transfer specific columns from Excel to specific columns in Access Table

I am attempting to transfer specific columns from an excel document to specific columns to a table in my Access database. For example my excel sheet might contain the following: Date Last First Gender Month School Grade 10/1 Rode Danny …
alpha_nom
  • 311
  • 3
  • 4
  • 9
7
votes
1 answer

Difficult grouped report from database

ID | Start of range | End of range ------------------------------------ ID1 | Ok-000001 | Ok-000009 ID1 | Ok-000010 | Ok-000014 ID1 | Ok-000015 | ID1 | Ok-000016 | Ok-000018 ID1 | Ok-000037 | Ok-000042 ID2 | …
JWB
  • 71
  • 2
1 2
3
…
99 100