Is anyone using the feature for "Saved Queries"? I see
the easy benefits of "Disabled users" and "Non-expiring
users". But, is anyone using it for anything else and if
so, can you give some ideas and even possibly a place to
find script queries for the active directory.
...Is there a template to create a template?
Mike Koewler wrote:
> Just wondering!
Oh Mike, hahaha
there is a macro to make a cake, I think Ed had it...
You don't use a macro to make a cake. First you need a box of
MVP Microsoft [Publisher]
"Steve in NC" <dtp2webSPAM@netscape.net> wrote in message
> Mike Koewler wrote:
>> Just wondering!
> Oh Mike, hahaha
> there is a macro to make a cake, I think Ed had it...
I ...Print template on a 42 cm * 28 cm paper
I would like to print a template on a big size paper 42 cm * 28 cm with my
printer (manual tray), so that the template fits the size of that paper. It
appears much to small now when I print it, I would like the size of the
template to adjust to the size of the page.
...Error message in Excel after exporting Access query to Excel
I have a few queries in Access that I have been exporting to Excel, and
never had any problems for 7 months...until last week. Each Access query is
not big, 5 columns, 2-50 rows. Excel file exporting to is about 500kb, not
Last week I exported queries from Access without any error messages. However
when I tried to open Excel, it says Excel file I am trying to open
encountered serious issues last time it was opened, then asked me if I want
to report to Microsoft. It did not matter whether I said yes or no to this
question, the question box kept coming up for a few ...calendar templates
I imported a calendar which I want to change every month but keep the same
text for each day of the week.
When I changed the margins to make the calendar wider I cannot get back into
the calendar portion to make the changes for the month and move the dates
Can I change the margins or create a new template on my own and make it work.
If so, how do I go about doing this.
Publisher 2007 is what I am now using
What template? From the Office site? Changing the margins shouldn't affect the
way you input your data. Have you applied a border...Importing Excel named ranges using MS Query
I want to use multiple ranges (named) as the data source for a pivot table
using MS Query. When I import the workbook my options are only to select the
"tables" (which are my sheets referenced as sheetname$). I don't want to use
the entire sheet, just my named ranges in multiple sheets.
Names ranges should appear in the list of tables, unless they're dynamic
ranges. But if there's nothing else on the sheet, you can use the
> I want to use multiple ranges (named) as the data source for a pivot table
> usi...How to modify templates and keep them templates
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
Is there an easy way to edit a template and resave it as a template without having to rename it or remember the exact name it had. I keep getting multiple versions of the same template each time I change it.
You can open the template file using the File>Open menu. That way, Word will
open the file as a template (as opposed to a new document based on that
template), and when you save any modifications you have made, they will be
saved to the template file itself.
By the way, Word 2008 stores templates in ~/Library...I m looking for design templates for the oil field
I need templates for valves pipe turns andohter related hardware
John... Visio MVP
Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
"jc" <email@example.com> wrote in message
>I need templates for valves pipe turns andohter related hardware
...I need a DVD case template
I am after templates for DVD cases not CD/DVD cases - any suggestions?
Might modify one of these
Try Neato or Avery for templates.
Mary Sauer MSFT MVP
"Helpee" <Helpee@discussions.microsoft.com> wrote in message
>I am after templates for DVD cases not CD/DVD cases - any suggestions?
...template for deleting columns.....
I'm trying automate the process of deleting about 70 columns from a
spreadsheet...I need to find out how this can be done (I'm assuming I need to
run some program to do this).....the columns I need to delete will always be
the same and to do this manually is killing me...any ideas?
Try recording a macro when you select some columns and delete them.
You'll see the code that works for you.
If you're anything like me, you may want to hide the columns instead of deleting
them (just another option).
If you're new to macros, you may want to read David McRitc...xcell template
i am trying to create a speadsheet that adds up all the xl or m or small in
the t shirt collum then give me the total number for that coolum.
t/shirt sweat shirt coat
xl m xl
m xl xl
m s m
s s s
total tshirt xl=1 sweat shirt xl=1
s=1 s=2 ...Quote template
Does anyone have a form I can use to get a quote from a contractor for a job?
In Excess 2000 there used to be numerous templates. They are no longer
easily accessible in XP.
Please send answer to firstname.lastname@example.org Thank you
you should be able to find a template to meet your needs here.
Control the things you can and Don't Worry about the things you can't
"Kitylove2" <Kit...Small Book Template
I am looking for a Publisher template for a paperback size book (any size
will do though). I'm looking for a template that has all the necessary
formatting to send to a printer as well as the necessary pages in the front
Thanks in advance.
Check with your printer first. You may find they don't use Publisher. I love
the program myself but I've learned that the publishing world isn't as
enamored as I am.
Two things are aesthetically perfect in the world - the clock and the cat.
"...Previous Month Query
This formula will give me the previous month (which is March 2010) and will
also include 01 April 2010 data.
Between DateSerial(Year(Date()),Month(Date()),1) And
I tried this formula, but 31 March 2010 will not show up.
Between DateSerial(Year(Date()),Month(Date()),-1) And
Regardless of how many days in the month, is there way this can be fixed to
show only the previous month?
This goes from the first of last month to the day before the first of this
Betw...Retrieving Count of rows returned from MS Access Query
probably a pretty routine question here ...
I am trying to determine the number of rows that would be returned prior to executing an Access query .
If the user selects more than 65,536 possible rows, I want to warn them and then either proceed with a subset, or give them the option of cancelling their query and specifying more selective criteria.
It is a dynamic query, which lets the users click on multiple list boxes to select the "Where" component of the excel query, and I want to enable them to select right up to the maximum number of rows.
Ultimately,...adding subject line to e-mail template
I have depts in my company who weekly send me a
spreadsheet of companys to receive a standard e-mail sent
using Outlook 98. I created a DOT file in Word for the e-
mail body. I set the mail format to Word and the template
to the DOT file. Since the subject is the same for each e-
mail, is there a way to add the subject line to the
...Template help Window
OK this sounds odd but how do I keep the template help window from appearing
when I open my template?
Thanks in advance,
I have several word doc. pages that I would like to convert into email
templates that I can send to various contacts as needed. The docs. have
graphics etc. already. Is there a way to drop them into an email message and
keep them as a template?
Trying to get ahead
Outlook and Word versions?=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
when I open word an old text comes up everytime like a template, I have tried
to delete, I have tried to find normal.dot file to delete when I am in word
it won't let me delete because file is open this is driving me crazy please
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
On Sat, 10 Apr 2010 13:34:01 -0700, maw
>when I open wor...Using Publisher Templates
I need to create different templates that will be used
interchangeably. i.e., I may need page one of my document
to be Template 1, page two of the document to be Template
2. How can I import both templates into the same document?
Copy and paste the items you want from one into the other. Save the
resulting file as a template.
Do not meddle in the affairs of cats, for they are subtle and will piss on
"CR" <email@example.com> wrote in message
> I need to create di...CRM Template in Access 2002
I downloaded the template for CRM to use in Access 2002 from the Microsoft
website. I am unable to get my data to populate the template. If I build my
own form, I can populate it, however the form template that I downloaded is
much nicer to view it seems. Has anyone used this template? Is there anyway
to get a decent template for a form in Access for this purpose, or do I have
to buy a CRM software package separately.
...MS Query #6
Just for curiosity.
MS Query has a status bar with seven boxes on the right.
I only get 4, 5 and 6 working: [Caps], [Num] and [Scrl].
Do the other boxes have a function? And if so: what function?
Thanks for a reply,
...Custom Template not listed with Standard Templates
My boss has custom templates for memos, faxes, etc... and they are saved in
the following path C:\Documents and Settings\Application
Data\Microsoft\Templates. He would like to be able to go to File, New,
Templates on My Computer to access these, but for some reason they're not
showing up. We're using Office 2003.
...Query Results Where Qty Shipped is not Divisable by 4
How would I construct a query to return all invoices where the qty shipped
for a specific item is not divisable by 4? Really its the divisable by 4 part
need assistance with. Thanks!
WHERE YourFieldName Mod 4 <> 0;
"meangene" <firstname.lastname@example.org> wrote in message
> How would I construct a query to return all invoices where the qty shipped
> for a specific item is not divisable by 4? Rea...Templates? How?
I have a file that I have made with the product info from a database, with
pictures and everything. Now, how do I add a cover with a pre-made template
design. (or publication design)?
How do I merge a template design with the pages I have?
Open the template, select all, copy and paste to your publication. You can have many
instances of Publisher open at any one time.
You may lose the color scheme, but it can be restored in the format menu, color
Mary Sauer MS MVP