Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [microsoft-access-2013]

The 2013 version of the Microsoft Access database product.

0
votes
0answers
17 views

MS ACCESS Compact on Close behavior for Backend MDB

I understand the "Compact on Close" Setting for a standalone Access MDB File. But, I cannot confirm whether the "Compact on Close" Setting affects a "Back End" MDB file (that is, an MDB "Database" ...
0
votes
0answers
9 views

Possible causes for Write / Read Race condition - Windows 7 - Access 2013 [closed]

This is one of those I have seen it happen often enough to know it happens issues but is intermittent enough to lose sight of it and impossible to "prove". I am in a big corporate environment using ...
0
votes
0answers
63 views

Using older Access 2000 MDW-file in Access 2013 (and later)

I have an Access application first created in Access 2000. The Workgroup file was created in Access 2000. It worked fine in Access 2007, but when I try to use it in Access 2013 (or later) it says that ...
1
vote
1answer
16 views

Is it possible to create a condensed view of an already existing table?

I have a database with two tables. The first table (Inbound) is a list of tables and their respective data fields that are used to create Output tables. The second table (Output) is a full list of ...
0
votes
1answer
422 views

MS Access won't display line breaks of existing data

I am creating an MS Access front end for data from somewhere else. In this case, it's a linked SQL Server table. The data is actually imported from a shared-hosting LAMP web server. It's the ...
1
vote
1answer
302 views

In an MSAccess Form, using Continuous Forms, how can I get alternate row colors by data grouping?

When I use Continuous Forms in an MSAccess Form, it automatically applies an Alternate Row Color to every other row. I would like to have the alternate row color for groups of rows of data. Some ...
1
vote
1answer
840 views

Tell If Local Table Is A Linked Table In A Separate Database

I just took over as an IT guy at a company that has a myriad of Access databases all with local tables. A database may have 20 local tables, and 10 of the tables are linked into different databases ...
0
votes
0answers
392 views

How To Catch Any Error In Access VBA

I found a tutorial which showed me how to log errors in Access VBA, and it works mostly...but when checking my error table there are roughly 40 entries that do not have an error number logged nor is ...
0
votes
0answers
191 views

Error Exporting Access Table to Excel

I am using the below lines of code to export an access table that holds roughly 7,000 lines to Excel 2013, but I keep getting an error. What do I need to do in order to resolve this error so I can ...
3
votes
1answer
244 views

Access 2013 32bit Crashes in Windows 7 but not Server 2012 R2

I converted a 97 Access database to Access 2013 32bit. The database now crashes in Windows 7 but works fine in Windows 2012 R2. If I copy the database to the PC, the first time the database is opened,...
0
votes
0answers
14 views

Automating Entries for Invoicing in Payments Table in Access 2013

I have an access database that I use to manage my customer base. Each customer pays me a subscription on a monthly basis but I have to insert an entry manually each in the payments table to "invoice" ...
0
votes
1answer
58 views

Trouble removing null fields and delimiter while concatenating in access select query

I am relatively brand new to Access (using 2013). I'm linking my query to Excel which is working fine. I had a concat function that I probably got from this site but Excel didn't like linking with an ...
1
vote
1answer
564 views

How do I make a macro to generate a record number based on the fiscal year? (Access 2013)

I would like to create a record number that is based upon the fiscal year and automatically advances... Something like: 2015001, 2015002, 2015003, 2015004; 2016001, 2016002, etc. I already have a [...
1
vote
1answer
1k views

Microsoft Access 2013 - Search for one word in multiple columns at the same time

Is it possible to search in multiple columns for the same word and get every row (no matter in which column the word stands) as a result? For example: I have a database consisting of 5 columns and ...
1
vote
2answers
612 views

How to replicate a MS Word document's layout and formatting in a MS Access 2013 report

I'm building an order processing system in MS Access 2013 that allows the employee to input order details from the customer's form, then the system records this in the database and generates an ...
3
votes
0answers
1k views

Getting error (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY) when migrating from MS Access 2013 to SQL Server 2014

OK.... I've checked and rechecked Google, StackFault, Experts-Exchange, etc... for a resolution on this error and they all say to register the DAO360.DLL and add its path to the environment settings. ...
1
vote
1answer
561 views

How to create a MS Access query to show a data in columns by criteria?

I have a little problem with MS Access 2013. I cannot figure out how to create a query to show needed data in one table. The data structure can be illustrated with the following: USERS ID Name 001 ...
0
votes
1answer
2k views

Access 2013:Trying to write macro to update form fields from a query result

I am trying to create a macro to update the value of a field in a form based off the results of a query. I am entirely new to working with vba in Access so I apologize if I am asking a basic question....
1
vote
2answers
1k views

Microsoft Access. Working with queries and null values

this might seem an easy question but I can't figure it out. I have a table with a number of fields. 3 of them (SizeA, SizeB, SizeC) are numbers and I have a form which uses a query to query the table. ...
0
votes
1answer
6k views

How to store a Display text along with Hyperlink in Microsoft access 2010 database?

i mean how to store "Display text along with Hyperlink" in microsoft access database so that when you generate "Forms" from the database table. and you click on the that item text , you are actually ...
0
votes
1answer
872 views

Opening an access 2007 database in access 2013

I have a database in ms-access 2007. Now my new system has been installed with office 2013. So, When I tried to open the access 2007 database in 2013, all the features like HOME, CREATE, EXTERNAL DATA,...
2
votes
1answer
576 views

Unable to edit data on datasheet in Ms Access 2013 - Get write conflict

I have been tasked with converting an old ADP project to something that Access 2013 can handle. I've imported all the forms and VBA, relinked the tables and changed the connection to an ODBC ...
0
votes
2answers
15k views

Import a large number of .csv files into Access

All the CSV files are all in the same format. I want each CSV file to be in it's own table, with the table name being the same as the filename. How can I do this?