[AccessD] Automating Acrobat

...would that I could but this is an asp.net2 app using an mdb be ...so vba 
is out of the question ...I may have to resort to vb.net but I thought I'd 
give it a shot here 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 7:27 PM
Subject: Re: [AccessD] Automating Acrobat


> You know, this is the point at which I usually turn to code - a couple of
> DAO recordsets, a few loops and walla - you've got the data you need in a
> temp table in less time than it takes to figure out how to make queries 
> jump
> through that hoop.
>
> 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 12:22 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Automating Acrobat
>
> ...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
>>
>
>
>
> -- 
> 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
>