Search results

Hi there, I know this is an older Post, but I have the Problem and can't solve it! I have tried the Attachment Field, but it does not Display in my Form. Ideally I would like to save a Bitmap in an Ole field in a table (I have only one in the databse.. the Logo) that I would like to be able...

Thanks so much for the reply... unfortunately still not working.. I have done a Little Workaround Set ExternKinder = db.OpenRecordset("SELECT * from tbl_ExterneGeschwister where tblxx_familie_id=" & Familie!ID) If ExternKinder.RecordCount > 0 Then ExternKinder.MoveFirst Else...

Thanks for the answer Paul... It doesn't select the records.. says it Needs another Parameter, but I can't figure out which one!

Hi All, I Need some help with the Syntax of a "relatively" simple Statement... I just cannot get it to work! I have a table with Family_Name and Birthdate and tblxx_Familie_ID: I am trying to create a recordset that selects all records that belong to a certaim Family and where the Person is...

Thanks so much! I am still working on it! Have had a few days holiday. Marion

Thank you for the reply. However, I would prefer no answer than a sarcastic one. It is quite intimidating for mere mortals like myself. If the question irritates you, then don't answer it. Marion

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