Print ACCESS 2003 report via VB6 Application
Hi Good Guys,
I need your help. Please help me.
My office is still using VB6 SP6 software and ACCESS 2003 Database. I
am trying print ACCESS 2003 report with VB6 application and I
constantly get the POPUP Screen of SECURITY WARNING from ACCESS 2003
which created problems for the users.
How to stop the POPUP SECURITY WARNING SCREEN for happening.
Here are the overall VB6 coding.
Dim objAccess As Access.Application
Dim dbName As String
Dim rptName As String
Dim strSql As String
Private Sub Form_Load()
Set objAccess = New Access.Application
...Account Overview report issue?
I am trying to run the Account Overview report (open an Account, run the
report from there). It chugs over it for a second or two, then I get the
following 2 errors:
Error: subreport could not be shown.
Note: The maximum number of accounts in this report cannot exceed 10.
The account I am running this on does not have any subaccounts and has a
total of 4 contacts. Has anyone seen similar errors with this report?
Thanks for any help...
What language are you running in? Is your environment SQL 2005? Go to the
Reports section and look at the "Hidden" repor...How do I track emails ONLY using tokens in CRM 4.0?
The pattern matching or "intelligent" matching of email content is
misapplying inbound emails to non-related cases. I want to turn this feature
OFF ASAP and return to ONLY tracking through tokens in the subject line. I
can turn OFF tokens but not the smart matching. A configuration option would
have been nice.
I think you turn on the tokens, and then your users have to use the option
to only track "E-mail messages in response to CRM e-mail" - that's how you
prevent CRM from using 'smart' matching.
"Forrest_Adam" <ForrestAd...CRM Field Names
Is there a list on field names that CRM creates in the database in order to
use them for setting up workflow?
...Deleted Items report?
Is there a report that shows the items which were Deleted as well as the
cashier who Deleted these items and the date?
No there isn't. There is a table that lists deleted records and which table
they're from, but no specifics other than date of deletion and record id of
the deleted item - which serves no purpose because if you go looking for
details for that id in the source table you can't find it because it's
been - can you guess? - yup , deleted. (g)
"Zorian" <Zorian@discussions.microsoft.com> wrote in message
news:46FF0032-...CListCtrl::HitTest reports Items under header bar
When I do a HitTest() from within OnDragOver() there are several things
that make no sense.
1) When I drag a file over the column headers in LVS_REPORT style,
HitTest() reports real list items that are hidden under the header bar,
rather than -1. When the list is scrolled to the top, it reports Item 0
as being under the header making its hit area twice as big as other
2) When I return DROPEFFECT_NONE from OnDragOver() I get the copy plus
OH! I found this one, I had DragAcceptFiles(TRUE) in OnCreate().
So, This one is fixed by removing it. (Left here for other readers.)
...CRM 3.0 and CRM 4.0
We were implementing MSCRM for a very protential CRM customer (Education).
Even they haven't signed the contract but we already started developing on
the CRM 3.0, 3 weeks ago.
A lot of customisation + .NET developing required on the version 3 but now
we knew that we're reinventing the wheels as some of them will be already
built in the V4 which one will be realease very soon (Q1-2008?)
If we place order to MS now, we will receive the V4 earlier than Q1-2008,
but it is V4, not V3
So now we decided moving the developing on V4 directly because no guarantee
what we wer...Organizational Settings in CRM 3.0
Is it possible to hide viewing of Organizational Settings from non System
...CRM and MapPoint
I have a client that has MapPoint 2004. They would like to have the ability
to map all of their current clients in certain areas, also with the ability
to make indication of future growth in these same areas. Currently, they can
only map one facility at a time. They would like to be able to map all of
their existing and future facilities for a spcific service area on one map.
Does anyone know of a solution for accomplishing this?
Not a mappoint expert by any means but I think there are 2 choices:
1. Export data from CRM (can probably just use the excel export option)...Cannot access CRM homepage on another machine
I have installed CRM 1.2 on a Windows Server 2003 SP1 machine. I can
work with CRM on this machine using http://localhost. But when I try to
access the homepage on another computer by typing http://CRMserver or
http://IP address of CRM server I cannot access it.
Can anyone please tell what do I have to configure to access the
homepage on another machine?
Thanks and Regards,
How can I reset CRM database?
I create contacts, acounts, invoices, etc., and i want
You cannot reset the database. You could restore the database if you took a
backup before you started adding data. You can also go into the system and
start deleting records. Can I ask why you need to do this? Have you been
experimenting with CRM and now want to go to a live server?
Microsoft CRM MVP
"Ricardo" <email@example.com> wrote in mes...Z Report to not print departments with zero sales
How do I amend a z report to not print departments if the sales are zero. We
have 192 departments but only a the sales seem to fall in a small portion...
Thanks. And thanks for all the help I've received...your suggestions have
made this much more bearable for me!
This is a multi-part message in MIME format.
Download one from here, all the way at the bottom =
Must have access to CustomerSource
J...Vista CRM 3.0 Desktop client
Can someone tell me where I can find the CRM 3.0 Desktop client which works
with Vista & Office 2007?
You can download it using the following link.
"circulent" <firstname.lastname@example.org> wrote in message
> Can someone tell me where I can find the CRM 3.0 Desktop client which
> with Vista & Office 2007?
...How works conflictresolution with the offline outlookclient and ms crm?
Does somebody know how the conflictresolution works if one ore more
offlineclients synchronise to the server. How does it work if diffrent
offlineclientds did some changes on the same field?
Does someone know a good description about this problem?
Consider a situation where a field has been changed.
1. Two offline clients making a change
2. One offline and the second online client making a change
when the client goes online the data present in the client is synchronised
and saved irrespective of the time when the last changes were made to the
"Hope...CRM registration can not be done!
After CRM installation and valid internet connection via LAN, I could
not succeed to register CRM 3.0. Is there anybody who had this problem
before and solve it??
When you fill in the registration details, if you specify the implementation
was done by a partner company, make sure you fill in data in all fields for
the partner company, otherwise the registration process can fail
David Jennaway - Microsoft Dynamics CRM MVP
> After CRM installation and valid internet connection via LAN, I could
> not succeed to registe...Migrating CRM to CRM
We had to delete the OU from the Active Directy, and now
cannot get to our data. Reading through the posts it
looks as though we have to use the DMF to convert our
data because of the GUIDs that are hard-coded in the
files. Unless someone knows of a utility that I can use
to change the GUIDs in the Active Directory - but we
tried a number of different things.
So, is there an easy method to import CRM data into CRM?
I tried using SQL DTS to the cdf_entities, but this is
like pulling teeth, and don't know if I am going to be
losing any data. Anyone have any insight into getti...PDF's not traking in crm
when tracking a pdf file in CRM we get an error saying that we can not track
it. the files are small so it is not an issue with them being to big. we can
track other types of attachments with no problem. in the event viewer we get
an error with the event ID: 5983. i did a google on it and find a solution
for the old 3.0 version(which was to update to a later 3.0 version). we are
on 4.0 with the latest updates.
thanks for your help
There is a problem attaching an email which has an attachment with an '&' in
the file name. Could this be your problem?
"Tyler Ba...Crm grid error
I've created a custom entity called Billed hours and associated it to
the case entity (which is the parent). It doesn't allow me to open the
instance of the billed hours entity in the associated view and when i
select it and try to delete it, it says: "You must select one or more
records before you can perform this action". I'd appreciate any help :)
...Upgrading to CRM 3.0 Problems
We're upgrading from CRM 1.2 to 3.0 and are coming across an error we can't
After entering all the information it brings up the system requirements
screen where it goes through everything to make sure the install will be
smooth. Everything checks out except for IIS. The exact error is "The Web
site's NTAuthenticationProviders must be Negotiate,NTLM"
We've researched the error on the web and found the adminscripts command to
make the site Negotiate,NTLM and the get command does show it to be just that
but when we restart IIS and start the ins...ACT to MS CRM 3.x Migration using Scribe Insight
I have installed Scribe Insight and Scribe Adapter for Microsoft CRM
(trial version for now). I can't seem to find a nice step by step
document to on how to use this software. First of all, does ACT need
to be installed on the server where CRM and Scribe are running or can
it just use an ACT file?
Has anyone used Scribe successfully without having taken the training?
Is the training recommended?
> I have installed Scribe Insight and Scribe Adapter for Microsoft CRM
> (trial version for now). I can't seem to find a nice step by step
> ...CRM 3.0 Changing CRM Mailbox
When I installed CRM/the Email router, I specified it to use the
administrator mailbox. I now want to move it to a dedicated CRM mailbox,
where cna I find this setting if it's not under Settings/Organisation
Settings/System Settings/Email ??
I believed that you have to use the Microsoft CRM-Exchange Email Router
-> Rule Deployment Wizard to update the mailbox information.
Make sure the logon to start that email router Service able to access
Darren Liu wrote:
> Hi Adam,
> I believed that you have to use the Microsoft CRM-Exch...Announcements in Crm
Can u set it that announcements shows to all users when they log on,as there
is no workflow for announcements. is there any way to intergrate a ticker at
the bottom of Crm to show information?
not without making unsupported changes to the announcement section.
Microsoft CRM MVP
"Zombie9" <Zombie9@discussions.microsoft.com> wrote in message
> Can u set it that announcements shows to all users when they log on,as
> is no w...Import Error CRM 3.0 German
I am running German version of CRM 3.0 and for testing purposes we're trying
to import just 6 adresses from an Excel sheet.
But every import fails with the message:
"Daten in der Zeile stimmen nicht mit dem Importtyp überein" "0x8004032d"
We already reformatted the Excel sheet, we exported the stuff into:
- txt, tabulator-splitted
- csv, splitcharacter splitted,
everythings fails, we are nor able to import those adresses into register
Someone got an idea why?
Thanks in advance for any hint, greets
check your datatype, is...CRM undelete?
We had a user who deleted an entire account, and so now I'm trying to
rebuild that since it all remains on SQL.
I was able to bring back the account, and all its contacts and
opportunities, and they all linked fine. I also brought back all the
activities, but they are not linked to the account.
When I do an advanced search, I can find this activities and it shows that
it IS part of that account, but when I go to that account and look in the
history, they are not there.
After a quick check, apparently they need to be associated in the
ActivityPartyBase table in MSCRM. This is where I hav...Migrate CRM Data from CRM Server to another CRM Server
we have a staging and a production CRM server and i'd like to migrate the
Production server data to the staging server database. Can anyone recommend a
tool or process that i can that doesn't involve rebuilding the staging server?
Please ignore - looks like Data Migration Framework is the way to go, based
on other posts
> we have a staging and a production CRM server and i'd like to migrate the
> Production server data to the staging server database. Can anyone recommend a
> tool or process that i can that doesn't involve rebuildi...