Library Forms

[piia]

I have created a library catalogue system. I have set up a system with publications catalogued with a catalogue ID. The publications are stored by genre in boxes which each have a box ID.
I have created a loan system to book publications in and out of the catalogue system, however I have been asked for users to be able to book the boxes out of the system, however I need the individual publications stored in each box to be automatically booked out of the publication loan system when the box is booked out and in respectively.
Can this be done using a macro within the form? I have tried using a subform but this doesn't seem to work.

 

[Geezer]

Not sure of your table setup but if for example you had a tick box attached to each item and the item is ticked when it is checked out then you could run a SetValue action in a macro when if the box is checked out all the items within the box getting checked out, i.e. the tick box value's get ticked (=yes).

 

[piia]

Thanks will give this a go.

 

[piia]

Thanks tried this but got the following message. 'The object doesn't contain the Automation object 'tblCatalogue' . You tried to run a Visual Basic procedure to set a property or method for an object. However the component doesn't make the property or method available for Automation operations. Check the components documentation for information on the properties and methods it makes available for automation operations.'

I'm not very experienced with creating applications in Access. Can you advise?

 

[dcb]

Can you upload your db? You haven't given much to go on....

 

[piia]

Hi
Tried to upload it, but apparently I don't have a security token.

Here's a print out of the relationships

Thanks

Piia

 

[piia]

Can you upload your db? You haven't given much to go on....

Here it is. Managed to upload it this time. All help appreciated.

 

[Geezer]

I cannot see how you register that a box or catalogue are booked out. I'd have thought you'd have a tickbox or yes/no field to tell the user if a publication is out.

One other thing, you might want to run a compact and repair on your database, it'll shrink the size right down. You can find this feature under <Tool><Database Utilities>, make sure to make a backup of the DB first.

 

[piia]

Hi Geezer

I have been booking the the publications out and in based on no of copies required - as there is more than 1 copy of some of the publications in the system.
Occasionally the box is taken out, I don't have a method to do this as I haven't figured out how to automatically book all of the publications stored in each box when the box is booked out by a member of staff.

I'm a total beginner at creating systems in Access so all help appeciated.

Piia

 

[Geezer]

Piia,

Okay, just a suggestion based on how I'd probably go about this.

Each publication and box has an ID or unique internal code. The publications table would contain all the ID's and any other relevant data for each and every publication. The box table would be similar and linked to the publication table making a many-to-one relationship, many publications that might reside in one box.

I'd add a yes/no type field (tickbox or text) which would signal when the publication or box is checked out. For example select "yes" when the publication or box is checked out and "no" if it's sitting on the shelf.

Now, attached to the yes/no field you could write a bit of code or reference a macro. Set the macro or code to run when a box is checked out or returned, i.e. the yes/no field is updated. If the yes/no field is set to "yes" then set the related publications yes/no field to "yes". If "no" then set to "no".

Hope that helps, others might have better ideas.

Gareth

 

[JANR]

Perhaps similar to this: http://www.access-programmers.co.uk/forums/showthread.php?t=186192

JR

 

[piia]

Thanks will give this a go