Welcome to SPN

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

Sign Up Now!

New autofill question

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

  1. Rog

    Rog
    Expand Collapse
    Guest

    I have seen numerous answers tot his question, but each time they suggest
    combo boxes. I cannot use a combo box because there are too many from which
    to select, so let's try again. I need to be able to manually enter drawing
    numbers and have the description of that drawing along with other data
    automatically fill in. The data must go into the table as a new record, not
    just display it. I have a master table with all the information in it. Can't
    I somehow enter the dwg number and upon tabbing from that box have the
    description and other fields auto fill? Thanks.
     
  2. Loading...

    Similar Threads Forum Date
    Question About GGS Questions and Answers Aug 28, 2016
    Marriage And Discrimination Related Questions Blogs Mar 21, 2016
    Sikhi Questioning Faith Sikh Sikhi Sikhism Mar 3, 2016
    Entering into Sikhism: Questions on Reht Maryada. Blogs Oct 22, 2015
    A question about kes/hair? Blogs Oct 21, 2015

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Check this link on how to use the Dlookup function, and implement in on the
    after update event of the text box

    http://www.databasedev.co.uk/dlookup.html

    --
    Good Luck
    BS"D


    "Rog" wrote:

    > I have seen numerous answers tot his question, but each time they suggest
    > combo boxes. I cannot use a combo box because there are too many from which
    > to select, so let's try again. I need to be able to manually enter drawing
    > numbers and have the description of that drawing along with other data
    > automatically fill in. The data must go into the table as a new record, not
    > just display it. I have a master table with all the information in it. Can't
    > I somehow enter the dwg number and upon tabbing from that box have the
    > description and other fields auto fill? Thanks.
     
  4. Rog

    Rog
    Expand Collapse
    Guest

    I tried the solution from the link using DLOOKUP, but it yielded errors. It
    would not recognize the database name for some reason. I followed the
    identical syntax but to no avail. This should not be difficult, but it seems
    there is no easy solution to such a simple sounding problem.

    If you'd like to assist, I'd really appreciate it.
    I have the following:
    A primary table called MASTER DWG LIST with all the fileds required.
    A form called NEW ENTRY which allows the user to enter the drawing number
    from which I need a field called DESCRIPTION filled in.
    The user then will fill in other fields as required.

    Sounds simple. I should be able to extract information from the DESCRIPTION
    field and put it into the new record entry from the ENTRY FORM. How hard can
    that be?

    Thanks so much for any additional assistance!


    "Ofer Cohen" wrote:

    > Check this link on how to use the Dlookup function, and implement in on the
    > after update event of the text box
    >
    > http://www.databasedev.co.uk/dlookup.html
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Rog" wrote:
    >
    > > I have seen numerous answers tot his question, but each time they suggest
    > > combo boxes. I cannot use a combo box because there are too many from which
    > > to select, so let's try again. I need to be able to manually enter drawing
    > > numbers and have the description of that drawing along with other data
    > > automatically fill in. The data must go into the table as a new record, not
    > > just display it. I have a master table with all the information in it. Can't
    > > I somehow enter the dwg number and upon tabbing from that box have the
    > > description and other fields auto fill? Thanks.
     
  5. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    On the After Update event of the Try something like

    Me.DESCRIPTION = DlookUp("DESCRIPTION","[MASTER DWG LIST]","[drawing number
    field name in the table] =" & Me.[drawing number field name in the form])

    =========================================
    If the drawing number is a text field, then add single quote

    Me.DESCRIPTION = DlookUp("DESCRIPTION","[MASTER DWG LIST]","[drawing number
    field name in the table] ='" & Me.[drawing number field name in the form] &
    "'")
    =========================================
    --
    Good Luck
    BS"D


    "Rog" wrote:

    > I tried the solution from the link using DLOOKUP, but it yielded errors. It
    > would not recognize the database name for some reason. I followed the
    > identical syntax but to no avail. This should not be difficult, but it seems
    > there is no easy solution to such a simple sounding problem.
    >
    > If you'd like to assist, I'd really appreciate it.
    > I have the following:
    > A primary table called MASTER DWG LIST with all the fileds required.
    > A form called NEW ENTRY which allows the user to enter the drawing number
    > from which I need a field called DESCRIPTION filled in.
    > The user then will fill in other fields as required.
    >
    > Sounds simple. I should be able to extract information from the DESCRIPTION
    > field and put it into the new record entry from the ENTRY FORM. How hard can
    > that be?
    >
    > Thanks so much for any additional assistance!
    >
    >
    > "Ofer Cohen" wrote:
    >
    > > Check this link on how to use the Dlookup function, and implement in on the
    > > after update event of the text box
    > >
    > > http://www.databasedev.co.uk/dlookup.html
    > >
    > > --
    > > Good Luck
    > > BS"D
    > >
    > >
    > > "Rog" wrote:
    > >
    > > > I have seen numerous answers tot his question, but each time they suggest
    > > > combo boxes. I cannot use a combo box because there are too many from which
    > > > to select, so let's try again. I need to be able to manually enter drawing
    > > > numbers and have the description of that drawing along with other data
    > > > automatically fill in. The data must go into the table as a new record, not
    > > > just display it. I have a master table with all the information in it. Can't
    > > > I somehow enter the dwg number and upon tabbing from that box have the
    > > > description and other fields auto fill? Thanks.
     
  6. Rog

    Rog
    Expand Collapse
    Guest

    You're a lifesaver. Thank you. It appears to work just fine. Regards - Rog

    "Ofer Cohen" wrote:

    > On the After Update event of the Try something like
    >
    > Me.DESCRIPTION = DlookUp("DESCRIPTION","[MASTER DWG LIST]","[drawing number
    > field name in the table] =" & Me.[drawing number field name in the form])
    >
    > =========================================
    > If the drawing number is a text field, then add single quote
    >
    > Me.DESCRIPTION = DlookUp("DESCRIPTION","[MASTER DWG LIST]","[drawing number
    > field name in the table] ='" & Me.[drawing number field name in the form] &
    > "'")
    > =========================================
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Rog" wrote:
    >
    > > I tried the solution from the link using DLOOKUP, but it yielded errors. It
    > > would not recognize the database name for some reason. I followed the
    > > identical syntax but to no avail. This should not be difficult, but it seems
    > > there is no easy solution to such a simple sounding problem.
    > >
    > > If you'd like to assist, I'd really appreciate it.
    > > I have the following:
    > > A primary table called MASTER DWG LIST with all the fileds required.
    > > A form called NEW ENTRY which allows the user to enter the drawing number
    > > from which I need a field called DESCRIPTION filled in.
    > > The user then will fill in other fields as required.
    > >
    > > Sounds simple. I should be able to extract information from the DESCRIPTION
    > > field and put it into the new record entry from the ENTRY FORM. How hard can
    > > that be?
    > >
    > > Thanks so much for any additional assistance!
    > >
    > >
    > > "Ofer Cohen" wrote:
    > >
    > > > Check this link on how to use the Dlookup function, and implement in on the
    > > > after update event of the text box
    > > >
    > > > http://www.databasedev.co.uk/dlookup.html
    > > >
    > > > --
    > > > Good Luck
    > > > BS"D
    > > >
    > > >
    > > > "Rog" wrote:
    > > >
    > > > > I have seen numerous answers tot his question, but each time they suggest
    > > > > combo boxes. I cannot use a combo box because there are too many from which
    > > > > to select, so let's try again. I need to be able to manually enter drawing
    > > > > numbers and have the description of that drawing along with other data
    > > > > automatically fill in. The data must go into the table as a new record, not
    > > > > just display it. I have a master table with all the information in it. Can't
    > > > > I somehow enter the dwg number and upon tabbing from that box have the
    > > > > description and other fields auto fill? Thanks.
     

Share This Page