Search results

yeah it's doing nothing there! thanks :)

Hi! I have a lot of registers for machines status that could be "off" and "on". However due to data error sometimes I have something like that: Machine Status A Off B Off A On A on B on B off A off B of A on B off...

it's working!! i only closed the access and re open and the error dissapeared

is the count of the records starts with 1 after that i have something like x=1+x

Hi! I'm stuck with this error : error 6:Overflow I've serch for this and the solutions are pretty similar : set the variable as long and use the Clng, I have did that however the error persists. There is my code, Dim End as Long Set dbs = DBEngine(0)(0) Set TABLE1=...

Hi :)! this was an hypothetical example, maybe wasn't the better.... I only want to understand how can i write this kind of code using SQL..things like that: If Object2=Object1 Then Tab2.Edit Tab2.Fields(2).Value= Colour Tab2.Fields(3).Value = "Check" Tab2.Fields(4).Value= Code Tab2.Update

Hello! I recently discovered that using SQL in vba is much more efficient. I'm searching for a way to transfer information to other table using SQL as well as running some simple cycles. So, giving an simple example that everyone could understand: I have two tables one with colours and code of...

Perfect!!! Thank yoou Arnelgp!! :)!!! i wish you a good year !!

I've done in this way: [In this specific case mydate= 01-01-2015 00:00:00) Date = DateValue(mydate) & " " & TimeValue(mydate) Dif=DateAdd("s",-4,Date) ---> it's giving 29-12-1899 23:59:56 Do you have any idea how can i correct this?

Thank you for the suggestion, however I have forced the formmat but stills appears only the date :/ any ideia how can i solve that?

:) Thanks, i have changed for DateAdd. However it stills stuck when the time is "00:00:00" or "00:00:04" , and in this case if i debug.print my date appears only "01-01-2015" istead of "01-01-205 00:00:00"

Thanks Ranman, but i want always - 4 seconds than my Date..(and this date is always changing.. so i think that i really have to write the "-4")

Hi :) I'm calculating the difference of 4 seconds before my date register, but i'm having some troubles when my date is "dd-mm-yyyy 00:00:00" or "dd-mm-yyyy 00:00:04" It brokes! Do you have any suggestion? I thought that can be an good ideia use sql, but i'm stuck :banghead: there ir my code...

Hi, thank you for your help :) great tips! I have a simple doubt about sql, how is the best way to write values on an existing table? Something that i will do in vba in this generic way: Me!Table.AddNew Me!Table.Fields(1).Value = Me!Tab1.Fields(1).Value...

I've also other code that is really slow, do you have any suggestion how can i speed it? The objective is more complex than the other. -I have one table with a lot of machine registers, I've the status(could be off,on, alarm, in course, programmed....) the date ( dd-mm-yyyy hh:mm:ss) and the...

Yeees! 4 hours running to some seconds!!! :D perfect!

Arnelpg, thank you so so much! you have revolutionized the way that i programme on vba!! You really added quality to my work!! :D thaanks!!

Thank you arnelgp, i will try this now!! :) seems an interesting way to do this task! Ranman, how can i do this using queries?:)

Hi, everyone! I've two tables: dictionary and InputTable. The table dictionary have 2202 entries and the InputTable 65536. I've a key that is formed by 3 fields of this tables, the ideia is to look on dictionary an row with the same key and then write on InputTable the description that is on...

Hi! Yes :) Well i've created a virtual query. 1st Me!TabCloseOpen.MoveFrist Do While Not Me!TabCloseOpen.EOF Date1=!MeDate Diference=DateAdd("s",-4",Date1) ---> gives me a date 4 seconds before Date2=Mid(Diference, 7, 4) & "-" & Mid(Diference, 4, 2) & "-" & Mid(Diference, 1, 2) & " " &...