Recent content by b_bds

Hi Image name is ENG for english picture and FRA for french picture. (I know it's not up to code but it is how it was setup) [Langue préférée - Preferred language :] is the field were the data comes from. I can show it but it doesn't change the fact that the images don't change the visibility...

Hi I have a table of participants for an event and I want to create the labels for them. I created the labels but now I would like to make the labels more interactive. I would like to make some picture visible or non visible depending on the data. I tried to make this code : Private Sub...

Hi anyone has any clue? Thanks Bruno

Hi I had the same problem but solved it by disabling the allow filter option of the form. I used to just right click than select remove filter and then I just disabled the allow filter option. hope this helps Bruno

Hi for example you have the tblField categoryID DisciplineID Category option2Caption option2rowsource option3Caption option3rowsource etc... on the onclick event of cboCategory the prog looks to see if their is a value for the caption. if their is the cbo is visible. hire is the code to see...

Hi all the cbos are unbound. to populate the cbos I use a table that contains all the vba code for all the possibilities. When click on cboOption1 the vba looks for the value of cbo option 1 and another cbo and finds in the table (tblfield) the value for the rowsource of the cboOption2...

Hi i'm having a problem and I really have no idea how to fix this bug. I have multiple comboboxes (option 1 to 5). When option is selected, the rowsource of all the other ones is set to a value that I keep in a table (tblfield). Everything works perfectly but sometimes I get the error : "The...

Hi thanks for the reply For your information, I don't have to enter any password. Sometimes in vb I have to enter a password but not everytime (is it normal?). I'll be reading the Jack Macdonald paper and will see if anyting can help me. Thanks

Hi I started a database a couple of months ago and after I while another collegue continued it. I'm going back as the one in charge of that database but there is a problem. He applied a security level in the database and I get once in a while a message telling me that I can't do this or that...

I'm speachless It's working... I played with the filter option in the right click menu and now it works... but now every time I close my form it asks if I want to save the new query (since I change the query everytime I change the values of the comboboxes). Is there a way to save the query in...

I may have a hint for you When I right-click on the form and choose "filter by form" then right-click again and choose "Apply filter/sort" It works!!!! I have to do that in order to be able to show the results. Is it possible to do that in vba? or is it possible to do a work around? thanks

Hi thanks for the answer Everytime I click a combo box it calls the fonction UpdateFields(). That way everytime a combobox changes values it will update the query to incorporate the new criteria I'll try to see what I could do with your suggestion and I'll keep you posted Thanks Edit : I'm...

I was able to get access to the reference menu and the reference to the Microsoft DAO 3.6 is selected. Now I have no idea what to do it still gets me the same message every time I click on the duplicate button... anyone has an idea what I could do to copy a record? Thanks

Anyone has an idea? I have the good results in my query but I can't get the subform(that gets the results from the query) to show it... the requery doesn't work Thanks

Hi I changed the OR to OrdReq as suggested but guess what... same thing... but I found something... When I put my form in "form design" then put it back in "form view" it does work for some time but when I add a second combo box value it stops to work. But when I open the query by itself I...