Search results for query: *

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

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...

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 ?

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

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...

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...

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...

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...

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...

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...

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...