Questions tagged as 'ms-access'

Tagged questions
1
answer

Using Access to Export in Excel, Parameterized Query

I'm using the Access database, I need to export a query to excel. My problem is as follows: I am using a parameterized query in Access for the access itself to export to excel. When I make the call to export, it opens the screen to ente...
asked by 08.12.2016 / 19:52
0
answers

Connecting Powerpoint to Access via VBA? [closed]

I am creating a type of "urn" in the Power Point would like 3 (three) basic solutions to determine the votes; Clicking the confirm button automatically votes for email , for a given email address; Clicking the commit button automaticall...
asked by 28.05.2016 / 18:14
0
answers

Access - put data from a table horizontally

Hello I already researched several forums, but I could not find a satisfactory solution. I have the following table: ID COD VLR_REEMB N_FICHA DT_RECEBIMENTO 1 1 4.022,06 965 24/09/2010 2 3 6.600,00 746 17/09/201...
asked by 19.05.2016 / 23:16
1
answer

How to execute a procedure only once?

I set up a payment generator that takes a lot of data and saves it to a database table, the problem is that I used the OnActivate event of the Form, so every time I go back to the initial form, the procedure is executed again. data should only b...
asked by 16.02.2016 / 00:37
0
answers

Pass values from a GridView to a database

I would like to know how do I get the values from a gridview in windowsform and pass it to my database in Access.     
asked by 30.07.2015 / 18:25
0
answers

MS Access 2013 ERROR - No unique index found for the referenced field of the primary table

I am learning MS Access 2013 and try to create relationships with 3 tables. When I list them without the Enforce Referential Integrity option the relation is generated, however, when I put the same option I get the error:    "no unique index...
asked by 01.07.2015 / 17:27
1
answer

Use "SUM" in access + vb.net

I have a small problem in the Access query, where I have the following code: Dim cn As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Dim Da As New OleDb.OleDbDataAdapter Dim Dt As New DataTable Dim dtinicio As St...
asked by 01.07.2015 / 21:17
1
answer

Combobox Relational C # BD Access

I'm building a C # application with Access database. I have two tables one of CIDADE and another one of ESTADOS . What I need is when I select in combobox1 a state, combobox2 loads only cities that match the stat...
asked by 01.09.2014 / 19:26
1
answer

Filter DataGridView by Interval Between Dates in VB.NET

I'm new to programming and I'm finishing a job, but I have a problem that I've been experiencing for weeks and I have not been able to solve it. I created a simple system that registers the OSs (work orders), and in a form I put a datagrid...
asked by 03.10.2014 / 20:25
1
answer

Visual Studio 2010 and Connection with Access Bank

My Visual Studio 2010 (10.0.40219.1 SP1Rel) is popping the following error message when I try to create a connection to an Access database (Office 2010):    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. I...
asked by 27.06.2014 / 20:37