Questions tagged as 'ms-access'

0
answers

How to Remove Print Dialog Box

In access, I inserted a print button, and when clicking it, the printer selection window always appears. I would like to remove this window for direct printing. Could you help me? Thanks!     
asked by 11.03.2018 / 14:49
0
answers

Dataset to Excel to MS Access

I have a certain dataset all in the same table, and I want to split it into a relational database in MS Access. I've been successfull to a certain degree but now I have a problem. My dataset had the products available in a certain store displ...
asked by 30.03.2018 / 00:18
1
answer

Replication in datagridview (vb.net and ms-access database)

When I'm making a new sale (in the case of this software I'm developing), every time I add new items in the datagridview it appears along with previously added items. I would like to clean the datagridview before adding new items (or making a ne...
asked by 12.12.2017 / 09:26
1
answer

The textBox Search multiplies the search values [closed]

Private Sub txtSearchByDish_TextChanged(sender As Object, e As EventArgs) Handles txtSearchByDish.TextChanged Try con = New OleDbConnection(cs) con.Open() cmd = New OleDbCommand("SELECT DishName, I.Rate, SUM([Qty]) a...
asked by 07.12.2017 / 09:18
1
answer

I need to update my acces database (.mdb) from an external computer

Hello, I have a client with two stores and I need the database to be interlaced. I need a primer on how to start studying this. obs: the database is local, not in the cloud     
asked by 16.11.2017 / 20:37
1
answer

Problem handling dates in an ACCESS / VBA application with SQL Server database

I needed to migrate the bank of an application made in vba using the access. The database was native to access and I switched to SQL Server. In access, as everything is native everything worked perfectly, but in migration a problem that is gi...
asked by 20.10.2017 / 06:19
0
answers

Access and excel - load parameters

Is it possible to use an excel table as parameters for access queries? Currently I have 4 access files to perform the same process, but with different filters (I used 4 files to leave organized). The filters are basically DATE START, END DATE an...
asked by 15.09.2017 / 16:32
2
answers

SQL - query for True or False records

I'm putting together a simple page that shows records marked as blocked by admin. The field is user-block and the options are FALSE or TRUE. I imagined that Query would be: "Select * from Usuarios WHERE user-block = "&TRUE&" order b...
asked by 27.08.2017 / 02:11
1
answer

Comparing a value from one table, with interval in another table

I'm very lazy in Access, but I need to use it to solve a problem. Assuming I have two Tables (just to give an example): Table A: CEP INICIO | CEP FINAL | CDD | CTC 20000-000 | 29999-999 | CDD Exemplo 1 | CTC Exemplo 1 30000-000 | 39999...
asked by 29.06.2017 / 20:10