Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unhappy Unanswered: Run Time Control

    HI,

    Is there any way I can create control run time? I am trying to create check box but run time after the query execute?

    Any help will be highly appreciated.
    mr_roomi

  2. #2
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    how many check boxes in question?
    ghozy.

  3. #3
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Check boxes

    It depends on query, it can't be more than 50 and these check boxes are in detail section of form.

    Thanks for prompt reply.
    mr_roomi

  4. #4
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unhappy idea

    I am kinda stuck on this problem, any idea about this problem?
    mr_roomi

  5. #5
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    if you want to create a checkbox for every record that query returns, you could just create a dummy Yes/No Field in the table and you could show it next to records?
    ghozy.

  6. #6
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unhappy Yes/No Field

    I tried that too. But as i am using Summry Query behind form, I can't update it. Thats why i trying to create control on run time to modify it on fly.
    mr_roomi

  7. #7
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    sorry I checked many references and couldn't find any example how to add controls on runtime to Forms in a VBA project. though there are ways to do it in VB, but can't find anything for VBA.
    ghozy.

  8. #8
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unhappy Vba

    Hi Ghozy,

    Its nice of you searching for my problem. I am trying too but couldn't find any thing yet. If u find any thing, near time soon, please let me know at mr_roomi@hotmail.com.

    Thanks again,
    mr_roomi

  9. #9
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    I will, If I come accross with any info.
    ghozy.

  10. #10
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    what about using a listbox control with multiselect option for your query instead checkboxes?
    ghozy.

  11. #11
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unhappy listbox

    It is detail form with more than 50 records at a time. so user needs to select or deselect each record separatly. Thats why I am looking for check box in detail portion of form.
    mr_roomi

  12. #12
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    what I see from your query type, it is a read only query. you could show whole query in a listbox and allow user to make multiple selections. then process selected records accordingly. thats is the only solution comes to my mind.
    ghozy.

  13. #13
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    yes

    Hi Ghozy,

    Yes, u r right, it is a read only query and unfortunately I'm asked to developed a summerized form. So this is way I am looking solution.

    Thanks,
    mr_roomi

  14. #14
    Join Date
    Nov 2003
    Posts
    1,487
    Quote Originally Posted by Mr_roomi
    It is detail form with more than 50 records at a time. so user needs to select or deselect each record separatly. Thats why I am looking for check box in detail portion of form.
    This looks like a prime example as to why Microsoft applied the Record Selectors Property to Access (for those of you who can't figure out why it's there).

    Perhaps you can utilize this feature to accomplish your task.


  15. #15
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Record Selector

    Hi CyberLynx,

    What would do Record Selector in my problem. Can u expain a lil bit more?

    Thanks,
    mr_roomi

Posting Permissions

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