Search results

  1. B

    Use input to determine which field to choose in SQL-WHERE

    Hi Micron,:) you are right, but actually what I let see above is only part of what I already have and anyhow, the database I am working on is far from finished. I intend to use the query to populate a listview and I have already made, years ago, the necessary bits of soft to make all kind of...
  2. B

    Use input to determine which field to choose in SQL-WHERE

    Isladogs, thanks also for your suggestion. I intended to indeed switch to use a single dialogbox with one combox with the list of fields to choose from and one textbox to fill in the name (or some characters of) . That's for one of the coming days, thanks!
  3. B

    Use input to determine which field to choose in SQL-WHERE

    Hi Arnelgp,:) many thanks for your very quick and helpful answer ! Maybe it has to do with the acces-version, but with very little adjustments it now works, thank you. I used a second inputbox, because the SQL with "[Name ?]" doesn't work in my module, I don't know for what reason...
  4. B

    Use input to determine which field to choose in SQL-WHERE

    HI, I want to avoid redundancy as much as possible.... We have an access database (2016) containing records for hundreds of movies, with numerous fields. The fields concerning this question are tblMovies.Director, tblMovies.Writer and tblMovies.Actors (in reality more, but if someone can...
Back
Top Bottom