Search results

Here you go Sean. Thanks for pointing me in the right direction. Alastair.

Sean many thanks for your input thus far. I've attached what I've done so far. If you could have a looksie, that'd be great. What do you think of my relationship structure - am I on the right track??? AliG

Several things are in my favour (and this is my last post on the subject of; benefits or non for implementing organizational change). 1) My boss is an autocrat 2) My job is to change the HSE culture with the implementation of a system 3) I have complete autonomy in the development of a...

There are many things that are not Proceduralized here, i.e; written down, and, have just been handed on verbally from employee to employee. And, you are right, there are a lot of pre-established written procedures. What does not exist is a complete list of tasks on site and the associated...

Ok Sean. What I want is this: Look up employee. Say it's a galvanizing dept employee. Have they had module Galv01? What modules have they had, I want to record that against the employee - do I need some sort of tick box?? Also, however, I want to be able to record procedures for...

Here tis. This is access 2007 btw.

Beetle. This is my first trial attempt at One-to many. Can you have a look? I'm not sure im getting the right filter on employees/training modules. What have I not done? Cheers.

Just one more thing So, the junction table would be where I pulled the query from, if, say, I wanted to see what training Joe Bloggs had had? Or, if I wanted to see who had been trained on the Setting Procedures for Die # 105698 in Press No1? Regards D

cool Many thanks for your insightful reply. I'll read your notes and do some research on Junction tables for Many-Many relationships. I wont ask any more daft questions till I've done so. :)

I'm not quite sure where to post this question. I have a table that records: Department Tasks Procedures for each task Associated Tooling (this is a lookup) Associated hazards I want to be able to Assign tasks to employee, pick out that task and print the related proceddures...

My report (query based) produces several copies. A couple of the fields the query looks up are multiple value fields (look up fields too). So, the more values you chose in that field, the more copies of the report is produced. How can I stop this from happening??

Yes. There are two look up fields in the table. However, the parameter query is not run on one of these.

I have a query built on a table (really!). No seriously, Project Tracking is the query on which the report is built. I want to have the report based on project name. So, I have the field - Project. And, the parameter is [Enter Project Name]. It won't return any results. Yet, if I...

My form, which is linked to my employee's table wont show all the records. I know this is a basic thing. I've checked that it's not set to data entry in properties. I don't know what else to do. the record source maybe? However, It was a tabbed form (cause it contains quite a lot of...

Thank you Paul. So, following on from that, Ideally, It would be really cool to be able to: Open Investigation Register from Accident Register, having that function create a new record automatically linked - what I mean is: I've opened a new accident. It is record 115(access assigned ID)...

I have used Access to build our Health and Safety system data base. (I'm reasonably new to access BTW. All my data is in tables. All my reports are based on queries. I have three forms. Accident Register (linked to a table), Investigation Register (also with it's own table) and Hazard...

I'm not sure whether to set up a report with the fields I want or to hve the record selected on a form. The other thing is that there are more than one code loaded against an employee - the codes equal task descriptions and there may be 8 or nine of them. Perhaps a report that gives me...

Hi everyone. I'm the HSE & HR Manager of an engineering company. I've built a data base with tables, forms and a modal dialogue as a switch. All works swimmingly. I've made tables for: Job Tasks, which includes corresponding codes Employees/Positions Training I want to generate...

this is the code. what should it be? Private Sub objOutlookFrame_Click()

How do I fix????