Recent content by chris_elevate

  1. C

    A database for our Church

    Hi, We're a church based in the south of England and we've grown from 35 to 80 members within 4 months (not bad going). We're looking to setup the admin side of the church and be able to create mailings lists etc. I've now installed something 9 scripts on website to give them a go and the...
  2. C

    Working out totals on a form

    It doesn't work on mine though.... I've used: =[Tbl_CustomerHireListsubform].[Form]![txtHiddenSum] Is this not correct?
  3. C

    Freezing the fields on a form

    Ok. Thanks Bob majorly appreciate this! If you could add me to msn I'd really appreciate it chris_elevate@hotmail.com http://www.kingofhosting.co.uk/database/hire_3.1.zip for the database. I've created you an ftp account so you can upload it back up again. I'll give you the password on...
  4. C

    Working out totals on a form

    Sorry Bob it still makes no sense. Just taken a look at that and I still don't know what to change this to: =[Tbl_CustomerHireListsubform].Form![txtHiddenSum]
  5. C

    Freezing the fields on a form

    Ok this is what I'm getting (see attachment) It's when I load the form.... press the lock button to let me edit some details and then press it again to lock it.
  6. C

    Working out totals on a form

    Ok.... I think I get you. So you don't refer to it as the form name but rather the CONTROL name? So how do I fond out the control name of the subform? Thanks
  7. C

    Working out totals on a form

    Thanks Mike I've used this on the main form: =[Tbl_CustomerHireListsubform]![txtHiddenSum] And it still isnt working??!!!! - Puzzled!!??
  8. C

    Freezing the fields on a form

    Any idea why this isnt working?
  9. C

    Working out totals on a form

    Anyone got any idea why this isnt working?
  10. C

    Freezing the fields on a form

    I now have this on the click event of my button but it produces and error: Private Sub lockfields_Click() If Me.Dirty Then Me.Dirty = False Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "LOCK_ME" Then ctl.Locked = False End If Next ctl End Sub How can...
  11. C

    Freezing the fields on a form

    Thanks. That works but it doens't seem to lock the cells again after it has been clicked for a second time. Is there a way to use the button like a toggle switch? Bob is there any chance you could take a look at my other post. I've got the sum function working but I can't get it to work on...
  12. C

    Freezing the fields on a form

    Fantastic!!! I've done all that!! How do I now toggle the locked cells on and off? Do I create a button with an event? etc? Thanks
  13. C

    Freezing the fields on a form

    A couple of things: 1. Where abouts do I put LOCK_ME ? How do I do this? 2. How do I get to the forms ON CURRENT event? 3. This code need to put in the VB like this: Private Sub lockfields_Click() Dim ctl As Control If Not Me.NewRecord Then For Each ctl in Me.Controls If ctl.Tag =...
  14. C

    Freezing the fields on a form

    Thanks guys, I've tried using Simplycongy's way of doing it and I can't get it to work. This is the code I've got on the even proceedure of my button: Private Sub lockfields_Click() For Each myControl In Me.Controls If myControl.Tag = "LOCK_ME" Then myControl.Locked = True End If...
  15. C

    Working out totals on a form

    Thanks. Ok my sub form is correctly calculating the value. I've made it visable so I can test it. I'm not managing to put the result on the main form though. My sub form is called: Tbl_CustomerHireListsubform And the main form is called: Frm_Hire And I've used a text box called txtTotal...
See more
Top Bottom