ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Making a book catalog? Possible ?? (https://www.excelbanter.com/excel-programming/390928-making-book-catalog-possible.html)

Carlos

Making a book catalog? Possible ??
 
Hi everyone !!

I´m trying to do a catalog, but using a UserForm, i have a database, with
the authors, bookname,number of pages, classification of book ( novel,
romantic, science fiction, etc..) , year of publication and I have the cover
pic.

So I one to make little query userform. Choose by author and display the
information and the picture cover of the books that are in the database or
choose the classification and display by book the information and pic of the
cover and son.

Is like a online catalog, but is personal is for my books and future books,
I love to read, so I keep the information of the future books I would like to
read.

Is this possible ??

Thanks in advance!!!

Jennifer[_2_]

Making a book catalog? Possible ??
 
On Jun 7, 3:17 pm, Carlos wrote:
Hi everyone !!

I´m trying to do a catalog, but using a UserForm, i have a database, with
the authors, bookname,number of pages, classification of book ( novel,
romantic, science fiction, etc..) , year of publication and I have the cover
pic.

So I one to make little query userform. Choose by author and display the
information and the picture cover of the books that are in the database or
choose the classification and display by book the information and pic of the
cover and son.

Is like a online catalog, but is personal is for my books and future books,
I love to read, so I keep the information of the future books I would like to
read.

Is this possible ??

Thanks in advance!!!


Hi Carlos. What is your database in? Access? SQL? Something else?

To answer your question - yes, it is possible. I don't think I'd do
it in Excel, though. If your database is in Access, I'd just use that
if I were you.

This is odd - I did this exact thing for a VB programming class I took
in college about 8 years ago. If you want (assuming I can find it) I
can send you the code. Just say the word.

Jennifer


Carlos

Making a book catalog? Possible ??
 
Hi Jennifer....

I really appreciate it if you find it, you could send it to me !!

Thank you very much !!!



"Jennifer" wrote:

On Jun 7, 3:17 pm, Carlos wrote:
Hi everyone !!

I´m trying to do a catalog, but using a UserForm, i have a database, with
the authors, bookname,number of pages, classification of book ( novel,
romantic, science fiction, etc..) , year of publication and I have the cover
pic.

So I one to make little query userform. Choose by author and display the
information and the picture cover of the books that are in the database or
choose the classification and display by book the information and pic of the
cover and son.

Is like a online catalog, but is personal is for my books and future books,
I love to read, so I keep the information of the future books I would like to
read.

Is this possible ??

Thanks in advance!!!


Hi Carlos. What is your database in? Access? SQL? Something else?

To answer your question - yes, it is possible. I don't think I'd do
it in Excel, though. If your database is in Access, I'd just use that
if I were you.

This is odd - I did this exact thing for a VB programming class I took
in college about 8 years ago. If you want (assuming I can find it) I
can send you the code. Just say the word.

Jennifer



Jennifer[_2_]

Making a book catalog? Possible ??
 
On Jun 7, 6:09 pm, Carlos wrote:
Hi Jennifer....

I really appreciate it if you find it, you could send it to me !!

Thank you very much !!!



"Jennifer" wrote:
On Jun 7, 3:17 pm, Carlos wrote:
Hi everyone !!


I´m trying to do a catalog, but using a UserForm, i have a database, with
the authors, bookname,number of pages, classification of book ( novel,
romantic, science fiction, etc..) , year of publication and I have the cover
pic.


So I one to make little query userform. Choose by author and display the
information and the picture cover of the books that are in the database or
choose the classification and display by book the information and pic of the
cover and son.


Is like a online catalog, but is personal is for my books and future books,
I love to read, so I keep the information of the future books I would like to
read.


Is this possible ??


Thanks in advance!!!


Hi Carlos. What is your database in? Access? SQL? Something else?


To answer your question - yes, it is possible. I don't think I'd do
it in Excel, though. If your database is in Access, I'd just use that
if I were you.


This is odd - I did this exact thing for a VB programming class I took
in college about 8 years ago. If you want (assuming I can find it) I
can send you the code. Just say the word.


Jennifer- Hide quoted text -


- Show quoted text -


I will search for it when I get back home tonight.


Jennifer[_2_]

Making a book catalog? Possible ??
 
On Jun 8, 8:43 am, Jennifer wrote:
On Jun 7, 6:09 pm, Carlos wrote:





Hi Jennifer....


I really appreciate it if you find it, you could send it to me !!


Thank you very much !!!


"Jennifer" wrote:
On Jun 7, 3:17 pm, Carlos wrote:
Hi everyone !!


I´m trying to do a catalog, but using a UserForm, i have a database, with
the authors, bookname,number of pages, classification of book ( novel,
romantic, science fiction, etc..) , year of publication and I have the cover
pic.


So I one to make little query userform. Choose by author and display the
information and the picture cover of the books that are in the database or
choose the classification and display by book the information and pic of the
cover and son.


Is like a online catalog, but is personal is for my books and future books,
I love to read, so I keep the information of the future books I would like to
read.


Is this possible ??


Thanks in advance!!!


Hi Carlos. What is your database in? Access? SQL? Something else?


To answer your question - yes, it is possible. I don't think I'd do
it in Excel, though. If your database is in Access, I'd just use that
if I were you.


This is odd - I did this exact thing for a VB programming class I took
in college about 8 years ago. If you want (assuming I can find it) I
can send you the code. Just say the word.


Jennifer- Hide quoted text -


- Show quoted text -


I will search for it when I get back home tonight.- Hide quoted text -

- Show quoted text -


Hello Carlos. Sorry, but I could not find the old program. However,
because I feel bad about that, I wrote a quickie Access database with
some forms that pretty much does what you wanted. I tried to email it
to you to the email above, but it came back. I can't attach it in the
newsgroup. If you'd like to have it, let me know where Ican send it.

Thanks,
Jennifer



All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com