Questions tagged as 'ms-access'

Tagged questions
1
answer

Using TransferSpreadSheet via VBA

I'm finalizing my improvement project and have something that intrigues me a lot. I needed to make a report based on the result of an SQL query, which I even asked in Exporting SQL query data to Excel , and now I need to do the opposite and...
asked by 06.04.2017 / 21:55
1
answer

Function in Access equivalent to COALESCE

Hello. I'm trying to build an INSERT with auto numbering in Access, but I'm not getting it. In SQL Server, MySql and PostGres use the COALESCE function, but I do not find this function in Access. I usually use it as follows: INSERT INTO CON...
asked by 31.07.2016 / 21:07
1
answer

Problems working with dates in the database using a maskedtextbox in the format dd / MM / yyyy

I'm using a MaskedTextBox in the en-BR culture to force the user to fill the date in the correct format (dd / mm / yyyy). Retrieve the string from the MaskedTextBox to insert into the database and record information containing the date of this i...
asked by 07.03.2016 / 21:20
1
answer

JavaScript check if Windows user is enrolled in MS Access Bank

The need is to check if the Windows user is registered in the Ms Access Database, but it is not working as it should. I think the problem is in the variable strUserName inside the select. I have tried in several ways but I still have not foun...
asked by 14.07.2015 / 14:50
2
answers

How to streamline searches in VB.net / Access97 database

I use a query that does the search in 3 different tables, return this query attribute in a Datatable that will fill a Datagridview . The problem is that the search itself is a little time consuming, I used TOP as a limit...
asked by 14.07.2015 / 17:22
1
answer

Conflicts in MS-Access

I have a table in an access database with the following fields: DATA | SALA | AULA1 | AULA2 | AULA3 | AULA4 | DOCENTE | TURNO ---------------------------------------------------------------------- 02/02/2015 | S1 | 1 | 1 | 0...
asked by 17.06.2015 / 19:52
1
answer

Find directory using wildcards

How do I find a folder as if it were a file? For example, the code to find the TESTE.TXT file is: b = dir("c:\minhapasta\t*.*xt") msgbox b But for folders the asterisk does not work. What alternative do we have?     
asked by 01.05.2015 / 16:36
1
answer

VB.NET with acces database

Good afternoon, guys, I'm trying to make a CRUD here using VB.NET and Access, so when I perform an INSERT it returns the error "Syntax Error in INSERT INTO statement". But I can not solve it .... if you can help me right now, I would appreciate...
asked by 16.04.2015 / 22:35
1
answer

How to display form of a BD Access directly on a website?

I want to put the information of .mdb on a site, to make it available to the public. When opened in Access, it has forms for querying. Can I have a website that directly displays these forms on the screen? Or would I have to crea...
asked by 26.11.2014 / 19:02
2
answers

Moving 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