Questions tagged as 'ms-access'

Tagged questions
1
answer

Connect PHP with MS-Access

I'm trying to connect my Access database with PHP, but it's not finding the way. I did not want to put the path relative to the HD because I host my page on a host (it uses Linux) and so I wanted to put the path relative to the page itself. M...
asked by 09.05.2018 / 13:49
0
answers

Add cascading data from one column in Access with Status by Line

I need to create a purchasing control per line where it generates a purchase need considering the quantity of each product per customer versus stock availability. As in the example of the table below I have an item XXX that is repeated in dif...
asked by 06.04.2018 / 04:01
0
answers

Association right access join does not show all records

After the association between the tables, the system shows only the records associated between the two tables: TBPaciente and TBMotivo . SELECT TBPaciente.*, TBMotivo.* FROM TBMotivo RIGHT JOIN TBPaciente ON TBMotivo.ID_MOTIVO = TBPacie...
asked by 11.02.2018 / 13:35
1
answer

Import data from MS Access to Sql Server via code

I need to import data that is in an Access database via code to Sql Server. My software that is made in C # for many years has been integrated into an Access database. From now on we are migrating to Sql Server and the intention is that in the u...
asked by 30.11.2017 / 17:34
1
answer

Open Access Report with Criteria

I'm a beginner in C # and am opening an Access report, but this report has criteria, ie, depends on numbering to open. This numbering I have in a textbox and my question is how to pass the textbox value directly to the Access report...
asked by 11.11.2017 / 23:22
1
answer

Looping on the rows of a table in VB

I'm trying to make this looping between the rows in the database work. I have code ready in C # and I'm using it as a reference but I can not get this part to run.  Here it goes something like this: For Each Row In ds.Tables(0).Rows...
asked by 13.11.2017 / 23:30
0
answers

Macro for Import in Access

I need help to create an import macro in Access, in case using VisualBasic, I need to download a zip file, inside this zip there is an excel spreadsheet, I need to extract it, copy all data, copy and paste to a table, this process should be repe...
asked by 20.10.2017 / 13:23
0
answers

Web Application in ASP.NET MVC CRUD with MS access

I'm doing a job, and I need to do a web application for tracking tasks. The requirements are those of the topic. It is a web application made in ASP.NET MVC and access database creating a CRUD. I'm having difficulty going through the connect dat...
asked by 29.10.2017 / 00:51
1
answer

How to use getElementsByClassName on an Internet Explorer object in VB.Net?

I'm trying to use a getElementsByClassName in an Access macro. You're experiencing an error on the line: If ie.Document.GetElementsByClassName("msgErroAdic").Length > 1 Then Being Dim ie as Object and Set ie = CreateObject("Int...
asked by 17.04.2017 / 18:59
0
answers

What is the best way to do database replication? [closed]

I have an application in WPF + MS ACCESS where users make registrations, queries, etc. The main server is located in SP, but we have branches in RJ, BA, MG, PR, RS, GO, etc., which also access the tool. Due to connection problems at these bran...
asked by 20.03.2017 / 14:44