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

Access 2013: could I use a data macro to trigger an MS SQL SP without delaying the execution in Access?

My client uses a multi-user split Access database (ie back end DB on server, client DB on each PC) as a point of sale system as well as for management functions. He now needs it to update a remote MS SQL database but cannot afford to slow down the…
YAOWSC
  • 1
  • 1
0
votes
1 answer

Using Distinct Clause with expressions

I am trying to use the distinct clause to add these two values together, but when I do it still gives me two separate rows. Ultimately I want to add these two rows together. A screenshot of the table view from my query Basically this is a database…
Ivan Yim
  • 21
  • 4
0
votes
1 answer

How to data from one form to another in MS Access 13

I have a database in MS Access 13 in which there are 2 forms "Project List" and "Completed Project". In the project list form I have a dropdown in "Status" field in which there are 2 options "Completed" or "InProgress". Now I want to move data to…
diamond421
  • 137
  • 1
  • 2
  • 12
0
votes
1 answer

What is the correct syntax for referencing a field with a hyphen?

I have an indexed field, and if a duplicate entry is attempted on a form, I want to give the user the option to navigate to the original record. I tried the following code, adapted from an answer to a similar problem I found here. In my case, the…
Can'tSpeakTheLanguage
  • 3
  • 2
0
votes
2 answers

Set Calculated field that calculates difference of a date field and current datetime (Now function)

I have 3 fields: [CreatedDateTime], [ClosedDateTime] and [TAT]. Default value of CreatedDateTime is =Now() so everytime a new record is added this field is auto-populated with the current datetimestamp. Now the 3rd field needs to contain the running…
L42
  • 19,427
  • 11
  • 44
  • 68
0
votes
1 answer

Is it possible to create HTML interface for desktop Access database?

I have a desktop database that I'd like to use an HTML interface for forms and such. Unfortunately SharePoint is not an option for me so I have to use a desktop database. Everything I've googled is either outdated or involves an actual web server. I…
CodeJack
  • 19
  • 2
  • 5
0
votes
1 answer

Form - Don't Add/Modify Record until Submit button clicked

I want my forms to function like most web site forms: no added/edited records saved until the Submit button is clicked. I want to be able to exit the form without getting validation errors or a new record created. Is there a toggle where it won't…
CodeJack
  • 19
  • 2
  • 5
0
votes
1 answer

MS Access : Drop down List is too slow

I created a drop down list in MS Access (Form) based on a Query (multiple tables), the problem is it takes about a minute to open the drop down. If I open the Query it opens instantly. I found out what is making the Drop down to respond so slowly.…
adp
  • 311
  • 2
  • 7
  • 19
0
votes
1 answer

Overflow error of dividing two columns of crosstab query

I have a qrosstab query to find the percentage of the passed students in each class and subject. The qrosstab query that I have includes three columns namely : Class (Row heading) subject (Column heading) Percentage: (Value) The percentage field…
FSm
  • 2,017
  • 7
  • 29
  • 55
0
votes
1 answer

Select Statement Includes a Reserved Word or an argument name that is misspelled or missing, or the punctuation is incorrect

I've written a SQL code in access 2013 where it runs smoothly and quickly (i reduced query time by 20 seconds with this code). When I bring it into excel vba to pull to a spreadsheet, i get the error that is in the title of this post. I made two…
RichWolff
  • 45
  • 8
0
votes
0 answers

MSAccess 2013 Weekly Report

I try to make a weekly report on Access 2013. This must show in columns the week days from Tuesday to current Monday and if it begins the month should show from the first day until current Tuesday. In this way if the user selects the entire month…
LOVS
  • 1
  • 2
0
votes
1 answer

Validation Rule in Access Not Accepting Valid Data; Can't Save Record

I am using some simple validation rules on a table in the database I manage (it is ANSI-89 at the moment, if that helps). One, for example, reads: Like "#" Or Like "##" As I understand it, this should allow any single- or double-digit number (1,…
user4734199
0
votes
1 answer

Connect to MS Access DB (.accdb) Without "Access Database Engine 2010"

I'm working on a 64 bit C# solution and I wish to connect to an MS Access DB (.accdb file) without installing "Access Database Engine x64". The "Access Database Engine x64" installation demand that the currently installed MS Office version is a 64…
Hanoch Giner
  • 359
  • 1
  • 4
  • 12
0
votes
1 answer

Microsoft Access 2013 Validation Rule with Literal Asterix

How do I add a validation rule to a column in MS Access 2013, where the column value can either be "A" or "*"? When I try to add the validation rule: "A" Or "*" The MS Access Expression Builder changes it to: "A" Or Like "*" Which doesn't…
Jeff G
  • 4,470
  • 2
  • 41
  • 76
0
votes
2 answers

SQL Calculate Percentage in Group By

I have an SQL query that is used as the basis for a report. The report shows the amount of fuel used grouped by Year, Month and Fuel Type. I would like to calculate the percentage of the total for each fuel type, but I'm not having much luck. In…
mack
  • 2,715
  • 8
  • 40
  • 68
1 2 3
…
99
100