[AccessD] Automating Acrobat

William Hindman wdhindman at dejpolsystems.com
Fri Mar 28 14:22:20 CDT 2008


...the EPCID is used to call other actions specific to it ...but I'll take a 
look at trying that if Patricia's code doesn't work first.

William

----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, March 28, 2008 2:50 PM
Subject: Re: [AccessD] Automating Acrobat


> In the second query can you include all the fields EXCEPT EPCOD and use
> unique values?  Do you need the EPCID in whatever is calling that query?
>
> Rocky
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: Friday, March 28, 2008 9:27 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Automating Acrobat
>
> ...that would be the normal approach but EPCID is a parameter and isn't
> known until the user supplies it ...thus I can't dedupe before hand since
> the data caught by the OR almost certainly has differing EPCIDs ..I'm
> thinking about using a UNION but those always make my head hurt :(
>
> William
>
> ----- Original Message -----
> From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Friday, March 28, 2008 12:08 PM
> Subject: Re: [AccessD] Automating Acrobat
>
>
>> Two queries - one to set up the records with dups and a second one using
>> the
>> first one but properties Unique Values - Yes?
>>
>> Rocky
>>
>>
>>
>>
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William 
>> Hindman
>> Sent: Friday, March 28, 2008 8:40 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Automating Acrobat
>>
>> ...given the following query:
>>
>> SELECT DISTINCTROW tblExhibitorProducts.EPCID, qryApr08Grid.CompanyID,
>> qryApr08Grid.CompanyName, qryApr08Grid.AdClass, qryApr08Grid.SGOn FROM
>> tblExhibitorProducts INNER JOIN qryApr08Grid ON
>> tblExhibitorProducts.CompanyID = qryApr08Grid.CompanyID WHERE
>> (((tblExhibitorProducts.EPCID)=11)) OR (((qryApr08Grid.AdClass)="A"));
>>
>> ...how can I avoid duplicates in the OR results?
>> ...I've tried totals and uniuqe values/records but nothing produces
>> consistent results ...help!
>>
>> William
>>
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> No virus found in this incoming message.
>> Checked by AVG.
>> Version: 7.5.519 / Virus Database: 269.22.1/1347 - Release Date: 
>> 3/27/2008
>> 7:15 PM
>>
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.519 / Virus Database: 269.22.1/1347 - Release Date: 3/27/2008
> 7:15 PM
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 






More information about the AccessD mailing list