Search results

Hi, I want to create a query that will show the total number recordsthat have a specific methods. For example see photo. I have multiple number of Project with the same name but the methods are sometimes differs and sometimes the same. I know in the query I have to Group the Projects together...

I think my brain just froze when I see the codes in the example. But I will keep it for my future reference, in case I will encounter the same problem (I bet I will face the same problem). Thank you ridders!

I see. Thank you. May I also know where should I paste the code? Just in case you know where.. Because I am an intern here and I have no access to Home-Office, so I couldn't test the error and debugged it. Also, the colleages are from another location far from here so I can't just peek into his...

Alright. That means there is no rigid solution to it isn't it? Just do not open the database without the network, right?

My colleage got an Error message when starting the Databank. Error 3044: 'O:\...\AccessBE' isn't a Valid Path. Make Sure that the Path Name is Spelled Correctly and that you are Connected to the Server on which the File Resides. He said that he is working via Home-Office and during opening of...

Maybe you can add.. ComboWSIB.value = 0 CboPrograms.value = 0 ..at the end of your searchbox code. So that when you started typing in the searchbox, the filter in the combobox will be reseted.

Minty you're the bomb! For the parameter criteria, I actually used [Forms]! but I don't know why it automatically came out as [Formulare]!. I used the Expression Builder instead of typing it manually and it works perfectly now. Funny thing is, what I typed in and what the Expression Builder...

Thank you ridders for your reply. I have looked at the example but it is quite complicated for me to do. But I will try it when nothing else works. Minty, I have tried your suggestion but it still ask for another parameter. See photo. As you can see in the photo, the textbox for dates is named...

Thank you for your reply. Okay I did a small form with a 'Set' button but how do I connect it with the query? Can I change the codes above to the codes below? SELECT tbl....... FROM tbl...... WHERE (((tblBill.datDiscussion)>(tblDatePicker.datStart) And...

Hi, does anybody know how do I insert a calendar date-picker at a parameter value input box? See picture. I have a query that will filter records between the given Start date and End date. Right now I have to manually type in the dates whenever I need to use the query but now I would like to...

Hi, how do I make coloured background for each record. See photo. The colour depends on the task assigned on the records. For example, when the task is set to Analysis, it will turn blue, when others, the background is normal. Does it have to do with the following codes? Private Sub...

I have a Form A where it displays the dates of the records based on Table A. Then I have a Pop-up Form where I enter some details of the record. There is a textbox where I can enter the date of the record. I am attempting to save the date entered from the Pop-up Form onto the Form A. The...

Thank you Orthodox Dave. But may I know where should I put this code? In VBA is it? If so, for which sub?

I have a Form with a Subform on it and the subform is showing records in Table Component. I just added a new field on the table, which will show the status colour of the component. The status of the component is taken from another table called Table Component Order. But for each component, there...

The solution lies at reply number #5. Silly me. Thank you Orthodox Dave.

Found the solution! In the form query at the properties section, just set Duplicate to No. A word 'DISTINCT' will automatically be added next to 'SELECT' in the sql. That's all.

Yes it is working like a charm :) Gonna mark this threas ad solved.

Omg you understand it perfectly and you are absolutely right! The codes works! Thank you very much!! :D

I have a subform that I want to filter using a combobox. The subform query is in the left side of the photo that I have attached and the result that supposed to show up on the subform when I clicked on the combobox is on the right side (in red box). The problem is I couldn't get the subform to...

Thank you! I just figured out that I just need to add Grouping in my combobox query. It works now. :)