Search results for query: *

Tried typing the * in place of the 1 when the parameter value prompt comes up but it doesn't work. I can open the form ok. I just ran a query already set up and managed to get all the names in the form but there was an error message #Name? in all the company fields - so it seems its either one...

Just really confused, if I put 1 in it lists the contacts under ' Superdrug ' in the form cos that's the company ID, but none of the other 1500 or so. No error message as such just this Enter Parameter Value, Customer ID ? Where should I be when trying stuff, Form or Table, Design View or...

Hillary, sounds promising, where do I type the asterisk, it's not accepting it in the parameter value box ? Cheers

Yes need to add the data to the form (not enter it), haven't created a relationship I don't think ! can I create a relationship between a Table and Form ? Do you mean the + sign in the Table ? - when I expand the company name in the table the contact names are all there, but it's getting them to...

Urgent query, I need to populate a Form with around 1900 Contact Names under the appropriate Company in a Form already set up. Data is under relevant Company name in a Table datasheet view but is not coming acoss unless I enter a parameter value (the Customer ID) - this only allows the names of...

Urgent query, need to populate a Form with around 1900 Contact Names in a Form already set up under appropriate Company. Data is under relevant Company name in a Table datasheet view but is not coming acoss unless I enter a parameter value (the Customer ID) - this only allows the names of one...

Sorry, I'm not and Access expert and still struggling a bit, I'm in a copy database so hope I can't do any damage. The contact names seem to be coming across but only one entry at a time if you type the Customer ID in the parameter value - is there something I can type in here to ask it to...

Thanks Ken, managed to link some contacts to company name in the form from the table but there's an enter parameter value which keeps popping up prompting me to put in a customer id. On doing this when I put in say 1 the contacts for Superdrug appear but the prompt doesn't go away and I need all...

We are trying to organise existing contact data from various files and formats, mostly Excel and Access, into one Access Database. We have now imported some further data from an Excel Spreadsheet and whilst the individuals associated with a Company now appear to be listed in the ' Customer...