I'd like to see all customers but only transactions since 5/1/10.
I have a query like this, but I'm getting a record for each Customer.
ARINH is a table for the transactions.
SELECT Customer.AcctNo, ARINH.Date
FROM ARINH RIGHT JOIN Customer ON ARINH.CustId = Customer.Key
How can I change it so some results in the date column would be null. They
Thanks for your help.
"SAC" <firstname.lastname@example.org> wrote in message
> I'd like to see all custome...BSOD After WinXP Install
I have a new HP 311-1000NR netbook, which came with WinXP Home
in english installed. I have been trying to re-install WinXP in
known working CD. The install fprmats the disk and proceeds through
install phases/reboots, apparently correctly. But when rebooting the
third time into what would notmally be the configuration phase, the
boot stalls at the WinXP slider screen, then does BSOD, reboots,
Attempt to boot into safe mode - same result - partial boot, BSOD,
reboot. In each case after BSOD the reboot starts so fast I can't get
any error ...winxp
Je vous propose ce lien:
Mon blog perso
...Multiple Joins in DataAdapters
I have a second question related to my previous post subject: Mapping Nested
XML to Relational Tables
The XML document which loads into the dataset must then be stored in
relational tables and recalled later. As mentioned in my previous posting,
the document is fairly complex and requires over 20 tables to store the
Is it necessary to create 20 DataAdapters to store and recall the document,
or can it be done with one DataAdapter containing multiple joins? Each XML
document represents one record in the dataset and records must be added,
recalled, and sometimes deleted from the...Not able to save changes to system settings
I have 3.0 with sample data. My issue is that I'm not able to save any
changes to the system settings. I have SA right. Any idea? Thanks.
This is normally caused by a incorrect SQL Reporting Services setup. Check
that your SRS Server is working, check that srs's url is well configured at
deployment manager. And if it doesn't solve the problem you should read this
> I have 3.0 with sample data. My issue is that I'm not abl...xyScatterChart macro works on WinXP Pro & not on WinXP Home?
I have a ScatterChart macro that works perfectly with Excel2000 on my Win XP Pro
computer. I select two columns and click on the macro and the xyScatterChart is
When I moved this exact same code to my new Laptop with Excel2000 and WinXP
Home, the macro would not produce a xyScatterChart but produced a double line
chart with two lines(two sets of points) for the selected two columns instead of
I can't figure out why the code below works on my WinXP Pro desktop and not the
same on my WinXP Home laptop.
Thanks for any help.
====myScatterChart Code==...Terminal server install domain problem help please
Hi everyone, this is my setup
windows 2003 sbs acting as domain controller, exchange, microsoft crm ect
windows 2003 standard acting as a terminal server and member server
I had a problem with folder redirection which works fine but i manually had
to give permission to each individual on the sbs server to the folder
redirection folder, is this normal? seems cumbersum
My problem is i have install microsoft crm on the 2003 sbs and now i am
trying to configure access via the outlook client on the terminal server but
i can only get it to work for the administrator. i noticed under the term...Need to reinstall WinXP
I'm planning to reinstall Windows XP Home on my system as there are
currently too many conflicts and speed problems. The last time I did this I
seem to remember that I misunderstood the procedure I should follow to make
backups of all my Microsoft Outlook data - and so I ended up losing all my
appointments, reminders, tasks - and many, many important emails.
So, instead of making the same mistake again I was wondering if people here
would be able to offer me advice on making sure I (a) save all my Outlook
data and (b) successfully import it into Outlook again when the reinstall ...Replicated account for a different domain
Hard for me to figure out how to properly ask this question.
I have a user on an Exchange 5.5 server. They want to use a WM5 device now.
We have a 2003 server for another domain in the company. We may eventually
migrate all their mailboxes to the 2003 server but it will be a couple of
I was thinking perhaps we could use some sort of rule to continuously copy
all their e-mail, contacts and calendar onto another e-mail account so they
could at least get real time data on the PDA. Perhaps there is a way to set
up just one e-mail address of the other domain on this exchange...Multiple installations in one Domain?? MS CRM 1.2!
we have the following problem:
We need a MS CRM of 1.2 server for some tests.
We had installed a 1.2 Server in former times. We have since deinstalled the
Now we wanted to install CRM on another server. But MS CRM 1.2 wants to
start the services of the first server. We have problems with the access to
the ActiveDirectory. But we have all rights!
A tried Redeployment breaks off while connecting the IIS.
I responded on the crm sandbox site.
Microsoft CRM MVP
"...encryptet Mail is no able to open... (XP)
If i try to open an encryptet mail, i get the password-
inputbox. but nothing happens.
if i save the password, nothing happens either! and after
i saved the pw and klick on to another encryptet mail it
but i want to open it without saving the password!
has anybody had this problem before?
Does WinXp sync it's clock to some outside resource if it's available?
I downloaded an atomic sync software. Found my clock to be about 5 minutes
off. Synced it and scheduled it to be synced every hour. It's now about 15
minutes later and it's off by 5 minutes again. Historically, evidently, it's
always 5 minutes off which makes me believe it is syncing with something I'm
not aware of. How do I troubleshoot this?
The system clock is losing time or not keeping time accurately.
...Need to be able to just click on the check box to check
I have a form that I am working with and need to check boxes by just clicking
on the check box. How do I make that the default mode instead of the not
checked box the default mode.
If these are check box form fields, the document must be protected for them
to work the way you describe.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"warden" <email@example.com> wrote in message
>I have a form that I am working with and need ...WinXP password
I recently decided I needed a password
to protect XP. As administrator, I went to
Ctrl Panel/User Accounts and entered
a password and confirmed it.
Since then, nothing has changed when
I start my WinXP Home/SP3. It's as
though I had never made the change.
Have I missed something?
In the Start menu Run box enter CONTROL USERPASSWORDS2 and then toggle
the "Users must enter a user name..." setting.
Jim Cladingboel wrote:
> I recently decided I needed a password
> to protect XP. As administrator, I went to
> Ctrl Panel/User Ac...Only Administrator can send mail to certain domains
Since installing a new Exchange Server (Exchange 2003 w/ SP2 on Server
2003 w/ SP1) we have been unable to send mail to certain domains. And
it looks like those domains are also using Exchange Servers. Today we
found that emails sent from the Administrator account go through OK but
all others do not. The return failure messages vary but predominately
we rec'v the message that the email could not be delivered in the
I've checked the usual suspects - checked Reverse DNS, telnet
succesfully to their mail server.
What does the Administrator's ability to send and ever...WinXP SP2 and VC6
As is known, the service pack 2 of Windows XP has introduced some
restrictions for RPC interfaces. For RPC applications to work properly,
code has to be modified; one way is to register an RPC interface with
the flag RPC_IF_ALLOW_CALLBACKS_WITH_NO_AUTH. This flag is defined in
rpcdce.h in VC7 - but I could not find it in VC6. What is the way to
make it work in VC6?!
My first idea was to copy the definition from VC7'2 rpcdce.h into my VC6
code - that works indeed, but I do not really like it - it has such a
Anything known here?!
"hs&q...TD Banknorth: Is anyone able to connect with Money?
On 5/23/2005, Bank of New Hampshire and the other Banknorth divisions
changed their names, web addresses, etc. to TD Banknorth.
Since this happened, I've been unable to connect to my accounts. Money is
still trying to connect to https://secure.banknorth.com instead of
https://secure.tdbanknorth.com, which is causing Money to get an
"index.html" error page instead of an OFX response.
Intuit warned its users of the upcoming change over the weekend, and Quicken
users were able to update their online banking details when the change went
through on Monday.
The only change I&...domain controller 01-25-06
The following is a quote from CRM3.0 Implementation Guide:
"Microsoft CRM Server must not be installed on a Domain Controller."
CRM3.0 should be able to run on an SBS, which system, normally, is a DC, as
well. Has anybody installed and run CRM3.0 on a DC?
The quote should really state "Microsoft CRM Server must not be installed on
a Domain Controller, with the exception of SBS 2003 when it is fully
CRM3.0 is designed to run on SBS 2003, just as CRM 1.2 was designed to run
on SBS 200 or 2003
I have an older Windows 2000 machine. I am attempting to upgrade to XP.
I do not have the password to log onto the machine and can not get it.
I have the XP disk and when I attept to boot from there it stalls at "Boot
from ATAPI CD-ROM :".
And and all suggestions on how to get past this would be appreciated.
"pjhjones" <firstname.lastname@example.org> wrote in message
> I have an older Windows 2000 machine. I am attempting to upgrade to XP.
> I do not have th...Adding Individual Mulitple Domains to Active Directory
We are a simple single domain using 2003 Server. Our company is now merging
with several other companies. Using AD how do I add domains of the other
companies and yet have each domain be separate from the others? For example
our domain would be xyz.com, now I need to add abc.com to our AD. I don't
want to have abc.xyz.com - I want them both to be separate but using the same
AD. I'm told there is an article in Microsoft on how to setup multiple
domains in a single AD environment but I haven't found it yet.
Could I not use the current DC that houses our AD? We don'...Install Agent on other domain
I have a problem installing DPM 2010 RC Agents in other domain.
Here is the scenario:
I have Domain1 and Domain2 ,and they have trusted relationships.
My DPM 2010 RC Server is installed on Domain1.
When I try to install the agent to a computer with Windows 7 in the other
domain it fails and show me this message:
Unable to connect to the Active Directory Domain Services database.
Make sure that the DPM server is a member of a domain and that a domain
controller is running. Also verify that there is network connectivity between
the DPM server and the domain control...domain issues w/ ActiveSync
We have a Forest w/ 2 trees with one domain in each tree.
Exchange is setup w/ 2 Admin Groups (one server in each domain).
When a user sync's using ActiveSync from the Root domain (company.com),
everything is fine.
When a user sync's using ActiveSync in the other domain (company.co.uk),
they get ERROR_500 unless we add an additional SMTP address to their account
from the root domain. In turn, they need a "company.co.uk" email address as
well as a "company.com" email address.
We're trying to not do this, but if we do not, they cannot sync. We just
want th...control works fine in win2k,but fial to run in winxp.IE throw a er
control works fine in win2k,but fial to run in winxp.IE throw a error
I develop an activex control using vc6(sp6).I pack it in a cab and refer
mfc42.cab in the inf file.It can be downloaded to client when the client OS
in win2k and works fine.It also can be downloaded to client when the client
OS in winxp,but fail to run.IE6 throw a error dialog box,show following :
AppName: iexplore.exe AppVer: 6.0.2800.1106 ModName: mfc42.dll
ModVer: 6.0.8665 Offset: 00003922
and then send error to microsoft,then shut down.
I need you help.Thank you very much .
...Am I able to manage multiple email accounts
I have several email accounts including Gmail, HOtmail and corporate. I can't make Entourage mail (2004) list individual accounts or find how to manage profiles. Apple mail works but doesn't allow me to insert a tiff company logo without making it an attachment. Outlook allows for all of the above.<br>
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
On 2/7/08 1...Installed fonts in WinXP but don't show in any Office program
I've tried all the suggestions given in here (TweakUI, resetting printer,
etc.), but NONE of those worked. I have 585 fonts in my Windows font folder.
Does Office have a limit on the number of fonts it will display in the drop
down Font box?
In article <B4E90712-7D9E-4575-915C-3DA41C745442@microsoft.com>, JeffH wrote:
> I've tried all the suggestions given in here (TweakUI, resetting printer,
> etc.), but NONE of those worked. I have 585 fonts in my Windows font folder.
> Does Office have a limit on the number of fonts it will display in the drop