In a form I created a button, used the wizard to set it to go to next
record when clicked. When I click it, I get this:
The expression ON CLICK you entered as the event property setting produced
the following error: Ambiguous name detected: PRINT_CLICK.
Now, if I wrote the VBA/Macro, I could understand it not working if I made
a mistake, but this button was generated by ACCESS and doesn't work.
Same problem with Previous record button and Save Record button.
Thanks in advance,
On 13 May 2010 16:00:59 GMT, Vito wrote:
> In 2007:
> In ...Authentication mode
Currently I have installed the MS CRM 1.2 Server on a server that host
another application(sharepoint portal server & project server), this
application requires SQL Authentication for work,but CRM requieres Windows
Authentication Mode; at least the CRM implementacion guide document
recommends this type of authentication, is there any way for work with both
applications on same server ?.
Microsoft CRM can work with SQL in mix mode authentication.
San Francisco, CA
"Rafael Diaz" wrote:
>...Problems with Access 2000 reports in Access 2003
we have a sent out a 2000 format access database to a
client running Access 2003. When trying to open any of the
reports they get an error - "the openreport action was
cancelled" - Not sure if they get this by running the
report from the database window or if it's only when done
through a form (buttons that run docmd.openreport when
Is anyone aware of any issues that may be causing this? I
couldn't find anything elsewhere on the MS site.
P.S. the reports work fine in 2000 and XP.
...URGENT!!! Problem with row data being truncated in a copy worksheet sub #2
Dave, Thanks for responding. I tried this but I could not get it t
work in conjunction with the entire module. It dies right afte
copying and PasteSpecial Values It does not kill the temp file or loa
the newly created sheet into an e-mail. Any Ideas
DoctorV's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=514
View this thread: http://www.excelforum.com/showthread.php?threadid=26863
You may want to post your current procedure.
> Dave, Thanks for respon...How can I convert my Archive Folder from its OL2002 style to the new OL2003 style?
The size of my Archive Folder is approaching 2 GB.
How can I convert my Archive Folder from its OL2002 style to the new
OL2003 style? I understand that the OL2003 style doesn't have the 2 GB
I use Outlook 2003. Any hint?
Juan I. Cahis
Santiago de Chile (South America)
Note: Please forgive me for my bad English, I am trying to improve it!
Juan I. Cahis <jiclbch@SINBASURAattglobal.net> typed:
> Dear friends:
> The size of my Archive Folder is approaching 2 GB.
> How can I conv...OFFSET problems in dynamic range
I'm having the strangest problem with the OFFSET function.
I have 5 dynamic ranges in my worksheet.
=OFFSET('Weekly ORF'!$F$4,1,0,COUNTA('Weekly ORF'$F:$F)-1,1)
=OFFSET ('Weekly ORF'!$D$4,1,0,COUNTA('Weekly ORF'$E:$E)-1,1)
=OFFSET ('Weekly ORF'!$G$4,1,0,COUNTA('Weekly ORF'$G:$G)-1,1)
=OFFSET ('Weekly ORF'!Aimline,0,-1)
=OFFSET ('Weekly ORF'!WCPM,0,-1)
The problem is that the two names for Date and Date2 keep reverting to
=OFFSET ('Excel Template.xls'!Aimline,0,-1) and
=OFFSET (...OnGetMinMaxInfo problem
I added an OnMinMaxInfo() function to my dialog so i can set the minimum
tracking width and height for my dialog,
I added this prototype to my dialog class:
afx_msg void OnGetMinMaxInfo(MINMAXINFO* lpMMI);
Then I added this function to set the min and max values:
void CMessDlg::OnGetMinMaxInfo(MINMAXINFO* lpMMI)
min.x = 200;
min.y = 200;
lpMMI->ptMinTrackSize = min;
It compiles but i can still resize the dialog to a smaller width/height,
Any help would be apreciated :)
Thx in advance,
"Thomas" <Da_QuiK@fake...Urgent Question Please Help: Credit Card Setup Problem
We have an urgent question regarding credit card setup/cash receipts/bank rec
We understand that in Great Plains when setting up a Credit Card to be used
by a Customer, it must be setup as a "Bank Card", not a "Charge Card", in
order for the transaction to hit Bank Rec.
However, we mistakenly setup all the Credit Cards as "Charge Cards",
therefore after posting Credit Card Cash Receipt transactions in Receivables,
the transaction does not appear in Bank Rec for us to perform Bank Deposits.
Please Please Help!!!
Is there any way to "fix" those pos...Problem running MS CRM 3.0 over SSL (https)
I have setup an install of Microsoft CRM 3.0 on a high spec Windows 2003
Small Business Server and it all worked happily.
I then generated an SSL certificate and applied it to the site in IIS.
Initially when you load CRM (using the web client) it loads the left hand
menu and navigation panes and shows the top menus and the user which is
logged in however to main content area remains blank. After a time out period
the error "An error has occurred. For more information, contact your system
The strange thing is you can navigate the menus etc and even edit...send as another user
i gave one user right to access another user mailbox and enable "send on
behalf" of him/her in exchange. back in outlook, when the user highlight the
other user inbox and click on send...it still say his send from his name
instead of the other user name?
am i doing someting wrong? if so, can someone tell me how to make this
thing work? thx in advance.
"send on behalf" is NOT "send as"
theyre 2 totally different things.
send as is given via ADUC
"vincentnyc" <firstname.lastname@example.org> wrote in message
news:F2A6FD12-5080-47...Moving a row from one sheet to another wrongly leaves blank-row artifact.
Moving an entire row within a sheet in Excel XP is implemented
Select the entire row, cut it, go to the target location, and Insert
Copied Cells. The target row is inserted (pushing all rows below it
down), and the source row is deleted (bringing all rows below it up, as
NOT so when the target is in another sheet in the same workbook.
Excel inserts the target row correctly, but fails to delete the source
row. The row still exists (only it's blanked out). You have to remeber
to, tediously, return to the source and delete the blank row. Which
means that if you intende...WindowsCE problems
I have some problems building application for Pocket PC (MDA1), maybe
someone could help me. I have these two problems:
-I need to create modal dialog box, but after creation sometimes I need to
access it (in response to system calls) and show some messages... what is
the best way to access modal dialog box while it's running?
-is there a way to change colors of single items in list-view control ?
Currently, when I'm using SetTextColor before each InsertItem, color changes
but for all items in list-view (CListCtrl) :\ Is there way make this work?
I'm using Microsoft eMbedded Visu...Draft Folder problem #2
I'm running outlook 2000.
My draft folder is called draft1. Can't seem to rename it! There isn't a
folder named draft so what's happening? Isn't a big problem, but I should be
able to solve it and I can't. Help.
Thanks in advance
You could try to start Outlook from the run line with the /resetfoldernames
"Peter Brown" <email@example.com> wrote in message
&...how do i open a publisher file created in new version?
I get publisher files in new versions of publisher. I have publisher 2000.
I can't open these files but don't want to update publisher. Is there a
download program I can get to translate these files?
"Peg" <Peg@discussions.microsoft.com> wrote in message
>I get publisher files in new versions of publisher. I have publisher 2000.
> I can't open these files but don't want to update publisher. Is there a
> download program I can get to translate these files?
There is not a download to tra...excel error "no more new fonts..."
Using Excel 2002. Pretty large sheet with about 60 tables.
refuses to copy and paste a table.
Getting error message "no more new fonts may be added to this workbook"
cannot find anything anywhere on this error.
...Problem of ghost unread posts?
I'm using Outlook Express.
Three times today I'm seeing unread posts reported that can't be
Synchronizing doesn't cure the problem.
When I use Edit > Mark All Read I get an OE hang up.
Ctrl + Alt + Del > End Task
Return to News and the ghost has gone.
Anyone else? Cause? Solution?
Not critical but annoying. I wonder if it's a remains of a spam that's
been removed before I read it.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available fr...Problem Sending Mail w/Outlook 2002
I receive and send a lot of email using Outlook 2002 and my Gmail
account with no problem. However, I have two friends to whom I send
emails that are always returned. I get an error message like this:
Technical details of permanent failure:
PERM_FAILURE: SMTP Error (state 9): 550 Invalid recipient:
However, if I send the emails to them directly from Gmail, they go
through just fine. Can anyone explain why they fail with Outlook?
This sounds like an issue with the SMTP server you have setup in outlook -
not outlook itself.
"patetc" <PatETC@gmail.com> wrote in messag...Software Distribution
I try to install software using msi with mst. Software supplier told that I
must run msi two times. First for some options and secound for another (
language option ).
I try solve this with two way:
1) Add two mst to one package. I prepare mst with ORCA. After add secound
mst and click OK i got error:
"An error occurred accessing the software installation data in the active
and event log:
Event id 110: Software Installation was unable to generate the script for
\\dc\client.msi. The following error was encountered: Error applying
transforms. Veri...New to mac...how do you make a calendar?
I am a teacher and have previously made my parent volunteer calendars
with my pc on Publisher....how do I create similar calendars on a mac?
Publisher is PC-only.
Would Entourage's Project Center be suitable? See
See also "Print a custom calendar in Entourage"
urage2004&type=howto&article=/m...Problems saving HKLM
I am trying to save the reg keys into a file:
My program has both "SeBackupPrivilege" and "SeRestorePrivilege". I am
using the RegSaveKey API.
The program succesfully stores these: HKEY_CLASSES_ROOT
The machine does not store these: HKEY_LOCAL_MACHINE HKEY_USERS
Error ("Access is denied").
Can someone tell me how to save the HKLM amd HKU? This probably what the
http://msdn.microsoft.com/library/default.asp?ur...EUREKA -- the mutual fund problem is fixed
I just tried once more to update my Fidelity Funds in MS Money and, this
time, the update worked. Both the quotes and the date were correct.
Honestly, thanks to all who, like me, bugged Microsoft endlessly to
understand the complexities of this problem and to get it fixed. We did it!
"Chuck Leven" <CHLeven@hotmail.com> wrote in message
>I just tried once more to update my Fidelity Funds in MS Money and, this
>time, the update worked. Both the quotes and the date were correct.
Mine just upda...Write formula for simple copy and paste to another cell
I have a worksheet that contains hundreds of columns. Each group of three are
related to each other (Cols A-C, D-F, etc...).
I have this formula that works well for columns A-C
=IF(NOT(ISBLANK('Page 5 Counts'!B2)),VLOOKUP('Page 5 Counts'!B2,'Color
Key'!$A$1:$B$87,2,FALSE),IF(AND(COLUMN()=COLUMN($B$1),ROW()=1),IF($A$2=$A$1,"",1),IF(AND(COLUMN()=COLUMN($C$1),ROW()=1),$B$1,IF(AND(COLUMN()=COLUMN($B$2),ROW()=2),IF($A$2=$A$1,2,1),IF(AND(COLUMN()=COLUMN($C$2),ROW()=2),IF($A$2=$A$3,"",IF($A$2=$A$1,$B$2,1)),IF(AND(COLUMN()=COLUMN($B$3),ROW()=3),IF($A...Problem Converting HTML to Access
I have Access 97... When I link an HTML document to my Access table,
the list shows that the information is there, but the cells are blank.
The names show up only when I highlight a cell. Ex. I have 300 names
and the list will say 1 out of 300, but no names will appear in the
cell. It is just blank. Any suggesstions as to why this is happening?
My first thought is that the HTML code in each cell of the table starts with
something (e.g. a <BR> tag) that Access is interpreting as a linebreak or
"rblivewire" <firstname.lastname@example.org> wrote in message
news:11...new recipient policy
I have an Exchange 2003 (1 FE and 2 BE) mail system.
Initially we had 2 recipient policies 1 with 7 smtp addresses and the
default. We are growing etc and need to better manage our users and I don't
want everyone to have to 10 email addresses.
I made a new policy for the new domain I need to host. I gave it the first
priority and added the new domain name @newdomain1. All the users who need
this are in a global security group and I used that as the advanced criteria
(IsExactly - pre-2000 name).
I then did the same for 2 more domains (with different groups). And then I
lef...Queue message problem
We have a Ex2k/Win2k advanced member server that had some serious problems
starting Sat. morning. SMTP, POP, IMAP, www, MS Route Engine all stopped
and seemed to start back up and then stop again at various intervals,
eventually just stopping completely rendering the mail down. A reboot had
the same problems occur. When I removed the messages that were in the
queue(c:\exchsrvr\mailroot\vsi 1\queue) and then manually started the
services all was well.
I would like to copy back some of those messages into the queue to see if
they process or cause the same problem again. Once I copy ...