Search results

Great advice, thanks a lot. Regards Eddie

Hi All, I’m using values provided by a query in a parent form to provide captions in a sub form. I’ve placed in the on load event of the sub form Me.lblday1.caption = me.parent.day1 Me.lblday2.caption = me.parent.day2 Me.lblday3.caption = me.parent.day3 Me.lblday4.caption = me.parent.day4 ………...

Hi Paul, Many thanks for the advice, Its the first time i've heard about conditional formatting, it really is useful. kind regards Eddie

Changing field colour Hi All, Is there any way of changing the colour of a field on a continuous sub form? I’ve tried If me![myfield] = 0 then Me![myfield].forecolor = 255 End if On the load, open and current event of the sub form, but all it succeeds in doing is (if the first field is = to...

Hi Rich, I have tried it on the On Current event using [EmpName] the name of my control and all it succeeded in doing was to slow down the opening of the form, It had no effect on the the parent form's caption. Regards Eddie

I agree it would be ideal to use datasheet view, however I want to control the field captions at run time, so I have to use continuous form. I've tried using: Me.Parent.Caption = Me.txtDescrip in the on Open, On Load, on Current and on got focus events and nothing happens, I've even tried to...

Hi Rich, I cannot make the fields any smaller and the sub form caption isn't shown when its part of a main form, is there anything else I can try? Regards Eddie

Hi All, I think that I’m probably wasting everyone’s time with this request but on the off chance that it can be done here goes. I have a particularly wide sub form that you need to use the horizontal scroll bars to see the fields on the right hand side. This unfortunately takes off screen the...

Hi All, I have a form that “frmSelect that I want to use a query to control its text box labels. I’ve tried putting the following into the load event of the form: Private Sub Form_Load() Dim db As Database, rs As Recordset Set db = CurrentDb() Set rs =...

Hi Mile-O-Phile, Many thanks for that, its working great. Regards Eddie

Hi Mile-O-Phile, What I actualy want to do is replace the name field is in a report with one that shows the name as initials. I beleived that the easiest way of achieving this is to split the name into its component Parts Name1;Name2;Name3;Name4, and then I can glue them together as a single...

Hi Mile-O-Phile, I’ve now got a module that has three functions: CountSpaces AssignName GetPart I have placed in my query the following “Field1: AssignName(CountSpaces([AssDet]),1)” and when I run the query I get the following error message: “A delimiter must be a single character.” and this...

Hi Mile-O-Phile, I've run the query as requested without the error trap and it stops on: GetPart = Mid(strTemp, intPos + 1, InStr(intPos + 1, strTemp, strDelim) - (intPos + 1)) Is this of any help? Regards Eddie

Hi Mile-O-Phile, I've loaded the Function and it works perfectly selecting the first word in the list, but when I ask it to call the second word in the list and there isn’t one it Error # 5 “Invalid Procedure Call or Argument”. The words I want to pick out are all separated by a space and I’m...

Is there a way of selecting words from a text field e.g. [NameField] contains the following text “John Paul Simon Smith” I would like to return the following: Firstword returns “John” Midword1 returns “Paul” Midword2 returns “Simon” Lastword Returns “Smith” Can anyone help with this problem...

Hi Col, Thanks for your help I've now got it up and running. Regards Eddie

Hi All, I want to calculate a date which, is exactly 1 year previous to a user-entered date. Eg 20/04/03 entered then I want 20/04/02 calculated. I've tried using: [fldPastDate] = [fldCurrentDate] - 365 But this does not always bring up the same date for the previous year, occasionally its1...

Hi Dave, Many thanks for that fix, it makes life such a lot easier. Regards Eddie:D

Hi Dave, Many thanks for the advice; I've certainly learnt something today. I never realised that you could customise the form icons. It was actually the application icon that I was concerned about, but thanks to your advice I can now add a new dimension to the customised look of my...

Hi Andy, Your a hero, everything is working perfectly, many thanks. Regards Eddie