If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Updatable Calander
Hi All,
I am trying to find a calander to use in a 2007 DB, I have been going through the posts and have tried to open several available samples such as Steve Lebans but I cannot open them in Access 2007, getting error message stating that they are write protected therefore cannot convert. Is there a way around this or is there other samples forAccess 2007. My aim is to have a calander that will display in week or month view and also have the ability to click on an appointment and bring up the "Customers_EditFrm" to change date ,time etc. The reason that I need this function is that I recieve my up coming appointments via a web portal with a tentative appointment date of approx 21 days, once I have recieved the equipment to install for the appointment I can then allocate date and times by making the changes in the "Customers_EditFrm" I also update various other tables and reports. I believe that this could only be done in a form because you cannot put a command button in a report. I was hoping to find an existing sample to modify. Any help is appreciated Bazmac |
#2
|
|||
|
|||
Updatable Calander
Have a look at the Flex Grid Appointment-Bookings Demo at :-
http://www.rogersaccesslibrary.com/f...3b 1d2zcccfb4 You will need to write a fair bit of VBA code to do this and you will probably need to download the Flex Grid Demo program on the same page for more information on using the FlexGrid control. HTH. Peter Hibbs. On Fri, 16 Apr 2010 22:20:01 -0700, Bazmac wrote: Hi All, I am trying to find a calander to use in a 2007 DB, I have been going through the posts and have tried to open several available samples such as Steve Lebans but I cannot open them in Access 2007, getting error message stating that they are write protected therefore cannot convert. Is there a way around this or is there other samples forAccess 2007. My aim is to have a calander that will display in week or month view and also have the ability to click on an appointment and bring up the "Customers_EditFrm" to change date ,time etc. The reason that I need this function is that I recieve my up coming appointments via a web portal with a tentative appointment date of approx 21 days, once I have recieved the equipment to install for the appointment I can then allocate date and times by making the changes in the "Customers_EditFrm" I also update various other tables and reports. I believe that this could only be done in a form because you cannot put a command button in a report. I was hoping to find an existing sample to modify. Any help is appreciated Bazmac |
#3
|
|||
|
|||
Updatable Calander
If they are all coming up as write protected it is likely that you are
trying to open the dbs from the Zip file. You need to extract them from the zip file and then open them with Access. Regards Kevin "Bazmac" wrote in message ... Hi All, I am trying to find a calander to use in a 2007 DB, I have been going through the posts and have tried to open several available samples such as Steve Lebans but I cannot open them in Access 2007, getting error message stating that they are write protected therefore cannot convert. Is there a way around this or is there other samples forAccess 2007. My aim is to have a calander that will display in week or month view and also have the ability to click on an appointment and bring up the "Customers_EditFrm" to change date ,time etc. The reason that I need this function is that I recieve my up coming appointments via a web portal with a tentative appointment date of approx 21 days, once I have recieved the equipment to install for the appointment I can then allocate date and times by making the changes in the "Customers_EditFrm" I also update various other tables and reports. I believe that this could only be done in a form because you cannot put a command button in a report. I was hoping to find an existing sample to modify. Any help is appreciated Bazmac |
#4
|
|||
|
|||
Updatable Calander
Peter & Kevin,
Thanks for your replies. Kevin I followed your suggestion and you were correct. Peter I have decided to use the Flex Grid Appointment-Bookings Demo. Thanking you again, Bazmac "kc-mass" wrote: If they are all coming up as write protected it is likely that you are trying to open the dbs from the Zip file. You need to extract them from the zip file and then open them with Access. Regards Kevin "Bazmac" wrote in message ... Hi All, I am trying to find a calander to use in a 2007 DB, I have been going through the posts and have tried to open several available samples such as Steve Lebans but I cannot open them in Access 2007, getting error message stating that they are write protected therefore cannot convert. Is there a way around this or is there other samples forAccess 2007. My aim is to have a calander that will display in week or month view and also have the ability to click on an appointment and bring up the "Customers_EditFrm" to change date ,time etc. The reason that I need this function is that I recieve my up coming appointments via a web portal with a tentative appointment date of approx 21 days, once I have recieved the equipment to install for the appointment I can then allocate date and times by making the changes in the "Customers_EditFrm" I also update various other tables and reports. I believe that this could only be done in a form because you cannot put a command button in a report. I was hoping to find an existing sample to modify. Any help is appreciated Bazmac . |
Thread Tools | |
Display Modes | |
|
|