Recent content by junkmale

On closing a form for "New Author", i need to requery the combobox in the original subform "AuthorBook", so that i can now select the new author from a dropdown??? yeah, the proper line works! :) thanks again!

lol... support your AIRWARE tho... works more often than not... no, i've not tried that particular line, but upon trying it, i get the message after i close the author form(supposedly when they carry out this command)... "Object doesn't support this property or method." first time i got this...

sorry, but having some problems with this again... it had worked fine for my drop down list to select a certain publisher for a book. can i requery for a field in a subform? basically, what i tried was this: Me.[BookAuthor subform].Requery no error msg, but nothing refreshed also. then, i...

i'm using Access2002, but still perturbed nonetheless by why simply typing the filename doesn't work. Anyway, Thanks!

I've tried not using the path at all, ie simply typing "pictname.jpg" in the field... but it does not work. "Microsoft Access can't open the file pictname.jpg." I have to key in the exact path for it to work. I'm currently selecting the picture by right clicking, properties, fomat...

Thanks for the speedy reply. I guess that works... but i'll be "shifting" my database around computers quite a bit... Is there a way to make it link to a file as long as it's in the same directory?

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

sorry for that... but i only started coming into close contact with visual basic this few week. No formal learning at all about this. In fact, not even any formal learning in SQL. I pluck all my information from online resources which teach SQL from the start, ie, "SQL is an ANSI (American...

yes, we were talking about publisherID. but my initial decision not to use autonumbers was based on the bookID issue i talked about, and i actually did it for everything else for consistancy. Anyway, i've changed all to autonumbers and there appear to be no problems... as of yet. hope it lasts...

I think in this case, ID is actually useful to the user, because for books, the combination of BookID/CopyID is actually going to be the unique identifier for any physical book found in the library(bcos the library will be holding multiple copies of some books). Refering to this call number...

Thanks... acFormAdd works, but presents a new problem. my ID is not an autonumber, but simply a number, for the person to key in. with FormAdd, I have no idea which IDs are already taken, as the information bar at the bottom shows it to be the first record. [previously, if it shows as 17th...

yes, my question is simply "how do i open it in preview" thanks!

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

thanks for the reply, but i dun think i'll be using it due to time constraints in finishin up my database... nevertheless many thanks!

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