Search results

Namliam Your proceedure causes other problems as I have quite a few if functions in the same form which it seems to interfere with. Mile-O-Phile Thanks this has solved my problem. I always seem to look at the hardest route to my probs and don't think of the easiest. I never thought of...

Bingo! It has worked, however, I didn't realise at the time but my filter by selection icon has dissapeared. Therfore I cannot filter the records anyway. Why is this?

Namliam Morning! Sorry to appear thick! but how do I change the field to Integer? I have looked through the help but cna't find it.

Hi All I'm not too good with VBA so I would appreciate it if somebody could tell me what I am doing wrong with the following: - I have a form with a label called Holidays Available. This is worked out from a label called Holiday Entitlement - Holidays Taken. I want the label Holidays...

Hi All I have a date field called "MyDate" in a subform I have created. I have created a label called Mth next to this field and in it's control source is =[MyDate] and set its format to m so that it dispalys the month. When I try to filter records by month it doesn't work properly as it...

Pat Thanks for your reply. The reason I want all 3 tables linked is because my absence details table also records overtime on a daily basis. Therfore I want to design a report through a query comprising of i.e name from employee table, salary from the salary table and then depending on the...

Mailman Sorry! When I read you explanation I didn't thnk you were being serious and thought you were joking. Sorry!

Mailman I was reading the above seriously until I got to the bottom! Access and relationships drive you insane at times until you think your going nuts! ha! Speak to you soon.

Namliam Thanks for your reply. I didn't think it was the correct way to set up your relationships to have 2 one to many relationships going from one main table to 2 others. This is why I asked the question to be sure I wasn't skipping something. I will see if it causes probs with myqueries...

Hi All I have created a db to log all employee details together with absence details and salary details. Therefore I have 3 tables 1) - Employee Details with a primary key set to Employee ID as AutoNumber 2) - Absence Details with no primary key set. Employee ID set to Number 3) - Salary...

Mile-O-Phile Good to hear from you, thanks for your reply so quick. It's worked a treat. Cheers

Hi All I have a subform which displays all employee names etc and holidays taken. I have an employment yr and current year text box with their formats set as "yyyy" When I try to subtract 1 from the other it comes up with the incorrect figues. Our holiday entitlement is 20 days which we...

Thanks IMO I will change my subform from datasheet. Thanks

Hi Colin I didn't think it would work in the same way which is why I posted you. I can't get it to work with the form with a subform in the same way with the coding so I would appreciate it if you could advise. Cheers

IMO Brill! - It's worked a treat Thanks

IMO Thanks for your reply but it doesn't work. I have added your coding to my detail part of the report and the text box name is called test, therefore my coding reads: - Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.test = "H" Then Me.test.FontBold = True...

Hi All I have a report, based on a query which is run weekly. It shows all the days for that week on the left for that employee and their attendance for each day from 8.30 am through to 5 pm. If that employee if i.e on holiday or sick for that date it displays "H" in the text box or "S" etc...

Rich I didn't realize it was as easy as that! - It's worked o.k Cheers

Mile-O-Phile Its a subform

Mile-O-Phile Thanks for your reply, I have changed my field "Date" to "MyDate" in my form. Also, in my after update part of the properties of "MyDate" I have changed the coding to read [Mth] = Month(Date). However, now when I enter a new record, whatever date I enter changes all other...