Hi all.
Need a bit of assistance with a data base I am putting together to help my wife in work.
She works for a reputable high street shop that does hearing aids, but they havent given her any software to keep a trsack of all her clients and their orders. In steps me.
Have got the basics down, but need a bit of help with the fancy twiddly bits as am fairly new to Access. Heres the bits I need help with
1. Need to enter the date of the appointment. Easy this one. Have a data entry field to enter manually, but want a pop-up calender. Have tried fighting with the calender in access, but it there permanently. How do i make it pop-up and get the data into the relevant field?
2. Depending on the type of appointment, a lot of the filds are redundant. I need to add a condition where if the returned value is one thing, a new record will appear.
3. There are other times when the above at 2 are needed but, if i can do it once, can adapt for the other situations.
Thanks for reading this far, and thanks for any helop that anyone gives.
Paul
Need a bit of assistance with a data base I am putting together to help my wife in work.
She works for a reputable high street shop that does hearing aids, but they havent given her any software to keep a trsack of all her clients and their orders. In steps me.
Have got the basics down, but need a bit of help with the fancy twiddly bits as am fairly new to Access. Heres the bits I need help with
1. Need to enter the date of the appointment. Easy this one. Have a data entry field to enter manually, but want a pop-up calender. Have tried fighting with the calender in access, but it there permanently. How do i make it pop-up and get the data into the relevant field?
2. Depending on the type of appointment, a lot of the filds are redundant. I need to add a condition where if the returned value is one thing, a new record will appear.
3. There are other times when the above at 2 are needed but, if i can do it once, can adapt for the other situations.
Thanks for reading this far, and thanks for any helop that anyone gives.
Paul
