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
5
votes
5 answers

MS Access unwanted BreakPoint

I have a complex MS Access 2013 database with tens of forms. On one of the forms, I have button with vba procedure back to it, which returns values from MS SQL(ADODB) and puts them into the textboxes. Problem is, whenever i click this button, it…
Tedo G.
  • 1,556
  • 3
  • 17
  • 29
5
votes
7 answers

VBA Access check if Parent form exists

in MS Acces I'm opening a Dialog Form from another Dialog form. So formA, opens formB. But they user can potentially open formB as standalone, I would like to avoid having errors in this case. I thought about checking for and Existing parent for…
KameeCoding
  • 693
  • 2
  • 9
  • 27
5
votes
2 answers

Execute a SQL Server stored procedure from MS Access

I use MS Access 2013 and SQL Server 2012. I have connected my SQL Server database to MS Access. I connect to SQL Server via SQL Server Authentication. I want to execute a stored procedure with a value entered into a textbox in one of my forms. I…
Joanna
  • 53
  • 1
  • 1
  • 3
5
votes
3 answers

Access ODBC can't pull from SQL table with more than 255 columns

I have a database that I'm trying to query from Access with ODBC. The table I need to read from has 304 columns, and I can only see the first 255 in the Query Builder. I've read elsewhere that the solution is to write an SQL query by hand rather…
mgroat
  • 1,092
  • 1
  • 11
  • 16
5
votes
1 answer

Hyperlink in MS Access report

I've made an MS Access 2013 database to keep track of all communications regarding a trading website. The tables and columns relevant to this question are Advertisements with columns ID (Number) and Link (Hyperlink), and Notes with column…
Gentle153
  • 327
  • 2
  • 5
  • 15
5
votes
2 answers

Access 2013 VBA - Setting New Click Event for Controls

I have searched everywhere for this, and it seems like a simple fix, but I can't seem to find the solution. I have several Rectangle controls in my Access 2013 form, and I'm creating an OnClick event that handles them all. I've worked on a few…
JaredS
  • 93
  • 1
  • 3
  • 9
5
votes
3 answers

Using SetParent to make an Access Form escape from Access

I have been trying to get a Microsoft Access for to 'escape' from the main Access window so that I can hide the Access window and just show the form on the desktop so that it can be placed alongside other applications easily. At first I found some…
ec2011
  • 570
  • 6
  • 20
4
votes
2 answers

File Save Dialog In Excel VBA

I am trying to follow the tutorial here http://software-solutions-online.com/excel-vba-save-file-dialog-getsaveasfilename/ and have typed up my code to be: varResult = Application.GetSaveAsFilename(FileFilter:="Excel Files (*.xlsx), *.xlsx") Now…
IcyPopTarts
  • 494
  • 1
  • 12
  • 25
4
votes
2 answers

DoCmd.TransferSpreadsheet Issue

I am exporting a query to Excel in Access 2013. This is the syntax that I am using for the export DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qryDataExport", strExportPath, True The data transfers as it should, but one of the…
BellHopByDayAmetuerCoderByNigh
  • 1,107
  • 4
  • 21
  • 41
4
votes
2 answers

Scrolling in subreports where parent is a form

I'm having trouble scrolling in a report that is in a Sub Report/Form control on a form. I can scroll by clicking and dragging on the scroll bar just fine but I would like to use the mouse wheel. I see that this functionality was removed as…
Brad
  • 11,934
  • 4
  • 45
  • 73
4
votes
2 answers

Move folder across network using vba

I am trying to figure out how to properly move folders on a Network Share using VBA code from an MS Access Form. Currently I am trying to use the FileSystemObject.MoveFolder method but keep running into a "Permissions Denied" error. I have…
Pants
  • 669
  • 7
  • 24
4
votes
1 answer

Connect Laravel with MS Access as Second database

I have three problems. Access MS Access with Laravel application. Connect MS Access as second database with Laravel application, my first database is mysql. When any new records added in MS Access database, my script copy that records from MS…
Waqas Mehmood
  • 199
  • 3
  • 17
4
votes
1 answer

How to run DDL in Access 2013?

I need to run DDL script to create tables to import data into Microsoft Access. I have the DDL script already made and it has worked in Oracle SQL Developer already, but I'm looking to do it in Access as well. I can't seem to find an easy way to do…
lmb57
  • 41
  • 3
4
votes
1 answer

Why does this loop not loop?

string GetSerials = "SELECT SerialNumber from Warranty"; string TestUpdateDates = "UPDATE Warranty SET StartDate = '@StartDate', EndDate = '@EndDate' WHERE SerialNumber = '@result'"; //string TestUpdateDates2 = "UPDATE…
Havoux
  • 165
  • 3
  • 17
4
votes
2 answers

How to remove images stored in access (.accdb)?

I'm trying to keep access database size to a minimum and need to remove several large images that previously were used but now aren't needed. My understanding is access files (.accdb) store images inside the database. Do you know if it's possible…
Rang
  • 55
  • 1
  • 7
1
2
3
…
99 100