Search results

Ah Yeah! I guess that's a good way to do it! You're right, i wouldn't care what book was used on the loan...i don't think the nursery would either. So basically, add another field to my book/book_copy table.. which you enter the total amount of books you have of one book. Then basically when a...

I did normalise my database.. It does, a library doesn't just have 1 copy of each book, they have 10's-100's of the same one.. Yeah, i would do that..BUT that would mean a nursery can loan A book many times.. if you get what i mean?

Ah, that's more like it! Well, okay then.. i'm fine with that, it's just I'm like that :' ) I hate people using my stuff xD - but, fair enough, i'll remove it ^^ Yeah, that's exactly one of my points in my first post (i think?). I don't know how to do that..so that's why I didn't try it. Ah...

Jawohl, i compacted and repair through 'utilities'. But, i locked the menus because that's how the database would be if I were going to put it on the End users machine. I'll upload another one with everything unlocked if that makes things any easier! No, wait don't turn it on me! I only asked...

Nah, i'm not touchy. Should've read the whole thing first then before posting ._. Blaming your eye sight, wow, that's a first. Just gimme feedback, pleeeeeease.

Where did I mention my class? People doing this kind of assignment, in GENERAL. Trust me, first thing people do when they've got an assignment to do, is google it. Library database filetype:mdb/txt/doc/etc. And if you haven't already realised... the information in that database is all...

There's no archive password. The password for the database itself is my user name on here.. The one i'm posting under.. I'm not saying it because if other people google for the name (of my assignment) and they can steal my work. Well, probably not :' ) But you never know.. xD 11 views and no...

Hoi, Well, this is my 1st EVER database and whatever I've learnt is either from here or 'on-the-way'.. It's a Libr4ry Database for a college assignment. Basically, I'm a DBA and also an employee at the library. Nurseries come to us/me to hire books for their students/children/whatever. In my...

Hmmmm yeah! I suppose that's another way of doing it! But, with me it's alot more complicated.. In my loan table I only have: LOAN_ID BOOK_ID NURSERY_ID LOAN_DATE BOOK_RETURNED And if one wants to delete a loan they must first either Look up the loan ID on the table and then search for the...

You're exactly right. You can't just ask for help without trying stuff yourself.. where's the fun in that! PLUS by doing so you might even find it out yourself.... IF answer_found <> yes then ask = yes end if </geek> :' )

Hoi! Basically, I've got a form: And as you can see, in order to select the right loan (Or even see the loan details, Nursery name, book name, author etc) you have to look in to the loan table and then remember the Loan_ID GO back into the delete loan table and select the right loan_ID from the...

AH, that's good to know then! Yeah, I've noticed on most forums, new comers just register, write a question and then expect every member to answer it :' ) I'm different, I know most people won't.. you've got to attract them :' ) OH, maybe you can help me on another question - It's another newb...

xD I know, I never see any other students asking nicely. They just demand you help them :') Which is probably why half of their answers don't get answered.

Thanks dude! Your above method worked perfectly! Can Delete Books and Authors from tables :)

Ruralguy suggested that i made a new thread - so I'm taking his advice (H) I've got another problem, well not problem..i want to make it more user-friendly. Database= (Look for yourself see what i mean) (rename to .RAR if it doesn't open) Basically, when the user adds a book, they can add...

AH, that's it dude! Knocked it on the spot! I've got another problem, well not problem..i want to make it more user-friendly. Basically, when the user adds a book, they can add it easily.. the only problem is, when ..just say i want to add a book, and I have 10 copies of this book, I have to...

I'll attach my database. Hope that makes it easier! -Couldn't upload as a .RAR so i renamed the .RAR to .ZIP Still opens, but if problems just renamed to 'whatever'.rar :)

Yeah, i created the combo box via the wizard. I'm using Office xp/2002. Well, that's what i would like to happen - the combobox selects the record, but it doesn't. Here's the code.. Private Sub Command24_Click() On Error GoTo Err_Command24_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8...

Jebus! Those were fast replies! No boblarson, when i select the author from the combobox and press delete i actually want it to delete the author from the table. I haven't really thought of that - haven't really used queries that much to know that either! I'll give it a bash! RuralGuy, I'm...

Hoihoi, Well, Hello.. Never thought I'd register on an Access forum, but, hey, why not! I'm new to Access, never really liked it..but this assignment has changed me.. i really like Access and well DBA'ing in general! I need a bit of help with a few things: -----I hate registering on sites JUST...