Update Field In Ms Access Using Lookup Table?

111 Comments

1. john o says:

   February 17, 2010 at 12:32 am

   As written your question asks to do something that is not normally done. Usually you do not update from the customer file, you leave the data there and just link it in with a query.
   So, upon viewing or printing the data is ‘linked’ in.
   If the customer data changes, the next time you view it or report it the changes will be seen, not the old data that you updated with your combobox question.
   Maybe I’m misunderstanding your question.
   Are you using a Form and you just want text fields populated from the combobox choice? If so, the ‘AfterUpdate’ event on the combo box can requery and poke data into the text fields.
   OK,
   add a textbox
   in the afterupdate event of the combobox put
   Me!textbox = Dlookup(“[columnname_of_customer_table]“…
   “customertable”, “[customernumber] = ‘ & Me!comboboxname & ” ‘ “)
   ( the last six characters are ampersand space doublequote singlequote doublequote closebracket IF customer number is Text and remove both singlequotes IF the customer number is a Number, so the last six characters are changed to one character, just the closebracket
   I think this will show you how one will work, you just need to do the rest.
   Damn, this editor keeps changing the line
   Me!textbox = Dlookup(“[columnname_of_customer_table]“…
   it should end with columnname of customertable closingsquarebracket doublequote comma
2. kbugiell says:

   February 17, 2010 at 1:03 am

   John O is correct. If you have an “Orders” table, linked to “Customers” table, only the “Customers” table needs to contain the customer data – phone, address, name, etc. Those fields should exist in one table only. The only field(s) that should appear in more than one table are the linking field(s), in this case “Customer Number”
   Your form, of course, will display the name,address, etc when the customer number is chosen, but to then copy that data into identical fields of the “Orders” table is not necessary. That kind of table/database design bloats your application and creates opportunities for data mismatch in the future. (What if someone opens the Orders table directly and changes the address? Now it won’t match the address kept in the Customers table – see what I mean?)
3. hadburn says:

   February 18, 2010 at 5:35 pm

   What you do is Share folders. Go to the PC and right click the folder you want to share (I Normally share Drive C: but if you don't have a sequrity key on the router its not recomened. right click on it the click "proerties" then the sharing tab on the display box. click the apporite bothen click ok.
   Now go to the laptop then find My Network Places its usually in the Start menu and could be on the desktop. there you will see a folder lke this "K: on \PC" Where K is the folder and \PC is the name of the pc.
4. segaraboul says:

   February 23, 2010 at 11:01 am

   There are almost 1300 celebs in the fast-lookup directory. Thank you
5. ston says:

   March 2, 2010 at 10:50 pm

   very nice piece… but a lot of materials wasted
6. saunek bert says:

   March 7, 2010 at 10:07 am

   To make a unique conference room statement, and to create a pleasant ambiance, you can ensure that you have a creative décor to grasp the attention of others, especially your clients. Going farther from custom adaptations of boring conference tables, have you ever wondered about a Lego block conference room table? Sounds bizarre?..
   This is a post from Walyou, who bring you the best New Gadgets gadgets, Cool Gadgets and Hi Tech News.
   Lego Conference Room Table
   Related posts:Lego Star Wars Foosball Table Lego Ceramic Set Must Be Handled With Care Lego Bricks Art Made of Lego Bricks
7. ramagazaro baderhambu says:

   March 10, 2010 at 1:16 pm

   I love Sting!! This song gave me so much. Thank you
8. agui says:

   March 13, 2010 at 5:35 am

   I thought by now you knew, that windows 7 is still beta and that you cannot use it as your prime OS. You can install it on a separate partition and use it for testing purposes.
   In August Windows 7 will be deactivated completely.
   As from next year windows 7 is available for official use.
   Sjo you better continue usisng vista or windows as your OS.
9. lori says:

   March 13, 2010 at 12:25 pm

   if you had to know any information about any person you had to have a look for addresses, but with reverse cell phone lookup you just need to understand the person’s cell telephone number and you will have all the information you want. It is that simple!
10. uward sike says:

    March 18, 2010 at 4:27 am

    First color touchscreen smartphone in 2002; first gesture-based smartphone in 2007; first 4G WiMAX smartphone in 2008… HTC have been laying their history out on the table, and it’s all designed to show Apple – and other industry observers – that they’re crowd leaders, not crowd followers. The company’s latest response to Apple’s patent legal threat has been to wheel out its record of innovation. It makes for reasonably impressive reading, too, especially to those people who forget that HTC acted as a whitebox OEM for various carrier partners before deciding to promote their own brand. The title of their statement – “HTC disagrees with Apple’s actions” – may be bordering on the unduly polite, but the underlying message from company CEO Peter Chou is still clear. ”[HTC] will fully defend itself … we will continue to embrace competition through our own innovation.” Don’t expect this battle to be over any time soon. [via Android Community] Press Release: HTC DISAGREES WITH APPLE’S ACTIONS…
11. sado faye says:

    March 19, 2010 at 1:48 am

    #advice pickup lines never work, and if you so happen to get a girl by using a pickup line. I guarantee you she's a basic bitch
12. villi hunnan says:

    March 19, 2010 at 3:12 am

    Way Funny! Easy Everyday Tutorial using only 2 eye shadows
13. patcheill fer says:

    March 25, 2010 at 7:48 am

    http://simulacrum.dorm.duke.edu/tools/javadoc_lookup/
14. freenys says:

    March 30, 2010 at 2:16 pm

    Reverse Phone Directory – Lookup Any Phone Number: We all receive irritating calls from telemarketers who try to
15. mtce says:

    April 2, 2010 at 9:39 pm

    Destroying Educational Institutions Using Them for Military Purposes Is War Crime #Destroying #Educational #Institutions
16. salke gita says:

    April 6, 2010 at 5:34 am

    Update: Stop Sugar Cravings And Lose Weight Naturally.