Search results

Hey!! :) When i run the code in my pc it is working without any issue, but when it runs in my end-users's PC appears always this error "System resource exceeded".... I've already tried: 1)HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0 to put the maximum number for lock = 50,000...

don't accpet the " :/ that way i have put ' , it worked with the acents exemple...

thanks!! :) ! I also want to replace the "'" from the words to blank spaces, I've write the follow code: update table set field1 = replace(field1,''','') but appears always the invalid syntax error... do you have any idea what i'm doing wrong? thank you! :)

Hey, I'm importing one table that for default cames with letters with accents( "´" "^" "~" as for exemple "á" "ê" "ã" . There is any quick way to clean the accents? (e.g. converts Olá --to--> Ola) Thank you :)

Thanks arnelpg! :D it is solved!!

Hey Arnelgp! Thanks..I've tried as you suggested but it still appearing the same error "data type mismatch in criteria expression" Thanks!

Thanks :) sorry i'm not really god on access... where should i put the "where" condiction? CountX2: LEN(CodeMachine) - LEN(REPLACE(CodeMachine,"X","")) where LEN(CodeMachine) - LEN(REPLACE(CodeMachine,"X",""))=2 or i should put " where LEN(CodeMachine) - LEN(REPLACE(CodeMachine,"X",""))=2" on...

Hey everybody! I have a derived column showing the # of times a "X" appears within the CodeMachine string. I'm using the follow code: Count: LEN(CodeMachine) - LEN(REPLACE(CodeMachine,"X","")) i only want the registers with the count="2" but when i write in criteria "="2" or "2" or "like 2"...

Hei! I've tried to force the "." but always appears the comma ",".... do you have ideia how can i solve that? :)

Thanks! I've tried with double but the error remains. How can I replace the "," for "." ? with vba code :) thanks!

Hei! I have one simple doubt about decimals numbers, how should I declare them to work in a SQL sentence? as Single? I have one sentence that count the number of entries with code=1 and with the TimeMS(time converted in miliseconds) between MEtimeMS and MeTimeMS2. The TimeMs is in this...

Hei :) I've one function that is really slow :/ , maybe you have some tips to improve that. I have one table with all the events(arround 915755 registers) and other with the Maintenance Events(9000). If one off my "on" or "off" events occured 15 seconds before or after the Maintenance Events ...

Hei all :) I'm using for the first time the command rst.FindFirst, but isn't giving the right output--is moving always to first row Dim strCriteria as String Dim rst as DAO.RECORDSET Date = RST.Fields(1) Date1= Mid(Date, 7, 4) & "-" & Mid(Date, 4, 2) & "-" & Mid(Date, 1, 2) & " " &...

Hi :) I have one calculated field TimeMS:CDbl([date])*86400000+[ms] --> is to convert the date to miliseconds So I have defined as Dim TimeMs as Long .... (code) .... TimeMS = CLng(Tab1.Fields(9).Value) .. And appears the error 6(overflow), do you know how can i solve that? :) Thank you I...

Thanks for your help :)! it is really usefull :) I've also other function that is really slow :/ , maybe you have some tips to improve that. I have one table with all the events(arround 915755 registers) and other with the Maintenance Events(9000). If one off my "on" or "off" events occured 15...

The Doc_Mac!! thank you this was really usefull :D!! TjPoorman thanks, was well noticed :) i've correct , now appears this error on Count1=rs![1] -> run time error 94 invalid use of null

TjPoorman :) Yes, i've one field called ID

Thanks Minty! :) I changed the date field ! I also change 'response' to [response] but the error 3001 remains :(

Ahh :) ok!! I've done that In my debug print window i can see: TRANSFORM Count(ID) SELECT 'Response' FROM TabMachine WHERE ((([Date])< #2014-01-05 10:41:44#) OR ((([ms]) <= 110) AND (([Date]) = #2014-01-05 10:41:44#))) and (([Date])>= #2014-01-05 10:41:40#) And [IDMachinenel] = 'KPB11' AND...

Thank you Minty! :) I did that and appears "Run-time error '13' Type mismatch" ....maybe I didn't understood Dim rs As String Set rs = CurrentDb.OpenRecordset("TRANSFORM Count(ID) SELECT 'Response' FROM TabMachine" & _ " WHERE ((([Date])< #" & Date1 & "#) OR ((([ms]) <= " & Date & ") AND...