Questions tagged as 'ms-access'

Tagged questions
1
answer

Error getting data in SQL

I have this code: SELECT Colaborador.IdColaborador, Colaborador.Numero, Colaborador.Nome, Colaborador.[Centro de Custo], Colaborador.Usuario, Colaborador.Responsavel, Colaborador_1.Nome FROM Colaborador, Colaborador AS Colaborador_1 WHERE (((C...
asked by 07.04.2016 / 23:55
1
answer

c # Microsoft Access converting date

I'm having problems with INSERT and UPDATE because on my machine dates are being converted automatically, but not on users' machines. Ex: OleDbCommand cmd = new OleDbCommand("UPDATE tblPendencia " + " S...
asked by 06.12.2016 / 19:57
1
answer

Random Records with Criteria

I would like some SQL command for an MS-Access database where I have 500 records and only 20 records to return random being these (10 in 10 MEN) and sorted alphabetically by name. The structure of the tbLista table is very s...
asked by 20.08.2018 / 17:31
2
answers

Error writing new record to the Access database

I'm doing a CRUD with Winforms in C # , I'm having an error inserting the date in the date field. The following message appears when attempting to write the new record:    Operator syntax error missing in query expression '10 / 02/1986 0...
asked by 24.10.2017 / 17:38
1
answer

Where to connect to the database?

In the MVVM standard where should I connect to the database, in the View, Model, or ViewModel?     
asked by 20.05.2015 / 18:07
1
answer

Problems with connection to MS Access bank

I developed a web application whose database is MS Access, well, when the user logs in I send the data by ajax to the java class to do the login validation and password, the problem is that when the system will connect in the bank my connection...
asked by 31.05.2016 / 13:35
2
answers

Split in VBA does not work

I have the following code snippet: CorpID = rsSQL.Fields("Name") Tmp14 = Split(CorpID, , 1) Tmp15 = Join(Tmp14) Me.nomeUsuario.Caption = Tmp15     
asked by 15.10.2014 / 16:27
2
answers

How to import data from ACCESS to MYSQL

I have db ACCESS with many tables and lots of data registered, I need to import these tables to my new db into MYSQL . Does anyone know a shape? or a tutorial to follow? I'm using MySQL-Front and phpMyAdmin to do th...
asked by 28.10.2016 / 17:28
1
answer

Wpf C # OledbParameters Update where select

I am trying to change a query to use parameters but when I execute using parameter I get the error "Data type mismatch in criteria expression." No parameters works normally. Follow the two queries . cmd = new OleDbCommand("UPDATE tblPen...
asked by 23.12.2016 / 16:21
2
answers

How to refresh a form in access?

I'm trying to make a refresh to a form, avoiding closing it to open it , and I thought about this function. However, to no avail. How can I do this procedure? Public Fuction (f As a String) Forms(f).Recalc Forms(f).Re...
asked by 07.07.2014 / 15:55