The 2013 version of the Microsoft Access database product.
Questions tagged [microsoft-access-2013]
21 questions
3
votes
0 answers
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. I've done that several times and I still get the…
John Schultz
- 300
2
votes
2 answers
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 invoice (which will then be printed in black and white…
jellyberg
- 41
2
votes
1 answer
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 connection.
Most everything seems to be working ok,…
John S
- 593
2
votes
0 answers
VBA options screen getting cut off in Access 2013
I was trying to change the font in the Editor Format tab of the Tools/Options window in VBA within Access 2013. The options window is not as wide as it should be. When I go to the Editor Format tab, the combo box for the Font option and the Sample…
Tony Mokonen
- 21
2
votes
1 answer
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, it won't crash but it'll will crash everytime…
1
vote
1 answer
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 hundreds of rows. Lets say the word "cat" stands in…
YHa
- 11
1
vote
1 answer
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 John
002 Sarah
003 Miles
RATING
UserID Year …
VIK
- 132
1
vote
2 answers
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.
Now, Size A is always not null, but SizeB and C…
guidout
- 123
1
vote
1 answer
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 what the Output tables are (Entity Name, Table…
Kaycee
- 11
1
vote
1 answer
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 groups might have just one row, but others will have…
Mike M
- 141
1
vote
1 answer
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 as linked tables.
Without opening each and every…
SmallFries BigGuys
- 99
- 2
- 7
1
vote
1 answer
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 [FiscalYr] field (calculated data type) in my table…
anmarse
- 11
0
votes
1 answer
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.
I should mention, the "test" query returns…
J.Scott
- 1
0
votes
1 answer
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 transferred to the website.
and what type of field…
Steve
- 157
0
votes
1 answer
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,etc. are disabled.
Also, when i try to open…
