Questions tagged as 'ms-access'

Tagged questions
0
answers

Passing data to a jDialog from a BD

Hello good night I want to pass data from my BD to a JDialog as you can see the code and the question that are in the table but I do not know how to pass the values of the combos and options to jDialog in advance thank you very much. private v...
asked by 27.06.2018 / 07:01
0
answers

ACCESS grouping by sql

Hi, I have a query with the following sql: SELECT Tabla1.Campo1, [CTrefercruz].Expr2, [CTrefercruz].[Total de Campo8], [CTrefercruz2].[Total de Campo8], [CTrefercruz3].[Total de Campo8] FROM ([CTrefercruz3] RIGHT JOIN [CTrefercruz2] ON [CTrefe...
asked by 13.06.2018 / 11:14
1
answer

Why does not this query work in codeigniter, and in the IDE of ms Access it works without problem? (I think it's the JOIN)

I have a query that I can not work inside codeigniter, removing parts of the query, it seems that the error is in the JOIN, but I do not understand why, and even less understand, that when performing the query in PostMan, for example, it does n...
asked by 11.06.2018 / 08:02
0
answers

UPDATE Microsoft JET Database Engine error '80040e21'

It is a website built in .ASP and with an ACCESS database. It has been in operation for 3 years and has not caused any problems but today I started to give this error. The error is as follows,    Microsoft JET Database Engine error '80040e...
asked by 11.06.2018 / 21:04
0
answers

error 53 when executing shell

In an Access form I have a button that I want it to execute: Shell ("c: \ Windows \ system32 \ osk.exe"). The bbdd runs on a touchscreen laptop so that when you click on the button the shell is run and the Windows screen keyboard appears in o...
asked by 03.05.2018 / 15:16
0
answers

Perform SQL query (access) that delivers a record of multiple lines

query can help me in an sql query that I'm running in access, as the image shows, the idea is to leave only one line with the fields that are visible. In the image there are 2 numbers of cpbnum and the idea is to summarize them as they appear in...
asked by 20.04.2018 / 01:02
1
answer

Inner join and left Join in Access

I have a problem with a query in access , I want to include a join and a left and the error that appears when saving the query of access gives me the following < strong> error :    "Expresion Join is not supported" T...
asked by 30.04.2018 / 18:53
0
answers

Access, calculated field. (Tell)

My database has two tables, one attribute of one of them is "Total number of video games", while the other stores the name of the video games. I was wondering, how, through a calculated field (Without needing a query) I could count the number...
asked by 02.05.2018 / 19:21
0
answers

How to update a view (Data sheet as subform), extracting data from a query of it In VBA ACCESS

I have the following code, the data sheet of the subform is the same that I have in my main form, it is supposed that only a Requery is required but it does not update me, it tells me that one of the fields is out of range: Private Sub cmd...
asked by 28.03.2018 / 02:35
2
answers

Access query with c #

I'm doing an Access query in windowsForm I get an error when changing the fixed dates by dateTimePicker how can I make the date the right way, that it works p> OleDbDataReader read = MSAConnection.read(@" select p.cod,...
asked by 16.03.2018 / 17:02