Stack Overflow
Stack Overflow

Questions tagged [ms-access-2013]

Questions regarding the Microsoft Access 2013 database management system.

Microsoft Access 2013 is a database management system and application development tool. It is included in "Microsoft Office Professional 2013" and "Microsoft Office Professional Plus 2013", and can also be purchased separately.

.

For more information on Microsoft Access, see

http://en.wikipedia.org/wiki/Microsoft_Access

.

For more information on new features in Microsoft Access 2013, see

What's new in Access 2013 - MSDN - Microsoft
http://msdn.microsoft.com/en-ca/library/fp179914.aspx

What's new for Access 2013 developers - MSDN - Microsoft
http://msdn.microsoft.com/en-us/library/office/jj250134.aspx

2184 questions
0
votes
2 answers

How to grey out items in an Access combobox.

I am currently trying to do some lock downs on a combobox within Access and I’m not sure if I can. The flow of the form is that a user will select a part, then, area, and then a process group. Afterwards there will be a list of items in the process…
vxd128
  • 71
  • 10
0
votes
1 answer

The Microsoft Office Access database engine cannot read the data in Table

I am writing a .Net application with back end database Access 2013 I connect using OLEDB connection and everything was working just fine Then suddenly without doing any change to the code, database, Office versions, OLDEB, operating system, I…
Muhammad Gouda
  • 849
  • 8
  • 20
0
votes
1 answer

Getting data from query using Dlookup

I have a query named "TeacherDistributions" includes the following : TeachertorName Subject Class and I use the code below to retrieve the teacher name according to value of two text boxes. However, it retrieves no teacher…
FSm
  • 2,017
  • 7
  • 29
  • 55
0
votes
1 answer

Displaying a zero when no stock is held

I have a simple query that shows books written by a particular author, and counts the total number of books held in stock. The result returned from the query shows five columns. BookID, AuthorID, AuthorName, BookName and the total books held in…
Nev in Redwood
  • 15
  • 5
0
votes
1 answer

Programatically click a row in a listbox

When I click the a command button to close the form, the code requery's a cbo and listbox, moves the focus to the lstbox and a particular row. What I need to do is add some code that "clicks" the current row in the listbox that has the focus. Here…
Nev in Redwood
  • 15
  • 5
0
votes
1 answer

Printing two records one beside other per one page

Can I print two records one beside other in one landscape page ? Example: Page1 Record1 Record2 .............................. ........................... .............................. …
FSm
  • 2,017
  • 7
  • 29
  • 55
0
votes
1 answer

How to search an MS Access Database Table using Javascript?

I have an MS Access Database Table 'ImportFromExcel' having 16 columns. When 'Search' key in the webpage is pressed after entering keyword(s), it should go to table and check if the keyword(s) is/are present anywhere in the table. If the keyword is…
Aziiz Pc
  • 49
  • 3
  • 11
0
votes
1 answer

Access 2013 - How do I link a result, from a query generated table, to a form?

I have 2 tables, CUSTOMER and ORDERS, whose common field is CUST_ID. In addition to CUST_ID (key field), the CUSTOMER table has fields for customer info - address, phone number, etc. I have a form that displays this information. In addition to…
gcarterIT
  • 125
  • 1
  • 4
  • 13
0
votes
2 answers

Loading Access table into DataSet .NET

Good day, I'm using the OleDbDataAdapter in VB.NET to load query results into a data set. However, when I step through the code it only loads the columns into the data set and not the rows in the query. I did do a brief test by exporting that query…
Rahul Kishore
  • 380
  • 1
  • 8
  • 19
0
votes
1 answer

Access Query to Delete data based on Complex criteria

I'm using Access 2013. I've a Table name - Raw and its Fields are: requestid - Number Formname - Short Text Timestamp - Date/Time Type - Short Text ActionBy - Short Text Raw table contains all the data. Same request ID will be…
Akkitech
  • 39
  • 1
  • 1
  • 11
0
votes
1 answer

Access dB Throwing Runtime 5 Shell Error when Run in Access 2013 but not in Access 2010

Ok, I'm Stumped. I built a dB that pulls data from Yahoo Finance API to compile a report. Built in Access 2010 and housed on out network. Everything was working like gravy. Well now, I have a dedicated computer, that this is going to run from. After…
SanLuka
  • 125
  • 2
  • 13
0
votes
1 answer

Error 3075 When breaking down long text for update query

The Description field is a long text field with over 255 characters. so I'm trying to break it down before I update it. My error reads: Run-Time error '3075 Syntax error (missing Operator) in query expression "titlename'Set Description =…
Mekenzie Buhr
  • 11
  • 1
0
votes
1 answer

Update Column C with the difference of Column A & B (Timevalue)

I'm looking for UPDATE query to update 3rd column with the difference of first two column. Below is my data. Table name - Report Field Name - Data Type -------------------- New - Date/Time Opened - Date/Time NewOpen_Time -…
Akkitech
  • 39
  • 1
  • 1
  • 11
0
votes
1 answer

MS Access: Passing Parameter to Subreport w/o SQL

I'm trying to find a way to pass a parameter from a report to a subreport without resorting to any SQL code or macros (my officemates are non-technical, but still have to use the Access database to run reports, occasionally making tweaks to them.)…
Chris Nemarich
  • 78
  • 6
0
votes
1 answer

How to update the table data using stored procedure in MS access datasheet view

I'm working with MS access front end and sql server backend.I have created a Pass-through query and i have the "Exec storedProcedurename" in the passthough query.when i create a datasheet view for this pass-through query the fields are non…
user2514925
  • 931
  • 8
  • 33
  • 56
1 2 3
…
99
100