Questions tagged as 'ms-access'

Tagged questions
0
answers

You can put a dynamic table or a dynamic graph in Access 2016

Good afternoon I have a query which I would like to make a dynamic table to create a report that comes out due to defects in the data. and I would like to know if it can be accessed?     
asked by 27.09.2018 / 15:23
0
answers

Help to connect Java with an Access DB

I made a Java connection with Access, and the connection is already done correctly, then I made an interface through which I can insert, edit and save data for the database but it does not work for me, I'll leave the connection code: package C...
asked by 22.08.2018 / 19:04
1
answer

filter delphi records

I am working on a project in delphi xe6 and ADO and MS ACCESS components as a base of tados. When I write a letter in edit1 for example the letter 'a' I see this error "incorrect arguments, outside the allowed range or in conflict with others...
asked by 17.08.2018 / 22:36
1
answer

VBA Acess - List Box (ListBox)

I want to make a List Box (ListBox) in Access 2010 not have any element selected by clicking on a button on the form. What VBA code could you give to do this?     
asked by 13.08.2018 / 13:37
0
answers

UCanAccess "user does not have sufficient privileges or object not found"

I have a problem using Ucanaccess. When I try to execute the query String query="SELECT Last Name FROM Table1 WHERE Name LIKE" + name; gives me the following exception: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc ::: 4.0.4 user d...
asked by 12.08.2018 / 19:26
1
answer

Get the name of the databases stored in a DBMS

I am trying to make a connection to a database manager (postgresql, Mysql and Access) and I would like to know if there is any way to connect to the manager and extract the information from the name of the databases that are stored there. All th...
asked by 22.07.2018 / 03:59
0
answers

SQL: Replace (Access)

|ID|cuenta| |ID|cuenta| |1 |"312" | |1|"0" | |2 | "422"|---------> |2|"312" | |3 | "55" | |3|"422" | Hello, I am looking for a query that can replace a data from one record with another from the same colum...
asked by 20.07.2018 / 18:07
0
answers

Problem with JSON, Access and Special characters in CodeIgniter

I expose the environment first: 1 Database in msAccess 1 Web server with a REST API generated in codeIgniter, which returns a JSON with the contents of a query to the database Access. 1 Postman to check requests. When in one of the fi...
asked by 19.07.2018 / 10:06
1
answer

Run Macro from a query (MS ACCESS 2013)

Is it possible to run a macro from a query in ACCESS 2013? I need to run it just by clicking on the query, I do not know if this is possible with clauses such as PROCEDURE, EXECUTE ... - . Attending the suggestion of calling the macro...
asked by 24.07.2018 / 21:14
1
answer

Access 2010 VBA - Error "The types do not match" in IF

In a VBA code of a button of an Access form, I have the following code: The result is an error like this: What is owed and how to solve it?     
asked by 09.07.2018 / 12:05