Search results

I am chasing a quick solution to what I am sure is a simple thing. In my database I have a table of items that have to be held for different periods of time (one item type kept for 5 years, another for 3 etc). In another table, linked to the first through the item type, I have dates entered...

I've been experimenting with queries to return data on a weekly basis, using datepart and :First Full Week". I now have results that show data entered on 1st to 4th Jan 04 as week 53, then following on to week 1. What I was wondering is, what happens when I get to the end of the year and end...

Ken Same thing, the records progress through the main form, but the tabbed part jumps to the last tabbed form/subform as well.

In the database I have created, I have a main form which contains some employee information. I also have, under this part, a tabbed form(s) that contains other information from the main table on several tabs, and some subforms on others. I have also created some of my own navigation buttons, to...

Thanks Gizmo The relationship between the two tables is a many-to-many (don't know if that is the cause of the problem). Reason for that is that each employee must maintain these 3 skills as current (taken from the date skill obtained/refreshed), and I would like to keep a record of each time...

In the form I have created, I have a combo from where I select an employee. Once this is selected, the subform in the form should show the list of training, and the dates the employee completed each. (The training list is only 3 records long and is the same for each employee, just the dates are...

This is probably quite simple, but I cannot seem to get a grasp of it. I have a form set up with two tabs on it. The first tabbed form lists all the employees in the database and is set as a continuous form. I have a select button for each employee in the list that I want to be able to click on...

Thanks guys, worked it out using your suggestions. Regards :D

I have a subform which is a continuous form. Each record contains 3 fields. In one of the fields, I have conditional formatting which changes the back colour of that field if the date in the field is within 30 days of the current date, and again to another colour if the date in the field has...

Len I don't know how I did it, but I managed to stumble over the answer and it works fine now. Thanks very much for your assistance. If you know anything about conditional formating, I could use some help with that. I have formatted a field in a record (out of the above lot) so that if the...

Sorry Len, I still get the same results (i.e. all records). Maybe I am missing something?

Len Thanks for your reply. I am progressing with help from your suggestion. I have found though that some employees have multiple listings against individual skills. I want the subform just to list the latest date against each individual skill for each employee. Hence, for each employee, there...

I have looked at similar problems on this forum, but cannot make sense from any of it, so am looking for a simple solution that even I can follow. In my database, I have a form which shows an employees details, including their Employee Number, name etc. In this form I want to put a subform...

In the database I am trying to put together, I have a series of records containing information on accountable records. I am trying to create, from these, a form showing the handing over of these records to another person. This form, as well as containing details about who is handing over the...

Gee thanks Milo, expected a little help, and get comments like that...

I am creating a database and am totally up against a brick wall. Would some kind soul be good enough to have a look at what I am trying to do and give me some help. I would rather forward entire DB to an individual and explain the situation as I think it is quite complex. It involves queries...

Nam No, the employees form is not still open.

In my database I have a form (frmHandover) which is bound to a table. This form has text box fields including a field for EmployeeNo. I also have an unbound text box on this form into which I want to have the employees name etc added, depending on what is in the employeeNo field. The employee...

Yes please!

I am putting together a database to record staff performance appraisals. I am a little stumped as to the best way to go about setting the following part up, and was wondering if someone could give me some ideas. I have a main table which records each employees details. I also have a table that...