Results 1 to 2 of 2

Thread: Access datasheet and setting focus to a column/field programatically

  1. Jun 19th, 2007, 12:05 PM #1
    DaveBo
    DaveBo is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2001
    Location
    N42 29.340 W71 53.215
    Posts
    422

    Question Access datasheet and setting focus to a column/field programatically

    I have a datasheet subform on an Access form, unfortunately, it's got more than 100 fields/columns so I had to cheat a bit to make it, i.e. the "wizard" couldn't handle it (some wizard!).

    I have to find & display problem data in the subform and since it's so wide I'd like to be able to programatically (in VBA) make the target column visible,
    i.e. so the user doesn't have to scroll sideways looking for the right column name.

    Since the user is QAing the data it all needs to be there.

    I've tried a variety of .SetFocus methods on the form, and recordset, but to no avail.

    Any ideas?
    Thanks, DaveBo
    "The wise man doesn't know all the answers, but he knows where to find them."
    VBForums is one place, but for the really important stuff ... here's a clue 1Tim3:15
    Reply With Quote Reply With Quote
  2. Jun 21st, 2007, 09:17 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Access datasheet and setting focus to a column/field programatically

    Didn't think you could. But if you find a way please post up

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width