Questions tagged as 'ms-access'

Tagged questions
0
answers

Write null DateTime field in Access database (mdb)

Good afternoon everyone. Please, I need your help. I'm trying to write / update a Birth field of type DateTime, but this field will not always be filled, due to the business rule sometimes it will be null. The base used is the Access md...
asked by 18.08.2016 / 20:28
1
answer

Stock Quantity Management C #

I can not find a solution for inventory and sales management. The scenario would be a Stock of Autoparts, where I register the entry of a product into stock with a certain quantity.    cod - name - qtd - vlr       3239 - Water pump - 2 -...
asked by 10.08.2016 / 18:37
1
answer

Access Database, Duplication of Records

In an Access BD with fields ID (automatic numbering), EMPLOYEE, DATE, QUANTITY, the data is collected daily (in a single message) via Outlook. So, is it possible to prevent the same employee from having two records in the DB with the same date?...
asked by 12.07.2016 / 16:46
1
answer

BD Access, Data field

In an Access DB with a "Date" field, when entering data in this field, is it possible to do something so that dates that have been passed for another 3 days are rejected? If possible, please teach me! In fact, I was only able to prevent future d...
asked by 09.07.2016 / 22:32
1
answer

Access SQL syntax error to find and delete duplicates leaving only one

Good afternoon guys. I'm trying to make an example SQL code that I found on the Internet to find the duplicates of my Access table and delete keeping only the first record. However, when I changed all fields where I said (Field1, Field2, ...)...
asked by 25.08.2016 / 20:58
1
answer

The field is too small to accept the amount of data you tried to add. Try to insert or paste less data

I'm using Access, and I have already checked the size of all fields and format also directly from the bank and also in vb.net itself. "insert into aplicacao (codigo, convenio, descricao , valconv, ativo, usuario, maquina, data_registro, flag)...
asked by 14.06.2016 / 20:09
1
answer

Locale database + node.js

I'm working on a project using node.js. I need to use a local database, but I wanted to reconcile performance with security, and if possible, portability as well. I only know MS Access (.accdb) and Sqlite3. [MS ACCESS] Prós: Senha...
asked by 13.11.2015 / 20:08
0
answers

How to access a linked table in access via C #

I would like to know if there is any way to do a query in an Access file, but not in a normal table created in Access but rather a linked file (in this example a txt). The error I made when I made the select was as follows: O mecanismo de b...
asked by 15.12.2015 / 14:28
1
answer

Ms access 2 querys for the same comboboxes

Good to all I'm programming a database and I would like to have a kind of 3 querys. I'll try to be as accurate as possible. I have 2 combo boxes that are interconnected, in this case I specifically make and model, and when I choose the brand, it...
asked by 01.07.2015 / 22:13
0
answers

Load multi-attachements into multiple form attachments

I'm trying to create a function to upload multiple files at the same time but I think that because I'm choosing the next function does not really attach the file, but rather creates a preview. In my opinion, what's wrong with the code is:...
asked by 03.07.2015 / 17:49