Questions tagged as 'ms-access'

1
answer

Adding cascading data from a column in Access

Hello I need to perform a query that returns me the weekly balance of certain products in stock. For example: Ano/Semana | Saíram | Entraram | Saldo ______________________________________ 2015/01  | 4 | 10 | [Entraram] - [Saír...
asked by 04.12.2015 / 17:23
1
answer

Multiple Access Instances

As you open multiple instances of the same Access Bank, I saw that an old coworker used the command: Shell "MSACCESS.EXE " & Chr(34) & CurrentDb.Name & Chr(34) But when I run it returns an error saying that the Bank is a...
asked by 25.06.2015 / 19:05
1
answer

Problems with sql in access, incompatible data types

Test / error image: I just want to fetch the data between one date and another, using: SELECT * FROM tblTRAZA WHERE FECMOV >= '2013-01-03' AND FECMOV <= '2013-01-09'; But I already tried other date formats to query as yyyy/m...
asked by 02.06.2014 / 14:15
1
answer

Consolidation of tables in MSAccess and VBA

I have the following database in access: mov_atm n_mov conta data valor mov_sc 100 200 1/8/2014 500 n_mov conta data valor 101 900 5/8/2014 800 200 900 5/8/2014 80...
asked by 19.05.2014 / 18:03
1
answer

Parameterizing travel counts in a select VBA routine

I would like to get the following select , so I'll provide the example below, remembering that I use Access 2007 VBA. Objective : Count the trips made by the fleet vehicles by Line / Sense. Taking into consideration the following param...
asked by 02.04.2014 / 00:03
1
answer

UPDATE update without affecting all rows in table without ID [closed]

I have a table with information from some clients and I needed to give UPDATE however as the table has no ID and most of the data is repeated including cpf is there any way to give the where on the selected line only?     
asked by 20.12.2018 / 16:10
1
answer

ACCDB + PHP get name of columns and table

I am uploading accdb files in the database to import clients on my system, in a CRM that I used I could upload this file and automatically already displayed the columns to be able to be linking with CRM information. I was able to read the data f...
asked by 03.11.2018 / 15:55
0
answers

Access - saving data

I have the VBA code below that saves a new post. Closing the Form, even if I have typed any name, it is not saved. But I noticed that Access automatically generates a new primary key, ie it skips a primary key that will no longer be used. Exampl...
asked by 22.08.2018 / 02:48
0
answers

Querying two VS + Access tables

I need to interconnect two tables in the same query, but it has not worked very well. I created this code: try { String StringCon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:_Semestre\PItry { String Strin...
asked by 17.06.2018 / 19:48
0
answers

Visual Studio 2017 OleDB Xamarin.Forms

I'm looking for help in the following, I'm doing a multiplatform project using Visual Studio 2017 and Xamarin.Forms, the problem is: I need to make a connection to MS Access Database. I've seen a lot of tutorials and all used OleDB to...
asked by 03.07.2018 / 15:16