Booking form in access

[goweb]

A mate of mine has asked me if I can build him a taxi booking form in access. I only have limited knowledge of access but I am willing to swot and build it slowly. Basically what he wants is a booking in form with details of the booking plus a booking sheet that will show all booked jobs in time order. Once the job has been despatched for it to disappear off the screen. This screen to be automatically updated once a booking has been taken.

On the booking sheet if possible when typing in the address a drop down box appears with all available variations ie typing in fir will show all available combinations eg firtree firwell etc but typing in firt will only show firtree plus any other cominations of firt

Thirdly can a clock be added showing current time? Not essential this as I know a workround that will add it to the title bar but it would be nice to have this in program if possible.

Can all this be done just with access or will an element of visual basic need to be added?

Thanks

John

 

[theprez]

Yes, all of this can be done with Access with some VP. The is a command called "Like" that does what you were asking with the fir. You will use the wild card character "*" where address like FiR*. The only thing is you will have some learning to do. My suggestion is spend your time in setting up your table structure. This will save you time in the end. Also, there is an event that you can run that will display the current time. You can have the timer run in different intervals i.e. display current time every second. Good luck.

 

[goweb]

Thanks for that. I will look into it further

John