#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 ...Watch Accounts
I've set up a watch account to use as a model for an investing strategy I'd
like to try. In doing so, I want to be able to track theoretical purchases
and sales of individual stocks. I want to track sales and realized gains on
my Account Summary window, so I've customized my view to do that. After
entering a purchase, the stock shows up just fine on my account summary, but
after I sell all shares, it no longer shows up so I'm not able to track
realized gains. How can I get Money to continue to display the stocks I no
longer "own" in my watch account?
a w...Changing SQL Server for CRM 1.2
As my SQL server is currently on its last breath I am in the process of
moving our CRM 1.2 databases to a new dedicated serever. I have detatched the
databases from the old server, copied the files to the server and attached
I have then gone into CRM deployment manager and changed to the SQL server
to the new server.
That all appears to work fine, no error messages. But when users try to
access the CRM system they get an error and the CRM server event log fills
with error messages. A few are listed below:
dmLog: Failed to execute the SQL batch in the file sqlbatch.sql.
MSCRM P...Business Portal Error-SQL server does not exist or access denied
We are running business portal 4.0 for one of our customer. It was running
correctly, however, they have changed the SQL server port (previously it was
set as default 1433). After that the business portal becomes very slow and
while creating a new request (purchase requisition) if we open the item pop
up; it is showing exception
"SQL Server does not exist or access denied...."
Can any body tell me how can I provide the new port number to business
portal connection to the database.
Thanks and Regards,
Thanks for using the newsgroups. I have a...CFile (delete file)
How can I delete all files that end with ".temp" in some folder?
"Petar Popara" <firstname.lastname@example.org> 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" <email@example.com> wrote in message
>...Can't insert Char(1) into SQL Server from Stored Procedure
I am trying to insert a char(1) field into a table from an ASP.Net/C#
At first I was inserting rows into the table but none of the columns that I
was inserting the rows into were char(1) columns, they were mostly int and
Then I found out that there was one column in the list that was not supposed
to be an int column but instead it was supposed to be one of the char(1)
columns into the table.
So I replaced the int column in the list with the char(1) column and since
the value of the char(1) column resulted from a CheckBox ('Y...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...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...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 ...Excel Opens Without Displaying Workbook
I am having issues with opening an Excel file. The file opens, but the workbook is not displayed. I tried the resolution in the article XL97: Excel Opens Without Displaying Workbook (http://support.microsoft.com/default.aspx?scid=kb;en-us;158996&Product=xlw97), but neither of the resolutions fixed the problem. Any suggestions??
Are you using Excel 97?
Fort Collins, CO
>I am having issues with opening an Excel file. The file
opens, but the workbook is not displayed. I tried the
resolution in the article XL97: Excel Opens Without
Di...Converting Opportunity to Account
How do I convert an Opportunity to a Account? Thanks
This is not possible, opportunities are opportunities for existing
accounts/contacts. This is why when you convert a Lead to an Opportunity you
must select the potential customer also.
> How do I convert an Opportunity to a Account? Thanks
how would I select a potential customer? does this mean I have to create an
account for them as well? it wouldnt make sense since they may not ending up
being an account. thoughts?
"Dan Quinton" wrote:
> This is not possible, opportunities...OLK 2k7
Outlook is behaving strangly with the "through the selected account"
Each time I restart Outlook the rule fails. When I go in to check on the
rules I get told that the rule is "invalid". and the "SELECTED" account
is no longer selected.
Each time the criteria the account needs to be selected by changes.
For example with the following data
Account Name Email Account
One time I go in and it's asking me to select the account ...Setting up a new e-mail account
I'm trying to set up my yahoo account so that I receive
my e-mail messages in my Outlook Inbox. I went to
Accounts, and servers, and put in mail.yahoo.com for
incoming mail (POP3) and smtp.yahoo.com for outgoing mail
(smtp). When I click on the send/receive button I get an
Dave <firstname.lastname@example.org> wrote:
> I'm trying to set up my yahoo account so that I receive
> my e-mail messages in my Outlook Inbox. I went to
> Accounts, and servers, and put in mail.yahoo.com for
> incoming mail (POP3) and smtp.yahoo.com for outgoing mail
&...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...Receiving POP3 mail into Outlook without Send/Receive
I want the POP3 mail to be received into Outlook (If open) when the mail
arrives in POP3 account. Is that possible?
Set an Automatic Polling Interval.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, delanda asked:
| I want the POP3 mail to be received into Outlook (If open) when the
| mail arrives in POP3 account. Is that possible?
...Archiving Projects in Project Accounting
Has anyone found a way to archive closed projects?
...Associating Multiple Existing Contacts to an Account, Until CRM 2.x
I have racked my pea-sized brain for endless days for a way to associate
multiple existing contacts (or accounts) to an account.
My client has accounts that have many contacts (or accounts) involved at
different stages of acquiring a new account.
The logical method would be to add a custom attribute with lookup
functionality into the existing CRM contact or account objects but this is
not possible with CRM 1.x.
The resulting UI would allow an end user to associate different contacts (or
accounts) to an account. Example:
- AccountPhysician: (existing account or con...Money 2000 Account Balance Changed Inexplicably
Opening Money 2000, which I've used without problem since late 1999, I
noticed that my checking account balance was overstated by almost $2000! I
went to the register to see if there was a false transaction entered and it
appears that this balance change goes back years with no obvious single entry
being the culprit. When I run the "balance this account" function, it shows
that the closing balance from my last statement, which was correct and
rectified, is now also wrong and reflects the higher balance. What do I do
now? The only thing that I can think of is to restore...SQL View with Smartlist Builder
I am having to recreate Anyviews (GP8) into Smartlists (GP10SP3). Not very
Many of our Smartlist require the use of SQL views do to the limitations of
Anyview and now Smartlist.
It appears that I must create a separate Smartlist for each company I wish
to use my sql view with. Is there not a way to include a custom SQL view in
Smartlist, and have Smartlist use the company the user is logged into? The
view exist in each company database.
Can this be done with SQL Reporting server and DynamicsGP? Can I pull a
report based on the company db the user is logged into?
Thanks for the...I want to add a mail account without setting a SMTP server. Is it possible?
I want to add a second mail account that is outside my company.
Since the company firewall does not allow us to connect to SMTP-servers I
to add this account without setting the SMTP propertiy.
I cannot specify the company server as it is an Exchange server and the
outside one an IMAP one.
Currently I have specified the outside SMTP server since outook does not
allow me to add an account wihtout setting this.
I keep getting annoying error messages as my computer can't connect to the
Any one know a way around this?
The company server has SMTP enabled, u...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 ...Outllok 2003 reply with wrong account
Howdy - I have Outlook 2003. For some reason my new pc has started doing the
same thing as my previous one. I have 5 email accounts. When a person sends
me an email to my default account and I reply, it comes from another
account. In theory (and it did until the last couple of days) it should come
from the account I received the email in.... I change the smtp settings on
the accounts as I travel a lot, but other than that I haven't changed
anything that I know of to cause this - anyone had the same problem, or
better yet - know how to fixt it???!!!
Thanks in advance
...Outlook to SQL
The problem is this I'm trying to get my Contact list that was created on a
Exchange Server to a SQL table. How do I do this with keeping the Database
created in SQL up-to-date via Outlook.
See http://www.outlookcode.com/d/database.htm and =
http://www.slipstick.com/addins/groupcontacts.htm for tools to help with =
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"ErikSQLConfuser" <ErikSQLConfuser@discussions.microsoft.com...Re-enabled user account cannot log in
In trying to troubleshoot and issue in CRM where I had multiple user accounts
for a single ADUC user, I tried disabling and re-enabling a user's account.
But even after re-enabling the account the user cannot log in now. The error
message says that it is disallowed when he tries to browse to the CRM server.
Please help, I need to get this user account working again asap.
...Recommendations Please: Software That Can Backup Outlook While It is Open/Running
As the subject says. There are lots of packages that will backup the pst,
etc. once Outloook is closed, but some products claim to do it while Outlook
is open. Any suggestions on products that actually do this and do it
properly? If the product can safely backup over the network to a server and
can do incremental/update backups throughout the day, I'd really like to
hear about it.