Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Dec 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to call a function (Access 2000)

    I have copied a function FlipEnabled, but i do not
    know how to call it. After writing FlipEnabled i must write
    something else. What it should be ?


    Public Function FlipEnabled(frmAny As Form, ctlAny As Control)
    Dim ctl As Control
    'Loop through the Controls collection using the For..Each Construct
    ctlAny.Enabled = True
    ctlAny.SetFocus
    For Each ctl In frmAny.Controls
    'Evaluate the type of the control
    If ctl.ControlType = acCommandButton Then
    'Make sure that we don

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: how to call a function (Access 2000)

    This is a strange question. You must have some purpose with this function. Where do you want to use the function, and for what purpose? That will determine how is is to be used.

  3. #3
    Lounger
    Join Date
    Dec 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to call a function (Access 2000)

    Thank you for your reply. You asked me what is the prupose of my function. This function is copied by me from another person.
    I have i form for offers..Sometimes the customer has decliend the offer, and in this case we want to preserve its data, but to make the
    controls in the form disabled, in order not to change them. I am sure you must be right and i have the wrong function and then i will forget it.
    Actually all the controls in the form must be disabled if the customer is not actual. Being not actual is made by
    Me![ turneddown] = True.
    I wanted to have a function that is valid for all forms, but in fact i could allso use a private module

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: how to call a function (Access 2000)

    Do you have a command button to make a customer not actual, or does the user clear a check box, or is there another way to make a customer not actual?

  5. #5
    Lounger
    Join Date
    Dec 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to call a function (Access 2000)

    Thank you.Yeas, i have a command button and your question has led me see the way to make it.
    Thank you very much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •