Recent content by omaggi

Thanks a lot. Works greatly!!! Greetings.

Hi Everyone. I tried to use DCount but I have some problems with the function "month". I wrote this code: pippo = DCount("*", "valori15min", "[id_puntoMisura] =" & Me.ccPuntoMisura & " and [id_obis] =" & Me.txtObis1 & " and month[data_ora] =" & Me.ccMese) But I have problems with the "month"...

Hi everyone. I have a Form included 3 sub-Form. At the top of the form I have 4 textbox that I use as a filter of the records I show in the sub-forms. My problem is that for the 2 sub-forms I need to make one type of filter and with the third one, I need to make another kind of filter (this can...

Thanks to all you. I found the solution. Thanks. Greetings

Hi everyone. I have a textbox with a date in the format dd.mm.yyyy hh:nn:ss (ex. 17.12.2009 09:45:00). I want in another textbox that this date will be formatted like yyyy/mm/dd hh:nn:ss (ex. 2009/12/17 09:45:00). How can I do? I tried with some function (date, datepart,...) but I have not reach...

Discussion closed! I solve...

I need help, please!

Nobody can help me? I really need it... :( Up... Greetings.

Hallo my friends. I have a problem doing a report. I have a form with 4 filters (drop down list) that works with a query (select). With the code "FilterOn" I make this choice and at the end I order the records with Me.OrderBy = "valore desc". Till now works greatly. Now I have the necessity...

Thanks to all of you. I tried all the possibilities and now it works. At the end I did it with the automatic configuration of query... Strange... ehehhe! Greetings.

I try the query directly in mysql and it works perfectly. I also try to change the name of the string but it's not this the problem...I still have the same problem.:mad::mad::mad: Other suggestions?

@dcb The output of the debug ist: insert into prova (data_ora, id_puntoMisura, id_obis, valore) values ('10.07.2008 10:45:00', (select id_puntoMisura from puntomisura where puntoMisura='CH10019012345-K-LUCT-LUCT-00AECA1'), (select id_obis from obis where obis='1-1:1.29.0*255'), 611); Seems to...

The debug doesn't go. I have as answer only a "beep sound"... very strange! Any other suggestions?

I tried but I don't have any answer... :(

Hi everybody. I'm trying to write a query for an insert, but when I click the button, I have an error 3067... This is my code: Private Sub bInserisci_Click() Dim query As String query = "insert into prova (data_ora, id_puntoMisura, id_obis, valore) " query = query & "values...