Recent content by Philman

Yes, jdraw, that line you added in your example is exactly what was missing in my code. Now it works as expected. Now, for those who need a similar code, just check the one I've posted above. In the last line of Listbox/properties/on double click event change the line: DoCmd.OpenForm "Update...

Hi jdraw, Thank you for the sample file. In fact, I was tired to use in my database the same expression as your sample, but it doesn't wants to work. Finally, I've got to the conclusion that, having the DB as I do, my search criteria can't be done by access features, it has to be done by VBA...

Thanks jdraw for the tips. You are a good guy! For my needs I don't need date for the records. My model of structure is enough for my needs and I think it's well designed for the purpose. I'm sure it could be better, but I don't know how to do it. So, it has to be like it is. I think the...

Thank you jdraw for your patience with me. As a begginer, I can't see other way to do the relationships. However, for the purpose, I think they are ok. Correct me if I'm wrong! Still, I'm not being able to set up the filter results as I wish, and this is very important to my work. Please, let...

You are right, they don't appear, but they are there. Please, when looking under database tools Relationships, try to hit the tool "all relations", right next to "show table". Please, give me a hand to solve this. Thank you very much.

Thank you jdraw for your tip. So, do you think I won't be able to filter the information as I want with the existing tables and relationships? :( Case not, could you please give me some guidelines of how would you build the tables and relationships, taking in consideration the needed fields to...

Greetings, First I would like to say that I'm portuguese and apologize for my bad english. So, I'm a begginer in Access and I'm making my first database, but I got stuck. I need to put in a form a way to do record searches based in some criteria. Given my database structure, I really don't...

Greetings, I'm portuguese and I'm giving my first steps in Access. I look forward to learning from the threads. Thanks