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

ADO Recordset data not showing on form

I've got a frustrating issue on MS Access 2010 that I would at this stage qualify as a bug. And after having tried all possible workarounds, I am out of ideas and rely on you. Context Huge Ms Access 2010 application with 25k lines of VBA and >50…
Thomas G
  • 9,886
  • 7
  • 28
  • 41
11
votes
7 answers

Search as you type with MS Access Combobox

I would like to create a simple search-as-you-type combobox in Microsoft Access as shown in the image below. NB: the above image is from a complicated implementation of what I am trying to achieve from here My combobox is named ctlSearch. Using…
iPwnTech
  • 545
  • 2
  • 5
  • 20
11
votes
1 answer

Putting a hyperlink in a MessageBox

Is it possible to add a hyperlink to a messagebox? I'm trying to do something like this: MsgBox "Sorry, but you have an out-of-date database version. Please redownload via the batch file to ensure that you have the latest version. Contact the…
Johnny Bones
  • 8,786
  • 7
  • 52
  • 117
11
votes
2 answers

Can I hide the 'Click to Add' column in Access?

When viewing a Microsoft Access table in Datasheet View, the right-most column is titled 'Click to Add,' allowing someone to add a new column without using the Design View. Is it possible to hide this column?
EJ Mak
  • 799
  • 1
  • 8
  • 29
11
votes
6 answers

Separate label from textbox

Is there a way to separate a label from a textbox? I found that this is supposed to work : Select the controls Arrange tab Remove layout But the remove layout button is always disabled... Probably cause it's only when you use the tabular or…
Marc
  • 16,170
  • 20
  • 76
  • 119
10
votes
5 answers

Adding Trusted Location to Access Run Time

I have created a Microsoft Access file. How do I add this file to the trusted locations on my client's PC where there is only the runtime version of Access installed?
Adarsh Madrecha
  • 6,364
  • 11
  • 69
  • 117
10
votes
5 answers

Converting Access Database to MSSQL Database Using Microsoft SQL Server Migration Assistant for Access

I am trying to convent a Ms Access Database to MS SQL 2012, using Microsoft SQL Server Migration Assistant for Access version 6.0 but each time i try to convert it an error pops up. any ideas how i can solve the problem i reinstall the program…
emilios
  • 375
  • 1
  • 9
  • 20
10
votes
2 answers

CSV export of an Access query limits float (Single/Double) values to 2 decimal places

I searching for hours to change the amount of decimal places to 8, instead of 2 with VBA Access. I found some solutions to change the system proppertys by using this tag: Public Const LOCALE_ILZERO = &H12 but it doesen't work and I dont know how I…
HamburgIsNice
  • 105
  • 1
  • 10
10
votes
4 answers

Recordset always returns -1 (excel VBA)

I want to count the number of rows returned by a query in a recordset, I tried recset.RecordCount function but it always return a value of -1. How am I going to count the number of records or rows in recordset?
Kentot
  • 512
  • 5
  • 10
  • 26
10
votes
1 answer

Microsoft Access 2007 / 2012 Source Control using Team Foundation Services (2012)

I've been struggling for few days on this workaround... So, as you may know, Microsoft ran its cloud ALM platform : team foundation services (https://tfs.visualstudio.com/). It is free to use for teams containing less that 5 users... and it can be…
boblemar
  • 1,143
  • 1
  • 10
  • 24
9
votes
1 answer

Is there a way to disable Access 2007's Code editors CTRL+Y Shortcut key?

Background I have used MS editors and applications for years including Visual Studio and office products and got use to CTRL+Y being redo. In fact so use to it doing that that I use undo CTRL+Z multiple times to look back on what I had just done…
GazB
  • 3,510
  • 1
  • 36
  • 42
9
votes
1 answer

How do you trouble shoot a "Data type mismatch in criteria expression" error in MS Access 2010?

I am trying to troubleshoot a Report in an MS Access Database. This file was build by the person that held my role before I joined the organization I work for. The report is throwing an error "Data type mismatch in criteria expression" This leads…
JasonR
  • 399
  • 4
  • 8
  • 26
9
votes
6 answers

Why is my .setfocus ignored?

I have an Access form with a textbox that is meant to allow for repeatedly typing a number, hitting enter, and letting a script do stuff. For speed, the field should keep the focus after DoStuff() is done. However, while I'm sure that DoStuff() is…
PowerUser
  • 11,583
  • 20
  • 64
  • 98
9
votes
6 answers

Corrupted Access .accdb file: "Unrecognized Database Format"

I'm having a problem. One of my databases on our shared network will not open for any user. It says "Unrecognized Database Format." I've had this problem before but was still able to open the database, compact and repair, or import all of the…
Scotch
  • 3,186
  • 11
  • 35
  • 50
8
votes
5 answers

how to export Access 2010 data macros

I need to transfer Access data macros from my test db to my production db. Anybody know how to do that? I know that transferring tables from one accdb to another will also transfer the data macros, but that's not an option in my case. I also know I…
unrazzle
  • 97
  • 1
  • 6
1
2
3
…
99 100