Search results

Dim lines As Integer lines= DCount("[field]", "[query name]") Dim array(0 To lngNbLignes, 1 To 10) As String I get a error at the declaration of the array.... anyone can tell me what i'm doing wrong ?? (btw the Dcount worked fine, i verified it) thx

How do I affect the number of reccords in a query, to an integer Something like Dim var as integer var = ... number or records in a query thx

great That seems to work thx. now i just have to figure out a few more bugs ..; :) there is for some fields where there is a err #6 where the capacity is exceded...

another monor problem the following worked mo1 = DAvg("[Field]", "Query name", "[criteria] = " & variable) but when i try to add another condition with "AND" it causes an error ex: mo1 = DAvg("[Field]", "Query name", "[criteria] = " & variable and "[criteria field 2] = " &variable2 ) where...

Got it ! GOT IT WORKING :D thx for your help

jst tried i just tried that,,, still did not work :(

again... dim variable as integer variable = "1" variable2 = CStr(variable) mo1 = DAvg("[Field]", "Query name", "[criteria] = ' " & variable2 & " ' ") sorry :)

Sorry second try was actualy dim variable as integer variable = "1" variable2 = CStr(variable) mo1 = DAvg("[Field]", "Query name", "[criteria] = '" & variable &" ' ")

that worked... but i have another question... in the following: mo1 = DAvg("[Field]", "Query name", "[criteria] = 2") What do i have to do to replace the numerical value by a variable ? tried to things already ... tried: dim variable as integer variable = "1" mo1 = DAvg("[Field]", "Query...

yep Yep , works fine now :D thx

I'm not the one who names the field... its a big project.. i just took it over

If BooleanFieldName is in more than 1 word, do i use brackets ?? " or ' ?

... I fund the following code on the net but didn't work... says the update expression is missing a parameter Dim dbs As Database Dim qdf As QueryDef Set dbs = CurrentDb dbs.Execute "UPDATE alarm" & "SET 'field name' = True " & "WHERE 'field name' = false" dbs.Close...

hmm How is update query used ? cant seem to find it in the help files...

Can the method DAvg be used to calculage the average of a query instead of a table ?? I have problems with the following line of code wich should be very simple.... mo1 = DAvg("[Field]", "Query name", "[criteria] = '2' ") sais incompatible data type in criteria... can anyone tell me why...

nope Its not a query but a table

darn... I tried what the thread said... and same result... BukHix- The program just crashes... program not responding and i have to use the good old ctrl+alt+del :(

not it Actualy there is already a reference to DAO 3.6

eish Thx alot for your help but... I used the folowing code (because i only want to change unchecked to checked) Dim rsFieldCK As DAO.Recordset Dim strCheck As String Set rsFieldCK = CurrentDb.OpenRecordset("Alarme") Do While Not rsFieldCK.EOF If rsFieldCK.Fields("Message envoyé").Value...

. thx but I knew that... I was wondering how exactly to midify the fields from scratch... like Command11_Click() -=CODE=- What finction is used to modify the values in tables ?