Questions tagged as 'ms-access'

Tagged questions
1
answer

Multi attchement upload function

I'm trying to create a function to upload multiple files at the same time but even with only one I get an error. What can I be programming wrong? 'FILE DIALOG OPENS UPLOAD PANEL Private Sub Comando715_Click() Call Selectfile End Sub The fun...
asked by 03.07.2015 / 13:09
0
answers

Count values in an MSAccess table

I am creating my first application and would like to know how to count values from a table in MSAccess with the following conditions: "requestor" and "Status" should contain specific values; If you contain data solicitante = solicitante...
asked by 15.07.2015 / 01:50
1
answer

Reports, Doubt with sums and dates

For a few days I have had a small problem where the client requested us to change a report that we have in our system written in VB.NET Basically, filter my DataGridView, and through it I'm mounting the report, With this code I make the filte...
asked by 08.06.2015 / 14:02
0
answers

How to use INSERT INTO (Value Currency) + SELECT (String Value) SQL DB Access

I'm trying to insert some data into a Currency format column, but the data is String . I tried to convert using Convert(Dados_String, Currency) , but it did not work either. Follow the command: INSERT INTO Tabela1(Dados_C...
asked by 16.04.2015 / 17:28
0
answers

Changes made to a record are reflected in the other records (Access + VBA)

I created a Form for Vehicle reservation where I have a field where the user must enter the destination of the trip. The user may also need more than one destination, so I created an add_destino button that makes inserting textbox into the Form...
asked by 17.03.2015 / 19:15
2
answers

Remember username and password for an Oracle ODBC connection

I am connecting an Oracle database with an Access database through Oracle ODBC Driver 11.2 . The problem is that every time I access the database in Access, the Oracle driver requests authentication: Is there any way to remembe...
asked by 29.10.2014 / 17:22
1
answer

MS Access - how to get date range of 30 days [closed]

I need to collect registered orders from a table named OrdersOn the last 30 days.     
asked by 24.07.2014 / 15:30
2
answers

Move images in VB6

Option Compare Database Private Sub Command0_Click() Do Until Me.Width < 4000 Let Image1.Left = Image1.Left - 5 DoEvents Loop End Sub As this allows you to move the image from right to left, how do the image to rotate t...
asked by 05.06.2014 / 14:00
1
answer

Copying table record to itself via vba [closed]

Can you copy a record from a table and insert it into it? I wanted to copy a record into a new one in the same table. INSERT INTO Produtos ( Produto, Preco ) SELECT Produtos.Produto, Produtos.Preco FROM Produtos WHERE (((Produtos.Produto)="AN0...
asked by 21.01.2014 / 18:36
2
answers

I can not decrease the quantity of stock

I am trying to reduce the quantity of the stock at the time of the sale and without success, I used the code below, no error appears .. Public Sub UpdateDecreaseQuantity() Try For Each row As DataGridViewRow In DataGridView1.Rows...
asked by 07.12.2017 / 09:15