Hi Les: That sure does sound more like something simpler that I could incorporate into my existing DB. The "marker column" sounds perfect. I'm not even concerned about the GUI as I am using a "drop down" box to display available slips for boat size and if I could eliminate "rented slips" from that drop down box it would be PERFECT.
You don't per chance have a sample DB using the marker column around do you ...:-). I'm wondering if I should put the column in a separate table or as part of the rental table or slip table. ALSO, How is the column formated. 365 columns/rows? Thanks Les....ANY help is very much appreciated. =Dave R.= If you own a Hotel, A B&B, An Inn or a Full service Resort YOU'RE LOSING MONEY DAILY.......START GETTING IT BACK. We can do it for you. Visit us at: http://marketing.dynalias.com:81/reservations -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of CGServics USA, Yahoo Users Groups Sent: Wednesday, July 05, 2006 8:12 PM To: [email protected] Subject: RE: [ms_access] Reservation Database A method that I used with success in the past for something similar - you will need a dedicated column to accept a 'marker' in a timeline table. When the slip is rented, the expected start and expected finish dates are entered. The dedicated column is automatically populated based upon the current date being between the expected start and expected end dates or cleared if outside those dates. You will need to allow duplicate entries for the slip numbers, but the slip number is definitely your key field. The GUI can then be setup several ways - display only slips without the marker at a particular date, display marked dates for a timeline or calendar for each slip, etc. The marker allows for easier programming rather than constantly look for the current or selected date being or not being within the specified date range.... Have fun, whatever you do! Les _____ From: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com] On Behalf Of DRR Sent: Wednesday, July 05, 2006 6:14 PM To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com Subject: RE: [ms_access] Reservation Database Hi Dawn: YOUCH, He's GOOD....Guess I've got my work cut out for me. (Hopefully not a complete re-write of what I already have but I like his style :-). Thanks =Dave R.= If you own a Hotel, A B&B, An Inn or a Full service Resort YOU'RE LOSING MONEY DAILY.......START GETTING IT BACK. We can do it for you. Visit us at: http://marketing. <http://marketing. <http://marketing.dynalias.com:81/reservations> dynalias.com:81/reservations> dynalias.com:81/reservations -----Original Message----- From: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com] On Behalf Of Dawn Crosier Sent: Wednesday, July 05, 2006 5:30 PM To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com Subject: RE: [ms_access] Reservation Database Check out MotelBooking compliments of AD Tejpal, if I remember correctly, it will help you find available Motel Rooms, which you should be able to translate into Dock Slips. http://www.rogersac <http://www.rogersac <http://www.rogersac <http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.> cesslibrary.com/OtherLibraries.asp#Tejpal,A.D.> cesslibrary.com/OtherLibraries.asp#Tejpal,A.D.> cesslibrary.com/OtherLibraries.asp#Tejpal,A.D. Dawn Crosier "Education Lasts a Lifetime" This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. -----Original Message----- From: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com] On Behalf Of DRR Sent: Wednesday, July 05, 2006 4:05 PM To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com Subject: [ms_access] Reservation Database Importance: High Hi All: Hopefully someone can point me in the best direction. I am charged with the task of writing a boat dock reservation DB in Access. I am "fairly" familiar with Access so most of the DB is already written and working. ie: A guest table & form, A dock table & form (containing the arrival date, departure date, slip#, boat size & ref to guest table etc.) and a "slip table" containing the slip# and max boat size it handles. My delema is finding available slips that have not already been rented. (or eliminating rented slips whichever is easiest). It sounds like it should be simple but is driving me to drink. It's really a small setup but a large headache. It's only 8 slips, I have a table with the guest's info, a table with the rental info and forms for both. I "think" I need a query that once the desired dates for a rental is entered, looks at the table with all the previous rental info and find an open slip for those dates for that size boat. Does anyone know of an existing DB for rental that I can use as an example and maybe use the logic from it? I imagine ANY form of rental DB could contain the info I need. Like a motel, car rental etc. or MAYBE, someone can just make a suggestion as to how I can perform this? ANY HELP WOULD BE GREATLY APPRECIATED. When I said I was "fairly" comfortable with Access, I mean I can and have written several Access DB's BUT, I know little of VB. I use mainly the wizard and have seldomly used coding. So any suggestions must be simple PLEASE. Maybe a query suggestion....Thanks AGAIN in advance for any help. =Dave R.= If you own a Hotel, A B&B, An Inn or a Full service Resort YOU'RE LOSING MONEY DAILY.......START GETTING IT BACK. We can do it for you. Visit us at: http://marketing. <http://marketing. <http://marketing. <http://marketing.dynalias.com:81/reservations> dynalias.com:81/reservations> dynalias.com:81/reservations> dynalias.com:81/reservations [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
