Welcome to SPN

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

Sign Up Now!

autocomplete? autofill?

Discussion in 'Information Technology' started by kozamel@hotmail.com, Jul 28, 2006.

  1. kozamel@hotmail.com

    kozamel@hotmail.com
    Expand Collapse
    Guest

    I'm not sure of the correct nomenclature here...but...

    I have a form that fills a table. :)

    Each form/query exists by job, B5050, for example.

    It is redundant to ask the user to enter the job # each time in the
    form...how can I get it to automatically enter "job" (B5050) whenever a new
    record is created in the form?

    I don't necessarily even want the user to have to ask "it" to do it...I want
    the user to open the B5050 form, update their data, add any new records and
    have Access automatically ID "Job" in the table/query.

    I hope I am making sense. Let me know if I need to clarify.

    Thank you for any help!!
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Is Autocomplete Evil? Some Women Take A Hard Look at Google ! Breaking News Nov 7, 2013

  3. schasteen

    schasteen
    Expand Collapse
    Guest

    It sounds like you have a form for every job, do you have a table for every
    job also? Sound like a lot of work to maintain and update. Why don't you
    create a form with a combo box and allow the user to select the job and open
    the form filtered to the selection made? To just strictly answer your
    question, set the Defalut value for the text box under the data tab on the
    properties window to the job number for the form, but this is not your best
    solution.

    "kozamel@hotmail.com" wrote:

    > I'm not sure of the correct nomenclature here...but...
    >
    > I have a form that fills a table. :)
    >
    > Each form/query exists by job, B5050, for example.
    >
    > It is redundant to ask the user to enter the job # each time in the
    > form...how can I get it to automatically enter "job" (B5050) whenever a new
    > record is created in the form?
    >
    > I don't necessarily even want the user to have to ask "it" to do it...I want
    > the user to open the B5050 form, update their data, add any new records and
    > have Access automatically ID "Job" in the table/query.
    >
    > I hope I am making sense. Let me know if I need to clarify.
    >
    > Thank you for any help!!
     
  4. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    Please explain "form/query exists by job, B5050, for example". How does the
    user specify to open the form for job B5050? Or, do you use one form, but
    just open it for a specific job; if so, how does the user specify to open
    the form for the specific job B5050.

    Is your form, as I infer from your talking about more than one record, in
    continuous forms view?

    Is the form bound to a query that is specific for the job?

    Larry Linson
    Microsoft Access MVP


    "kozamel@hotmail.com" <kozamelhotmailcom@discussions.microsoft.com> wrote in
    message news:A904CCBA-DA64-47FA-BCD8-AE24A447FCEB@microsoft.com...
    > I'm not sure of the correct nomenclature here...but...
    >
    > I have a form that fills a table. :)
    >
    > Each form/query exists by job, B5050, for example.
    >
    > It is redundant to ask the user to enter the job # each time in the
    > form...how can I get it to automatically enter "job" (B5050) whenever a
    > new
    > record is created in the form?
    >
    > I don't necessarily even want the user to have to ask "it" to do it...I
    > want
    > the user to open the B5050 form, update their data, add any new records
    > and
    > have Access automatically ID "Job" in the table/query.
    >
    > I hope I am making sense. Let me know if I need to clarify.
    >
    > Thank you for any help!!
     
  5. kozamel@hotmail.com

    kozamel@hotmail.com
    Expand Collapse
    Guest

    Thanks for your help! I am an EXTREMELY new Access user...

    Let me see if I can explain a little better...

    I have 1 Table called ProjectList - Every Project is listed here. The
    Fields are job, deadline, etc.

    I have a query for each job (this was the best way I could figure to get the
    form to work...) that updates the table.

    I have a form for each query that modifies the query, that updates the Table.

    Table - ProjectList
    Query - B4030
    From - B4030

    The Form for B4030 allows the user to update various field - some with combo
    boxes, most just typed in info.

    What happens is when the user adds a new record in the form view, since I
    have no "job" input cell (?), the new record has no "home". I have to go to
    the table and input the JOB. There has to be a way to ask Access to
    automatically do this.

    If you guys can help me come up with a better format - I am ALL ears. This
    was the best way I could manipulate the info for my purposes with my limited
    understanding.

    Thanks!

    "Larry Linson" wrote:

    > Please explain "form/query exists by job, B5050, for example". How does the
    > user specify to open the form for job B5050? Or, do you use one form, but
    > just open it for a specific job; if so, how does the user specify to open
    > the form for the specific job B5050.
    >
    > Is your form, as I infer from your talking about more than one record, in
    > continuous forms view?
    >
    > Is the form bound to a query that is specific for the job?
    >
    > Larry Linson
    > Microsoft Access MVP
    >
    >
    > "kozamel@hotmail.com" <kozamelhotmailcom@discussions.microsoft.com> wrote in
    > message news:A904CCBA-DA64-47FA-BCD8-AE24A447FCEB@microsoft.com...
    > > I'm not sure of the correct nomenclature here...but...
    > >
    > > I have a form that fills a table. :)
    > >
    > > Each form/query exists by job, B5050, for example.
    > >
    > > It is redundant to ask the user to enter the job # each time in the
    > > form...how can I get it to automatically enter "job" (B5050) whenever a
    > > new
    > > record is created in the form?
    > >
    > > I don't necessarily even want the user to have to ask "it" to do it...I
    > > want
    > > the user to open the B5050 form, update their data, add any new records
    > > and
    > > have Access automatically ID "Job" in the table/query.
    > >
    > > I hope I am making sense. Let me know if I need to clarify.
    > >
    > > Thank you for any help!!

    >
    >
    >
     
  6. kozamel@hotmail.com

    kozamel@hotmail.com
    Expand Collapse
    Guest

    Larry - I think that yes - my form is bound to a specific query by job.

    I feel like an idiot..but what do you mean by "continuous forms view" ?

    "Larry Linson" wrote:

    > Please explain "form/query exists by job, B5050, for example". How does the
    > user specify to open the form for job B5050? Or, do you use one form, but
    > just open it for a specific job; if so, how does the user specify to open
    > the form for the specific job B5050.
    >
    > Is your form, as I infer from your talking about more than one record, in
    > continuous forms view?
    >
    > Is the form bound to a query that is specific for the job?
    >
    > Larry Linson
    > Microsoft Access MVP
    >
    >
    > "kozamel@hotmail.com" <kozamelhotmailcom@discussions.microsoft.com> wrote in
    > message news:A904CCBA-DA64-47FA-BCD8-AE24A447FCEB@microsoft.com...
    > > I'm not sure of the correct nomenclature here...but...
    > >
    > > I have a form that fills a table. :)
    > >
    > > Each form/query exists by job, B5050, for example.
    > >
    > > It is redundant to ask the user to enter the job # each time in the
    > > form...how can I get it to automatically enter "job" (B5050) whenever a
    > > new
    > > record is created in the form?
    > >
    > > I don't necessarily even want the user to have to ask "it" to do it...I
    > > want
    > > the user to open the B5050 form, update their data, add any new records
    > > and
    > > have Access automatically ID "Job" in the table/query.
    > >
    > > I hope I am making sense. Let me know if I need to clarify.
    > >
    > > Thank you for any help!!

    >
    >
    >
     
  7. schasteen

    schasteen
    Expand Collapse
    Guest

    A continuos form shows many records on the screen at once while a single form
    shows just one record at a time. This can be found on the format tab of the
    forms properties. One easy way is to create a startup form where your user
    selects the job number from a combo box. You then open your form filtered to
    just that job number. You can then hide the start up form and have the job
    number control set with the hiden forms combo box as the default value. Then
    when your form closes, unhide the startup form so your user can select
    another job or close the form.

    "kozamel@hotmail.com" wrote:

    > Larry - I think that yes - my form is bound to a specific query by job.
    >
    > I feel like an idiot..but what do you mean by "continuous forms view" ?
    >
    > "Larry Linson" wrote:
    >
    > > Please explain "form/query exists by job, B5050, for example". How does the
    > > user specify to open the form for job B5050? Or, do you use one form, but
    > > just open it for a specific job; if so, how does the user specify to open
    > > the form for the specific job B5050.
    > >
    > > Is your form, as I infer from your talking about more than one record, in
    > > continuous forms view?
    > >
    > > Is the form bound to a query that is specific for the job?
    > >
    > > Larry Linson
    > > Microsoft Access MVP
    > >
    > >
    > > "kozamel@hotmail.com" <kozamelhotmailcom@discussions.microsoft.com> wrote in
    > > message news:A904CCBA-DA64-47FA-BCD8-AE24A447FCEB@microsoft.com...
    > > > I'm not sure of the correct nomenclature here...but...
    > > >
    > > > I have a form that fills a table. :)
    > > >
    > > > Each form/query exists by job, B5050, for example.
    > > >
    > > > It is redundant to ask the user to enter the job # each time in the
    > > > form...how can I get it to automatically enter "job" (B5050) whenever a
    > > > new
    > > > record is created in the form?
    > > >
    > > > I don't necessarily even want the user to have to ask "it" to do it...I
    > > > want
    > > > the user to open the B5050 form, update their data, add any new records
    > > > and
    > > > have Access automatically ID "Job" in the table/query.
    > > >
    > > > I hope I am making sense. Let me know if I need to clarify.
    > > >
    > > > Thank you for any help!!

    > >
    > >
    > >
     
  8. kozamel@hotmail.com

    kozamel@hotmail.com
    Expand Collapse
    Guest

    right now the user enters into a single form.

    Create a start up form? Can I use HELP to do that? Can you tell I am
    absolutely lost? How do I use a combo box without creating a whole new table?

    "schasteen" wrote:

    > A continuos form shows many records on the screen at once while a single form
    > shows just one record at a time. This can be found on the format tab of the
    > forms properties. One easy way is to create a startup form where your user
    > selects the job number from a combo box. You then open your form filtered to
    > just that job number. You can then hide the start up form and have the job
    > number control set with the hiden forms combo box as the default value. Then
    > when your form closes, unhide the startup form so your user can select
    > another job or close the form.
    >
    > "kozamel@hotmail.com" wrote:
    >
    > > Larry - I think that yes - my form is bound to a specific query by job.
    > >
    > > I feel like an idiot..but what do you mean by "continuous forms view" ?
    > >
    > > "Larry Linson" wrote:
    > >
    > > > Please explain "form/query exists by job, B5050, for example". How does the
    > > > user specify to open the form for job B5050? Or, do you use one form, but
    > > > just open it for a specific job; if so, how does the user specify to open
    > > > the form for the specific job B5050.
    > > >
    > > > Is your form, as I infer from your talking about more than one record, in
    > > > continuous forms view?
    > > >
    > > > Is the form bound to a query that is specific for the job?
    > > >
    > > > Larry Linson
    > > > Microsoft Access MVP
    > > >
    > > >
    > > > "kozamel@hotmail.com" <kozamelhotmailcom@discussions.microsoft.com> wrote in
    > > > message news:A904CCBA-DA64-47FA-BCD8-AE24A447FCEB@microsoft.com...
    > > > > I'm not sure of the correct nomenclature here...but...
    > > > >
    > > > > I have a form that fills a table. :)
    > > > >
    > > > > Each form/query exists by job, B5050, for example.
    > > > >
    > > > > It is redundant to ask the user to enter the job # each time in the
    > > > > form...how can I get it to automatically enter "job" (B5050) whenever a
    > > > > new
    > > > > record is created in the form?
    > > > >
    > > > > I don't necessarily even want the user to have to ask "it" to do it...I
    > > > > want
    > > > > the user to open the B5050 form, update their data, add any new records
    > > > > and
    > > > > have Access automatically ID "Job" in the table/query.
    > > > >
    > > > > I hope I am making sense. Let me know if I need to clarify.
    > > > >
    > > > > Thank you for any help!!
    > > >
    > > >
    > > >
     
  9. schasteen

    schasteen
    Expand Collapse
    Guest

    If you create a form in design view, the add a combo box from the tool bar
    menu. Then double click the combo box to get the properties. In the row
    source area of the data tab you can add
    Select distict JobNumber from YourTable

    Then add a button and ih the on click event add
    Docmd.openform "YourFormName",,,"[JobName] = '" & Me![Combo1]

    Then use just on of the forms and set its record source to the table.

    You can use the help menus to get a lot of information on how to do this,
    and there are wizards that can also help.

    "kozamel@hotmail.com" wrote:

    > right now the user enters into a single form.
    >
    > Create a start up form? Can I use HELP to do that? Can you tell I am
    > absolutely lost? How do I use a combo box without creating a whole new table?
    >
    > "schasteen" wrote:
    >
    > > A continuos form shows many records on the screen at once while a single form
    > > shows just one record at a time. This can be found on the format tab of the
    > > forms properties. One easy way is to create a startup form where your user
    > > selects the job number from a combo box. You then open your form filtered to
    > > just that job number. You can then hide the start up form and have the job
    > > number control set with the hiden forms combo box as the default value. Then
    > > when your form closes, unhide the startup form so your user can select
    > > another job or close the form.
    > >
    > > "kozamel@hotmail.com" wrote:
    > >
    > > > Larry - I think that yes - my form is bound to a specific query by job.
    > > >
    > > > I feel like an idiot..but what do you mean by "continuous forms view" ?
    > > >
    > > > "Larry Linson" wrote:
    > > >
    > > > > Please explain "form/query exists by job, B5050, for example". How does the
    > > > > user specify to open the form for job B5050? Or, do you use one form, but
    > > > > just open it for a specific job; if so, how does the user specify to open
    > > > > the form for the specific job B5050.
    > > > >
    > > > > Is your form, as I infer from your talking about more than one record, in
    > > > > continuous forms view?
    > > > >
    > > > > Is the form bound to a query that is specific for the job?
    > > > >
    > > > > Larry Linson
    > > > > Microsoft Access MVP
    > > > >
    > > > >
    > > > > "kozamel@hotmail.com" <kozamelhotmailcom@discussions.microsoft.com> wrote in
    > > > > message news:A904CCBA-DA64-47FA-BCD8-AE24A447FCEB@microsoft.com...
    > > > > > I'm not sure of the correct nomenclature here...but...
    > > > > >
    > > > > > I have a form that fills a table. :)
    > > > > >
    > > > > > Each form/query exists by job, B5050, for example.
    > > > > >
    > > > > > It is redundant to ask the user to enter the job # each time in the
    > > > > > form...how can I get it to automatically enter "job" (B5050) whenever a
    > > > > > new
    > > > > > record is created in the form?
    > > > > >
    > > > > > I don't necessarily even want the user to have to ask "it" to do it...I
    > > > > > want
    > > > > > the user to open the B5050 form, update their data, add any new records
    > > > > > and
    > > > > > have Access automatically ID "Job" in the table/query.
    > > > > >
    > > > > > I hope I am making sense. Let me know if I need to clarify.
    > > > > >
    > > > > > Thank you for any help!!
    > > > >
    > > > >
    > > > >
     

Share This Page