Here is my situation. I have a query that needs to return data depending on
certain criteria. There are 3 date fields that the query has to look at:
BOY, EOY and MOY.
If all 3 fields are blank, I don't want the query to display those records.
If any one of the fields has a date between 7/1/2006 and 6/30/2007, then I
want the query to return that record.
There is one more thing that has to be taken into consideration. There are
2 other fields that must be looked at and can be done separately. If the
difference between the enrollment date and termination date ...email issue using OL 2003
I have office 2003 installed.
I use OL 2003 as my email program.
I use Word 2003 as the email editor.
When I reply to someone's email the original is quoted as per the set up
under email options.
The issue is that when I reply an email sent from a MAC or Apple PC, the
original message is not included unless I uncheck to use Word as the email
editor in the email options.
Any suggestions are appreciated.
The default format in Outlook is Rich Text. Only other Outlook users can
read Rich Text. If that's the format you're using, try switching to HTML...Task Bar Issue
I am running XP SP2 on a Leveno desktop.
My task bar suddenly went from one line to two lines on the bottom left side
of the screen and to 3 lines on the bottom right side of the screen. How do
I get everything back to one line?
First tell me why SP3 hasn't been installed yet and what other updates you
may be missing?
Note: Extended Support for WinXP SP2 ends on 10 July 2010. After that date,
computers running WinXP SP2 will NOT be offered any further critical
security updates, Automatic Updates will not work, and Windows Update
website will not be accessible unti...Outlook 2003/Lotus Notes Issue
I have been having this outgoing problem with receiving emails from Lotus
Notes. It seems to only be a problem when I got replies from a Lotus Notes
system. When I open up the reply, the only think I see in Outlook 2003 is my
original message and nothing else.
I have tried changing the format to HTML, Rich Text, Text, etc and still get
Are you using Outlook Connector for Domino?
"frequent_flyer" <firstname.lastname@example.org> wrote in message
> Hi All,
> I have been...Header's Date issue!!!!!
I have a problem with header's date on Excel 2000. On my
computer, the date that i have for the header is December
7, 2003. BTW, the date is typed manually. However, when
my boss open the excel document, the date on it is
November 7, 2003. We both use Excel 2000 and Window XP.
Does anybody know how to fix this problem? Any help would
If the date is really typed in manually as "December 7, 2003", XL
would have no reason/ability to change it. Are you sure your boss
isn't opening an old file?
In article <email@example.com>...mail merge issue
just got a new computer with 2007. Old system was 2003 on Vista
Do invoices and envelopes for the advertisers in our town newsletter thru
mail merge which is an .mdb file in Access. Somehow, it has decided that I
can only use 3 of the 86 entries in that file. Am able to get to the whole
thing in Access by overriding the security popup but can't get it useable by
other programmes. Pulling my hair out. What can I do to get "access" to
this information short of retyping it all over again? Can't figure how to
print it from Access either which would make it som...Exchange Server issue
Can an Exchange server be removed and rejoined to a domain without incident
or will attempting this turn my life into a living hell?
I have a strange issue that I can't quite figure out. My exchange server has
recently dropped off of the radar. I cannot see it when browsing the network.
It will reply to a ping and I can reach it using Remote Destop but it does
not show up when browsing the network nor from a run command using IP or
netbios name. Because of this I cannot back anything up on this server.
Wondering if I were to rejoin to the domain if that might help the issue.
I doubt ...Information Store issue #2
We currently have a 200 GB information and only 350 people. In 2 years
we will be 1500 people and I'm guessing that the Information Store might get
a little larger.
We currently have a 2 node cluster setup and I'm wondering what would be the
best way to increase availablilty without having to many servers. I also need
some ideas when it comes to fault tolorance.
Personally I think we should outsource it however, the powers that be want
it in house
what version Exchange? in Exchange 2000/2003, you can configure multiple
storage groups/mailbox stores to keep the size of the sto...Free Text Search issue ?!
SQL 2008 FTS
Why my FTS doesn't return the following data set while using like
select * from lo_text lt where lt.title like '%123%'
Q2 Mandatory Training 2010 (123)
select * from lo_text lt where FREETEXT (lt.title,'123')
Q2 Mandatory Training 2010 (123)
I also tried select * from lo_text lt where FREETEXT
(lt.title,'"*123*"'), but still no result
Thanks in advance,
Pat (firstname.lastname@example.org) writes:
> Hi Friends,
> ...Issues with Pivot Chart
I have a workbook with a pivot chart and a pivot table.. The workbook
contains the details about the sales made for that particular
assessment period. The Pivot chart sources the data from the data sheet
containing sales for all levels.. The chart has Chart fields for all
The issue is when one corresponding level is selected, the chart gets
updated to point to the data corresponding to that level. But the other
pivot chart-fields still have data pertaining to all the levels.. Its
fine as the chart points to the data sheet, which contains data for all
I...DPM 2010 Replica/Index issue
We are running into issues where there is not enoguh disk space for replicas.
Is there a way to change the storage location of replicas? There doesnt seem
to be a way to change the default location in the GUI.
You can either grow the disk allocation for the replica volume or
migrate the entire replica volume to a different disk with better speed,
disk space and also to reduce the number disk extents for the replica
volume. For this you can use the MigrateDatasourceDataFromDPM.ps1 script,
please find more information about it at:
http://technet.microsoft.com/en-us/library/dd...Dynamics GP Client Update Security Issue
Hi, I tried deploying the July Tax Update (.msp) via the Automatic client
Update tool and sadly failed...
When I enable the update at nex login my users (and myself) get the message
but after acknowledging it they immediately get the "infamous" "Not
privileged to open this form" message.
I have no idea what this for can be. I wanted to do a Dexterity Trace but I
have no way to start it before being loggued in. So I started recording a
macro, hoping it would tell me which form is opened but I don't seem to have
it in the macro.
Here are the lines:
# DEXVER...email issue....
i need to have a user send emails from account but i need to make it
look like the mail is coming from a different address.
the mail will only be going to a specific email address from this
for example it would be mail going from say :
going to : email@example.com
from : firstname.lastname@example.org (on behalf of user)
but really from : email@example.com
is this possible????
Posted via http://www.webservertalk.com
View this thread...Exchange 2007 coexistence routing issue.
I'm having trouble getting message routing to exchange 2003 servers
running in one of my sites.
I have Exchange 2007 installed in two sites and created one routing
group connector for traffic to and from Exchange 2003. Messages sent
from Exchange 2003 are delivered correctly to both my Exchange 2007
Mail from the Exchange 2007 site where the routing group connector is
homed to Exchange 2003 is also working correctly.
Mail within the Exchange 2007 'routing group' is also working
Only thing not working is mailflow from the other Exchange 2007 site
to Exc...bstr size issue
Is every char in a BSTR always 2 bytes? Does it depend on
BSTR is defined like typedef OLECHAR* BSTR;
OLECHAR is defined like typedef WCHAR OLECHAR;
WCHAR is defined like typedef WORD WCHAR;
WORD is defined liketypedef unsigned short WORD;
unsigned short always is 2 bytes.
So each BSTR element is 2 bytes.
Rodrigo Corral Gonz�lez [MVP]
>Is every char in a BSTR always 2 bytes? Does it depend on
My understanding is that a BSTR is always Unicode. Unicode is t...Money 2005 Upgrade via Download Issue
I currently am using Money 2002 and want to update to 2005. If I go
the download route is it the same as buying the CD version? If I go
the download route is there a potential problem in installing on a new
More or less after you get all of the download stuff. Yes. You have to keep
the same Passport forever and retain the trial version download to bootstrap
the process. Nobody knows how long you will be able to use that d/l to
bootstrap the process. Buy the CD. If you read posts here you will find lots
of problems with download purchase. The ratio to problems reported to the CD
purcha...Notes Connector alias issue not correctly mapping.
in our notes environment that we are desperately trying to transition
from we have many users with multiple "shortName" entries so when you
bring that across the "alias" field in AD looks like:
When this is turned into an email address by exchange it looks like:
I have been trying to get the mapnotes.tbl to convert
dspInternetAddress into Alias.
now the problem we have is that we have two mail systems sharing the
same Name Space so i need to be able to ensure that email addresses are
correct in ...Outlook Time Zone Issues and syncing to a mobile phone
I have read that 2007 is time zone sensitive. I have no problem keeping my
laptop on home time, but when I sync to my mobile phone, which is set to
local time, all my appointments on both the laptop and mobile phone are
adjusted. My problem is I travel up to 11 time zones in 24hrs. It would be
very difficult for me to add the appropriate time zone for each appointment
and even if I did the difference between the laptop and phone would still
cause problems. I enter the appointment (plane departures) in the local time,
no further adjustment is required by the computer.
Is there ...how to: multiple currencies in money pocketPC (MS deluxe 04)
I am using MS Money Deluxe 2004. I am going on a trip to another country.
I will have to exchange my dollars into another currency and I want to track
my spending when I am on this trip. I used to have Ultrasoft Money on Palm
505 and this was simply a matter of making a transfer entry from cash-USD to
cash-Euro on my Palm (upon which I would be asked for an exchange rate).
I have been given an iPAQ 1930 (PocketPC 2003) as a gift and I have
installed MS Money for pocketPC version 2.02 and have just discovered that
this program doesn't support multiple currencies. Does anybody have a wor...Need to decrease decimal places for an active currency ID
We currently have the JPY (Japanese YEN) set at 2 decimal places, but it
needs to be set to none. We already have transactions against this currency
is several databases (we have over 120 companies in MSD GP 10), so rebuilding
is not a good option.
Is there any way to force the reduction of decimal places (I'm assuming
update MC40200 set DECPLCUR = '0' where CURNCYID = 'JPY'), and what would the
The only way to do this is via SQL, then to perform a checklinks on all
Multicurrency table. However, not because you can means you sh...Send On Behalf issue #3
Hello - I have been reviewing the existing postings for this issue, but none
pertain to my issue. I have a user who can send as her manager, but she is
not set up to "Send As" this person. I have validated that in ADUC /
Security tab. She is set up to "Send on behalf" of her manager, but when she
places his name in the From Field and sends the message - it shows as only
coming FROM her manager.
I would appreciate any assistance you can provide.
OSF Mail Admin
Could she be getting her 'Send As' permission from a group membership? If
remove he...Security issue GP 10
We upgraded to GP10 this weekend from GP9. I am having trouble getting
security to work for a couple of payroll items:
Inquiry payroll - check history
Payroll reports - Groups - Employee list, Reprint Journals, Setup, Perod
End, Qtr End, Cross Company
Any help would be appreciated - we can't open the system until we get this
On Aug 25, 7:52 am, Deb Crabaugh
> We upgraded to GP10 this weekend from GP9. I am having trouble getting
> security to work for a couple of payroll items:
> Inquiry payroll - check his...Template issues
I am attempting to create a template that I can open and make changes to,
then save these under various filenames depending upon what edits I have
made. I have done this successfully on several templates but now they are
giving me some troubles.
Every time I create a new template and open it it asks me if I would like to
save the changes even though I have made no changes. I just want to be able
to open the document quickly and see if it is the correct one and close it
without having an annoying dialogue pop up.
I've tried narrowing down the issues and I believe it coul...XML ASP.NET 2.o Issue
I have the following code and I'm using News.xsl to read the XML file -
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
THIS PAST (myXml.Document) IS NOT WORKING IN ASP.NET 2.0
myXml.Document = getXML(nSource.SelectedItem.Value)
Function getXML(ByVal sourceFile As String)
Dim myRequest As System.Net.WebRequest =
System.Net.WebRequest....cells formatting issue
unfortunately I don't know Excel very well that's why you see this
message. Anyway I have a column of data with text of the type:
what I need to do is get rid of the 0 in front of each number (which is
formatted as text at the moment, I think).
So the result should be:
I need to convert thousands of these cells so I can't really do it manually.
I apologize if this is a silly problem, but please help me if you can.
Thanks a lot.
in B1 enter