[AccessD] [Fwd: Word XP and access]

Borge:

I print labels one at a time to mail out a consumer based product in an 
envelope so in the Detail_Format event of the label printing report, I use:

    Me.MoveLayout = True
    Me.NextRecord = False
    Me.PrintSection = False

and iterate for the number of labels you want to skip.  But, of course, 
you have to know how many labels you want to skip and pass that to the 
loop or counter.

HTH

Rocky



Borge Hansen wrote:
> Hi,
> Funny, I am sitting here working with the exact same issue....
> I am using Helen Feddema's code from
>
> http://www.helenfeddema.com/access.htm
> Number 92  accarch92.zip
>
> mentioned in a post a few days ago
>
> I am using SQL string as the record source, (see frmMailMergeSQL in Helen's example).
>
> I noted that when opening the Word mail merge document you are met with the SQL alert you mentioned, and tried to find the source of
> this message and get rid of it...
>
> It's created when using the Mail Merge wizard, and I've found no way to get rid of the message other than suppressing it using
> William's suggestion.
>
> If I understand correct, William's suggestion would require a Word 'macro' / vba code, which by itself *could* create other another
> message appearing....
>
> Two ways of getting totally rid of the sql alert message:
> Either
> ....copy the table with the mail merge info into a new document with the same page setup as the original mail merge document.
> or
> ....create a mail merge document for labels without using the mail merge wizard..... just set up the page and label type and manully
> add the fields into each label on the page
>
> Now, New Question:
> Any ideas of how to offset the start of printing on the label sheet to the first 'available' label on the sheet. Say you have a 2 x
> 7 label sheet and the first two rows of labels have been used; the offset is to start on label 5.
>
> My initial thinking was to create say x 'empty' records (zero length fields) for the offset by way of using a union query: first
> part adding the x 'offset' records and the second part being the sql select query... (and with the x empty records sorted to the top
> of the list).
>
> Is that a way to go, and if so what's the sql to create x empty records???
>
> Any suggestions appreciated.
>
> Regards
> Borge
>
>
>
> ----- Original Message ----- 
> From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
> Sent: Tuesday, August 22, 2006 11:49 PM
> Subject: Re: [AccessD] [Fwd: Word XP and access]
>
>
>   
>> Look right to me (what do I know?).  I'll forward to the client and let
>> him test it.
>>
>> T&R
>>
>> Rocky
>>
>>
>> William Hindman wrote:
>>     
>>> ...try something like
>>>
>>> Application.DisplayAlerts = wdAlertsNone
>>> Documents.Open FileName:="c:\my documents\testmerg.doc"
>>> Application.DisplayAlerts = wdAlertsAll
>>>
>>> ...hth
>>>
>>> William
>>>
>>> ----- Original Message ----- 
>>> From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
>>> To: "Access Developers discussion and problem solving"
>>> <accessd at databaseadvisors.com>
>>> Sent: Tuesday, August 22, 2006 1:42 AM
>>> Subject: [AccessD] [Fwd: Word XP and access]
>>>
>>>
>>>
>>>       
>>>> Dear List:
>>>>
>>>> My client writes:
>>>>
>>>> I have a template that has mail merge codes in it. I have a one-table
>>>> Access mdb to which the template is linked. My regular access program
>>>> empties and reloads the single table in the one-table mdb.
>>>>
>>>> Then my regular Access program opens the template and saves it to a
>>>> predetermined .doc file... The only problem is when the template is
>>>> being opened, I get a MS Word message that says: "Opening this document
>>>> will run the following SQL command. Etc.
>>>>
>>>> Question: How do I prevent that screen warning?
>>>>
>>>> Anybody know the answer?
>>>>
>>>> MTIA,
>>>>
>>>> Rocky
>>>>
>>>> -- 
>>>> Rocky Smolin
>>>> Beach Access Software
>>>> 858-259-4334
>>>> www.e-z-mrp.com
>>>>
>>>> -- 
>>>> AccessD mailing list
>>>> AccessD at databaseadvisors.com
>>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>>> Website: http://www.databaseadvisors.com
>>>>
>>>>
>>>>         
>>>
>>>
>>>       
>> -- 
>> Rocky Smolin
>> Beach Access Software
>> 858-259-4334
>> www.e-z-mrp.com
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>     
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com