Search results

Hi there, I need some advice on database design/structure. I have about 30 Employees (employees can be added or Deleted etc). Each employee can have a number of Roles (job type) e.g. Manager, Deputy Manager, Senior day, Carer day etc up to 15 The employees are supposed to attend a combination...

OK I have a table to record all employee absence (Events) e.g. Annual Leave, Sickness, Maternity Leave, .... etc. which are in a table with EventID and EventName. The table which records the above has: EmployeeNo, EventID, DateStart, DateEnd......etc. Now I need to produce a daily calendar...

I have a datasheet form with combo box containing roles for employees e.g. Role Name 01 Role Name 02 Role Name 03 Therefore, Combox RowSource = "Role Name 01, Role Name 02, Role Name 03" form table which has ID, RoleNames. The combo box is bound to the database table. The user creates 3...

I have a table to record sickness i.e. DateStart and DateEnd. I need to report total sickness recorded for an employee for each of the weekday in the year. Mon Tue Wed Thu Fri Sat Sun 2 1 3 0 4 0 5 How can I generate SQL for the above?

I have a simple test form with one text box, READ and UPDATE buttons. User1 reads data using Recordset into the text field, changes data, so in the text box KeyPress event I set the Recordset.Edit, clicks the UPDATE button which updates the Recordset.Update. All done... BTW the database is split...

Hi there, I have a legacy application developed in Access version of Office 2010. Which uses ListView control in many forms. When I originally transferred the app from earlier version to Office 2010 I needed to un-regiter MSCOMCTL.OCX and replaced it with the earlier version and all worked...