Buttons with multiple actions

[Andren]

Hi all!

I'm trying to set up a librarian database, that should keep track of books and articles in books, magazines and articles in magazines as well as doctorial dissertations and university papers.

So I made myself a look-up table containing 1) Books, 2) Mags and 3) papers. I also made three forms for input. Then I have a swichboard with thre buttons - guess what - Books, Magazines, Papers. Here is my problem: I want those switchboard buttons to open the proper subform and AT THE SAME TIME select only reccords that are apropriate for the selected form.

If anyone can give me a hint, I will be VERY thankful.

All the best.

Yours: Anders

 

[caman]

re problem

Dont know if it is what you want but this is what I do.

I assign the button on the switchboard to a macro

The macro then opens the desired form, but at the same time it applies a filter (in my case another query) the filter (or query) has only the fields that require editing in it

if it is a query then you just set the criteria to restrict the info you want,believe me it works

hope it helps

caman

 

[Oldsoftboss]

Does your table have a field to define whether the entry is a book, paper or magazine ?
If so create 3 queries with different criteria in each, book, paper, magazine.
Then simply base your form on the query. ( use the query as yor record source)
HTH
Dave

2 min whip up example

 

[Andren]

Thanks Dave !

I posted a reply some days ago - but apparently it did not get through.

Anyway - I did what you suggested. However I have more information to put together. So I took a copy of your library table -and added some more fields. Then I brought (copied) some other tables about classification (type of population described, gender, age, problems, diaagnosis, key-words etc ) and a table containing "Abstracts" of the articles.

Then I joined them. After that I made three Questions (tables) - one for books, one for Papers and one for Magazines.

So I now have four tables (Library, Type, Classification and Abstract ). I have four forms (Library, Books subform, Papers subform and Magazines subform).

After putting the subforms in the tabbed Library (main form) - my subforms went blank when shifting from design to form wiev - despite I have my tables populated with data.

Why is it this way? Did I something wrong with relating tables to each other or did I forget to do anything else very crusial?

Do I have to inform the subforms what variables that are to be shown somewhere? How and where ?

I do not really expect that an expert like you should bother with a problem from some stupid novice "Up-Over" but anyway - if you or anyone else would kick me out of my deep and dark ingorance -I would apreciate it. Thanks anyway....

By the way - I have been "down-under" two times attending coferences in Perth and Sydney. I had much fun and really want to go back.

Yours sincerily: Anders Andrén

 

[Oldsoftboss]

Can't think of anything obvious. Maybe zip and post the DB for us to have a look.
Dave.

PS.... This 'Expert' is self taught and only mucks around with access A.Hrs !!

 

[Andren]

Hi !
Thank you very much for yor interest and the time you took.
Then I have another question.
When I populate my forms with some data - they don't show upp next time I start the program - despite they are stored in the right tables. Why is that. Do I have to write some special code for that? I thougt Access automatically should show all data that you put in tables through a Question?

I'm thankful for all suggestions what to do.
Trying to post my work it showed that the zip-file was to big.
I tied to shump it in smaller pieces by file-shredder but still one part was to big. Is there any way that I can send it by mail directly to you. I will be willing to pay you for your time.

Sincerily:
Anders Andrén

 

[Oldsoftboss]

Email to predator@impulse.net.au

 

[shadowraven]

Database for Library

Hi Andren,
Is it possibel for you to email me your database for some ideas and to see how you have created it as im also starting a library database and you have coverd some of the things I would like to have in mine thanx.

Shadowraven

 

[Andren]

Hello!
Yes of course I will e-mail it to you. However - it is now quite big so I cant not send it to this forum. I will need your e-mail and then send it in zipped form. Then I can not do that right now (sunday night) since I have the latest version at my work.

/ Anders

 

[shadowraven]

my email

thanks my email has been sent to your private message