Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!!! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Excel for making a book index | Excel Discussion (Misc queries) | |||
45 RPM Record Catalog | Excel Discussion (Misc queries) | |||
Making changes in all pages in a work book | Excel Discussion (Misc queries) | |||
Making a check book ledger | New Users to Excel | |||
Making a media library for movies, cd, book, so on | Excel Programming |