wedd
01-08-2012, 08:48 AM
Hi experts,
I've created a form where new customers can be added, deleted and textbox where the user enters a customer number to search for a customer. I would like a feature on my form history of a customer's bookings can be displayed; as well as a list of bookings done on specific dates searched for; as well as the particular activities done on those dates either based on a customer's first name and surname or customerID ...I'm not sure the best way how to display this information automatically to the user who overlooks the bookings and history of activities and bookings done on different specific dates. Can this be done? If so, how can this be done? I am a beginner/intermediate vba programmer...so if you know of any websites, or you have similar experience handling a similar task...your advise will be valuable in how you was able to do this and what code you did to display automatically a customer's transaction history and general booking activities done a specific dates and times on maybe automatic sub forms or tables displaying the data automatically based on search conditions. This subform or table should be updatable depending on activities done by the customer or customers' activity. The sub form will record all the history of activities, times, dates of the customer's transactions based on their ID number...also the search will allow the user to search the different stores where different activities have taking place on different dates and times.
Thanks for your contributions:friends:
I've created a form where new customers can be added, deleted and textbox where the user enters a customer number to search for a customer. I would like a feature on my form history of a customer's bookings can be displayed; as well as a list of bookings done on specific dates searched for; as well as the particular activities done on those dates either based on a customer's first name and surname or customerID ...I'm not sure the best way how to display this information automatically to the user who overlooks the bookings and history of activities and bookings done on different specific dates. Can this be done? If so, how can this be done? I am a beginner/intermediate vba programmer...so if you know of any websites, or you have similar experience handling a similar task...your advise will be valuable in how you was able to do this and what code you did to display automatically a customer's transaction history and general booking activities done a specific dates and times on maybe automatic sub forms or tables displaying the data automatically based on search conditions. This subform or table should be updatable depending on activities done by the customer or customers' activity. The sub form will record all the history of activities, times, dates of the customer's transactions based on their ID number...also the search will allow the user to search the different stores where different activities have taking place on different dates and times.
Thanks for your contributions:friends: