Search results

TJPoorman :) I've tried to use this code, but appears always this error "run-time error nr 94 invalid use of null" and appears one pop up saying " item not found in this collection" Do you have ideia what could be wrong? Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("TRANSFORM...

i've also this sub that is really slow, do you have any suggestion to improve my code? I have one table with entrys with two status: Alamr and Man(from Manual). For each status=Alarm there is an Man pair. So I want to discover the sets Alarm-Man. Sometimes I have repeated Alarms or Man status...

I am grateful for your help,I learned a lot from it! :) I will apply this right now!

Ok :)! I want to speed up my VBA codes, i've read that I can use in an generic way this code: Sub xxx() Application.ScreenUpdating = False Application.DisplayStatusBar = False Application.EnableEvents = False my code Application.ScreenUpdating = True Application.DisplayStatusBar = True...

Hey Minty! Thanks for your reply. If you coulld help me would be great!! there is my code: Sub OffClassifications() 'This code will analyse the registers with off status and verify what happens 4 seconds before! Beyond the EventCode i can say if the off is ok or not. Dim Ins As String Dim...

Hi :) I'm trying to use this code to accelerate my program.... Application.ScreenUpdating = False Application.DisplayStatusBar = False Application.EnableEvents = False ... but appears always this error: method or data not found Could you please help me?Do you have other tips to speed up my...

I want to import all columns but the error only refers one problem on F1

Thank you :)! I've wrote this code, I have my "Tab1" in access with exactly the same columns as the Tab1 That i want to import, when i run the code it stops at DoCmd.TransferText acImportDelim, , "Tab1", selectFile, False and appears always this error: Run-time error 2391. Field F1 doesn't...

Hi everyone :) I want to do one vba module that prompt the user to select the CSV file that i want to extract to one table in my DataBase. I'm trying to write this code, but it only works with xls files...could you please help me to understand what i'm doing wrong..? MODULE: Function...

Hei everyone!!! I have one field with my date in this format : dd-mm-yyyy hh:mm:ss and other field with my milliseconds. I use a lot of vba comparisons with date, like see all registers between 01-01-2015 10:10:10 ms=100 and 01-10-2015 10:10:15 ms=200 Do you know how can I compare the...

Hi Everyone!:) I have an input tab with many registers with different satatus from machines (on,off,alarm,error...). I need one virtual query(Tab_Alarm), builded from my input table "Tab", where I want to see all the events 4 seconds before with the status "Alarm". However in case that it finds...

Thank you! You are right :)!!! This is perfect. However, I have almost 53508 inputs and this is really slow to proccess and the access is always stucking and closing. Did you know if it is possible to do this "formula" with so many records? I'm really thankfull for your help. :)

Sneuberg, thank you for your solution!! :) I've learnt so much with that. I've only one issue with that, in the qryIDtoBeDeledet appears some ID's that are right as 106. ID Date ms Machine State 102 16-01-2015 05:32:07 260 Machine B OFF 106 16-01-2015 07:01:12 790...

Hi Doc_Mac! Thank you for your point! I've already reported this error to techinicals, they are trying to understand the reason beyond this errors. However was told me to ignore this registers and only consider the Off immediatly follow by one ON. I wish you the best luck with your case!! :)!!

I think that i will ask you for your help . I 've tried but I'm realy stuck with that :/ there is my data: http://we.tl/OFJR5tusbx I really appreciate your time and help :) it's really generous

thank you a lot for the tip! I will study that :)!

Hi! :) I want to keep the last one, once that i'm adding daily information and the ON can appear in other data

Dec 31,2015 A Off Jan 1, 2016 A On Jan 2, 2016 A On Jan 3, 2016 A On Jan 4, 2016 A Of The red ones because don't have a precendent match with one Off

Sorry...!!! I will try to be more clear as possible. I want two things 1-Delete Extra Records 2-Put the information in order (off on off on off on) My table have information relative to a lots of machines the metadata is: Date, Machine, Status Sometimes the sensor of the machine don't work in...

Hi Rannam :) Sorry, i will try to explain better: Register is an input. A and B are the name of machines. I don't want to change nothing :) only to put the status in right sequence: off follow by one on off on off on.... But sometimes due to wrong data I have this: off on on on off off on off...