Booked?

[burton]

As some of you might already know what my database is on. For those who do not i'm doing a garden tool database that loans out equipment.

I have a problem. i need to know if something has been booked.
so when i enter some details like Item ID and then the date a box will come up ans say "Item Booked Between date? and date?"

any help would be great

 

[Ally]

I have a similar thing to this with TENS machines.

The way I got round the booking issue (it was Colin's brainchild) was to add a field to my Machine masterfile (in your case equipment), called OnLoanTo.

Then in code in the form, when the machine is booked out to someone it runs code to update the OnLoanTo field with the Patient's name and the status to the machine to "On Loan".

The machines I also put into a combo box on the form which only looks at those with a status of "Free". Anything "on loan" or "out for repair" etc does not appear in the list.

I had originally gone down the road that I think you may be looking at: writing code to loop through the recordset to then say "Sorry you can't have this, it's already out on loan" sort of thing. I find that by eliminating those on loan in the first place is a slightly better way.

I also have a form which tracks the current status of the machines, ie saying whether machines are free, out on loan and who to etc.

Other's may have other ideas, but post back if you need anymore info.

 

[burton]

thanks for the reply.
but i would like to know when the item was booked out.
and maybe a message box would then come up and say "sorry that item has been booked" or something like that.
if this is possible then could you tell me step by step because I'm new to access.

thank you

 

[Ally]

From the way I understdood your original message, I thought that your first issue is to work out whether the equipment is booked? So long as you've got date fields to determine when the machine went out on loan and a return date then the rest should be easy.

If you haven't got them already, add date fields to your table - one for DateLent and one for DateReturned.

Have you got a form yet? Once in your form, you can write code for it to automatically post the date.

Can you post what you've done so far - that way it'll be a bit clearer for me and anyone else who looks at it, to know exactly what sort of help you need and will prevent us from telling you to do stuff you may have done. You'll need to zip it.

 

[burton]

i can't send the file it is too big
if you want i could email it to you

 

[burton]

the file is too big to email aswell.
it cuts down to about 1.3mb from about 5.5mb so i can't quite send it!

 

[Ally]

We only need to see the information relating to that form, so you can delete other info (tables / forms in a copy of the db, not the real one) that's not relevant in order to reduce the size.

Anyway, it doesn't matter - we should be able to crack it without seeing it. I'm just a bit confused and it would have been easier to see it.

As per my other post: Have you got a form yet? Once in your form, you can write code for it to automatically post the date.

Can you post exactly what you have done so far and where you want to go from there.

 

[burton]

i have tried cutting it down to the bare essentials but there is still 1.2mb left of data after zipped.

 

[Ally]

Anyway, it doesn't matter - we should be able to crack it without seeing it. I'm just a bit confused and it would have been easier to see it.

As per my other post: Have you got a form yet? Once in your form, you can write code for it to automatically post the date.

Can you post exactly what you have done so far and where you want to go from there.

 

[burton]

i have just sent it to you

 

[Ally]

Please can you just tell me which form you're trying to do this on? The forms here are the "frmBOOKINGS" which if you click "Bookings" takes you to the "frmBookings (borrowed Items)" which already states which item was borrowed by who and what dates. The only other form is "FrmAll Bookings Past And Present" where the subform doesn't appear. Not sure if it's missing one.

 

[Ally]

Just twigged that it may be in the "frmBookings (borrowed ...", that you want to do it in. If so, then there are a few points to note:

• Booking ID doesn't appear to relate to anything. What is this?
• The surname and forename fields appear to be just text - there's no ID field for entering the name of the borrower. I see these are held in your members table, so you just need to link it with a combo box.
• The same goes for the Items - these are held in your tblItem. You just need to link them first so that the ID is stored for that "booking".

 

[burton]

thanks for helping.
I'm Greatful

 

[Ally]

When you've sorted those things or need anymore info, just post back.

 

[burton]

yeah i was trying to do the thing on "frmBooking"
this is because this is the main booking form so if someone wants to enter some data then hopefully a box would come up to say that that item is currently booked etc.

please could you tell me how to do this.

im not sure what state the database is the one i sent you. have currently updated this one.

 

[burton]

booking ID is a number that is given to each booking. it's just so i can see how many bookings i have had