cannot modify linked tables in A 2003
In a front-end/back-end application created in A 2000 I
cannot modify or add data in the linked tables if I open
the front-end in A 2003. In A 2002 everything still
worked fine. Refreshing the links using the linked table
manager does not solve the problem.
Who has experienced the same problem and found the
Try adding a primary key in the back-end database and then refresh the
...How do I set up a chart to only chart values greater than 0
I have a chart in Excell that I would like to only have chart those items
with a value of greater than 0 (zero). Not sure if there is a better, easier
way than having manually manipulate the data.
Let's say the values are in B1:B20
In C1 enter =IF(B1>0,B1,NA())
Now use column C for the chart; the displayed #N/A values will be ignored by
the chart engine
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"debra49424" <firstname.lastname@example.org> wrote in message
news:A513E053-4AD9-44FE-952E-E9A60F49...Will excel 2003 format a cell to the year?
It seems like it should be obvious, but I am finding it impossible to
get excel to do a date format that recognizes a year. Is there some
I typed a date in A1 (09/28/2006)
and used format|Cells|number tab|custom category|yyyy
with my USA settings.
> It seems like it should be obvious, but I am finding it impossible to
> get excel to do a date format that recognizes a year. Is there some
...How to create email template for campaign response in CRM 4.0 ?
I am trying to create a workflow to send email (using a template) after
create a campaign response but it fails ( Show "invalid Argument" error ).
I have also tried to do the same workflow for campaign and fail too. Is CRM
4.0 not supported using email template to send mail thru workflow ?
Thanks for help !
...Outlook 2003: Links cannot be viewed
Hyperlinks in messasges are not functioning properly.
Instead of taking me to a website, etc., when I click on
a link, a dialog box appears asking me to save the file
as an executable. Any clue on how to get hyperlinks in
Outlook functioning properly? I have already performed
a "repair" from the Office installation CD to no avail.
Thanks in advance!
...GP8.0 Upgrade Problems
I am trying to upgrade a test server to GP8.0 SP3 from GP7.5 SP6. I
have run into several issues, and although I have resolved some of them
(i.e. can't have IDENTITY column in any tables that's not named
DEX_ROW_ID), there's a few I am still having trouble with. I am
installing GP8.0 into a separate directory on the server.
1) When I run the Perform Special Upgrade in GP Utilities after
installing SP3, I get a "Invalid column name DAYTOEXP" error. Looking
at a SQL profiler trace of this, I can see that it is failing when
recreating the IVR10015 table. I checked our live ...CRM 3.0 Tax Calculation
I tried to automate tax calculation for the Quote Product form (can also be
the Order- or Invoice Product form, principle is the same) in an onChange
event, simplified like this:
crmForm.all.tax.DataValue = crmForm.all.baseamount.DataValue * TaxRate;
The problem is that the field crmForm.all.baseamount.DataValue is updated
after a Save or SaveAndClose, so after a possible onChange event.
Also using the onSave event of the form does not work, the
crmForm.all.baseamount.DataValue is calculated or updated after the event (?).
Question: How/Where are the fields crmForm.all.baseamount.DataV...Accounting format for 0
I have had the same problem in both Excel 1997 and Excel
2000. I always use the Accounting format which gives a
dash for a 0. However, every once in while I will get a 0
instead of a dash. When I do that I extend out the
decimals and way out there are some numbers. I always
check to make sure that any formulas I have either round
or are from whole numbers so there is no possibility of it
being a rounding problem. I think it's probably a glitch
in the Excel program, but I haven't talked with anyone
else who has encountered this. Mainly I think because
most people don'...Copying from 2007 (past 65Kth row) to 2003
Fill in 4 cells in 2007, A300000:B300001, putting in the values
1,2,3,4 to easily identify them. Select and copy the (square) range of
Open 2003 and paste to cell A3.
Interestingly, only the contents of (2007's) A65536:B65536 will be
pasted to 2003's cell A3. (or any destination in 2003). To verify, put
=row() & "C" & column() in A65536:B65536 and repeat.
Was this patched or something...or do you duplicate the behavior?
Same machine with dual 2003/2007 installation. 2003 is version SP2. I
can't tell you with my 2007. (Yes, that's right. 2007's...Trying to get a blank cell presented if B26=0
IF B26=0, how do I present a blank cell in another place, or put an amount if
not true. I have used =IF(B26=0,0,Sheet1!E2) , but I get a $0.00 figure
which I do not want. Even I if I used a blank cell for the true portion, I
get then same $0.00 figure.
I get the right amount for false. I am preparing an excel program for a
small plowing business.
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
Does anyone w/ experience in both CRM v1.2 and v3.0 know if the standard
reports in v3.0 are the same (if not better) as what was in v1.2? Were any
left out of v3.0 that were part of v1.2?
The standard reports are very different. From memory, there were about 120
reports in CRM 1.2 - there are only about 20 in CRM 3.0. Also, Crystal
reports is no longer the reporting engine - Microsoft have moved to SQL
Reporting Services. If you're doing an upgrade you can still use the old
reports, as long as you have a licensed version of the appropriate CR
"RE&qu...CRM Version 2.0
I see several features that I'm looking for are planned
for version 2.0. Can anyone tell me when this version is
due to be released?
ETA Q1 2005
San Francisco, CA
>> Other Microsoft CRM Online Forum Resources:
>I see several features that I'm looking for are planned
>for version 2.0. Can anyone tell me when this version is
>due to be released?
Latest "hope for" date is Q2 2005, however that is not a set date...
"Terri" <anonymo...Clicking web links in Outlook 2003
In O2K, clicking multiple web links (inside the emails) re-uses the same IE
window. In O2K3 this opens an IE window for each link clicked.
Is there any way to get O2K3 to behave like O2K?
...Regarding bluetooth HFP support on Wince 6.0
Thanks in advance.
I am vinayakumarc, i have developed bluetooth application on wince 5.0 with
Navready patch installed previously.
Now i want to port the same application on the Wince 6.0, is it possible?
Does Wince 6.0 support Bluetooth Hands free profile & PBAP?Which version of
BSP should i use? 1.4 or 1.5.
...Great Plains integration to CRM 4.0
does anyone know if there is integration of great plains with crm 4.0? we
have crm 3.0 integrated to great plains 8.0 and want to upgrade both.
There is no Microsoft connector yet for CRM 4 and GP. There is one for CRM 3
and GP. Other options are to use
• some third party tools like Scribe
• or use Microsoft BizTalk
• or do custom Programming.
uMar Khan :: MS CRM MVP
Microsoft CRM Consultant
Email :: imumar at gmail dot com
Blog :: http://umarkhan.wordpress.com
MVP :: https://mvp.support.microsoft.com/default.aspx/profile/umar.khan
> does an...How to migrate data from Act!9 to CRM 4.0
We just a new customer who is using Act!9 now. We need to move data from
Act!9 into CRM 4.0. The data includes contacts, notes, history, activities of
It is easy to use DMM of CRM 4.0 to import contats. But there is no
exporting for notes, history, activities of Act!.
Now looks I have two choices,
1. use a 3rd tool to export ACT!9 notes, history, activities, import into
CRM by DMM.
2. use Scribe to do it
for option 1, anyone knwo which tool I can use for ACT!9?
For option 2, which Scribe part I should buy? how to use it?
I'd use Scribe's 45-day license for ...format of go to cells
using excel 2007, using find-go to special formulas, the shading on the
formula cells is the lightest blue and very difficult to see. Can I change
this fill color format?
Unfortunately I don't think you can.
There have been a lot of complaints about shading of cells in XL2007.
"Charlie Woll" <email@example.com> wrote in message
> using excel 2007, using find-go to special formulas, the shading on the
> formula cells is the lightest blue and very difficult to see. Can I
> cha...Prefiltering CRM 3.0 Reports
I'm hoping someone can throw some light onto this one!
I have a CRM 3.0 installation running on a Windows 2003 Small Business
Server with SQL 2005 and reporting services (2005).
I create a report using Visual Studio 2005 and the Report Wizard, to
list all of the active accounts. I upload the report using CRM. The
report runs fine, until i want to filter it.
So, back in Visual Studio i create an alias CRMAF_TableName. And
re-upload the report. The report still runs, but it will not let me
filter the report.
I could do with filtering the report. I read somewhere that i might
ne...Problem showing full category list after upgrade from Money 03 to
I just upgraded from Money 2003 to 2007.
When I select : Microsoft Money Settings -> Category settings -> Show Full
I receive the following error message:
Money encountered an error and must cancel this operation. Please try again
Is there any way to find out more about what is going wrong?
...3.0 client crashes when going offline?
this user hasnt had any problems since we implemented 3.0 about a year
ago. they are using Office 2007 with the 3.0 client in offline
A couple days ago they ran into a problem where it crashes when trying
to go offline, it gets to "waiting for offline database initialization"
and then crashes outlook.
Have you verified that the localo SQL instance is happy and checked the event
> this user hasnt had any problems since we implemented 3.0 about a year
> ago. they are using Office 2007 with the 3.0 client in offl...Outlook 2007 cut and paste double spacing
When I cut lists from a text file I use and paste them into the body
of an Outlook message, the list becomes double spaced. I have to
highlight the text and then use the single space format button. Is
there a way to paste the lists in without them being automatically
double spaced? Thanks, K
Are you pasting into a double spaced or single spaced message? Which paste
option do you use? as text should use the spacing of the paragraph you are
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://...CRM 3.0 Campaigns
Can anyone point me to a detailed article highlighting the steps/
functionality of a how to create, deploy, manage, a CRM Campaign? I
have looked but most articles just talk about possibilities without
any groundwork on how to get there.
maybe this will help:
Castor Advanced Solutions
> Can anyone point me to a detailed article highlightin...How do I link to an Item within a Public Folder in MS Outlook 2000SR-1?
Title says it all.
Remove MAPSON to reply to me directly.
This post represents the views of the author and does not necessarily
accurately represent the views of BT.
...Upgrading MS CRM 3.0 to MS CRM 4.0
We have an MS CRM 3.0 setup and running well for quite long time. We would
like to upgrade it to MS CRM 4.0.
Current setup is,
1. Lot of reports added & customized for user needs
2. Lot of entities added & customized for user needs
3. Lot of forms added & customized for user needs
4. Lot of custom developed pages added (developed in ASP.NET 1.1). Of course
it's running on separate site but integrated inside the MS CRM 3.0 (so
typically used MS CRM 3.0 service calls)
5. Lot of Stored Procedure's & View's added
6. Customized the settings based on user needs
My do...Second GAL won't show up in OUTLOOK 2003
I run exchange 2003, upgraded from 5.5.
1 Information Store, 1 Server.
I have 1 Global Address List.
I have created a another one, but it wont't show up in the OUTLOOK under
drop down menu next to Global Address List.
I have waited for like a week for it to update and also run RUS.
What could be the problem?
As far as I know a user onlt gets one GAL. You can control which one they
get, but I don't believe you can make multiple ones available.
"HHRP" <HHRP@discussions.microsoft.com> wrote in message