Linked worksheets #2
I've been able to link worksheets so that data
automatically updates from one to the other, but all my
(previously) empty fields in the destination workbook now
show up with zeros. This is especially a problem in the
date field that now shows 00-Jan-00, where there were
empty fields in the source workbook. Can anyone help??
In article <firstname.lastname@example.org>,
"Julie Maginnis" <email@example.com> wrote:
> I've been able to link worksheets so t...highlight row #2
Is there any way to have excel automatically highlight the row of a selected
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
.LineStyle = xlContinuous
.Weig...GP 9.0 SP 2
I have placed the SP 2 on my server and my additional clients. However 1 of
my clients is not able to install the update. I receive the following:
The installation source for this product is not available. Verify that the
source exists and that you can access it.
Why am I only receiving this error on 1 client?
Sounds like that client doesn't have access to the share on the server. try
copying the service pack to the client and running the installation locally.
Make sure that the user on the client has machine administrative priviledges.
Special offer on Dynamics GP,...Mailbox store is dismounted after reboot ?
I have resently restored my Exchange server 2000.
The only problems i have after that, is that the mailbox
store is dismounted after reboot....???
If your mailbox store dismounted , you can see a Red arrow at
start -> Programs -> Microsoft Exchange -> System Manager -> Servers -> ( Your Server Name ) -> First Storage Group -> mail Box Store & Public Folder Store
If the Red Arrow is there which means your mailbox store Dismounted .
> If your mailbox store dis...Publisher 2003 Page setup menu #2
I am trying to change some page setup options but
On 01 May 2004 18:41, "j ringer" <firstname.lastname@example.org>
>I am trying to change some page setup options but
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and confers no rights.
...How to modify Expression1 or 2 in existing FormatCondition?
I try to programmatically propagate the change of a name of a table field
through all my forms and reports, but got stuck with modifying conditional
formatting where the name change is to be applied to the condition
expressions themselves. So, the specified colors etcetera must not be
changed, only the conditions.
For Each obj In db.Containers("Forms").Documents
DoCmd.OpenForm obj.Name, acDesign
Set frm = Forms(obj.Name)
For Each ctl In frm.Controls
For i = 0 To ctl.FormatConditions.Count -1
Set fcd = ctl.FormatConditions....vertical text box #2
Does anyone know where to find the vertical text box to
add to the Objects toolbar in Publisher. Using publisher
2002, operating system is Windows 2000.
I looked around briefly and couldn't find any place in Publisher's user
interface where you could find the vertical text box to add to the Objects
toolbar. The following macro would do the job instead:
Shortcut Manager - Assign keyboard shortcuts to menu items and macros
http://officerone.tripod.com/pbsctmgr/pbsctmgr.ht...550 5.7.1 Unable to relay #2
I have configured secured POP3 access on Exchange Server 2003 with SP1 (SBS
2003). It was working fine but now POP3 users are unable to send mail outside
exchange organization. If they sends message outside exchange org. thier
messages are returened with error 550 5.7.1 Unable to relay for email@example.com
or any domain name.
I checked the event log there are two event id which are logged
Event ID 1069 Source POP3SVC: SSPI authentication attempt from
126.96.36.199 has failed with error 0x8009030c.
Event ID 7004 Source MS Exchange Transport: This is an SMTP protocol log
for vi...Check 'If LDAP field exists for user then...
If I have a query which returns the LDAP data for a user how can I run an
'IF' on whether or not a field exists?
If LDAPFieldX Exists then....
I've tried IsNull and a few others but they don't seem to work.
Generally, for detecting existence of an object or property, you can use
IsNull or IsEmpty as below:
propertyout = ""
prop = Session.Property("SOMEPROPERTY")
If IsNull(prop) Or IsEmpty(prop) Then
' do stuff
propertyout = propertyout+prop
' do other stuff
==...Command Button Enable/Disable
I am using conditions to enable and disable record selection command buttons
in a form. I'm doing this to run additional scripts when navigating through
records, which I can't do simply using the standard record selection bar at
the bottom of the form window. It was working perfectly at first and then I
suppose when I made a change somewhere it doesn't work properly when the form
is first opened. It is set to diable First/Previous Record buttons when at
the first record, disable Last/Next Record buttons at the last record, and
all buttons are enabled for all records in betwe...2 Designers
how would you handle having two persons who work on
creating/designing/editing a DB?
FYI I'm not in this situation but just in case.
Simultaneously or consecutively?
If simultaneously, one approach might be to allow both to open the same
file, but the first one on an object will 'lock' it from the other.
If consecutively, you'd need a way to ensure that PersonB doesn't start
until PersonA is done ... that's a matter of communication.
There are tools that help with the communication ...
Microsoft Access MVP
...Excel to pdf #2
We have a worksheet in Excel that we are needing to
convert to pdf. However, when it converts the pdf file is
very small (text) and the page size changes from 8.5 x 11
to 40 x 28. Any assistance in correcting this matter
would be greatly appreciated.
Try deleting unused rows and columns, as described here:
Then covert the file to pdf format, and see if the problem has been fixed.
> We have a worksheet in Excel that we are needing to
> convert to pdf. However, when it converts the pdf file is
> very small ...>>>Please Read: Holiday Hours<<< #2
In observance of the upcoming holiday the Partner Online Technical Communities will provide (limited, delayed) service
on New Year's Day January 1, 2009
We will respond as quickly as possible on the day following the holiday. Our apologies for any
inconvenience this may incur.
We wish you all the best and a safe and happy holiday!
Online Technical Community Support Team
When responding to posts, please "Reply to Group" via your newsreader so that others may learn and b...Spam email going to one user
A user has been complaining of getting junk email that are not addressed to
her but in the TO field is addressed to random addresses. For example:
firstname.lastname@example.org, email@example.com ... etc. PLease help because I'm a
novice at Exchange and don't know why she's the only one getting this. How
do I fix this? Thanks.
What product are you using for anti-spam?
On Thu, 7 Apr 2005 16:59:19 -0700, "Geeo" <firstname.lastname@example.org>
>A user has been complaining of getting junk email that are not addressed to
>her but in the TO field is addres...Deploying Delphi xml (Single User)
I recently upgraded an old Paradox-based database application, and
decided that the new version should use an XML database for reasons
of speed and reliability (among others), and the conversion and
update went smoothly except for 1 thing: Although everything works
as designed on my system, when deployed on another computer it
throws an exception and dies. I'm not sure where the exception is
because the address given appears to be in the DevExpress grid
component, but I've never had a problem with their components
before. Anyway, since I'm new to the XML world, I'm gues...Automatically filling Box 70 on T4 #2
Enhancment request to automatically fill in Box 70 (found under T4 edit >
other information) on the T4.
Box 70 is Municipal Officers expense allowance. Customer has to manually
calculate this right now by taking the taxable income and subtracting Box
14(2/3 taxable) to get the Box 70 amount of 1/3.
v7.5 GP CDN Payroll
Please enter this in product suggestion site:
This posting is provided "AS IS" with no warranties, and confers no rights.
Any views contained within are my personal views and not necess...Access to MS CRM data by non-licensed users
What is the best way for a non-licensed user to access MS CRM data?
Has anyone from Microsoft ever stated that you can access the MS CRM
SQL database directly with a SELECT statement and not break the
Can anyone copy the MS CRM data into another database and access that
data without a license?
Can anyone use the MS CRM filtered views to either access the MS CRM
database directly or to make copies of the data?
Has anyone written an MS CRM add-on application that pass the
certification test which directly reads MS CRM data?
If the MS CRM license is only for the software, ...Newsgroups? #2
Trying for info again. Outlook 2000. Have succeeded in moving the location
of the pst file so that all my emails and address book get saved to My
Documents, which I back up frequently.
But it seems that Newgroups subscribed to are not so saved. Where are they
they are in outlook express -so its whereever outlook express has their dbx
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly...SMTP logs #2
Does anyone know of an application that can monitor your SMTP logs for you?
I need to monitor the SMTP logs in the morning for repeated attempts on the
SMTP service. This is very annoying considering theres over a thousand lines
Any suggestions? I even read somewhere you can use a script to monitor it...??
How about logging it using ODBC and then you could dump it into Access and
do queries against it:
This posting is provided "AS IS" with no warranties, and confers no ri...replace "#DIV/0!" errors with blanks #2
Does anyone know how to replace #DIV/0! errors with blanks
I am working with very large data sets, and complete
averages, maximums, etc when compiling the data. However,
the #DIV/0! errors always affect each subsequent
I have tried using the Find and Replace commands under the
Edit menu, and have also attempted formulas such as:
=IF(AVERAGE(A12:A19)="#DIV/0!", "", AVERAGE(a12:a19))
Both of these methods leave me with the same "#DIV/0!" as
before. As you can see, this will negatively affect any
calculations based on the cell...Changing Sent Items mailbox.
Is there any way to save sent messages to a mailbox other
than Sent Items? When using IMAP, if you need to keep
copies, you can run out of space on the server. Is there a
way to save these to a set of private folders?
...XML Validation in C # 2.0
I am trying to validate an invalid-XML against an XSD. I am using an
XmlReaderSettings to set the ValidationEventHandler, ValidationType
and adding the Schema to the SchemaSet.
The XML has quite a few validation errors in it. But the
ValidationEventHandler is throwing only the first validation error.
I have used XmlValidatingReader instead and it was listing all the
validation errors. Since it has been made obsolete in Version 2.0 I
would like to know how do i list all the validation errors of an XML
> I am trying to validate an invalid-XML against an XSD. I...How to let users add lines in lists in protected worksheets?
In Excel 2003, I have set up a protected worksheet with only a few cells
unlocked, including a list.
I want to let the users add lines to the list eventhough all the cells
outside the list are protected. The users should not be able to add lines
anywhere outside the list.
...Drop Down Menu #2
In Word I'm able to attach a calendar as a drop down menu...then a person who
clicks on that drop down menu will see the calendar and then can click a date
which will be seen in the cell.
Would you like to something similar in Excel?
See Ron de Bruin's site for instructions on using a Calendar Control on a
Also note the section for calling the calendar from a Toolbar button.
Gord Dibben MS Excel MVP
On Tue, 5 May 2009 14:24:15 -0700, Marlas <Marlas@discussions.microsoft.com>
>In Word I'm able to attach a c...