Questions tagged as 'ms-access'

Tagged questions
1
answer

Connect VB6 to MSAccess

I created a database in MSAccess and created a connection module. However, when the execute gives connection error. Does anyone have another example of how to connect VB6 to MSAcess? My module code: Option Compare Database Option Explicit...
asked by 04.06.2014 / 14:29
0
answers

Repeat Query in Access

I need to open a form when a query is executed automatically. I do not know how to do this, I found Macro AutoExec but I do not know if it has any relation     
asked by 19.10.2018 / 17:00
0
answers

Form blank access

I created a form from an imported Excel table, and the fields are filled with the data in the first row of the table, I want them to be blank and even if it is possible to write in one of the fields. I tried to use the function: DoCmd.GoToRec...
asked by 19.10.2018 / 15:39
0
answers

Insert and total balance line by line in the same access table delphi

I have a single table in access bound to an ADOQuery and a DataSet with the following fields: CodR DataR Descricao Receita Qtde Tipo/Nome Valor Rec CodD DataD Descricao Despesa Valor Desp Cod Data Historico Receita D...
asked by 01.10.2018 / 01:13
1
answer

Add and display time greater than 24 hours in Access 2007 VBA

I'm using Access 2007 to develop a garage control form, which provides travel information made by drivers. I need to calculate the total amount of time for each trip, and this period can be longer than 24 hours. I was able to calculate without p...
asked by 20.09.2018 / 13:48
2
answers

Python code too slow ?? Access to Access database with pyodbc

I need to get some data from a huge access database (two, actually, depending on which input I have). I have a function that calls that bank by chunks (if I try a fetchall gives memory problem). This function is sometimes called by my main funct...
asked by 20.07.2018 / 18:48
0
answers

Recreate ACCESS table with identity ID of deleted records

I have a table in ACESS that over time have been deleted 100 records (improperly and I do not have backup), example: HowdoIre-createthetablewiththesamestructureanddata,butwiththerowsthatweredeleted?HomeIneedtorecreatethetablewiththeIDs6790,6791...
asked by 31.05.2018 / 14:15
0
answers

Composite Key (Product Code and Product Lot) how to do it?

Good afternoon, I started a little in ACCCESS, and I am making a table that should include the product code and its production batch, as well as other data such as description, quantity, etc. I would like to do this so that the product code a...
asked by 24.05.2018 / 19:54
0
answers

Oracle for Access

I need to pass an Oracle database to Access. However, my Access is 97, and only contains 999000 rows. My Oracle database has 12000000 lines How do I export Oracle to multiple Access files?     
asked by 07.05.2018 / 20:39
0
answers

Forms in Access

I am trying to assemble a form in Access (2007) to try to manage school hours. Currently everything is done by Excel, but because of the number of tabs, the file gets kind of slow. In addition, the system only works in the 2003 version of Excel....
asked by 14.03.2018 / 18:02