Installation Help 04-27-04
I'm totally lost, i've got a windows advanced server 2003 up and running and i've got the latest Microsoft SQL installed and i'm trying to install Microsoft CRM however during the installation (early) i get the following error
Setup could not locate the specified SQL server. Verify that the specified server is a valid SQL server running with supported software. Only Microsoft Great Plains 7.0 or late is supported
I've been to the CRM website and i couldn't find reference there to me needing anything by the name of great plains 7.0 just the SQL server, can ...Muliple Entries in Access 07 fields
I have a very basic question (I think). In previous versions of Access even though fields could be set up to accept multiple entries it was not recommended. Is that still the case? If so could you elaborate on what problems it could cause?
Submitted via EggHeadCafe - Software Developer Portal of Choice
Professional XML for .NET Developers [WROX]
Actually, it wasn't possible in previous versions of Access (unless you're
talking about typi...Sumifs 04-06-10
I tried to do a sumifs for my simple spreadsheet but could make it works. I
have a table with EmpID column, Plan elem, and the weighted avg %, I want to
sum the weighted avg % for all the plan elem = 1 per empID. Note that one
emp have multiple plan elems. Please help...Thanks, MyLan
EmpID Plan Elem weighted avg%
1 1 20
1 2 10
1 3 10
1 1 50
2 1 30
2 2 20
2 3 10
3 ...Access 2007 02-13-07
I have a database created in access 2000. When using access 2007 the
database is very slow. Clicking on command buttons and tabbed pages. The
database has been converted to access 2007.
Thanks for your help
General descriptions get general suggestions...
Does your PC have the "horsepower" to run Access 2007 applications?
Microsoft Office/Access MVP
"Andy" <Andy@discussions.microsoft.com> wrote in message
>I have a database created in access 2000. When using a...Counting 04-26-07
I am having difficulty counting numbers within a very large table based on
The table is set as follows subjectname, q1a, q1b, q1c, q1d...q5e
Values for each question range from 1-5 and the field could be empty if no
response was given.
I have tried the something similar to the following and it is not counting
Select subjectname, count(iff(q1a=5 or q1b=5 ... or q5e=5, 1, 0))
group by subjectname
My desired outcome will be to display the total 5's, Total Responses for the
subject (count where the response is in 1-5), and from this I can calcu...CRM email router 04-04-04
I have the crm server,exchange and email router installed on one machine
But it's not clear to me how the email router should function
if i create an email activity in crm and send the mail to another crm user, everything seems to work fine, an activity is created in crm with a GUID and a mail is received on the recipients side
When i reply to this mail (using simply outlook), nothing happens? Should the router not intercept this (my CRMEmailEnabled flag is set correctly), is this because i'm sending messages between two crm users? or because i'm not using the sales client for ou...Report Problem 04-08-04
CRM was running on a virtual directory port was 79. But After getting the
back up I needed to format the machine. After reinstalling te machine I have
deployed the CRM on port 80. Everything is running perfect except te
reports. It says you do not have enough licenses.. Why can I have this error
Check all your crystal services are started. Also try restarting them.
Another more drastic way would be to rebuild the crystal database. If you
have access to partnersource there are instructions on how to do this.
"Alper Can" <email@example.com> wrote in message
new...Query Question 10-11-07
Let us say we have a table called GL with the following fields
DATE DEBIT CREDIT
Let us define balance as sum of CREDIT-DEBIT from a given start date. I
want the balance for every day from given start date to end date. How can
this be done?
Will this give every day or just the end date?
I want something that will output
Day 1 Balance
Day 2 Balance
Day 3 Balance
etc ... ... ...
day 30 Balance
"KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message
> Try this ---
>...Blank subform 06-14-07
** Mistakenly posted to General Questions originally. **
Please help me figure this out!
My user has a main client form with multiple job subforms.
On client selector's onNotInList event, the user is presented with a new
client entry form popup.
On closing the client entry form, the user returns to the main client form
(the new client) and a job (on the subform) has been started -- assigned an
ID number and the date entered.
The tables are related, cascading updates/deletes, one client-many jobs.
Here is code excerpted from popup new client entry onClose event:
Forms![frm1 Client]...Internet Explorer cannot display the webpage 04-05-10
I have a machine running vista basic and internet explorer 8. I am able to
open most internet pages. But when I click on a video the page that opens up
states "Internet Explorer cannot display the webpage" I tried opening it with
firefox and get the same. I tried opening it using my iPhone (Using the same
wireless network) and the page loads. Ive tried disabling firewall and
anti-virus, all to no avail. Please help!
"Jay125" <Jay125@discussions.microsoft.com> wrote in message
> I have a m...Conditional formula 04-20-10
Date Name Approved Total
12-Jan-10 John Yes $120.00
15-Jan-10 Mike Yes $50.00
20-Jan-10 John No $300.00
31-Jan-10 John Yes $80.00
02-Feb-10 Mike Yes $50.00
05-Feb-10 John Yes $180.00
Needs yr help to formulated how to find out the approved name with highest
(total $) for the month jan 2010. (expected result for above condition : Jan
2010 - John - $200.00)
I think this formula will do what you want...
Rick (MVP - Excel)
...Summary Report 04-11-10
I have a table that stores daily totals which user inputs in a form. I
created a report (with a parameter query) allowing user to input the beg and
end date for the report. The daily totals are summed and displayed on report.
My question is how do I create a summary report by month that displays
totals by months since I am not storing totals in a field in the table.
date Field1 Field2 Field3 Total (used NZ)
7/1/09 10 12 5 27
7/2/09 5 1 2 8
Total for the month would be:
On Nov 14, 7:48 am, "joaquim" <teixeira-...@tele2allin.be> wrote:
c'est le site anglophone, mais si tu as une question d'Access je peux
Operating System: Mac OS X 10.5 (Leopard)
Email Client: pop
Some of my email is received into my 'Deleted Items' folder instead of my Inbox. How can I change that? Thanks.
On 2010-04-19 23:00:07 -0400, firstname.lastname@example.org said:
> Some of my email is received into my 'Deleted Items' folder instead of
> my Inbox. How can I change that? Thanks.
99.99% of the tile it is due to a faulty Rule or Mailing list manager.
Review then very carefully, I bet the destination folder for one of
them is off.
Now this is a stupid question, but I don't understand so I must ask.
What is the point in trying to convert an application when you can take say
an ms access 2003 new db and export all objects from say ms access 2000 over
to 2003 and now you have 2003?
Explain why this does not complete the process?
Message posted via http://www.accessmonster.com
The end result of the two should be the same. What difference are you
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"Mell via AccessMonster.com" <u18304@uwe> wrote in ...Dates 06-18-07
My problem: I am trying to have one date minus another date. I want to
display the difference in days. Help!
DateDiff("d", [StartDate], [EndDate])
> My problem: I am trying to have one date minus another date. I want to
> display the difference in days. Help!
On August 1, 1996, Michael Johnson electrified the world by winning an
Olympic gold medal in the 200-meter dash with a time of 19.32, shattering
his own world record and capping one of the greatest individual track and
field performances in Olympic history. Johnson became the first person in
history to win both the 200 meters and 400 meters in the same Olympic Games.
These performances in front of an American audience highlight a decorated
career for Johnson, who will be competing in his third Goodwill Games in
1998. Some of Johnsons accomplishments include:
� W...Date and time 07-28-10
date and time are correctin properties but when saving files the save date is
"Duane" <Duane@discussions.microsoft.com> wrote in message
> date and time are correctin properties but when saving files the save date
> in 2007
I suspect you're looking at two different files: One that you just saved and
another file of the same name that you saved three years ago. If you post
full details of your testing procedure then someone can tell you more.
I try to use HookInterrupt function for ISR but build fail. I do not have
NK.lib . How to create Nk.lib ? NK.lib is necessary for HookInterrupt function?
How to use HookInterrupt function? Who have example?
I am create project by Vitual Studio 2005 (WInCE 6.0) platform x86
On 4/1/2010 2:33 PM, han-tf wrote:
> I try to use HookInterrupt function for ISR but build fail. I do not have
> NK.lib . How to create Nk.lib ? NK.lib is necessary for HookInterrupt function?
> How to use HookInterrupt function? Who have example?
> I am create project by Vitual St...qwe 10-26-07
I need to allow my users access to shared folders on my
local area newtwork from remote locations. How do I do
set us a RAS server. Also consider increasing your network security if users
are going to be able to connect to your network.
You need to go buy a few books on networking as this is a tricky area and
you need to get it right
"Dean Williams" <email@example.com> wrote in message
> I need to allow my users access to shared folders on my
> local area newtwork from remote locations. How do I do
> this...Pivot Table Help 04-05-10
I have 2 columns in my pivot table (Columns F - "% of total return $" and
Column G - "% of sales for 2009") that is taking information from column C
-"Net Return Dollars".
I've made the pivot table to make column A of the table represent the Return
Reasons and I've placed the sales numbers in a column of its own in the
source data, but no in the pivot table itself.
Here's the problem: I'm able to use the "% Of" function to figure out Column
F which is based off of the total in column C (by return reason). But, I'm
L3doYXRldmVyIHRvIHVzZSB0aGUgTVMgQ1JNIGxpYnJhcmllcy9jbGFzc2VzL...Windows Live Mail not responding 04-30-10
For the past month I get not responding when I try to open an email. I end
up having to close the program and reopen it. That does seem to help for
awhile, but it's really bad. Do you have any thoughts what could be causing
this problem? I'm thinking of uninstalling and reinstalling windows live
mail. I have a lot of mail in storage folders and I wondered if there is an
easy way to reload thiese folders. Any assistance would be greatly
Delete any problem messages in your acount(s) Inbox.
Perform a manual compact in WLM.
Open WLM(in mai...qwe 04-25-07