Search results
-
J
linked picture
i found that a small increase in size of a picture file used as background in my database leads to a huge increase in size of the database file. having a linked file (as compared to embedding one) works much better, especially when the particular picture is used in several forms. however... -
J
view report
On my switchboard, i've placed a button to view a report. The expression is as below. Private Sub BooksbyAuthorbyYear_Click() DoCmd.OpenReport "Author2" End Sub I receive a runtime error, telling me to install a printer first. [my current compute is not connected to any printer] How do... -
J
report or query problem?
hi. i'm doing a database for a library, and one of my reports shows all books written by a certain author. what i'm doing now has a "popup" promting me to key in the author last name. This works. But, i'm trying to improve on it. Is there some way that will display a list/dropdown of authors... -
J
not the right heading?
i'm trying to display as you can see, all books and periodicals published by the same publisher in a certain year. The code i placed below works, but one problem is this. The end result shows in this order: "BookID Title PublisherName YearofPub" BookID in this case is not quite the right... -
J
belated followup
quote: -------------------------------------------------------------------------------- Originally posted by namliam To Add to a dropdown list, add a popup form On double click or On not in list or add a small button behind it. Then open a form, where the user can input his data on the... -
J
namliam! help!
help! Just to jot your memory, I asked you for some help some time back... here is the relevant thread. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=54357 I'd gone on to do the database and was pretty happy with it but i just realised that a problem would occur if the... -
J
generating primary keys based on values in another table
Hi... i'm trying to do up a basic library database, and having problems with one part... one of the tables (BOOKS) will have fields: "BOOK ID"(Primary Key), and "Number of Copies". On another table(Book copies), I'm trying to generate unique call numbers for each copy of a book. There would...