Search results

  1. B

    Make visible image based on data

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

    Value not valid for field in Combobox

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

    How to remove security

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

    Requery doesn't work

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

    Query on a variable number of comboboxes

    Hi I have a form where I have 6 comboboxes and a subform that will show the result for the query. The query is pretty simple : get all the records that have one or more of the comboboxes value. the values are in 2 tables so I used a INNER JOIN. I have the 6th comboboxes that works as a...
  6. B

    How do I get ItemId of the selected record

    Hi I have a Form that as a Subform (populated by a query). The subform query uses the values of the form combo boxes. I have a command button in the form that is supposed to duplicate the record selected by the user (The duplication is there if the user wants to add almost the same item but...
  7. B

    How to control a subform in the Form

    Hi I'm not sure if I'm doing it right but here you have what I want to do: (To help you visualize my form I've added the image of it) I want to control the record control through a command in the form. I would have a Previous, next command and a Delete. I also want to put an edit so I can...
  8. B

    Estimation database - Structural help needed

    Hello to all of you I'm reading lots of your post to try to find a hint of how I could structure my database. But can't quite find something that will allow me to start in a structured way. Let me first explain what is the goal of the database and what it will be doing : The database is to...
Back
Top Bottom