Susan Harkins
ssharkins at setel.com
Wed Aug 23 10:57:57 CDT 2006
You create a temp table of the addresses, and use SQL to insert blank rows
-- representing the missing labels -- at the top of the recordset. Really
very easy. If you need help, let me know -- I can dig up the exact
instructions... I think. :) The report doesn't know the difference between a
blank row and the data. Interface wise, all you really need is a simple form
to capture the number of blank records you need.
Susan H.
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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.7/411 - Release Date: 8/7/2006