Search results

Hello! I have two tables: -Table1:with Start Date and End Date of the " authorized Work periods" per city - table2 with the date per city. I want to see if my date of table 2 are between the dates of table1 As the picture below: i wrote on vba code, but i'm thinking if i can write a...

Hello, I don't have a lot of experience with access solutions. I've finish all functions. Now I'm working in the better way to present the tool. I was thinking about connecting with visual studio. It is possible tu run all the code (vba) in Visual Studio? Do you think that i have strong...

Thanks, The_Doc_Man , was really interesting your answer and now i understood. :)

Hei, I'm using complex algorithms. I'm processing 500.000 records ......:/ but it stills to much?

Hi! :) I'm quite newby at forms. I have a button that runs a lot of functions and takes almost 10 hours to finish that! I want to show in the form the function that is running in one box, something like that: "running the Maintenance Function (1-50)" "running the Alarms Function (2-50)"...

I found some sites that said yes, but i didn't understand how. And about CPU? can I improve the CPU usage? seems that it is only using one processor :)

Hello all, I'm thinking that multi threading of different functions could accelerate my process. I've google that, and found many controversial information. It is a good ideia to use multi threading in access? If yes, how can i do that? Thanks ! :)

Re: Dcount->Run-time error '94'. Invalid use of Null [SOLVED] It is solved! Was a empty row that caused the problem.

update: SOLVED! empty row caused the error Hi, I use the DCount command to count the number of "Invalids" or "Stop" , 40 miliseconds after one "Off" in different machines but with the same function. It is appearing this error, but i can't understand the reason Run-time error '94'. Invalid...

Hei arnelpg, thanks for the reply, I didn't get how can i do that on a table. I should do an append query to transfer the information to a table? I've tried but appears the following error " your query not include the specifieds expression" CountAlarms" as aprt of an aggreagate fuction"

Arnelpg, thank you! I've tried this code: Sub CrossCountry() DoCmd.RunSQL "UPDATE [CountAlarms1] AS T1 INNER JOIN [CountAlarms2] AS T2 ON T1.[Day]=T2.[Day] and T1.[Hour]=T2.[Hour] and T1.[Minute]=T2.[Minute] and T1.[Second]=T2.[Second] and T1.[machine]<>T2.[machine] SET T1.[Flag] = '1'; " End...

I need code, because I've also miliseconds. So at the same second could occur more than one alarm in the same machine... I want to flag the machines that had simultaneous alarms (ie i have one alarm in machine b and at the same time i have one alarms in the machine c)

I can count cause I also have the miliseconds, so I can have more than one alarm in the same second... :)

Hello, I've a Totals Query grouped by: -Day -Hour -Minute -Second -Machine and counts the number of "Alarms". I want to flag the cases where at in the exact time (day,hour,minute,second) i've alarms in different machines. Day=day minute=minute Second=second Machine <>Machine Do you have...

Hi! I have two tables: 1) Table 1 with Off Events 2)Table 2 with Alarms events The alarms events could have different nomenclatures: -Alarm -Alarm x -Alarm y -Alarm z I need to analyse the alarms 4 seconds before my Off event. In this analysis is important delete the repeated alarms and only...

Hello, I have a simple doubt about CSV import. I want the user chooses the file path to be transfered to an existing table:table1. My table1 has the following columns: Date;MachineName;Status;MachineCode;Employee;Location Code;RunTime;Maintenance. And my input table only has Date;MachineName and...

thanks pbaldy! little tip but was all i needed :D

Hello, I have one table with the machine status associated with a date and an Machine, as the follow picture: I want to do a access query that counts the number of alarms per day and per machine, do you have ideia the more efficient way to do that? Thank you for your precious help, :)

Yes, i've tried this solution, but appears always this error: "Microsfot fix does not apply to your operating system or application version". I've the windows 7 and i'm downloading for my windows version.

Hy! thank you for the aswers :) They have all the same operative system and the same machines...there is no difference. I've tried to run after restart the pc, without any app running and the error persists. Any suggestion to solve? :) happy easter!