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

Parameter Value

SELECT ID, AppID, Description, Min([Transaction Date]) AS TransactionDate FROM AppProsHist WHERE [Description]='Non-Final Rejection' GROUP BY ID, AppID, Description ORDER BY TransactionDate DESC I keep receiving a Parameter Value box for…
Johnfun10
  • 118
  • 8
4
votes
2 answers

uploading data with dates to MS Access database with pyodbc

I'm trying to insert data with a date to MS Access using the pyodbc library in Python. My table has 3 fields: Date (Date/Time), 1Y (Number), and 2Y (Number). I know the problem is not a connection issue since I'm able to insert successfully without…
tpoh
  • 261
  • 3
  • 11
4
votes
2 answers

Access 2013 accde file can't export to acFormatXLSX

I have an Access 2013 database and I saved it as an accde file to give to the end users. I noticed that the Report Print Preview no longer had the export buttons on the ribbons. I am not sure why they are there in the accdb but gone in the accde…
Mrphin
  • 185
  • 2
  • 15
4
votes
1 answer

Access: Update query with count in subquery - error or all results

I know that you should not store calculated values in a database but in this case the structure is given and I have to deal with that. I have two tables: Table1 with the fields (i.e. customer, product, price, count) Table2 with the fields (i.e.…
Thorsten
  • 43
  • 1
  • 4
4
votes
1 answer

Error Handling in Queries of Access #Error

I am working on a Attendance table in Access, where I have InTime and OutTime. These fields are of Date/Time Field. Some records contains only Time like 11:40:00, some contain Date as well as time like 21-07-2015 11:45:00. Hence have used the below…
Adarsh Madrecha
  • 6,364
  • 11
  • 69
  • 117
4
votes
2 answers

What are the String, LongText and ShortText lengths? Setting Long Text as SQL Parameter results in Error 3001

When I create an append Query in ms-access 2013 with parameters and any of those parameters' type is set to LongText the query fails with error code 3001 Invalid Argument. Changing the type to ShortText however results in a working query. Both…
luk2302
  • 55,258
  • 23
  • 97
  • 137
4
votes
3 answers

Pasting into Access from Excel - Non-numeric entries don't get through

Every once and awhile a user will complain about my Access application losing fields. I've found out that they are right. Access in certain situations will simply drop accepting data from a copy and paste operation for a certain field,…
Israel Lopez
  • 1,135
  • 3
  • 11
  • 25
4
votes
1 answer

MS Access 2013 - Filter values in a list box, based on value in a Text box

I have made a form with a Listbox displaying a lot of names and addressees based on a query. How can I filter the names in the form, based on a Text box in the same form? (Not all the names are relevant for every record)
user2308227
4
votes
1 answer

Are Access 2010 databases not accessible with Excel if password protected using default encryption (High Security)?

I am currently supporting an Excel 2010 spreadsheet and Access 2010 database that were written by business users. One of the requirements of the Access database is that it be encrypted. It was encrypted with the default encryption settings "Use…
tonyriddle
  • 388
  • 1
  • 3
  • 12
4
votes
3 answers

How do you export MS Access Query Objects to text file

In MS Access I need to back up all queries to a text file Im able to do this with other Access objects fine, for example the following is a sample that backs up all reports to a text file Dim oApplication Set oApplication =…
MichaelTaylor3D
  • 1,615
  • 3
  • 18
  • 32
4
votes
3 answers

SQL for showing total count of domain names from email column

I have an email column (duplicates-ok) in MS Access table from which I want to show all domain names (from domain part of email) and their counts in MS Access. Table: I have SQL: SELECT EMail.EMail, COUNT(*) FROM EMail GROUP BY EMail.EMail ORDER BY…
Computer User
  • 2,839
  • 4
  • 47
  • 69
3
votes
3 answers

TransferSpreadsheet Error 3251 Operation Not Supported

I have code to export MS Access (2016\2013) queries results into Excel spreadsheets that has worked for years. This is the code (not posting all variables definitions I've on top of it): strSQL = "select[query].* FROM [query] " Set qdf =…
Deltav
  • 33
  • 2
3
votes
1 answer

How to sum multiple fields from a UNION Query in MySQL?

I'm currently learning how to use MySQL in queries and I have a dilemma. Currently, I have 2 queries that fetch data from multiple tables. Both queries contain the same number of column fields and field names. For simplicity, the output of the…
Pangu
  • 3,721
  • 11
  • 53
  • 120
3
votes
2 answers

Updating an Access Table with a CSV File Automatically

Problem Background: I have a Powershell script that I can execute from my Microsoft Access Form that scans through file folders that contain information on different facilities, and produces a CSV that looks something like: SiteCode …
nuclearmatt
  • 35
  • 2
  • 8
3
votes
1 answer

Why won't the ForeColor of this label visibly change when altered in a loop?

I am making a form that has groups of controls that I want to visibly enable/disable with a related toggle button (let's call them Group Toggles). Each group has a different variety of control types, so I made a common procedure to handle the…
Ryan W.
  • 33
  • 6
1 2
3
…
99 100