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!

  • Congratulations bkrike 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
  • Content: Threads
  • 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

    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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. PLiNk

    How to: on not in list, add to table then select

    How would I do this in an effective manner? To be more specific I have a table with a lot of names in it, but the primary key is a autonumber. I have a table that stores this NameID, but to make things easy for the people using the database I would like them to typein a name, and if it doesn't...
  10. PLiNk

    If not in list, then add the update then select

    Hello wonderful forum! To be brief, I am tired of the "Item not in list" error message. I am creating a database for notes, and somebody is gong to sit there all day typing in the title, the name of the composer and the arranger and the author of the text, as well as the publisher...
  11. PLiNk

    Pass thorugh query to MySQL

    I need to connect to a MySQL server to get som e data into my application but i cant do it because (i assume) windows doesn't support other servers than the ones they're makeing themselves. Anyone can help? thank you Jens Tandstad
  12. PLiNk

    Bound Column 0 silly problem

    I'm still not exactly sure how this occured so correct me if i have misspelled something, What happened was that i had 20 people listedwith their own number from one to 20. 20 posts with dual listboxes Then I added record labeled and number 10 in the list into the other listbox and with a...
  13. PLiNk

    Need to filter combobox query for already selected values. Need Help

    Thorough problem description: I am constructing a database program that is intended to control how a competition unfolds, say with teams, team match with paintgun or football with variable teams, and score processing. When selecting the teams I absoluteley need to remove say Frank Conners from...

Part and Inventory Search

Back
Top