link custom field to resource names
i have created a custom field "Primary contact"
is there a way to link it to the list of Resource names?
maybe turn it into a drop down list?
"greg" <email@example.com> wrote in message
> i have created a custom field "Primary contact"
> is there a way to link it to the list of Resource names?
> maybe turn it into a drop down list?
...how do I open files from other versions in Publisher 98?
I have Publisher 98, and am trying to open a Publisher file emailed to me
from someone else. I don't know what version they have, but I would guess
it's from Windows ME, because I know they don't have XP. And when I try to
open it in my Publisher, it says, "Publisher cannot open files from a
different version". Is there any update or anything I can download to fix
this, or do I have to buy a different version, or is there a way the other
person could save their file so that I could open it? Thanks very much.
A small child turns to Ed, and exclaims: "Look! Look...Display Field Name as Text Listing if Value True from Checkbox Fields
I have 40 or so columns in a table using the yes/no data type. Each
record in the table represents an audit of a paper form. Those items
filled incorrectly or incompletely on the paper form receive a check
on an access form during the audit process.
I would like to create a feedback form based on the audit record that
displays a listing of fields that received the check boxes, or rather,
were incomplete or incorrect on paper form that was audited.
On the feedback form, I only want to display something like this:
"Your form had the following errors:
Erro...Print Command Button Corrupted
Does anyone know how to recreate a corrupted button in Excel 2000?
Basically the Print button comes up with error messages when I press
onto it. Printing works fine if you select from the File menu, it is
just the button. I thought there was a tool to recreate buttons but
cannot find it.
I have also run detect and repair which did nothing (Surprise
Any ideas would be much appreciated.
Try this: In Excel XP, View, Toolbars, Customize. Select the Standard
toolbar and Click the Reset Button. Note, that this will cause any
customization that you may have made to you...spreadsheet does not print as large as created
I have created a spreadsheet in Excel 2002. Simple layout
with number, name, address,blank, blank,number. I created
with large font size (28 or 32). I want the columns large
enough for me to write in blanks and make notes. When the
document is printed (hp laser 5p) the size of the font is
Probably because that printer (driver) will not support that font and/or
Granite Shoals, TX
"Jim Morgan" <firstname.lastname@example.org> wrote in message
I have a report that I have been doing in Excel but is better done in Access.
However, the report is too large to print on a single page and that is a
necessity. With Excel, I just adjusted the scaling. I can't seem to do that
with Access I've also tried exporting from Access to Excel, but the
calculated fields are not exported.
Any suggestions on how I can print the report on one page?
Sorry, when I posted, it said there was an error and that I should try
> I have a report that I have been doing in Excel but is bett...Excel Database
I'm developing a database in Excel and I need some help with macros.
It's a database of drink short takes for a bar. Each tab has a different
summary category, such as spirits, wines, cocktails, etc... Cells in each
summary tab links to a new tab, where the data for that entry is explained
(the short take sheets themselves).
Short take planner
Now, imagine a simple monthly calendar, each cell corresponding to each day
of the month that has a drop down list of values to choose from.
First, I would like to make this drop down list show data from the...Determining and Printing a specific page
I have a HUGE Excel spreadsheet and I only want to print a certain page. Is
there any way that I can tell what page the row resides on so that I can
specifically print only that page of the spreadsheet???
Any help would be GREATLY appreciated!
Thanks in advance!
"wnfisba" <email@example.com> wrote in message
>I have a HUGE Excel spreadsheet and I only want to print a certain page. Is
> there any way that I can tell what page the row resides on so that I can
> specifically print only that p...i can change the font on the screen to be large but can't print t.
i am trying to make the print on my spreadsheet larger. i can change the
font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!!
Maybe in the Page Setup you have this setting
"fit to1 by 1 page"
Regards Ron de Bruin
"tj" <firstname.lastname@example.org> wrote in message news:244325C6-A407-4CD8-BE76-75AB3C93A78A@microsoft.com...
>i am trying to make the print on my spreadsheet larger. i can change the
> font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!!
...Anyway to open a Publisher 2002 file in Publisher 2000?
I need to open this file for a project tomorrow. I have Publisher 2000, but I think the file sent to me was done in Publisher 2002 or 2003? The person who sent it to me is out of town until Thursday, so I can't have them resave it or resend it. Any ideas
buck <email@example.com> posted:
> I need to open this file for a project tomorrow. I have Publisher
> 2000, but I think the file sent to me was done in Publisher 2002 or
> 2003? The person who sent it to me is out of town until Thursday, so
> I ...Search Multiple Worksheets #2
Is there a way to search trough multiple worksheets for a specific value?
Other posts have mentioned to use VBA, but I have never used that before. If
anyone can give me some advice on using that or a type of formula to perform
that can search multiple worksheets.
There may be other ways but, while holding down the ctrl key select each of
the worksheet tabs you want to search in then select Edit|Find from the
menu. Type in the value you want and it will go to the first instance of
that value. Now if you are wanting to preserve a specifice value for
reference or ???, then...map data (x-y axis) with diffent series name
I have a set of x-y coordinate data set and i would like to plot them showing
the respective series name. Is there an automatic way of doing this without
haing to plot the data points separately. eg
Name x y
A 1 6
B 2 3
C 3 4
D 4 2
E 5 5
.. . .
.. . .
.. . .
I will like to have a plot of x and y with A, B, C as series name without
having to plot the points one after the other.
Here are a couple of free addins that allow you to link data labels to
Rob Bovey's Char...URGENT!!! Problem with row data being truncated in a copy worksheet sub #2
Dave, Thanks for responding. I tried this but I could not get it t
work in conjunction with the entire module. It dies right afte
copying and PasteSpecial Values It does not kill the temp file or loa
the newly created sheet into an e-mail. Any Ideas
DoctorV's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=514
View this thread: http://www.excelforum.com/showthread.php?threadid=26863
You may want to post your current procedure.
> Dave, Thanks for respon...Counting of Names ?
I have some names in some cells like " Abraham" " Sathish " etc . I
want the number of occurances of each name Counted ,within a range of
cells and made known at a perticulat cell
Name No of Times
Put the unique names in a column and use (eg)
If you want a fast way of extracting the list of names see:
Norman Harker MVP (Excel)
Excel and Word Function Lists (...Difference Between Contacts and Address Book
I'm just trying to start to use Outlook (MS Small Bus 2007 w/ Outlook and
Bus. Contact Mgr) for email and have a number of Contacts setup in different
Categories. WHAT IS THE DIFFERENCE IN USING "Contacts" VERSUS USING THE
There is no address book in Outlook. What you think is an address book is
simply a view of the electronic addresses contained in your Contacts Folder.
Explain why you are confused and what you question is.
"CFLJoe" <CFLJoe@discussions.microsoft.com> wrote in message
news:06ED2E...opening excel worksheet
Operating System: Mac OS X 10.6 (Snow Leopard)
whenever I try to open an existing excel worksheet it opens very short. I have to drag it down to the bottom of the screen, is there a setting that i need to adjust?
No, simply SAVE the workbook after you adjust it.
Next time, it will open at the size you want.
On 27/03/10 6:42 AM, in article 59bb6065.-1@webcrossing.JaKIaxP2ac0,
"firstname.lastname@example.org" <email@example.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> wh...Different background color depending on x-axis value
Is there any way to have the background in a chart have differen
colors depending on x-axis values?
x-axis value 1-10 => blue background
x-axis value 10-20 => red background
RealRaven's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3705
View this thread: http://www.excelforum.com/showthread.php?threadid=56778
Here are a few of the ways you can get custom background fills for your
http://PeltierTech.com/Excel/Charts/ChartIndex.html#Backgro...print area #2
i cannot clear print area. when i select the print area
and 'file', 'print area',the options are not available.
When you use this command, Excel creates a range "print_area". Try deleting
New York City
"bronxxbabe" <firstname.lastname@example.org> wrote in message
> i cannot clear print area. when i select the print area
> and 'file', 'print area',the options are not available.
> any suggestions?
Perhaps you have two or more ...screen prints failing best demonstrated practice
When Outlook messages have screen prints embedded and the email is related
and tracked in CRM the screen print does not come over to CRM. I understand
this is not supported. But, what are practitioners doing to manage retaining
these screen prints as pertinent background for the case. Looking for best
...Printing in Landscape mode
This is a multi-part message in MIME format.
Is there a code snippet in which I can set the printer print-mode to =
Ideally, I want to set it in the MFC CView::OnPreparePrinting() method =
If you have any suggestions... please help.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD H...Printing on 2 sides of a page?
How can I print a 2 page spreadsheet on the front and back of the same
sheet of paper? Using Excel 2008.
It depends on whether your printer supports duplex printing. Check your
printer's features to find out. If it does, the setting will be available in
the Print dialog.
You can also do a "manual duplex" job by printing page 1 (or 'Odd pages'),
flipping the paper yourself, then print page 2 (or 'Even pages')... If it's
only 2 pages that might be the simplest approach.
"Rick"...Print all records on a report ONLY IF Invoice NO is same
How do I get all the detail records for the same invoice no. to appear on the
Presumably you have 2 tables, such as:
- tblInvoice (the header record), with fields:
o InvoiceID primary key
o ClientID relates to tblClient.Client
o InvoiceDate Date/Time
- tblInvoiceDetail (the line items), with fields:
o InvoiceID relates to tblIvoice.InvoiceID
o ProductID relates to tblProduct.ProductID
o Quantity Number
o PriceEach Currency
To create a report that looks like an invoice:
1. Create a query that uses both tables, along with...Why are checks printing incorrect amounts? Please help.
When I print a Payables check batch, several invoices within the batch are
printing incorrectly as $0.00 amount, even though it should be paying off a
The problem seems to be with invoices that are applied to credit memos. Say
I have an invoice for $500 and I apply a credit memo of $80 to the invoice,
when I go back to pay the invoice, it should pay $420, but instead it shows
$0.00 under amount paid column of check stub.
Does anyone know why this is occuring? By the way, I am using MICR check
How can I modify the OU in order to assign an especific domain to the users
that belong to that OU?
Suppose that I have two OUs, one called First and the 2nd one called second;
and I have 10 peoples in each OU, but I have two domains, one colled
domain1.com and the other one called domain2.com
I want to create the 20 users, but once inside the OU the software should be
able to assign the domain that belongs to tha OU. Is it possible?
Tks a lot.
In the last exciting episode, "Administrator"
>How can I ...how do i open a publisher file created in new version?
I get publisher files in new versions of publisher. I have publisher 2000.
I can't open these files but don't want to update publisher. Is there a
download program I can get to translate these files?
"Peg" <Peg@discussions.microsoft.com> wrote in message
>I get publisher files in new versions of publisher. I have publisher 2000.
> I can't open these files but don't want to update publisher. Is there a
> download program I can get to translate these files?
There is not a download to tra...