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
7
votes
5 answers

MS Access 2010: "collating sequence not supported with the specified file format"

I recently upgraded to MS Access 2010. When I open a certain .mdb (2000-2003 file format), I am greeted with this message: collating sequence not supported with the specified file format. I'm not sure what it means, but it gives it to me every time…
Icode4food
  • 8,504
  • 16
  • 61
  • 93
7
votes
3 answers

Access sub form not loaded when using SQL tables

I have a form in access with 5 nearly identical sub form . When I load the form it usually go fine. However, we recently changed from Access backend to SQL and since then , the form doesn't seem to load properly. If I go to design mode and then to…
David Brunelle
  • 6,528
  • 11
  • 64
  • 104
7
votes
2 answers

Edits getting lost

Background: Split access database, maximum two users. The back end is located on one of the two computers on a mapped drive and the front end is local. The computers are connected to the router by wifi. (I am trying unsuccessfully to get them to…
E Mett
  • 2,272
  • 3
  • 18
  • 37
7
votes
1 answer

copy formatted text into access using vba

I need to save formatted text from Word in an Access Database. So far I've managed to figure out how to store formatted text in an Access Field (Create a Memo Field in a Table and set the Text Format as Rich Text). Searching SO I have not yet come…
rohrl77
  • 3,277
  • 11
  • 47
  • 73
7
votes
1 answer

"Duplicate declaration in current scope" error in Access VBA

I'm having an issue with a VBA program I made. I want to create a program which inputs 50,000 records throughout a table (which is the Employee Table in my case), and every time I try to run it, it states an error that says "Compile Error: Duplicate…
Vince
  • 73
  • 1
  • 2
  • 4
7
votes
1 answer

iif (Iserror ()) function still returning #error

I have the following function that creates a column in my query: MTD: IIf(IsError(FormatNumber([62xx]![F40])),0,FormatNumber([62xx]![F40])) This is linked to an Excel file and where people put numbers and text in the same column (F40 in this…
Nigel
  • 309
  • 1
  • 4
  • 16
7
votes
1 answer

Achieving ROW_NUMBER / PARTITION BY in MS Access

How can you make use of "Row number over partition by" in MS access? I googled it, but couldn't find any information as to how one would go about doing this. I'm talking about this particular function, which assigns a sequential integer to each row…
saikri
  • 147
  • 1
  • 1
  • 12
7
votes
2 answers

Lookup field appears as numerical values instead of text on Access report

I am trying to create a report putting a field called contact which has the name of a person. This name is linked directly to another table where I keep all the contacts. For some strange reason, when I include this name (which in query view…
Marchese Il Chihuahua
  • 1,099
  • 4
  • 31
  • 59
7
votes
4 answers

CONCAT equivalent in MS Access

I'm doing some work in MS Access and I need to append a prefix to a bunch of fields, I know SQL but it doesn't quite seem to work the same in Access Basically I need this translated to a command that will work in access: UPDATE myTable SET [My…
salty
  • 594
  • 4
  • 6
  • 18
7
votes
1 answer

How can I populate textbox through VBA in MS Access?

I have a table RR_info which hold following fields RR_ID, HR_ID, No_of_Beds, Room_Category. Now i want that through VBA code with Form_load event I should populate textboxes for all these table fields. For this I wrote a query which get certain…
Rizwan Safdar
  • 125
  • 2
  • 2
  • 11
7
votes
5 answers

Run time error 3021- no current record

I want to link the result of a query to a Textbox but I get this error: here is my code: Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("SELECT XValue, YValue,Wert FROM tb_DCM_Daten WHERE (FzgID=" & Forms!frm_fahrzeug!ID & " AND Name='"…
Kaja
  • 2,962
  • 18
  • 63
  • 99
7
votes
2 answers

MS Access SQL LIKE query from C#

I have this query for Ms Access and im using C# and Ole DB commands. It works on Ms Access but when I'm passing the query from C# using OleDB, nothing happened. Anyway here's my code: SQL query SELECT * FROM tblIssue WHERE id LIKE '*2*' AND…
ViFer
  • 283
  • 1
  • 6
  • 23
7
votes
3 answers

Exporting Recordset to Spreadsheet

Just getting to grips some VBA (this stuff's new to me so bear with us!) From query ContactDetails_SurveySoftOutcomes, I'm trying to first find a list of all the unique values in the DeptName field in that query, hence the rsGroup Dim storing a…
Matt Hall
  • 2,412
  • 7
  • 38
  • 62
6
votes
0 answers

how do i build a website using access 2010?

has anyone done this yet? please show me some good tutorials on building websites with databases using ACCESS 2010 you can build a website using it: http://www.youtube.com/watch?v=AU4mH0jPntI
Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
6
votes
1 answer

VBA CreateObject("MSXML2.DOMDocument60") throws an Error 429

I'm having trouble declaring new object using CreateObject() Sub A() Dim x 'This works Set x = CreateObject("Scripting.FileSystemObject") Set x = Nothing 'This throws an error 429 "Active component cannot create object." …
Combinatix
  • 1,186
  • 3
  • 12
  • 24
1 2 3
…
99 100