Search results

After getting this far in Excel, see post here: http://www.access-programmers.co.uk/forums/showthread.php?t=178846 I now have Key Item 1010 1 1010 5 1010 7 1010 9 and also another worksheet with: Key(for Access) Key(store) 12 1010 13 1010 14...

Hmmm....can't get it to work. I think I found the run-time problem, I changed N1 to C1, stopped the error but it has now put column B from the original sheet in both column A and B of the new sheet and disregards column A from the original sheet(the most important bit!) It is also only working...

Thanks Brian, Access is the final destination of the list but without me actually knowing what to do with it there it would be pointless for me to try. Thanks for the code Holger - I hope I don't sound like an idiot when I ask; which bits do I need to change to make it work? I've changed the...

Maybe if I try and show an example of what I mean: I now have Key Item 1010 1 1010 5 1010 7 1010 9 and also another spreadsheet with: (this worksheet can be transferred so all in one file if needed) Key(for Access) Key(store) 12 1010 13 1010...

Thanks HaHoBe. That worked relatively easily. Now have a new similar problem to solve. The keys in Column A have general keys saved in a different workbook. Some of the keys in Column A have more than 1 key in the other workbook(basically the keys are stores and the numbers I have just sorted...

Thanks muchly, will give it a try.

Bear with me if I'm not making sense, I will try to explain. I have a spreadsheet with a list of keys and a list of item keys. I need to create a new entry for each item key that belongs to a key(confused yet?) I will try to write an example rather than uploading an example but can upload if...

No, as I said, I'm doing the Switchboard via the Switchboard Manager. I'm guessing the only way is going to be to do a Switchboard via VBA instead? Which is a pain. :(

Currently, I have an 'Exit' button on my Switchboard which should 'Exit Application' (as per choices given in Switchboard Manager). But when I click the button it just exits the DB I am working on and takes me back to the Access start page (with the templates etc on). Is there something I need...

Thanks David. The tutorials I'm looking at are really confusing - any idea which would be the best 'plain english' tutorial to help me do this?

As the title says. I have not yet split my database, do I need to do this before I create the passwords? Sorry if this is a completely obvious and easy thing to do!

Thanks all, I'm think I'm going to leave it for this week now. I have a lovely day off tomorrow. :D Thanks again for your help, might be bugging you again on Monday!

Thanks Scooterbug, When you say 'create a join' do you mean create a relationship? If so, which bits join to where? Sorry if I sound like a complete idiot... :o

I know how to write a query. What I don't get it how to do this one. I want my end user to choose a brand by name, and then choose whether they want to see just HQs or all and also a county or country(these will all be chosen via combo boxes on a custom parameter form). So how would my query...

These bits: And then how do I create the query to pick out the stores based on brands sold as well as other criteria such as country, category etc.

TBH I don't 100% understand what you were saying - I think I need an plain english explanation rather than someone doing my DB for me as I still don't understand what you've done with it. So I give each store several entries showing which brands they stock - the brands are numbered....BUT, how...

The key is there as a Primary Key as it is the only thing will be different on each entry(The keys relate to the entries in tblMain) - the number on it's own denotes whether it is a branch or HQ, i.e 103 0 is the HQ 103 1 is a branch belonging to that HQ, 0 is always the HQ but that's irrelevant...

There you go, I told you I'm doing it wrong!! tblMain_Brands is tracking which customers buy which brand. Customers are the Key and Brands are the brands...the customer data is kept in tblMain.

Wonderful! Thankyou!

But would this not omit all of the entry rather than just the Country name? I'll explain; when I print out address labels I don't need it to put 'England', 'Scotland' or 'Wales' at the end but I do need it to have 'Ireland', 'USA', 'France' etc. But the country information for all countries is...