new database for acc

[over101]

Hi im am creating new database for accommodation
Now i need help.
Ive got 4 tables each with forms booking accommodation, flights, car rental
in my booking ive got these in my forms.
I want for example when i select accommodation in booking and select
example germany from this date up till ex 15 nov 2008 and submit.So
next time i book something in accommodation germany will not be availible up
till 15 nov.How can i set up a system like this?

 

[rsmonkey]

search the sample databases and take a look at the calendars in their, im sure you'l probably be able to find a booking system in thier aswell. Then you can assign specific accommodations to specific days, thus with some coding you can create a form which you can filter out location, dates etc.. and see the available bookings.

how proficient with VBA are you?

 

[over101]

Vba

I dnt know vba at all!

 

[over101]

sample

Does anyone have a sample database?please

 

[Rabbie]

Does anyone have a sample database?please

Try looking in the Sample DB section of these forums

 

[over101]

!!

already looked no luck.

 

[over101]

Isnt there somewhere else ?

 

[Rabbie]

Try doing a Google search

 

[over101]

what do you know about access?

 

[Rabbie]

what do you know about access?

I don't like bragging but I have been using Access for 10 years and generally get things working to requirements quickly.

 

[over101]

you have some good knowledge of access!

 

[over101]

You understand the system i want to set up?