Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

New User, Set Focus & Coded Requery

Discussion in 'Information Technology' started by Economics, Jul 28, 2006.

  1. Economics

    Economics
    Expand Collapse
    Guest

    I am fairly new to access, so a thorough response would be very much
    appreciated.

    Layout of the database: 1 master table, from which make-able queries were
    run in order to group desired information sets. Reports were built upon
    these "make-table" tables. I have oneform which is sourced to my master
    table. 2 questions.

    1. I would like to be able to re-run the make table queries from a command
    button on my form. The goal is to be able to enter and edit data, then print
    the corresponding updated reports, all from a switchboard. I am not very
    familiar with writing code and do not know which option i should use to build
    my expression. Is there a way to write in code to re-run these queries upon
    closing the form and just scratch the command button altogether? I noticed
    you could build an expression to execute upon closing the form.

    2. I want for focus to remain on a combo box, and do not know which of the
    areas i should enter my experssion into, or how to enter the expression. If
    anyone could give a fairly brief explanation of the code that would be great.
     
  2. Loading...

    Similar Threads Forum Date
    After FIR, Social Media Users Wary of Offensive Jokes on Sardars Information Technology Oct 2, 2013
    USA US govt secretly collecting data on millions of Verizon users: Report Breaking News Jun 6, 2013
    using spiritual name as a username Questions and Answers Aug 23, 2012
    Audience of 3 Million Users Receiving Anti-Sikh Messages Hard Talk Sep 17, 2010
    General How can I change my username ? Hard Talk Sep 4, 2010

  3. Economics

    Economics
    Expand Collapse
    Guest

    I figured out the first part of my message, still need help on the second
    though.

    "Economics" wrote:

    > I am fairly new to access, so a thorough response would be very much
    > appreciated.
    >
    > Layout of the database: 1 master table, from which make-able queries were
    > run in order to group desired information sets. Reports were built upon
    > these "make-table" tables. I have oneform which is sourced to my master
    > table. 2 questions.
    >
    > 1. I would like to be able to re-run the make table queries from a command
    > button on my form. The goal is to be able to enter and edit data, then print
    > the corresponding updated reports, all from a switchboard. I am not very
    > familiar with writing code and do not know which option i should use to build
    > my expression. Is there a way to write in code to re-run these queries upon
    > closing the form and just scratch the command button altogether? I noticed
    > you could build an expression to execute upon closing the form.
    >
    > 2. I want for focus to remain on a combo box, and do not know which of the
    > areas i should enter my experssion into, or how to enter the expression. If
    > anyone could give a fairly brief explanation of the code that would be great.
    >
    >
     
  4. tina

    tina
    Expand Collapse
    Guest

    if you can use a query to pull the appropriate records to dump into a new
    table, why bother with the new table? just use the query as the source for
    your report; it's quicker, cleaner, and reduces database bloat.

    hth


    "Economics" <Economics@discussions.microsoft.com> wrote in message
    news:ECB004BD-8920-48AF-8FC9-05DCFE5D78B0@microsoft.com...
    > I am fairly new to access, so a thorough response would be very much
    > appreciated.
    >
    > Layout of the database: 1 master table, from which make-able queries were
    > run in order to group desired information sets. Reports were built upon
    > these "make-table" tables. I have oneform which is sourced to my master
    > table. 2 questions.
    >
    > 1. I would like to be able to re-run the make table queries from a command
    > button on my form. The goal is to be able to enter and edit data, then

    print
    > the corresponding updated reports, all from a switchboard. I am not very
    > familiar with writing code and do not know which option i should use to

    build
    > my expression. Is there a way to write in code to re-run these queries

    upon
    > closing the form and just scratch the command button altogether? I

    noticed
    > you could build an expression to execute upon closing the form.
    >
    > 2. I want for focus to remain on a combo box, and do not know which of the
    > areas i should enter my experssion into, or how to enter the expression.

    If
    > anyone could give a fairly brief explanation of the code that would be

    great.
    >
    >
     

Share This Page