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" <firstname.lastname@example.org> 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?
...Error with VBA code
I am having error with this statement. Do anyone know what's the error
with this line:
..CheckBoxes(i).Value = False
Dim i As Integer
For i = 1 To 19
..CheckBoxes(i).Value = False
I would guess that you have fewer than 19 checkboxes.
<email@example.com> wrote in message
|I am having error with this statement. Do anyone know what's the error
| with this line:
| .CheckBoxes(i).Value = False
| Dim i As Integer
| For i = 1 To 19
| .CheckBoxes(i).Value = False
| Next i
...Error removing replica from "SYSTEM CONFIGURATION" Public Folder
I want to remove an Exchange server from the replication tab on the "SYSTEM
CONFIGURATION" public folder (Exchange System Folder). I am logged on with
full rights however when I remove the server I get prompted for a username
and password. No matter what I type I cannot remove any of the servers and
eventually I get this error:--
"Exchange System Manager
The operation failed.
ID no: 80004005
Exchange System Manager
I am running Exchange 2003 with SP1.
Is the other machine inaccessible? You might want to try turning it back on
and then remove t...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...Outlook 2002 and Retrieving Data Error Message
OS is Windows XP SP1
Email - Outlook 2002 SP3
Error Message: Outlook is retrieving data from the Microsoft Exchange
Server <server name>. You can cancel the request or minimize this
message to the Windows taskbar until Outlook closes the message
Other Related Issues: At times, the message displays the correct
server name and sometime it does not. At times, it displays the name
of an active directory server. This only happens to workstations
located in an remote office connecting to the exchange server via
ADSL\VPN connection. We have one exchange 2003 server - public...divide so no error Excel 2007
I have a simple issue. I have two cells with numbers and I want to divide
one by the other and set it up on many cells. Problem is if I enter the
folmula befor there are actually numbers in the two cells I get the Divide
by 0 error (#DIV/0!)
So How can I divide A2 / B2 only if it won't produce an error?
"Striker" <email@example.com> wrote in message
>I have a simple issue. I have two cells with numbers and I want to divide
>one by the other and set it up ...Swipe cards for Cashiers / Customer Loyalty
Is anyone useing swipe cards for cashier sign on?
Or customer loyalty functions?
If so do you know of a good add-on for these or can you give me any other
We have a biometrics Add-in that can be very simply modified to accept a
card swipe instead of a finger print. If you are interested please give us
a call at 1-888-267-RITE or drop us an email at firstname.lastname@example.org.
Retail Information Technology Enterprises (RITE)
320-230-2282 ext. 4002 (Office)
"Gaz" <Gaz@discussi...Any idea why this is giving me a #Value! Error?
Function FrstLtrs(MyStr As String) As String
Dim i As Long
TmpStr = Split(Trim(MyStr))
'MsgBox "String" + TmpStr
For i = 0 To UBound(TmpStr)
If Not (UCase(TmpStr) = "OF") And Not (UCase(TmpStr) = "FOR") And Not
(UCase(TmpStr) = "THE") And _
Not (UCase(TmpStr) = "AND") And Not (UCase(TmpStr) = "A") Then
If Asc(Left(TmpStr(i), 1)) >= 65 And _
Asc(Left(TmpStr(i), 1)) <= 90 Then
FrstLtrs = FrstLtrs & Left(TmpStr(i), 1)
Find the mo...Erratic custom properties
Two apparently related problems when I use custom properties in custom
stencils with custom templates and property sets (taking into account the
settings related to master and document stencils):
1) Using custom properties result in unpredictable behavior - the custom
properties of the instance does not correspond to that of the stencel (both
with master or document stencils)
2) From time to time when I save a file and re-open it, the custom
properties seem to have gone to MS heaven - properties and values gone.
Appreciate any assistance
...Conversion error 05-09-04
I am using access 2003.
When I link or import tables from Excel XP I get a Coversion Error table for
those fields which contain user defined functions.
I would appreciate it if you could susgest how I can remedy this problem.
...HELP- error Outlook
What's this mean and how to fix?
in error dialogue box: "c:\program~1\micro~2
Abnormal program termination
...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...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...CUSTOMIZING YOUR OUTLOOK TODAY
When you change the style of Outlook Today by customizing
it (to summer or winter styles for example), then go to
another screen such as Messages or Calendar, and then
switch back to Outlook Today the style that appears is not
the style that you customized it to be.
How can I get it to stay that Style?
Your Caps Lock is Broken
"BRENT (Please Help)" <firstname.lastname@example.org> wrote in message
> When you change the style of Outlook Today by customizing
> it (to summer or winter styles for example), then go to
> another scr...HTTP Error 401.2
I have installed MS CRM 1.2 on my Domain controller running windows 2003
standard server and email router on exchange 2003. My local ip subnet is
With ms vpn connection, I can access to ms crm by using outlook 2003 or
internet explorer by opening the default ms crm page remotely. However, if i
connect to ms crm with different subnet 10.0.0.x, i cannot connect to ms crm.
10.0.0.x subnet is routed to 172.0.0.x, where my users normally login email
from the exchange 2003.
What puzzle me is why i can authenticate from exchange 2003 but not ms crm
server on using the same...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" <email@example.com> 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
...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!!!!!!!!!!!!!!
Using Excel 2003. I usually use excel to make forms (glorified word
processing) I have recently started to paste data from an Access database
tables, and queries into excel. I would like to know how I should set up my
spreadsheet to show my data by month, quarter and then yearly. I want my
report to show an average percent for the month of April, May, etc then
other cells that show the percent per quarter.
I don't necessarily need you to tell me how to do it step by step because I
think it is going to be alot of steps. For right now, I have 2 sheets and
...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...'Microsoft Visual C++ Runtime Library Runtime Error! 2nd Request
I just upgraded my Dell PII 400 from W2000 SP4 to WXP SP1.
I was having a lot of problems with Outlook XP crashing multiple
times while in use, which was 1 reason for the upgrade, as
Outlook is current, with all available updates having been applied.
Under XP, when I start Outlook, 9 out of 10 times I get a message
'Microsoft Visual C++ Runtime Library'
with the text:
abnormal program termination.'
When I click OK, Outlook closes. The next time, it starts OK, but has to scan
the Personal f...Report Manager #4
I have created a cusomised toolbar but when I customise the toolbar I cannot
find "Report Manager" anywhere to add to it.
The odd thing is that it is on the main menu but does not appear in the
customisable dialogue box.
Does anyone know where to find it, so I can put it on my toolbar.
All help much appreciated.
I'm guessing you created this customized toolbar manually (not by code).
If that's the case and you have "report manager" under the existing tools menu
already (or is it under Data???).
Tools|Customize (just to see that dialog ...Designing a report based on a crosstabe
Hope someone can help cause this is getting into my nerves...
I have a crosstabe that I run with a parameter for "date of sales".
Date of Sale is my column and the results are showed per month. So I run the
query and set the dates from 01/jan/07 to 31/july/07 and the query returns
the 7 months I want (mm/yy). How could I design a report that that would run
with various parameters? From what I understood so far, the field in the
report must necessarily have the name of the result achieved (ex. 01/07,
Hope I made myself understandable...