Insert special into empty picture frame
I have a client who until about a month ago used Publisher 98 to do series
of pages with 4 pictures. He had a template containing four empty picture
frames. When having a picture in clip-board, marking an empty frame and
choosing insert special, the inserted image resized to fit the frame.
In Publisher 2003 the frame however resizes to fit the picture.
Is there any way to have it like in Publisher 98?
Use the autoshape option instead, create it to any size, click fill, fill effects,
Picture tab. You can change the line to "no line".
Mary Saue...Plot empty cells as not plotted (leave gaps)
Under Tools/Options/Chart Menu I have set the "Plot empty
cells as: Not plotted (leave gaps)as well as Plot visible
cells only, however the chart still plots null values
causing the automatic scaling to be impractical
If you're using a formula that returns an empty string for missing
values, change it to an NA()function. For example:
instead of =IF(B9="","",B9)
To hide the resulting #N/A errors on the worksheet, you can use
conditional formatting. There are instructions on my web site:
http://www.contextures.c...Resource Update does not update location field
We have one person create a meeting request for a resource and some other
users. Then if someone else goes and modifies the meeting request resource
for the location, the location field does not update. But if the original
creator does the same process, it works fine and does update the location
...Remove duplicate enries with blank fields
I need to create a key word index for past issues of a magazine. Th
index will be published on the publisher's website. Key words, title
and issues are collected in an Excel file, and are alphabeticall
sorted. One keyword can have multiple references to articles, but fo
eastethic reasons I want to remove duplicate keywords while off cours
maintaining the title and issue info. The result should look like this
http://www.belastingzaken.nl/trefwoordenregister/P.htm (it's Dutch)
I have deleted duplicate key words manually, but since I need to updat
this index each month that's just ...Adding Size Field In Outlook 2000
In my Domain, I want to add to All my users the Size Field to their Outlook
How can I do this..???
I realize that this on the level of user outlook Profile, And not in the
level of the Exchange Sever.
Send these instructions to the users:
Right click in the column heading areas, and select Field Chooser. Switch
the drop-down to the All Mail Fields and then scroll down to the "size"
entry. Drag it from the field chooser window to the toolbar and drop it
where the individual user wants it to display.
Milly Staples [MVP - Outlook]
Post all replies ...Workflow rule to check changes in CRM fields
Is there anyway using work flow to check fields change such as if one of the
address fields on account or contact is changed then send email to
appropirate CRM user?
I have has a look at the only thing to evoke the workflow rule is when
Assign, Create, Manual or Status change.
You have to use post-callouts to check this situation.
> Is there anyway using work flow to check fields change such as if one of the
> address fields on account or contact is changed then send email to
> appropirate CRM user?
> I have has a look at ...How-to hide comment field on Invoices
For one of our customers, we needed a way of classifying items which
are Urgent in need to make sure our warehouse ships them out as soon
as they are received. The only way field that would work is the
'Comment ID' field which can be found in the 'Sales Item Detail Entry'
window. I then modified the related smartlist report to use this field
and life was good.. until we printed invoices.
On the Invoice, for every 'Urgent' item, a blank line appears after
it. With more than one 'urgent' item on the same Invoice, it makes for
an odd/unprofessional looking Invoice...How to count the number of cells not empty?
I get a table from cell M2 to W200, and would like to count the number of
cells not empty? which the cell equals to "". Does anyone have any
Thanks in advance for any suggestions
Try the formula
in any cell outside the table.
> I get a table from cell M2 to W200, and would like to count the number of
> cells not empty? which the cell equals to "". Does anyone have any
> Thanks in advance for any suggestions
it counts the empty cell too,
Do you have any ...Counting Blanks in Non Numeric Fields
I am trying to see how many blank spaces employees leave when filling out a
particular form. These fields are generally non numeric, though there are a
few check boxes too. Is there an equation I can use in the report footer that
would add up the total number of blanks? The goal would be to use that
information and divide it by the total number of fields to produce a
percentage of complete forms.
You'll need to decide what constitutes a "blank".
If someone enters something, then deletes it, is that a "blank"?
If someone skips past ...Adding tab on Users Field
Is it possible to add a tab under Setting> BU Settings> Users> beside
Hope to hearing from you soon.
No possible to modify the user object/entity via out of box system
> Is it possible to add a tab under Setting> BU Settings> Users> beside
> Hope to hearing from you soon.
...Comparing text and number fields
I have AutoNumber field EnvelopeNumber and text field AuthenticationCode,
with the default for AuthenticationCode equalling EnvelopeNumber. In Allen
Browne's code to duplicate records, I have code to update the
AuthenticationCode if it equals the AutoNumber, but accept it if the user has
entered his own code.
If Me.AuthenticationCode = Me.EnvelopeNumber Then
!AuthenticationCode = !EnvelopeNumber
!AuthenticationCode = Me.AuthenticationCode
This always copies the AuthenticationCode, I assume because Access does not
recog...Update Status field by record selection
Table 1 Name: Bank
Table 2 Name: Ledger
1 Main form with 4 subforms (only having problem with 2 subforms)
1st Subform: UnMatch1 (query based on Ledger)
2nd Subform: UnMatch2 (query based on Bank)
Once my users verfied information from both subforms, they will decide if
those items match (by record) on the Status field.
I need to have a CmdMatch which can allow users to select particular record
and make update the Status to Match or UnMatch.
I did some research all day but only one that's close enough to what I wanted
is the following code:
Private Sub CmdMatch_Click()
Dim rs As...Creating a field to search and enter non duplicate data
I have a team of 15 pople that all work with reference numbers, on occasion
a number has to be sent to a different work group. I've created a spreadsheet
for them to enter the numbers into, but we have been duplicating numbers. I
want to create a field to enter th number into, have the field cross
reference the exsting numbers, and if it does not find a match, enter the
number and sort the list.
I know how to create a custom macro that will accomplish what I want to do,
but I'd prefer a static formula if it's possible.
A formula can not do waht y...Adding fields to tables in SQL/CRM
I would like to add about 5 fields to the contact form
and was wondering if that can be done with MSAccess.
To add fields to CRM you first add them using the schema manager in the crm
deployment manager tool. After adding the fields you need to publish the
fields using deployment manager then reset the web server to refresh its
data. Once done you can then go into the CRM web interface as a crm
administrator and then go into customization and add the fields to whatever
form you need. MSAccess is never used to do this.
"Antony" <firstname.lastname@example.org...Restrict information fields for contacts in Outlook emails
I often send email to multiple people and want them to see who other
recipients were. However, I don't want a recipient to be able to right-click
on another recipient's email and by looking at the "properties" see their
cell phone, and other personal information I have for that contact in my
contact list. How can I use Outlook 2007 to manage my contacts, and use
those contacts to address emails, but not send ALL the fields I have for a
contact for every email "co-recipient" to see.
Does that make sense? It seems this must be basic and obvious, bu...see only name in the "from" field composing emails
When sending an email, how do you show your name only in the from field as
opposed to your name and email address? I noticed whe I watched the the
"outlook" demo that the example email that is being composed shows the
senders name only, how do I make that change?
If you create a Contact Record for yourself and change the Email Display As
field to contain your name only, that's what you'll see in the To: field.
You won't be accomplishing anything, but if it makes you feel better, go for
it. What the recipient sees will be determined by their email software a...Date calculation on 2 fields
I have a query that calculates captures a date filed 20 days after the date
which is entered. It then gathers all the dates after the 20 days has been
calculated. I need to code another date field that doesnt grab info 45 days
past the date.
Example: works now
user - puts in date 1/28/2010
query - subracts 20 days from that date = 1/08/10
query - then gathers all the dates after 1/8/10.
Need - To look at another date field and make sure no data is gathered 45
days from the date in field.
Are you talking about two separate queries, or a single query with two
...The Pivot Table field name is not valid,
I am receiving the above error message, but don't understand why. My data is
in columns, organised as a list and the columns are labelled. What do I have
to do to get over this?
Maybe there's a hidden column, with no heading text, or you've
accidentally included a blank column at the end of the range.
> I am receiving the above error message, but don't understand why. My data is
> in columns, organised as a list and the columns are labelled. What do I have
> to do to get over this?
Ex...To many fields defined error message
I am currently using access 2003 and when I am attempting to bring multiple
queries together into one... I am getting a To many fields defind error
message. Below is my SQL that I currently have. I am going to want to add
another 30 fields from 3 other queries to this one as well.
SELECT [Employee Hierarchy - Current Month].[Performance Year], [Employee
Hierarchy - Current Month].[Performance Month], [Employee Hierarchy - Current
Month].ATTUID, [Employee Hierarchy - Current Month].Skill, [Employee
Hierarchy - Current Month].Ramp, [TC-All-Weeks].[TC-Week1-Step2].[Trans and
Co...Populate Markdown field in Sales Transaction Entry with differenc.
When using Extended Pricing, we would like the system to automatically
populate the Markdown field on the line item with the difference between the
Item’s Net Price and promotion. For example, if the Net Price of an Item is
$150 and the promotion is $10 off, we would like the Unit Price to be
populated with $150, the Markdown field to be populated with $10.00, and the
Extended Price to be populated with $140.
Not sure if you'll see this or not but I thought you (or someone) might like
to know that I have gotten this request a couple times and have written such
a product. Email mbs...Total number of Jan 2007 entries in a list of date formatted field
I have a report that captures work done by sales reps. For each entry there
exists a date. This report is exported in Excel format and the date is
captured as mm/dd/yyyy hh:mm. I would like to have a column that lists the
number of work entries by Jan 2007, Feb 2007, Mar 2007, etc.
I am at a loss as to how I can conditionally count the occurrence based on
the month and the year in this date field.
Thanks in advance.
where B2:B200 holds the dates
you can expand on that if you want to count for an individual
=SUMPRODUCT(--(A...Three questions about fields in worksheets
Hello! I have a workbook that tracks patients (mothers) and contacts (mom's
family members). The mother worksheet is named MAT_INF and the contacts one
is named CONTACTS.
1. In MAT_INF, I have a field named CASE_NUMBER. How can I tell this field
to automatically start out with a value like "2009-"? An example case number
would look like 2009-001 or 2010-099.
2. Once CASE_NUMBER, LAST_NAME_MOM and FIRST_NAME_MOM have been populated by
the user in MAT_INF, how can I automate adding those values to the CONTACT
sheet, where the corresponding fields are named CASE_N...Mail Merge with unequal number of fields
This is a multi-part message in MIME format.
I receive a monthly report showing search engine-generated web site =
hits. Included is name/address/contact info and the information category =
for which they were searching. I want to use this information to drive a =
Word MailMerge to create a response to each of these inquirers. I want =
to be able to address the area of interest that brought them to the =
The problem is that one person may ha...Change A Field content to spaces
I have a transfer text routine to transfer the contents of a query to a text
file. In that file is a field name cost_ctr that has the word "none" in it.
How do I change "none" to spaces for the output file only? I still want to
keep it in the query for reporting purposes.
Thanks for your help.
Message posted via AccessMonster.com
Create a query against the recordset. Use an IIF() expression to change
"none" to "..." (you didn't say how many spaces). E...Pivot Chart with 2 horizontal axis field (categories)
I've created a pivot chart that has two horizontal axis fields. The chart
labels are too long to display properly and overlap each other. When I try
to modify the axis labels, I can only modify one of the categories. How can
I modify the other category labels?
When using multi-level category labels only the inner most level can be
formatted. True of Pivot chart and normal charts.
> I've created a pivot chart that has two horizontal axis fields. The chart
> labels are too long to display properly and overlap each other. When I try
> to ...