Questions tagged as 'ms-access'

Tagged questions
1
answer

Exception: "Can not convert a DBNull object to other types"

I have the following function that obtains data from a DB in Access. I throw the commented error in the header. I made a stop point, to know more or less in which place the error was occurring and I managed to find it on the next line. p4 =...
asked by 21.09.2017 / 17:45
1
answer

I need to print several querys in different columns in an html table

I have a large table and for each column I need a different query, the problem is that I can not get the data printed in the column on the next right; $connect = odbc_connect("proyecto", "usuario", "contrasena"); print ("Fecha de Inicio: $newD...
asked by 16.06.2017 / 18:18
2
answers

Resize a set of fields in a set of tables by means of a .NET loop

I have two vectors with String data Public tablas() As String = {"LinFraVen", "LinAlbVen", "LinPedCli", "LinPres", "LinFraCom", "LinAlbCom", "LinPedPro", "LinInven", "LinTarifa", "NecesidadProductos", "LinCuotas", "LinActob", "LinOrdCom", "Lin...
asked by 20.03.2017 / 13:31
2
answers

insert records from an excel file to a DB MS access delphi

I'm doing a program that imports Excel into the database, This is my code: var importdir, ipo: string; begin if OpenDialog1.Execute then begin importdir := ExtractFileDir( OpenDialog1.FileName ); ipo := OpenDialog1.FileName; end; ADOConnection...
asked by 11.09.2018 / 01:22
1
answer

Count different variants of a value in a VBA recordset - Access

I have a Recordset in VBA , I want to count how many variants there are of a value. That is, what in a query SQL would be:    SELECT COUNT (tag)       FROM table       GROUP BY tag Table would be the Recordse...
asked by 16.05.2018 / 10:45
0
answers

Calculate the difference between a previous value and a following value in Access [closed]

Good, I need to perform a calculation that brings me the difference between a current value and a previous value ..... The schema would be the following: Fecha | Costo | Diferencia 15/02 | 1500 | 0 17/02 | 1600 | 100 19/02 | 1500 | 10...
asked by 21.02.2017 / 13:14
1
answer

C # Add attachments to a database in Access

I have a database in Access that has a field of type 'Datos Ajuntos' and I would like to insert pdf files. I have the PDF path, I just need to send it. I imagine it would be something like: //Abrimos la conexión mas arriba OleDbCommand...
asked by 03.04.2017 / 04:53
2
answers

SQL syntax with variables

I'm building a database in Access, and I want to run an update query in vba . I know the syntax a little bit, but it's giving me a bug. The problem is that I try to pass some values to him by means of two variables, and it seems that...
asked by 13.03.2017 / 14:53
1
answer

Join queries in one, ACCESS

I have these questions: consultaA: SELECT DISTINCT t1.FK_HD, t1.DE_rfc FROM tbl_DE t1 WHERE (((t1.FK_HD)=105)) GROUP BY t1.FK_HD, t1.DE_rfc HAVING (((Sum(t1.DE_cantidad))<>0)) ORDER BY t1.DE_rfc; consultaB: SELE...
asked by 17.12.2018 / 17:00
2
answers

Print total of query count in a label

How about, I'm trying to print the total of a query count in a label , but when I call the result only prints a System.Data.DataRow This is my query /***********GET ALL THE FAKE TOOLS FROM FCH*************/ public...
asked by 09.06.2017 / 21:28