Search results

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...

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...

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...

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...

Hi Everybody. I'm trying to build a Dmax function that include more criteria. But I have some problems. Here I post the 2 DMax function: DMax("age", "data", "[id_name] = " & Me.ccName) DMax("age", "data", "[id_address] = " & Me.ccAddress) I need that the 2 are together so I will receive as...

Hallo everybody. I have a problem with a query. I need to select the max value of a field in a table and after I want to show all the record (the max value and the other field). For exemple: 200 CH1 CAT 220 CH3 DOG Output --> 220 CH3 DOG So I write this query: select max(value)...

Hi my friends. I have a little problem using Dlookup. In my form I have 1 textbox (with date and hour ex. 2009-10-30 11:00:00), and 3 dropdownlist. I want that when I choose the date and the first ddl, the third will be enable and show only the value with the other 2 (date + 1st ddl). After that...

Hi Everyone. I have a problem with my Project. I have 2 textbox. In the first one is possible to write a string of maximum 255 characters. I want that when I arrive at the 255nd char, it's impossible to write anymore. In the second I want that we have a "countdown" of possible writable...

Hi Everyone. In my project I tried when I clicked on a button, to create a file.txt with all the informations that contains a table of my db. Here my code: Private Sub bBackup_Click() Dim SQL_query As String Dim Path As String Path = "c:/test.txt" SQL_query = "select * from...

Hi everyone. I search in the forum but I didn't find anything really "perfect" for my problem... In my project in Access 2007 I use a MySQL database. In a form there are 2 buttons (one is backup and the other restore). I want with the help of VBA to do a complete backup of all tables in my...

Hi everybody. I'm doing a job in access 2007 with a db MySQL. In one form I need to filter 4 box (2 are ID and 2 are date). For this form I did a query (select *) and after I use the key "filter". So, I don't have problems with the 2 ID but when I try to filter the date I occured in an error...