Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Thank you so very much!

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

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