Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PLiNk
  • Order by date
  1. PLiNk

    NOT IN subquery problem

    I am trying to join to find publishers that have no registered books. I am moving books from one publisher to another, and need to delete the former publisher. I want to delete all publisher that have no books attached. So I select all publisherkeys and subtract the publisherkeys (distinct) I...
  2. PLiNk

    Date change later than 00:00

    I am building booking database for a student house in Norway. Many things happen here, and different organisations book rooms for the activities. The house usually closes 03.00 in the morning, and when booking a room rhe time is usually the next effective day, thatis, later than 23.59.59 This...
  3. PLiNk

    ATI Radeon 9800 XT

    Thank you for this post. It was helpful for me as well!
  4. PLiNk

    Advice on graphics card purchase. For 3D Studio MAX or Cinema 4d v.8.

    Advice on graphics card purchase. For 3D Studio MAX or Cinema 4d v.8. Hello. I am going to buy either 3D studio MAX or a similar program but my computer is not up to it. I have a NVIDIA titanium 4200 right now and it would be too slow for the amount of complexity i will build. Can anyone...
  5. PLiNk

    Subforms and other object resize to fit screen resolution.

    Thank, i wasnt so easy that I hoped, bu I think I'll get it to work: thank yuo very much. jens
  6. PLiNk

    Making button disappear when criteria is met

    I have a UNION query with two classes of records mixed. Leaflets and Papers. I can combine two classes of records into one query, but I would like to have a button that enables the user to access the leaflet to overlook the contents (papers) of this leaflet. When the button is on every record...
  7. PLiNk

    MSAccess Search Very Slow when connecting to SQL server

    I never use it though. I am not entirely sure, but if you are using the standard searcg facility you must run a query (receiving all data on the server is still a query) on the server and have that transmitted, and then search thorugh this with ctrl+f. Since this is bound to take up a lot of...
  8. PLiNk

    One query with mixed data from more than one table

    or let me rephrase. When the button is on every record shown, every paper and every leaflet, it will produce an error message when clicked upon if the paper does not belong to a leaflet, otherwise it will function as intended. How do I disable the button if ,say, (Belongs_to_leaflet_number IS...
  9. PLiNk

    One query with mixed data from more than one table

    Thank you. I am quite new to this, and with no education Union queries are new to me. It isn't the first time I ask questions that are very simple. Not anymore. The impeccable logic of union queries are now understood. I am also writing this whilst quite drunk. Again, thank you for your help...
  10. PLiNk

    How Can i Delete a Single Record in DataSheet View

    Yo can also program the macro which selects your records to turn off warning-messages. Set "DisplayWarnings" to No as the first procedure in the macro. (it might be called something slightly different, you'll find it).
  11. PLiNk

    Subforms and other object resize to fit screen resolution.

    Hello, I am making a program and throughout the database I have numerous subforms. On the computer this was designed for the screen resolution is only 1024 * 768 but on my computer the resolution is 1280 * 1024. How can I make the subforms (most importantly) increase their vertical heitgh to fit...
  12. PLiNk

    One query with mixed data from more than one table

    This is exactly what i have done, on the spot! But what i want is to have one subform with all the records in, and not two. Essentially when searching for, say, "love" all recors in both tables cotaining the string "love" are equally interesting. It therefore makes sense to put them in the same...
  13. PLiNk

    MSAccess Search Very Slow when connecting to SQL server

    I am not sure this will be of great help, I am quite new to this myself. It sounds as though you know more than me. The problem I have experienced is that the whole database i transferred to the localhost, and then the query is run. If this is the problem, you must use a pass-through.-query...
  14. PLiNk

    One query with mixed data from more than one table

    Hello, I have a problem that I hope someone can help me with. I am going to explain very thoroughly, so skimm through if you know what i mean. Right know i am solving this problem by having two subforms. This is not so good since they become difficult to navgiate. Description. I have two...
  15. PLiNk

    Free search string in query?

    That simple? But how would I make it so that those two asteriks doesn't have to be written? And how would I do it if I wanted to have many such search functions referring to say an array of textboxes on a form so that: When the a textbox contains a value, this value will be compared to records...
  16. PLiNk

    Free search string in query?

    Hello, I am making a database for an organisation that are archiving sheetmusic and scores for choires. In the future people will be coming in and searching different things about the score. I already the capability to search on people and on title. What I need is a free search string so that if...
  17. PLiNk

    Adding records to a subform from a Button on a Form

    It it works the first time, just reload the entire form when you press the button. Jens
  18. PLiNk

    Pesky SheetID wieved as duplicates due to middle table problem.

    Thank you so very much!
  19. PLiNk

    Pesky SheetID wieved as duplicates due to middle table problem.

    Hello, hope someone can help. I am creating a database for sheetmusic, and information about the different sheet are stored in the "sheet" table with sheetID as primary key. Also I have a table called "creator" with all the names of people that has made the music in it. As a middletable I have...
  20. PLiNk

    Form Becoming Blank

    This happened to me during an exam and I was had a driving lesson, who had to wait outside at the same time as I was rebuilding all the forms from scratch. Luckily this was in Bournmouth England, and not in Redwood USA, since if it was, I would have told my dear driving teacher that we would now...

Part and Inventory Search

Back
Top