Wrong message with cascading deletes
A2003: Table Person linked 1 X M to table Activity. The relationship has its
Referential Integrity checkbox and the Cascade Delete checkbox both checked.
When I delete a person all related Activity records are deleted which is to
be expected. According to
http://www.informit.com/articles/article.aspx?p=26115&seqNum=5 I should get
the following message in this case:
"Relationships that specify cascading deletes are about to cause 1 record(s)
in this table and in related tables to be deleted. Are you sure you want to
delete these records?"
In stead I get:
&quo...#Delete Mark in Bound Memo filed
I have form that has bound memo field, sometime, no sure how it happen, the
memo filed is filled with #Delete. My application is a stand alone program.
Kindly advise what can cause this and how to avoid it from happening.
When was the last time you performed a compact and repair?
Is you db split? Does each user have their own copy of the front-end?
http://office.microsoft.com/en-ca/access/HA011865661033.aspx - No very
helpful but directly from MS ...Problems with creating a newsletter
I chose the form "Newsletter - email".
I have created a 3 page newsletter. Now, I have NO IDEA how to send it out
as an email. I do not want to send it as an attachment. I cannot figure out
which "save as" format or what I need to do so that i can email this
newsletter. Is there a website that goes through how to do this?
Am I correct when I say that it has to be html in order for me to send it as
email? That is not one of the options.
Any help you give me would be greatly appreciated.
...Receipt not in Item Transaction Inquiry
I have a client that uses project accounting. They have received against a
purchase order. The receipt shows up in the Purchase Receipts Inquiry, but
does not show up in the Item Transaction Inquiry. What could be causing
...CFile (delete file)
How can I delete all files that end with ".temp" in some folder?
"Petar Popara" <email@example.com> wrote in message
> How can I delete all files that end with ".temp" in some folder?
SHFileOperation() will and it supports wildcards! DeleteFile() will operate
on one file at a time.
"Petar Popara" <firstname.lastname@example.org> wrote in message
>...Send to certain person using specific email account
I send an email to a certain receipient but don't want to use the
default email account.
Is it possible that when I send to them (plain text) , that it will
choose the other account I want to use to send it? Please advise how I
set this up.
I do not believe that this can be achieved automatically through standard
use of Outlook as you need to manually specify the name of the account to
send from if different than the default.
However, it would be possible using the Outlook object model. An Addin would
need to be developed that monitored each mail item prior to sending. If the
d...Resolving Email Address to existing contact problem
Has anyone else come across this issue in MSCRM3.0? - when you attempt to
resolve an email address to an existing contact in CRM (that does not
currently have an email address stored in their details) the contact resolves
OK but does not update the email address in the contacts details.
Is this by design, or have I found a bug?
...Need Help with Deleting Empty Paragraphs in Word 2003
I have written the code below to delete all empty paragraphs at the end of a
document and then place the cursor at the end of the last paragraph.
It works fine as a stand alone sub in a new doc, but fails inside the real
document that contains other code that manipulates several documents.
The failure is that it will delete the last empty para, but then gets stuck
looping inside the While...Wend because subsequent .Delete are not happening.
So, the question is why would this work in one document, but then fail in
n = 0 ...HELP Recovering addresses and email from Outlook 2003
I had some serious driver issues that required re-installing XP from
disc. I did use the backup option and have a backup of all the old
data. And of course had to reinstall Office 2003.
Will third party software restore my old email and addresses or am I
out of luck?? Thanks for the help
> I had some serious driver issues that required re-installing XP from
> disc. I did use the backup option and have a backup of all the old
> data. And of course had to reinstall Office 2003.
> Will third party software restore my old email and addresses or am I
> out of lu...Offline folder problems #2
Basically I installed Outlook 97 on my office PC which is
connect to microsoft exchange server.
For some reason all of my messages were copied into
offline folders, this causes a problem, whenever I open up
outlook I get this message.
Upload of offline changes could not be completed you do
not have sufficient permission to perform this operation
on this object. See the folder contact or see your system
I do not administrator access on my user profile, every
time I open outlook it resets everything I have changed
(view etc) and gives that error message. How ...Public Folder link to Excel File
I have a user that claims that he had a shortcut to a spreadsheet "in
his public folders" at his old job. Obviously, he's an end user that
may or may not know what he's talking about.... I'm trying to figure
out the best way to accomodate him.
He basically wants an Excel file stored on a shared folder to be
available to all user as either a shortcut, or a link in the public
folders (can't post to a folder as he will be updating the sheet
regularly). When a user clicks on the shortcut/link, it would just
launch Excel and display the file.
Anybody have any ideas...Where is the cache files folder located for windows media player?
Does windows media player have a cache files folder? Where is the cache
files folder located for windows media player? Or how do I find the cache
files folder for windows media player?
Thank You for your Help.
Background info: I have a desktop AMD 4400+ 64X2 4GB memory 320GB HD(way
bigger than I need) Acer computer (AM3100-U3201A) I purchased new February
2008 running 32-bit MS Vista Home Premium SP2 box. I use MS auto updates.
I think it has onboard shared memory for video and sound. My ISP is Comcast
12mbps with Motorola SURFboard SB5101 Cable Modem direct to...Corrupt "Deleted Items" folder
I am unable to empty the "Deleted Items" folder. The
error that comes up tells me that the "Outlook.pst" file
has errors in it and to use the "Repair Inbox Tool".
I've tried using the repair function under the "help"
menu...to no avail.
I have also tried opening the "Outlook.pst" file in MS
Word, but the file is 129 megabytes! It crashes MS Word
when I try to open it.
Look for scanpst.exe on your local drive and run it
against your outlook.pst file
>I am unable to empty the "Del...Multiple copies of email in "Forward to"contact
I am running Exchnage 2003. My CEO has a conatct in our organisation that
refer to his blackberry contact. I have set the forwarding to also keep a
copy in his mailbox.
What happens is that three copies of his forwarded email hit his blackberry
account! Only one hits his internal mailbox.
What I ahve determined is that the front end Exchange server seems to be
creating the additional copies. Is this how its meant to be (don think so cos
its such a nuisance and my CEO keeps complaining about it).
How do I tell the front end server that this guy's mail server is the one
that...Help me identify my missing permission (Cannot open public folder) -2147217843 (Maybe Authentication Fails?)
The following snippet of code throws an error number -2147217843. When
I googled this error code, I see many references to authentication
failed. I am assuming my problem is some kind of permission related
problem on the "MyNewFolder" public folder.
-- start code ---
Dim objFolder As New CDO.Folder
Dim f As ADODB.Field
'sURL is like: file://./backofficestorage/mydomain.com/Public
objFolder.DataSource.Open sURL, , adModeReadWrite, adFailIfNotExists
--- end code --
I have code that runs before this that actually creates the
"MyNewFolder" publ...Sending Email #6
When sending e-mail I heep getting it bounced back with
the following message;
Your message did not reach some or all of the intended
Sent: 1/12/04 4:34 PM
The following recipient(s) could not be reached:
'name' on 1/12/04 4:34 PM
553 sorry, that domain isn't in my list of
allowed rcpthosts (#5.7.1)
Why does this keep happening? Receiving e-mail is not a
Generally, this error message means that the email address to which it
refers is not accurate. Go to your address book and carefully check the
spelling and ...Report to show Item Class Distribution Amounts
We would like to create a report, using Crystal Reports, that would show the
following: dollar amount break down of the Sales Distribution accounts (COGS
and Sales) per item class based on a date range. What is the most accurate
way of going about this? We could only think of this method: (in short) sum
the Ext Price based on SOP30300.CSLSINDX and SLSINDX and hope it matches the
SOP10102 summed distribution amounts. Any advice would be appreciated.
Thanks in advance.
With the SLSINDX you would use the Extended Price and the CSLSINDX you would
use Extended Cost. You would probably ...Creating a Macro to Delete Commas #2
I have an excel file that the size will varry. I need a macro that will
check all the fields for a comma. If there is one I would like to get
rid of it. Does anyone have any idea how to do this? I have no idea and
I have been assigned this task.
Message posted from http://www.ExcelForum.com/
No macro required.
ctrl-H for find/replace. find , replace nothing (leave the
replace field blank). You can of course record that within
a macro if you wish.
>I have an excel file that the size will varry. I need a
macro that will
>check ...automating email marketing with workflow in CRM 4.0
I am attempting to prepare a client demo that demonstrates some of the
features of Microsoft CRM 4. The potential client is a staffing
agency, and I have spent some time thinking about how they might use
Here is a business process I have thought up that, if I could get it
to work, would be great to show at a demo.
1. An account calls about an opportunity. The opportunity is
entered. The opportunity has certain skills attached to it, such as:
SQL Server, Linux, C#, etc
2. Contacts (candidates) also have certain skills attached to them,
such as: SQL Server, Linux, C...Workplace Queues
We just rolled out CRM a few weeks ago. I'm getting a lot of complaints from
the users about the thousands of items showing up in their My Work\Queues\In
Progress folder. When I look at my own items, I have about 1000 activities
showing in my In Progress folder but when I open them up most of them are
owned by someone else. According to the Help description of this folder,
only items that I have accepted should show up in my In Progress folder.
I've never accepted anything, so I'm not sure anything whatsoever would be
showing up in this folder. We used Scribe to import ...Right clicking on a CListCtrl item
I have a TreeCtl object in a dialog box. I created an OnNMRclick.. override
function to capture a right clicks. The problem I can't figure out is how to
find the tree item that the user has right clicked on.
Here's what I tried:
void CRestoreFiles::OnNMRclickXYZ(NMHDR *pNMHDR, LRESULT *pResult)
lpht.pt = CurPos;
RightClickItem = TreeView_HitTest(pNMHDR->hwndFrom,&lpht);
I figured that GetCursorPos would give me the position of the cursor where I
had right clicke...With and import tool can you change only item description?
Is there a way to change only the item description on a large quanity of
items. What about the extended description? Thanks for your help.
Use the MS SQL Data Import Tool by EMS. $65.00. The QSImport Tool available
to download from Microsoft will probably work but is not supported by
Kinnard L. Kohler
Business Machines Systems
6101 South Shackleford Road
Little Rock, AR 72204-8606
> Is there a way to change only the item description on a large quanity of
>...item class table
I am creating SOP IM import. I need to fill the distribution fields with a
rev account that is part of the item class. I would like to find a table that
would hold the item class accounts. I looked in IV40400 and did not see any
distribution accounts. What is the best table to pull these accounts.
If the accounts have been defined on the Item Class, they will appear on the
records in the IV40400 table. They're in the fields IVIVINDX, IVIVOFIX, etc -
and they're just the keys to the actual account definitions in the GL00100
If a particular account type isn't defined ...CRM Email Displays Size=2>
One of my users is experiencing an issue when they save an email that is
tracked within CRM the email displays in CRM with "Size=2>" directly in front
of certain lines of the email. So for example "Size=2>" will appear in front
of someone's comments in the email or in front of their name. Does anyone
know why "Size=2>" is displaying in front of the lines of an email? Thanks.
"Mike H." wrote:
> One of my users is experiencing an issue when they save an email that is
> tracked within CRM the email displays in CRM wit...Email cannot be resolved...
When you send an e-mail message from an existing Microsoft Business Solutions
CRM contact, the e-mail address does not resolve to the contact record. When
you view the e-mail message in Microsoft CRM, you receive the following error
The sender's email address could not be resolved to a record in the system.
At least one recipient could not be resolved to a record in the system.
There is a KB article with a hotfix that addresses this issue for CRM 1.0 -
has anyone had this problem in version 1.2 and been able to resolve it?
I experience the same problem, though it ...