Questions tagged as 'ms-access'

1
answer

Integration into banks

Good afternoon! I need an orientation / suggestion. It is as follows: we have a clock software where it will record all the markups in a database in MS Access. I need to create a report for each employee in the company intranet, where the same i...
asked by 13.06.2017 / 22:44
1
answer

Error 3706 Microsoft Visual Basic

I'm doing an application and when I was programming the VBA code to connect to Access Database what was my astonishment gave the error:    "Microsoft Visual Basic Error 3706" The connection line is: .ConnectionString = "Data Source=" &a...
asked by 26.04.2017 / 12:53
2
answers

SQL Query VBA Excel

Good afternoon! I have a problem with an Access query via form. The form is from the Excel vba, which connects to the database. The full code is below. This is the button code. Clicking it validates which of the two buttons is marked...
asked by 28.03.2017 / 16:58
2
answers

SQL Query in Excel VBA

Good morning! First of all I would like to say that I understand almost nothing of Visual Basic and that everything I have learned so far has been in the race in forums. So if that is too simple to solve, forgive me. Now to the problem. I...
asked by 27.03.2017 / 17:10
2
answers

Null value displaying zero MS Access

I need to set a field in Access to Null, through SQL, but after setting this field, it gets the value Zero and not Null. Due to a business rule, I need this field to be NULL and not Zero. The field is numeric.     
asked by 06.12.2016 / 20:35
1
answer

VBA MS Access - application version

Does anyone know how to change the version of my access application. Type, in C # one I put the version number in the assembly file, and then I can get this to put in a label for example. How do I do this in VBA MS Access?     
asked by 22.11.2016 / 15:28
0
answers

MySQL table XML via Access

I need to first know if Access can connect to MySQL database. From this connection, I need to generate through XML an XML that contains the data of a table in my MySQL database. Later this XML should be sent to a remote server every day (via...
asked by 21.09.2016 / 20:54
0
answers

Problem Connection DB

I am doing a C # system, I connected the database (Access) and the program asked to copy the database to the system folder and everything. The problem is that the application is not saving the data in the system folder bank, I have to direct...
asked by 03.10.2016 / 19:19
1
answer

Find / select database with C #

I have a form with a button and a simple datagridView, but my problem is that I have to look for my file in ".mdb" (Access database) on the computer, so it can be shown in the datagridView then the question remains: When I click the button, I...
asked by 28.07.2016 / 15:39