 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / February 2008Combo Box with multiple selection in text boxes
All masters, I know this is very basic question. I have searched alot but couldn't get what I need. I have a table with the following info: HolidayTable: - ID - Date - Purpose of Holiday - Type I have another table named Overtime where I want to keep the employee overtime records in details. One employee might work overtime on 5 different holidays in a month and different hours in a holiday. OvertimeTable: - ID - EmployeePIN - Date - Purpose of Holiday - Type - Hours Worked I want to creat a form where I have a combo box selecting ID or EmployeePIN and then I should have 5 more text boxes which preview the data based on the selection of the combo box. My combo box should retriev data from HolidayTable. there should be more than one combo box for different holidays and hours worked as overtime. At the end I want to update the same information I have selected from a combo box and the rest data displayed by text boxes should be updated into overtime table for my later use. I need to have a detailed information of which date an employee worked and how many hours. Is there any one to post me back on this regard. I appreciate your cooperation in advance. Thanks, Daoud Fakhry It's not clear why you would need/want more than one combo box for the Holiday table information? I would think that you'd want to see/edit/review the data for just one Holiday at a time? Otherwise, the form will become unwieldy if you're trying to view multiple records of data and edit/view them at the same time? Or perhaps you could just use a continuous forms view for the form, and see all the Holiday records for the chosen employee at one time? Then you can edit/review the separate data because each record will contain one holiday's information.  SignatureKen Snell <MS ACCESS MVP> > All masters, > I know this is very basic question. I have searched alot but couldn't get [quoted text clipped - 38 lines] > > Thanks, Daoud Fakhry Dear Ken, The reason that I want to have more than one combo box is that most of the time it happens that one employee works 5 different holidays in a month. Please hele me on how to proceed to have the following job done. Thanks. > It's not clear why you would need/want more than one combo box for the > Holiday table information? I would think that you'd want to see/edit/review [quoted text clipped - 49 lines] > > > > Thanks, Daoud Fakhry >Dear Ken, >The reason that I want to have more than one combo box is that most of the >time it happens that one employee works 5 different holidays in a month. >Please hele me on how to proceed to have the following job done. Thanks. Daoud, are you storing information about each holiday (or each day worked) in a differernt *FIELD* in your table? If so, that's the problem! You should have a different *RECORD* instead. How are your tables structured? SignatureJohn W. Vinson [MVP] Hi John, If you see my first treat, it shows all the details of my tables. I am storing each holiday in a different record not in a field. I have one table named HolidaySchedule (see the fields in my original treat) which is stored the holidays during a month or a year. then I have a nother table named overtime (see my original treat for details) which I need to store employees holidays worked during a month or year. an employee might work more than one day (one holiday during a month, so I want to use a combo box in a from to retrieve the data from Holiday Schedule, so when I pick a holiday from a combo box, the rest columns of the Holiday schedule should show up in the text boxes which I have in the form to show the (purpose of holiday, type and other fields). After I should be able to store the information my overtime table. Any help in this regard is much appreciated. Thanks - D > >Dear Ken, > >The reason that I want to have more than one combo box is that most of the [quoted text clipped - 4 lines] > a differernt *FIELD* in your table? If so, that's the problem! You should have > a different *RECORD* instead. How are your tables structured? >Hi John, >If you see my first treat, it shows all the details of my tables. I am [quoted text clipped - 10 lines] >holiday, type and other fields). After I should be able to store the >information my overtime table. Daoud, I use Agent to connect to the newsgroups. I read about 150 or 200 posts a day, and answer quite a few of them. You're not the only person posting here, by far. It's rather rude of you to suggest that I should bring up Google Groups and search through the archives to find your previous post. Since you do presumably have that information available, would you please repost it? SignatureJohn W. Vinson [MVP] Hello John, I am sorry requesting you to find my original post, I aplogize for that. Below you can find original post. All masters, I know this is very basic question. I have searched alot but couldn't get what I need. I have a table with the following info: HolidayTable: - ID - Date - Purpose of Holiday - Type I have another table named Overtime where I want to keep the employee overtime records in details. One employee might work overtime on 5 different holidays in a month and different hours in a holiday. OvertimeTable: - ID - EmployeePIN - Date - Purpose of Holiday - Type - Hours Worked I want to creat a form where I have a combo box selecting ID or EmployeePIN and then I should have 5 more text boxes which preview the data based on the selection of the combo box. My combo box should retriev data from HolidayTable. there should be more than one combo box for different holidays and hours worked as overtime. At the end I want to update the same information I have selected from a combo box and the rest data displayed by text boxes should be updated into overtime table for my later use. I need to have a detailed information of which date an employee worked and how many hours. thanks John, > >Hi John, > >If you see my first treat, it shows all the details of my tables. I am [quoted text clipped - 20 lines] > Since you do presumably have that information available, would you please > repost it? > At the end I want to update the same >information I have selected from a combo box and the rest data displayed by >text boxes Displayed in textboxes is easy. You can put textboxes on the form with control sources like =cboHolidays.Column(n) where cboHolidays is the name of the combo box control, and n is the zero based index of the field you wish to display. > should be updated into overtime table for my later use. Ummmm... No. The Purpose of the Holiday is an attribute of the holiday table. It is not an attribute of an overtime work! All you need to store in the Overtime table is the HolidayID or in fact just the date of the holiday. You can easily create a Query joining the overtime table to the Holidays table to pick up the other information about the holiday. Could you explain why you feel it necessary to copy data into the overtime table which would be redundant there, and which could easily be looked up? SignatureJohn W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.