Search results

Hello, I analyse machine behaviours. So, i have one table with the MachineName and the defect that occured. I want to count the number of times that each defect appeared and do report with a ranking chart, only with te top 5! The follow picture shows the main ideia: Do you know how can i...

Hey all, I want to replace the " ' " to blank spaces. (e.g it's ---> it s" I tried to write the follow code, but always give me the run-time error 3075, sytanx error in tring in query expression... DoCmd.RunSQL "Update [TableName] set Field1= replace(field1, ''' , '') " Do you know what...

Hello, It's possible to show only the form in a .accdr file? That is, hide the tab with the forms names and the bellow tab with the records, filters, search...As the follow picture: Thanks!

Hello, I'm searching for ways to create a button that export one list from a form to Excel ( the list is dynamic, i.e appears after the user choose through combo boxes the condictions). But i didn't find a code that works fine....do you know how can i do that? Thanks for your help! :)

Hello, I doing one form that shows all the machine that don't work since a certain date. The user choose trought one combo box the month and the year and after click int he button "update table", after that i want to show in a list the filter table. As the following image. So i have write the...

Hei, I've some simple doubts about how to work with queries on vba. The follow command, always open the query? DoCmd.OpenQuery "Query!Name", , acReadOnly It is possible only to run the query without open it? Thanks!

Hello, To run the code the user click in the button "run" in one form. However, while the code is running i want that the user have the perception that access is working to achieve the results. So, I tried to do two forms, one with a clock image and the text " Please wait..." and other with a...

Hey! Everytime that I add information to my main table I have a dictionary table that translate each record to a unique Class. However sometimes i have inputs that aren't in the Dictionary table and the user have to classify this new inputs. As the follow picture: I already have a query...

Hello, I have a historic table, and everytime that i introduce new data I need to move all the information two cells to the right. As the follow picture: Do you know how can i do that using vba? thanks!

Hi all! Hi want to take out the the --> ' <---- that i have in my name column(e.g. "d'rey"" So i wrote the follow code: DoCmd.RunSQL "Update [TableNames] set [Name]= replace([Name],' ' ' , ' ' );" But appears the error 3075 Syntax error. If I change the ' for "´" it works... do you have...

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...

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)"...

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 ! :)

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...

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...

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, :)

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...