Search results for query: *

Oh, wow - THANK YOU SOOO MUCH! This is going to be VERY helpful! - Karen :)

I like that approach, MajP. It may be a little tricky to set up the synchronized forms, but I know where to come if I hit a snag. :) THANK YOU! - Karen

Thanks, John - I like that setup, and it makes sense to do that. I am having a very faded flashback memory of having an application where I have used SELECT DISTINCT in the past (for some reason, I don't typically have that kind of thing come up), and after you said what it is for, I remember it...

Ah, Ginger, thanks for pointing that out! I had scrolled up a little too fast and scrolled right past the ID tag on the post to see that someone else had joined our party! So sorry, MajP! Thank you for the help! I'm still scratching my head a bit over my duplicate address issues mentioned in the...

I'll look up that one too. [g] - Karen

I didn't know about that option, MazeWorx. I will read up on it. Thanks so much! - Karen

Hi, John - Thanks for the quick response! This is very helpful to ponder, except for the little kink that, if I'm understanding your setup correctly, I think I am going to still end up with two separate entries of an identical address in those scenarios where an individual has one address that...

Here I am again, working with the same database referenced in my "design strategy" post, with another design dilemma. FYI, I have not created any tables for this database - it is still in the "drawing on paper" stages. I am creating a mailing list that will be used by a client to manage...

Oh, wow, Ginger, you have really nailed it! Putting this into action may be a little tricky - I'm sort of picturing multiple levels of subforms within the form in order to keep all the linkages together and keep it user-friendly, so that will be interesting getting it all set up! But what you...

Name: John Q. Public Business: John Q. Public, Esq. 123 Main Street Springfield, MO 12345 Personal: John Q. Public 123 Cherry Blossom Lane Sleepy Suburbs, MO 00001 Occasion: Birthday: June 10, 2009 John Q. Public 123 Cherry Blossom Lane Sleepy Suburbs, MO 00001...

Hi, Ginger - Thanks so much for the quick response! I have not even created the first table yet - I'm still sketching it out on paper, and got stuck with the birthday/anniversary thing, so I came here first. Yes, that is exactly how I anticipated setting it up, pretty much the way you have...

Hi everyone - I am creating a mailing list for a client in MS Access 2007. It will be utilized for a mix of business and personal mailings, so most entries include two addresses, for office and home mailings. Her existing list has almost 2,000 names. The client also wishes to use the list to...