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
1 answer

Add 2 Datetime + 1 BIT Columns to MS Access DB

ALTER TABLE Warranty ADD COLUMN StartDate2 DATETIME, EndDate2 DATETIME, Status2 BIT This isnt getting me far - I even tried to break it down like this: ALTER TABLE Warranty ADD COLUMN StartDate2 DATETIME But get an error saying "The following…
Havoux
  • 165
  • 3
  • 17
0
votes
1 answer

Access 2013 - Validation Rule Troubleshooting

I am trying to import data from an old system into an Access backend. In the new Access backend, I have field validation rules on multiple fields. I've imported the old data into a file dump table. This dump table is then queried to make sure all…
TMY
  • 471
  • 1
  • 7
  • 20
0
votes
1 answer

Make report title equal to last field in table Access 2013?

I have a report that displays information from a query of a Trucks Table in access. I also have another table called Versions that stores the date of the last edit. In the title of the report I currently have the following control source. ="Trucks…
Darin
  • 47
  • 1
  • 6
0
votes
1 answer

Horizontal and Vertical filter in Access SQL

Hey guys I'm trying to achieve the above, and having trouble finding a starting point (Also apologies on using an image, I'm fairly new to both stack overflow and access so I couldn't format a nice table for an example). Here's the table…
mattlore
  • 144
  • 2
  • 4
  • 17
0
votes
1 answer

Unfreezing columns in a subform in Access

I have a form with a subform that displays records, and the user is able to rearrange that subform and save their preferences. This means they can change the width of the columns, the order, hide columns, etc. and save their changes at any time, and…
Kat
  • 239
  • 2
  • 12
0
votes
1 answer

How do I work out the average of two columns? Microsoft Access

I'm currently making a report on Microsoft Access 2013. I've created a query first and then selected the appropriate tables and fields. The last two fields of my current query are: CourseworkMarks Examination Marks Both fields contains a number…
Matt
  • 61
  • 2
  • 12
0
votes
2 answers

How do I make table links in between 2 Access databases persist?

I have 2 Access 2013 databases, A and B. A is used as a front-end with links to tables in B. A is used by multiple users. Sometimes when opening, the links need to be refeshed using "Linked Table Manager." Sometimes the "Linked Table Manager" will…
gcarterIT
  • 125
  • 1
  • 4
  • 13
0
votes
0 answers

ms access search for record with multiple combobox

I have form with several comboboxes set to filter my database by record. For example I have: product, type and size columns and according to this i have dynamically changing comboboxes. So what I want is to find a record that matches all choices…
nika
  • 59
  • 1
  • 8
0
votes
1 answer

Create sequential ID value based on the year that a record is added

I am working on an Access 2013 database that will have different utility poles entered into the database and linked with other attributes. Each pole will have a unique global ID, and to simplify working I would like to add another unique ID that is…
GIS Pat
  • 113
  • 1
  • 4
0
votes
1 answer

Access - Sum a singular field entry

In Microsoft Access I am trying to create a form to enter expense reports by their type of expense (i.e. Airfare, Meal). These expense reports often have multiple charges for each type of expense that I would normally have to add up each expense…
Jcoleman328
  • 1
  • 1
0
votes
1 answer

Difference speed between physical machiner/virtual machine for a LDAP connection in VBA

I'm currently working on a access project in which I have to search different users and groups in a LDAP server. I use vba code to do that. To test my application I ran it with Access 2013 in a physical machine and in a virtual machine. I noted that…
J.Mercier
  • 1
  • 1
0
votes
1 answer

access 2013 crashes when opening report in design view

I am in the process of migrating several critical Access applications from Access 2007 to Access 2013. Generally this is going smoothly, but I am now facing a major issue. Foreword: 1. By migrating I mean using the same db's (they are in accdb…
Dan Koenig
  • 1
  • 2
0
votes
2 answers

Query to find out entries where dates don't overlap

Can anyone help me create a query which will populate a list of DJs who are not already booked in. My user will select a start date (and time), and an end date (and time) - and then click a button to select a DJ. I only want those DJs which are…
Mitch
  • 53
  • 9
0
votes
1 answer

Office 365 and Sharepoint apps

is there a way to create a access web app and use as database an azure sql database. and use it as the main application database or a secondary one. Either is it possible to create a database that is shared over more than one sharepoint app. Last…
Sarantis
  • 3
  • 3
0
votes
2 answers

Adding rows of one table to rows of another table where two tables are matched by ID

In an Access 2013 database, I have a table t1 and another table t2. They both have the same number of columns and column names are also the same. Table t2 have a number of overlaps with id variable of table t1. I am trying to make a new table t3…
shammun
  • 177
  • 2
  • 3
  • 14
1 2 3
…
99 100