Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Chippie

    addinf combo box to input box

    Thankyou, but i was hoping to just run an input box from a macro. Is it possible to do it without a form ?
  2. Chippie

    addinf combo box to input box

    Is it possible to add a combo box to an input box ? I want to display a list of current tables in a db, and allow the user to select one for which a query will be applied. Currently I have a simple input box, from which the user enters the table name. A combo box would be an excellent...
  3. Chippie

    linking combo boxes in table

    Does anyone know how to link a combo box in a table to display only values relevent to a previously selected value in a combo box ?
  4. Chippie

    Adding values calculates on a form to Table

    Does anyone know how to add data to a field in a table from a form. I guess I'll hae to use VB...
  5. Chippie

    Deleting similar Dups

    Sawatzky, I read your email but many of the ship/bill addresses have the same place, therefore making it impossible to apply the key field trick. Bummer. Ummm, I tried your code, thankyou again, but without the primary keys it added the bill info - great, but when adding the ship info, it...
  6. Chippie

    Deleting similar Dups

    Thanks to Sawatzky I now have a table with records in which contain either 2 options BILL and SHIP selected (tick) or one option SHIP selected. Unfortunately the Items which have SHIP and BILL have been duplicated also with only SHIP selected. Therefore I need to know how to delete the records...
  7. Chippie

    Merging Tables

    Excellent, thankyou very much. I tried on some trial data before I step into the big golliath. The only thin I wondered is how do I create 2 primary keys in access. The customer name, and street can be used many times in my table, and are therefore not able to be primary keys. Trying your...
  8. Chippie

    Merging Tables

    Sawatzky, Customer is just one huge table. I have multiple entries of records with the only difference being that in one particular field the value can either be SHIP or BILL. I blame the rubbish legacy system the data was ripped from. Anyway, not all Customer SHIP and BILL, some just SHIP...
  9. Chippie

    Merging Tables

    I have a table called Customer. In it there are similar records with one value Ship/Bill set to either Ship or Bill. This is obviously duplicating many entries in my DB. All the data is in one table, how do I join it so that I have 2 extra fields Ship and Bill with a tick box in. If one...
  10. Chippie

    Populating a combo Box from a field

    Where do I actually put this. I have entered the code, but I get a prompt asking me for Forms!Customer!Country.Value All I want to do is rip it from the screen, and place the country code in a SQL query. Also if I do enter the code in the prompt it doesn't update the box on each record...
  11. Chippie

    Populating a combo Box from a field

    I am trying to populate a combo box (Region/County) using an entered field (country). I have to use the country field in the WHERE clause to obtain the correct results set from the SQL query. I know I need to rip the data from the form, and have tried using VBa as so...

Part and Inventory Search

Back
Top