Forum Home | Log in | Signup | My Page | Rules | FAQ | Boards | Members | Search
« 6TH POPE Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next

Re: Something Cool To Stumble Upon...

By: Decomposed in 6TH POPE | Recommend this post (0)
Tue, 10 May 22 5:18 AM | 47 view(s)
Boardmark this board | 6th Edition Pope Board 		Msg. 31863 of 60008
(This msg. is a reply to 31862 by Zimbler0)
Jump:
Jump to board:
Jump to msg. #

Zimbler0:

Re: “Can I assume that when one types in a Title, that the database checks to see if it has already been entered?”Hey, I'm a beginner. You probably know Access far better than I do. I have fields where duplicates aren't allowed, but I don't have informative windows popping up to tell me whenever I've duplicated a title. I'm not sure I'd want that anyway. It might get annoying - because duplicate titles ARE permitted in this database.
Re: “'Originator' - I assume is the same as author?”An author... when the Media type is a book, a band when the Media type is a CD, a Director when the Media type is a DVD. Sometimes there is no author. Better Homes & Gardens has a bunch of gardening books with no author. So the Originator is the Publisher.

I mulled this over quite a bit before I settled on "Originator." That works for all the types of media this database can and will track. Even photos. Not everything has an author, but everything does have an originator.Re: “'Location' reminds me of when I used to keep the shop inventory of spare parts - on a computer. Access database, and the location was a text field. And it was usually something like 'A-27-C'. Where the first character (A) was a cabinet number. The second number was either a drawer number, or a shelf space. And the third character (C) was the space inside the drawer.”I've got boxes that were packed in Sacramento, at the 1st house in Virginia, at the 2nd house in Virginia, at the 3rd house in Virginia, at the condo we were in during our last year in Virginia, at the Charlottesville condo where my son lived, and at the current NH house. The box codes all mean something to me, as does your shop inventory. But their main purpose was and is just to give me unique box numbers each time I moved. I've got a spreadsheet with a detailed inventory of most boxes. But not books. There were just too many.Re: “Can you add new authors on the fly? Have you looked at subforms yet? (This would be a form, with another form on the form.)”Naw. As I suspected, you know Access better than I do. When I open a box, I pull out its books and make one pass through them just to enter all the authors my DB doesn't yet have. It doesn't take too long but would certainly improve if I could add them "on the fly' while typing in the books. The database can't do that yet. Nor does it have subforms. But it does have dropdown boxes derived from other tables. For instance, when entering a book's genre, the database only allows genres to be entered that are already in tblGenres. That way there are no mistakes and I don't just invent new genres on the fly, sometimes calling something a 'Murder movie' and other times a 'Horror movie' and still others a 'Suspense Thriller.' Everything along those lines gets classed as a "Suspense/Thriller." Every now and then I have to add a new genre to the table, but it's not common.




Avatar

Gold is $1,581/oz today. When it hits $2,000, it will be up 26.5%. Let's see how long that takes. - De 3/11/2013 - ANSWER: 7 Years, 5 Months


 - - - - -
View Replies (1) »



» You can also:
- - - - -
The above is a reply to the following message:
Re: Something Cool To Stumble Upon...
By: Zimbler0 in 6TH POPE
Tue, 10 May 22 4:57 AM 		Msg. 31862 of 60008

Ahhhh, said the blind man.

Can I assume that when one types in a Title, that the database checks to see if it has already been entered?

'Location' reminds me of when I used to keep the shop inventory of spare parts - on a computer. Access database, and the location was a text field. And it was usually something like 'A-27-C'. Where the first character (A) was a cabinet number. The second number was either a drawer number, or a shelf space. And the third character (C) was the space inside the drawer.

'Originator' - I assume is the same as author? With a separate table for all the authors and the pull down arrow access that list making it quick and easy to assign an author. Can you add new authors on the fly?

Have you looked at subforms yet? (This would be a form, with another form on the form.)

Zim.


« 6TH POPE Home | Email msg. | Reply to msg. | Post new | Board info. Previous | Home | Next