Search results

R6Flyer I now have entered your code into my on current event of my form. When I open the form the message box appears for every record on any employment date. Any idea what the problem could be? Regards Sharon

Hi All I have now managed to create 2 combo box's to filter data in my report. The first combo box (FilterOptionsYear) is to choose the year and has 3 options to choose from in its row source which are 2003, 2004 & 2005. The second combo box (FilterOptionsMonth) is to choose the month which...

R6Flyer Thanks for your suggestion I have just had a similar thought but not for the weekend. I was thinking if I was off sick or on holiday or something and the form does not get opened. I think I will have to add something extra to the code for these reasons. However in the mean time I...

Thanks Mile-O-Phile It's worked a treat. :)

Mile-o-Phile Thanks for your reply. However, I have entered your code into the On Current Event properties of my form, changed your part of code Me.txtDateStarted to Me.EmploymentDate but I can't get the message box to appear. For one of our employees I have entered a date of 12.02.94 then...

Morning Mile-O-Phile You havn't by any chance had time to look at the above have you?

Can anybody help at all with the above - I am still struggling? :(

Hi All I have a form which logs all our employees holidays/sick ect. This is ran from a query. In this form I have a date field called MyDate & MyYear which is calculated from MyDate in my query. Is it possible to create a filter on my form by using combo box's rather than option groups? I...

Mile-O-Phile Thanks for your reply. However, I forgot to mention that I wanted the message box to appear, lets say 1 month prior to the 10 or 15 year period. Is this possible. Sorry to mess you around:(

Hi All I have a form showing various employee information. One of the fields is employment date for when the employee started. I want a message box to be displayed to remind me when any of our employees have served 10 years, 15 years, 20 years & so on from their employment date, when the form...

Wayne I have now tried both of your codes in myAfterupdate event of my Salary field. When I enter new salary details into my subform in my tab control on my main form for that employee, after I have entered the new salary figure the message box appears stating this is a new employee etc. and...

Wayne Thanks for your reply. Quick question, my salary histoy is entered in a seperate table which has a one-to-many relationship with my main table. This is joined through EmployeeID. So in my main form I have Employee name etc in the header, then in the details part I have tab controls...

Hi All I have a form with a subform created through a tab control. The subform displays salary information for that employee from when their employment started. This subform has six fields which are Employee ID, Date From, Date To, Salary, Position & Department. I want to be able to create a...

dcx693 Result! at long last - I knew that there must have been something either not typed correct or something missing in the coding. And there was - I had End if missed and also a bracket missing. It now works a treat Many thanks for your help.

dcx693 Thanks for your reply. I have looked at the above and I don't have an AfterUpdate option in my Command8 button's properties. Do you mean to put this coding in the Option Group Properties? I have now tried to enter the coding in the AfterUpdate part in my option group properties...

dcx693 I have been really struggling attaching the file but here goes again

dcx693 Thanks V much for your reply. I think the buttons on the same screen which you suggested would be the best idea. However, I am not too familiar with the coding. I have used macro's for what I have done so far. Is it not possible to add this in the macro? If not where do I put the...

Hi All I have a form called FrmPrintReports. This has an option group which lists all my reports. I then have a command button called PrintPreview which runs the report depending on which option button is highlighted. I have created another form called FrmEmployeeID. This comprises of just...

Hi Colin Long time no speak. Good to hear from you. My form is bound to a query, however it has still worked using the wizard. Thanks - I didn't realise it was that simple. Sharon :)

Hi All I have created a form and numerous subforms ran from queries. Basically In the Form Header I have Employee ID, Surname & Christian Name. In the details part I have created subforms in tab controls. Rather than using my Navigation Buttons to go to each employee, is it possible for my...