Recent content by moodhi

Yeh, I agree, I think you have got it. This was previously designed in Excel where the grid is full of colours with various conditional formatting. For example "The course is due in next days", "Over Due", "In Date" etc so the field when I mentioned Course Date is NOT Date/Time its simply Text...

So for example if there are a total of 28 Employees and they have to attend some or a number of 30 Courses. So a Grid of 28 rows times 30 columns is required to show: Row Heading: EmpID, EmpName Column heading: CousreA, CousreB, CourseC, CourseD.....up 30 courses. i.e. 28 x 30 Grid. Each cell...

Apologies but an Employee can have a maximum of 4 roles e.g. 1 employee having up to 4 roles, hence 1 to many? So what I have so far is: (1) tabEmployees (EmpID, EmpName, .........all other fields) (2) tabRoles (EmpID, RoleID, DateStart, DateEnd, ......all other fields) Any way my query is...

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...

Thanks Guys

Yes, you are right it works perfect in fact really great. I am honestly very grateful and thankful to this great help and the App, it worked absolutely as I needed. The difference was in the Report Form - the code with hashes around the date did not work for me. I changed them to Format...

Example (Gantt Chart sample database) in post 6 is exactly what I am after and its how my tables are structured BUT the example does not seem to be working!!! Its not showing all the range in the chart. I am really confused and can't find what can be wrong with the Crosstab query. Any Idea?

I think I am stuck because my Absence table is designed as: EmployeeNo, EventID, DateStart, DateEnd......etc. Where even though I am looping through all records trying to spread them into basket of daily storage but it is becoming painful to deal with a situation where a date range falls...

Yes but the dates in tAbsence are a range i.e. DateStart to DateEnd. So if the outer join is on DateStart and DateEnd then what about the dates in between?

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...

Apologies again guys. As I am using linked tables to the BackEnd database, for some reason one of my table did not have the primary key, adding back the primary key its now working. Many thanks.

OK, I followed the demo and it makes sense, however my form's record source was the table itself but now when I have added the textbox to overlay combo box I need to bind the textbox to the Role Name for which I changed my form's record source to a query which contain the Role Name (text). It...

Sorry, I failed to mention that the the combo box RowSource = ID, RoleName e.g. 1 Role Name 01 2 Role Name 02 3 Role Name 03 So the database field values are: 1 2 3 The next time as I said the combo box RowSource = ID, Role Name i.e. 1 Role Name 01 3 Role Name 03 If I...

Apologies but the bound field contains the ID and the actual text is displayed form the combo box so I am not sure how will that work? Also how will that work? does that mean to set combo box visible to false? then how will the user select an item from the combo box? I am sorry I am a little...

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...