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

select data by month sql

I have a table consisting of: Product_ID (number), Product_Name (varchar), Expired_Date (datetime) I need to select the products which will be expired on the next six months. I already created a statement, it doesn't give me an error message, but I…
imstuck
  • 13
  • 4
1
vote
1 answer

Dlookup in Textbox value is not returning up with matching data from table

I have a 1st Textbox named Txtresult which has date "03-07-2015" and I have table name "Datetbl". Table has Duedate column which has date and the matching column is Action which has comments. I need to get the matching data comments from table to…
Prabhu
  • 11
  • 4
1
vote
1 answer

Sqooping MS Access data into HDFS - Hadoop

I have use case where I need to Import/Sqoop Microsoft Access data into hdfs. Is there any drivers available for MS Access to Sqoop data. Has any one came across such a case . Please drop your comments and observations .
Abhi
  • 6,471
  • 6
  • 40
  • 57
1
vote
2 answers

Access query - Percentage

I have a table which tooks like this: ID_1 Total Active Inactive 124507 4 1 3 124519 4 0 4 124521 4 2 2 I would like to add a column at the end, which would tell me which percentage of the the total…
Data_101
  • 893
  • 7
  • 14
  • 25
1
vote
0 answers

MS Access 2010, update query generates error, but updates anyway

I have a front end database for a remote user who needs to occasionally update records. When he hits the command button to update the records, access throws an error, but updates the table anyhow. How do I turn off the error? The query in question…
msiudut
  • 251
  • 1
  • 20
1
vote
0 answers

How to locate data source for unbound control?

I've inherited some Access VBA code and there are controls on a form (such as a listbox named lstOrderID, mentioned below) which have no RowSource property set (an empty string). I look in the code and find statements like this in various…
udog
  • 1,490
  • 2
  • 17
  • 30
1
vote
1 answer

Select values from Access 2010 query calculated field

I have a query in Access where I want to select a range of dates from a calculated field in the query. The field is populated using the following expression: DueDate: DateAdd("m",-([PMI job lookup table]![Frequency]),[Date]) I'd like to select…
Ian Hollis
  • 21
  • 3
1
vote
3 answers

Insert Query with Foreign Key

I have three tables in a database and they are interlinked to each other with foreign keys. I want to do a INSERT query so that I can enter the data. I can insert data to each tables individually but when using foreign key constraint I am getting…
Sensay
  • 49
  • 2
  • 9
1
vote
1 answer

Converting Macros to VBA from Outside Current Database

I'd like a way to programatically convert Access macros to VBA modules. I know how to do this manually. I was working with some code to do this within the current database and I got it to work. However, I would like to be able to do this outside…
Tyrone
  • 77
  • 1
  • 10
1
vote
1 answer

MS Access Linked Table Manager full network path

Is there any way of inputting the full network path in MS Access Linked Table Manager?
Elixir
  • 303
  • 3
  • 9
  • 26
1
vote
1 answer

Why won’t 2010 MS Access preview or print a report with subreports?

I have a perfectly compliled report consisting of two subreports (thanks to the Stack). I use this line of code to open it: DoCmd.OpenReport "rptGRANT_REPORT", acViewPreview …looks like this: But when I try to preview or print report it looks like…
Michael
  • 99
  • 1
  • 3
  • 13
1
vote
0 answers

Link text file with the latest date stamp to MS Access

I have a MS access which I have link a file called CSAT. Everyday I overwrite this file with the latest CSAT and run a query. I their a way to autmatically overwrite or Linked the file with the latest CSAT ? Here is a Printscreen of the CSAT Folder.…
ChiHam
  • 85
  • 1
  • 2
  • 14
1
vote
0 answers

Why does Listbox not filter based on mulitple dropdown fields

The Case: I have a listbox that has a query as a datasource. The query contains parameters that are based on dropdown fields which are on the same userform as the listbox. If I use only a single dropdown field as a parameter in the query, the…
rohrl77
  • 3,277
  • 11
  • 47
  • 73
1
vote
2 answers

Select highest value in row with microsoft access sql

So my table format is as follows: Project | type1 | type2 | type3 | type4 a | 0 | 1 | 1 | 2 b | 1 | 0 | 1 | 1 c | 0 | 0 | 0 | 0 I need the max of each row, as follows: Project | max a | 2 b | 1 c | 0 I cannot use the switch()…
barker
  • 1,005
  • 18
  • 36
1
vote
2 answers

Microsoft Access/Updating Record

Can anyone help me with the below code to edit the records please?Im trying to edit but there is a Syntax error and I cant fix that. See the error that appears below. Run Time Error '3075' Syntax Error(missing operator) in query expresion…
Key K
  • 169
  • 13
1 2 3
…
99 100