Recent content by mfaqueiroz

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

it is solved!! thanks Sneberg for share your knowledge:D

Thanks! it worked! And there is any way to fit the access to the form? :) as the follow picture

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!

Thanks Sneuberg for your help and time. But I still dont understand... 1. -This code i should put in Form->Event->On Current->[Event Procedure]? -the query Name, i should create one physic query? if yes how can i change the values through the combobox? 2. I leave this code in same place as...

Sneuberg, thanks for your help. Sorry for my little knowledge. But how can i do this query that is filtered in the same way the list box row source is? An example of an issue I've posted here: -I have two combo boxes where the user choose the month and the year and i fill the list box with the...

I mean a list box that changes according the user choice in the combobox, this listbox is connected to a query and the combo box works as filters...

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

Thanks SneuBerg. It's solved :) !!

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

Minty in this case , i have two kinds of query that i need tu run without the user see it, one is a select query and other is a append . Thanks!

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