Search results

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

Apologies guys. Many thanks of all useful responses. Basically I was trying to see if there was a quick MS Access Query solution. But since there isn't I have used VBA to first loop round for all employees and within that loop round for dates between DateStart and DateEnd for each of the record...

OK but what about the difference between the Start Date and the End Date?There is obviously range of dates between

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