Search results

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

Thanks guys for the reformating... I'm sorry I couldn't do it but I keep having problems here (at work) with the buttons (like insert image and code). Once in a while they work... I will work on those suggestions and keep you posted... thanks you very much edit: as for the OR column it...

Hi The database is pretty big but I can show you the line that updates the queries upon changing the values of the combo box (see http://www.access-programmers.co.uk/forums/showthread.php?t=155755) Here is the function that I use and where the requery is asked : Private Function...

As for the error here you have an image of what I get : [img=http://img165.imageshack.us/img165/9049/91152335kf7.th.png] As for the reference to the DAO object model, I can't access the tools menu on the main menu because the person how works with the database removed the acces from all...

Hi I should of said that I do have that line and I tried the refresh because I couldn't find anyting else to try. Sorry for the mislead thanks

Hi I have a query that gives me the information that I want. I have a form and a subform. The subform as the query as his "source object". The query selects the info based on combo boxes that are in the Form. when I change their value, I don't get a refresh. In debug mode I see that the line...