Search results

Thanks, been there done that! Still can't get it to work. If I read the documentation, I understand that if the selection is changed it should trigger an event procedure, but it doesn't. As I said I have put message boxes in the event procedure to check, but they event procedure is not called at...

Hi there, Can anyone tell me when the Form Property "selectionchange" kicks in? I am trying to use this to run an event procedure. I have a sub form datasheet which contains a date, and when the selection is changed from one record to another in the sub form, I would like to run an event...

Hi Chris and thank you so much for the reply! I really like the week view! Because I really like to understand what's happening I will take a bit of time to try and decipher the code. I have opted for an "easy way out" for a quick fix and have inserted 48 unbound fields representing half an hour...

Thank you so very much for the time and trouble you have taken! It's such a good feeling to know that there are people like you out there! I will spend the whole afternoon trying to put into practice what you have explained and will let you know how I get on! Marion

Hi there! Thanks, but it doesn't work... but this does! For I = ops!WorkshopTue * 2 + 1 To 48 Me.Controls(CStr("Txt" & I)).BackColor = 11111 Next I Thanks

Hi all, I hope I can explain this properly! I have a form with 48 unbound text fields name txt1 to txt48. These are to represent 24 hrs in half hours, to visually represent the hours capacity of my workshop. Now if I choose a date, which is say Monday, I check my settings, and see that the...

Thanks so much for the reply. Seems to work fine! Marion

Hi all, Hope someone can help me out here. New ground for me! I have a small application for booking cars into a Garage. Tbl_Bookings: Date in: 6.8.2013 Brief: Full Service Approx. time: 4 hrs Next car : 6.8.2013 Brief : Brake pads Approx. time: 2 hrs. Workshop capacity on any day -16 hrs...

Hi all, Would appreciate a bit of help if possible: I have a form which contains 2 Sub forms. When a record is clicked in the one Sub form (datasheet) the corresponding records are shown in the other Sub forms.(also a datasheet) What I Need: When a record in the first Sub form is deleted by...

Perfect! Thanks I didn't realize you could write more than one condition in. Thanks again... you just saved me hours! M

Hi All, I have a form in datasheet with the fields "Date In" and "Date out" among other. I want to be able to Change the backcolour of the "Date In" to red, yellow, or green depending on the length of time elapsed between current date and date in. This works fine on the conditional formatting...

Thanks so much and thanks to Pat as well!

Hi All, I know this question has been asked before, but my search doesn't give me what I need. Hope someone can help. I am trying to calculate the age on the day the report is printed in Years and months ( and display it thus) in a report. e.g. 6 years 4 months. Thanks for any help M

wow thats wonderful! Thank you so much! Marion

Hi again! I really would appreciate some help on this: I have a form where I enter a date:- Then I have an option group called day/week/month/quarter/year now I need to filter the subform to display all children who turn 2 on this date if day is chosen who turn 2 in this week if week is...

Thanks a million guys!

Hi all, Again I need a little help from my friends! Can someone tell me how I can copy just one field from the previous record into the next record? On the keyboard (German) this can be done by ctrl-hash. I want to put a procedure on double click that will copy the field from the previous...

I think I do need to store the working week (39 hrs) as I later need to subtract hrs. worked from this. I also need to split this time into 2 sections (actual work time and preparation time) and subtract worked hrs. from this to get a weekly overtime or - time report. Getting more and more...

Hi there, So in the table the field must be a numeric (double) field? So I store 39 or 19,50 etc. and just display it on the form as 19:30 in an unbound form?

OK sorry - I didn't explain that very well, did I! I want to enter 100 in the Appointment (%) is not part of the field name - just put it there for clarity:). Then the Appointment_Hrs should calculate 39:00. If I enter 75 then 75% of 39 Hrs etc. My problem is that I need to be specific in the...