ms-access-2013 Questions
6
Solved
I have created a Microsoft Access file.
How do I add this file to the trusted locations on my client's PC where there is only the runtime version of Access installed?
Tom asked 20/7, 2015 at 5:23
7
Solved
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 ...
Nappy asked 7/9, 2015 at 8:46
4
Solved
How can I view the metadata(data dictionary) for a Microsoft Access 2013 table?
Housemother asked 6/7, 2014 at 4:36
14
I have an Access database created more than 10 yrs back.
I have very important data in it & I think it can be opened in Access 2007 or earlier version. Currently I have Access 2013 in my desk...
Rosol asked 9/6, 2014 at 8:41
5
Solved
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 textbox...
Clingfish asked 8/9, 2016 at 13:3
2
Solved
I want to be able to view the contents of my access database's laccdb file through VBA so I can use it to alert users (through a button) who else is in the database.
I specifically don't want to u...
Nonferrous asked 8/9, 2016 at 13:54
2
Solved
having a problem with an Access 2013 program that I need some outside insight on.
We have upgraded our terminal server to windows server 2012 r2 from windows server 2008 r2, along with Office 2010...
Aculeate asked 18/9, 2017 at 10:33
3
I have made up Tracker form in Access 2013 in which end user update their daily routine tasks. I want to keep the table as read-only so that no one can make any unauthorized changes in the existing...
Fastidious asked 19/5, 2014 at 12:45
1
Solved
I am iterating through files in a folder (which means I do not know the names in the folder), and have a file with a Polish ł character.
The Dir function converts this to an l which means the fil...
Imagery asked 13/11, 2015 at 4:33
2
Solved
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 va...
Purcell asked 12/4, 2015 at 18:46
2
Solved
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 Shor...
Scalawag asked 19/5, 2015 at 11:13
2
Solved
Access 2013 does not support ADP. Some alternatives to ADPs are given:
Convert the ADP to a linked Access Desktop Database.
Import objects into an ACCDE file and then create linked tables to the...
Nicholson asked 6/11, 2013 at 8:18
3
We have a fairly large Access front-end application that has been running on Access 2010. It makes extensive use of ADO recordsets for accessing data on our SQL servers, and frequently uses the Uni...
Ciscaucasia asked 20/12, 2013 at 0:28
1
Solved
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) an...
Isleen asked 4/11, 2014 at 13:54
1
Solved
I am trying to figure out a way to create a program that allows me to find the best combination of data based on several different factors.
I have a Microsoft Access file with creature data in it...
Privatdocent asked 13/9, 2014 at 6:58
2
Solved
I have the following code which allows me to attach a report then send it to one recipient.
How do I send it to more than one address?
I've tried putting the addresses in an array but it gives a...
Jacquiline asked 27/8, 2014 at 10:37
1
Solved
I am trying to rebuild an Access adp project in Access 2013 as and mdb. The tables are all linked tables in both version so that is not an issue.
I have imported the forms from the old project so ...
Futurism asked 3/4, 2014 at 17:51
1
Solved
I am updating a table in a .mdb format Access database with Access 2013. I want to add a new field, lets say a Description field, to an existing table.
I can add a text column using the following...
Rode asked 18/2, 2014 at 15:16
3
Solved
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 oA...
Drew asked 27/11, 2013 at 20:35
5
Solved
I am trying to code an if statement where if a certain combobox is null, then it runs a certain part of code if it has data in it then it runs another. I wrote up this:
Private Sub ProjectAddSetDa...
Premeditate asked 12/11, 2013 at 12:27
1
Solved
My SQL query is as follows:
SELECT * FROM Suppliers
WHERE SupplierName
LIKE 's%';
When I submit this query on W3 School's TryIt Editor (v1.2) (http://www.w3schools.com/sql/trysql.asp?filename=try...
Chateau asked 27/9, 2013 at 12:41
2
Solved
How can I get second table from first table using TRANSFORM and PIVOT functions:
TABLE_01
Config_ID | ConfigField | ConfigValue
-----------------------------------------
11 | Name | Basic
11 | ...
Bicipital asked 22/5, 2013 at 12:31
1
© 2022 - 2024 — McMap. All rights reserved.