Search results

Hi, There is some command to call the value of a specific row? For example I want the "Blue" value there is a command to go to 3rd position of column "color"? ID Code Color 1 11 Red 2 12 Black 3 13 Blue 4 14 Green I've search about this but I didn't get if is possible. Grateful for your...

I'm using the 2013 version :)

It's a row with the fields :) i'm from brazil maybe was because that i call it register

Hi everyone! :) I have two fields: !MeDate: dd-mm-yyyy hh:mm:ss !MeMs: ms State: OPEN or Close When I found the close state I want to go back from my Date 3,5 seconds to see what is before this register. Set dbs = DBEngine(0)(0) Set Me!TabCloseOpen = dbs.OpenRecordset("!Me table with...

Thank you for all the tips! :) I did in this way and worked Do While rs.EOF If rs.EOF then else my code end if loop So, where is achieved the last record vba don't read him, in this way the last record processed by my code is the penultimate one. :)

Hei, everyone :) I'm doing a do while cycle and I want that it finish at the last bue one record, do you have idea how I can do this? The idea is represent in the following code, but off course ins't working in this way Do While rs.EOF-1 |||| |||| Loop grateful for your help!

Thank You :) I'll explain better There are two tables with a date field, I'm comparing this value, when the dates are different I add a flag to indicate that the day changed. [AF2!Flag = "I""] So, when I go back for the for cycle i want that it begins where the last for cycle ended. In the...

Hei :) I'm doing a code that compares two tables(AF1,AF2) with 2 for cycles. I want that when first for cycle ends the next for cycle begins at AF2 stopped. So, I recorded the ID2 and I've write( as are in red) AF1.Move ID2 but isn't working, it moves for a row very far away of what i...

Thank you a lot! much more easier :)

Thanks :) "File sharing lock count exceeded.Increase MaxLocksPerFile registry entry." I've search for this error and i've done what they indicate here: http://www.thewindowsclub.com/file-sharing-lock-count-exceededoft-access I think that now it is solved!! thank you

Thanks! I didn't know it. Well my MachineOn,MachineOff,DepartOn,DepartOff are text so, i should put them as String? The DateOn/DateOff are in this format dd/mm/yyy hh:mm:ss, it is a string as well? I've done in this way, but it stills crash. Thank you :)

Hei :) I've a module that compares two tables: -Table1: with all On registers -Table2:with all Off registers And give me the time difference between this two. When I run this module it crashes after 4863 row. I have put all my variables as Long, but still crashing ..any other suggestion? :)...

Yes! mine is working! Was a problem with for cycles that weren't well done... thank you for help and time! :)

I'm sorry for cross-post, I thought that wouldn't be any problem to ask the same question to get different points of view and share knowledge. However, I understood that isn't "ethic", i will no do it again :) thank you for advice and one more time sorry

Hei, Thank you IIKhoutz, I've read this solution, but I didn't get how can I integrate my Time1 and Time2 values in the suggested code, I'm sorry if this is really basic.....I'm newbie with access/vba. Thank you for your help

Hei! I've one table with dates in this format dd:mm:yyyy hh:mm:ss and in another column the milliseconds. Do you have any suggestion how can I make the time difference in milliseconds? I've write the following code, but isn't working for all cases If Ms2 > Ms1 Then Dif =...

Sorry, The column Human only is fill with "Yes" the letters are correspondent to the Painel. I've tried to edit to be more easy to read but everything appears all united... how can i copy tables for here?

Sorry, I will try to explain again. So, 1.I have a table with status, Machines and Data/Hour. 2.The table have a lot of values and sometimes I have one On/Off that don't match with other Off/On. 3. I want to order by pairs Off-One, this pairs have to belong to the same machine. So I will have...

Thank you the corrections:) I've change to the dbOpenDynaset and define the variable with the of option explicit...but the code isn't doing what I want, anny suggestion for that? thank you!

Hi! I have 1 table with State "On" and "Off" that belong to a certain machine, I want to order Off On Off On Off On considering that the "Off" following by the "One" are in the same machine. Input: State Machine On A On F Off H On D On H On A Off B Off B...