I am prompted to 'Enter Personal Email' and it returns just the work emails.
I have a similar query for Mailing addresses, Work/Home, that runs just fine.
I did change the name of Personal Email, from Home Email, but I have updated
it wherever it counts. Any suggestions?
Re: Query an external database... ... > Create a Query in the Access 2K file. ... > The reason I put 0001 on the front is because if it's the first> query in a set of queries, you'll be able to know what it's doing,> how many queries there are, etc.> ... > Im working within an Access2000 database and writing code in VBA. ... > Unpak my email address before sending me personal email... (microsoft.public.vb.database.dao)
Re: Query an external database... ... > Create a Query in the Access 2K file. ... > The reason I put 0001 on the front is because if it's the first> query in a set of queries, you'll be able to know what it's doing,> how many queries there are, etc.> ... > Im working within an Access2000 database and writing code in VBA. ... > Unpak my email address before sending me personal email... (microsoft.public.vb.general.discussion)
Re: Qualifying and locking a yes (yes/no) ... >> Please only reply to this newsgroup.... >> I do not reply to personal email.... you can refer to a control on the form using ... A better solution would be to use a query as this form's recordsource ... (microsoft.public.access.forms)
Re: Query an external database... ... > Create a Query in the Access 2K file. ... > The reason I put 0001 on the front is because if it's the first> query in a set of queries, you'll be able to know what it's doing,> how many queries there are, etc.> ... > Im working within an Access2000 database and writing code in VBA. ... > Unpak my email address before sending me personal email... (microsoft.public.access.queries)
Re: Dates between ... This is done in the query,... >> Bob,... >> Please only reply to this newsgroup.... >> I do not reply to personal email.... (microsoft.public.access.gettingstarted)
