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

"No current record" message in Access database

We have an Access (2013, 32 bit) front-end database with a switchboard form with buttons to open other forms. Those other forms have buttons that (when pushed) close themselves and return to the switchboard form. Recently, when you have a…
Emily Beth
  • 709
  • 1
  • 7
  • 23
3
votes
1 answer

Access Update Query using VBA

I have a Table like this SNo Block SAP SAG BAP BAG DEP DEG 1 600403 1 3 5 4 2 600405 1 3 1 3 1 1 3 600407 3 1 2 4 4 600409 3 1 5 600410 1 3 2 5 1 3 6 600413 1 4 …
Macs
  • 61
  • 1
  • 8
3
votes
2 answers

Simple SQL statement

I have a table that has 2 columns: Location and job title in MS Access I want to create a query that can find the sum of job titles in each location. For example: Location Job Title…
Milad
  • 43
  • 5
3
votes
1 answer

SELECT INTO query with NOT IN subquery takes a long time / hangs

The issue is that this query hangs or has infinite records which I am not aware on how to fix using MS ACCESS: Expected User Input: User input Start Date: 1/15/2015 User input End Date: 11/15/2015 User input Upper Data Threshold in kB: 50 Source…
stitch70
  • 143
  • 1
  • 3
  • 15
3
votes
1 answer

Code to read and then write a file into a SQL Server BLOB column producing files with different bytes

Using: MS-SQL Server 2014 MS-Access 2013 with linked ODBC tables to the SQL Server database "SQL Server" ODBC driver (10.00.10586.00, Microsoft Corporation, SQLSRV32.DLL) DAO We have an Access database with linked ODBC tables to a SQL Server…
Steve F
  • 1,527
  • 1
  • 29
  • 55
3
votes
2 answers

MS Access 2013 to show only startup form and nothing else

While starting up my MS Access 2013 database, I only need it to show the startup form and nothing else. Desired result would be something like below. The background is my desktop. Desired: However when I open the DB, the form opens taking the…
Subhojit Bhowmick
  • 33
  • 1
  • 1
  • 3
3
votes
4 answers

Cannot add or change a record because a related record is required in table 'COMPANY'

I think my Contact List database design is correct, but there is an error. Access 2013 is telling me: You cannot add or change a record because a related record is required in table 'COMPANY' I'm new to Access and this is for a class called…
Eric Hepperle - CodeSlayer2010
  • 3,745
  • 10
  • 38
  • 53
3
votes
1 answer

Access 2013/2016 does not support treeview control, giving error message "User defined type not defined"

I have a VBA project which runs perfectly upto windows 7 (both 32,64 bit) and upto office 2010. But when i try to run it on office 2013 or 2016. It does not load treeview control and gives error at: Private SelectedNode As MSComctlLib.node The…
yogeshgirnar
  • 29
  • 1
  • 4
3
votes
1 answer

Set label visibility in continuous form

tablecontinuous formI need to update to visible or invisible a label in a continuous form based on the status of a field in the same record. I tried with the below but it only takes the value of the first record. In other words it updates…
Johnny H.
  • 51
  • 4
3
votes
1 answer

Delete 5 Records but RecordsAffected Property is 0

Here is a code snippet: Private Sub frmSearch_UnMarkAll() Const sqlD As String = "DELETE * FROM PickList WHERE TableName = ""CARS"" AND KeyNo IN (" & _ "SELECT RecNo FROM Cars " If frmSearch.WhereSql <> vbNullString Then CurrentDb.Execute sqlD &…
Perry Sugerman
  • 179
  • 1
  • 11
3
votes
1 answer

VBA and GetRawInputDeviceList

I am working in Access 2013 and try to get GetRawInputDeviceList, GetRawInputDeviceInfo, RegisterRawInputDevices and GetRawInputData equivalents for VBA with no success. I have also searched in vain for a procedure, function or module to get a list…
DevilDawg
  • 53
  • 5
3
votes
2 answers

Determining if a field is a calculated field in MS Access

I have an Access 2013 database and I'm trying to connect to it in C# and get information about the fields in the database. Everything is working except one thing I'm not sure about is how to determine if a field is a calculated field or not. Here is…
Icemanind
  • 47,519
  • 50
  • 171
  • 296
3
votes
2 answers

Access INSERT with nested SELECT

Why does the following SQL statement not work? INSERT INTO dialog (speaker, dialog_text) VALUES ( ( SELECT FIRST(id) FROM FIGURE WHERE char_name="Doe" AND forename="John" ), "Some text" ); It produces this error:…
Sandro Koch
  • 303
  • 1
  • 4
  • 11
3
votes
1 answer

Access 2013: What is the proper way to delete records containing multi-value fields?

I want to delete a set of records as determined by a query which joins two tables. The tables contain multi-value fields (the bane of my project but I can't get rid of them at this point). I've learned that nothing is simple with multi-value…
CS4
  • 77
  • 5
3
votes
1 answer

VBA calculate MD5 hash on file contents

I need a VBA routine to calculate the MD5 hash of a file's contents. I located some examples (e.g., here) but I found that they crashed when the filename contained certain Unicode characters, so I am trying to tweak the code to avoid that. This code…
user3791372
  • 4,445
  • 6
  • 44
  • 78
1 2 3
…
99 100