Questions tagged as 'ms-access-2010'

Tagged questions
2
answers

Emulate subquery without main table in Access

I can do this in SQL Server: SELECT 'HERRAMIENTA ELÉCTRICA' AS TIPO_PRODUCTO, 0 AS DEPRECIACION, (select sum(empid) from HR.employees) STOCK But in Access the same query returns the following error:    Query input must contain at least o...
asked by 15.12.2015 / 07:53
1
answer

Problem with sub-query in Access

I have a database in Access that has the following tables: Table Options Columns: Id_Option int Option varchar (50) Status (bit) Contains these data: Table Votes Columns: Vote_ID int Id_Option int...
asked by 16.08.2016 / 23:59
1
answer

Syntax error in the FROM clause

I have 2 questions on a single topic. The following function works on other developments normally. Public Function VerificaUsr(ID As String, Psw As String) As Boolean Dim Rslt As Boolean Rslt = Conectar() If Not Rslt Then Exit Fun...
asked by 21.03.2018 / 05:52
1
answer

Use the value of a variable within the string of a query

Usually when I assign a variable to a constant I would do it in the following way. Dim user As Variant user = InputBox("Ingresa tu usuario de la PC") I am connecting data with Visual Basic and Access. In one part of the query I declare th...
asked by 06.03.2017 / 19:08
1
answer

Insert of c # with access

I have an error with the insert to the Access database, when I run the program and fill in all the fields and I click save it appears that it was saved correctly and does not show any error in the exception, and when I go to see in the database...
asked by 25.07.2016 / 04:44
1
answer

How do I fix this error in Access and vb

I need help with the following error in the following images the code in which the error occurs is displayed     
asked by 23.07.2016 / 07:01
1
answer

Create query with LIKE parameterized? (JAVA / UcanAccess)

Good! I come here with a small question: How exactly could a query be written using a Like and be parameterized? I'm using UcanAccess with JAVA. I have a window in my program that requires the use of Like. Try first by writing it "normal" i...
asked by 28.10.2016 / 16:19
2
answers

Free space used in BBDD Access

I am making an application in VB.net (4.5) using as BBDD Access (2016), but I have a small problem: when I insert a record (for example, a Richtextbox converted to Byte ()) the size of the DB increases. But when I eliminate it, the size does not...
asked by 19.02.2016 / 09:40
0
answers

Fields that have no Access sql Access

I'm trying to get an sql for Access that takes out the records that have no relation, the key of the references is Type, Anne, Number and the other table, article, has the fields: type, anne, number, dossier I have done this but it does not retu...
asked by 16.05.2016 / 13:15
2
answers

Obtain unrelated data from each other

I'm trying to get the data that is not related through a query between three tables, but I have not achieved the feat. In my case I have three tables Marcas Categorias Asignacion (It is the intercept table between Br...
asked by 14.10.2017 / 04:30