Word integration that works ?
Does anyone have a link to a good solution in creating word documents from
CRM, i.e. quotes etc.
A solution where maybe it's possible to create it with a button and at the
same time get an activity attached to the oppertunity.
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f� 14509 spam-mails
Betalende brugere f�r ikke denne besked i deres e-mails.
Hent en gratis SPAMfighter her.
Suggest you look at Mail merge from mscrmaddons. Other than that i...How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
...comdlg32.ocx and Access 2007
I have several Access databases that were originally written using an Access
version prior to Access 2007. I am in the process of converting the
databases and installing them on new machines running Win7 and Access 2007.
Over the years, one of the References I commonly used was comdlg32.ocx. It
does not appear that either Win7 or Access 2007 installs that particular
Active X file. I can copy it from an older machine, but that seems like a
Is comdlg32.ocx a "legacy" Active X file and has it been replaced with a
newer (and differently named) Activ...Outlook and Windows Integrated Authentication
Does anyone know if Outlook (not OWA) can use Windows Integrated
Authentication (like IE) to automatically log onto Intranet Web sites to
retrieve graphics in HTML messages? Right now we get a logon dialog and
have to manually log in. Thanks.
if you paste the url into a browser, does it work as desired?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outloo...Integrating Great Plains 8.0 and CRM 1.2 and Windows Small Busines
Integrating Great Plains 8.0 and CRM 1.2
I run a Windows Small Business Server 2003 Premium box along with a Windows
Server 2003 Standard box used for my Great Plains 8.0 and SQL 2000. I’m
considering introducing CRM 1.2 Professional into the mix. From a hardware
stand point I know I’m fine all around. I’ve been researching how I should
configure CRM and am a bit confused. The info I’ve found in KB887153 states
“When you install Microsoft Business Solutions CRM Integrations for Great
Plains 7.0, 7.5, or 8.0, Microsoft BizTalk Server is also installed. However,
BizTalk Server 2000 and B...Error 2455 Closing Access 2007 database with form open
I have a form with a subform that is requeried when you select a new key for
the main form from a combo box.
Everything works fine - usually. But sometimes if you have the form open
when you close the database down you get the following error message (twice)
in a pop up. You say OK (twice) and the database closes OK
"2455 you entered an expression that has an invalid reference to the
If I close the form before the database I never get the error.
If I do not touch the form before you close the database I don't get the
If I update a field by t...Inserting Excel into Access Reports
Have a great Access application that produces a nice template (headers &
footers) report into which I'd like a spreadsheet inserted before going to
the printer. In the past, I'd just print the Access reports, then reload
them into the inkjet printer and run the Excel spreadsheets as needed. The
heat of the new color laserjet turns the paper grey if it runs through too
often, so it's time to get the reports printing on one pass.
Any suggestions would be welcome. I've of course also got Word XP, MS
Publisher XP, as well as Adobe Acrobat, if anyone thinks it m...Simple Access counting queries
Hi, hoping someone can help a relative newbie with a pretty simple
query. My database (Access 2007) has three tables:
Purchases (many-to-one links to both of the other tables, this is
basically a linking table)
I have two simple queries I'd like to get out of this database, but
I'm a bit stuck on how to construct the SQL. Any direction you can
give me would be helpful.
1. List of all customers who have purchased 2 or more products (or 3
or more products, or 4+, etc.)
2. List of all customers who have purchased both Product A and Product
B (or A, B, and C, or B an...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <firstname.lastname@example.org> wrote in message
> How to get only the year in the date form...Expression Too Complex in Access 2000
Consider the following query:
SELECT crTbl.acct_1, crTbl.amount, crTbl.date
WHERE (((crTbl.acct_1)="Supplies") AND ((crTbl.date) Between
The query works fine on my own computer in Access 2002.
When converted to Access 2000 and used on an other computer,
I get the following error:
"This expression is typed incorrectly or is too complex to be evaluated.
Try simplifying the expression by assigning parts of the expression to
The problem is with the "Between...groups detail section totals access 2003
I know this can be done, but haven't figured out how yet. I have what
basically is a summary report that my sql comes up with for the detail
rows. I want to total these rows in the report and display
immediately below the detail section. I don't really want to group
anything, but want to treat the whole detail section as a group.
That being said, how can I get a "group footer" on the designer so I
can add my total columns. If I use "sorting and grouping", it starts
grouping things and that is not what I want.
I don't want to use the "page foo...Remote access to another company's Outlook calendar?
I have one client on Exchange 2003 that wants to access the calendar of an
employee (consultant?) at another company running Exchange (version not
known yet). How can the remote company share this person's calendar with my
client? He would need to access it and add appointments to it.
Thank you for the help!
On Mon, 30 Aug 2004 22:15:24 -0700, "Gregg Hill" <email@example.com>
>I have one client on Exchange 2003 that wants to access the calendar of an
>employee (consultant?) at another company running Exchange (version no...Create Excel macro for barcode output
I am looking for suggestions or samples of an Excel macro that will output
barcodes that can be printed and then attached onto loan documents.
Example: input loan # 555 and print off 20 barcoded labels - each label
contains loan number + the document type.
you don't need a macro for that. we just got throught
barcodeing our part numbers in the ware house and used
excel and no macro.
bar codes are just another font. excel uses 3 0f 9 barcode
font. you can download others off the net.
you can format a cell with this font and it will show as
barcode on the sheet and numbers in th...Can't connect to Exchange server after VPN access
I can connect to my office Exchange server when in the office (LAN) but I
cannot connect outside with Outlook.
I can only use the webmail after entering a web VPN access:
- First portal for VPN : https://xxx.yyy.com --> I enter my
- On the next web page, I have the choice for the webmail and it's a link as
https://xxx.yyy.com/go/webmail.yyy.com~ssl where I can enter my
So I can't enter the url in RPC as every slash is forbidden
In my Outlook, the Exchange server (EXC.yyy.com) is not reachable by ping
(or tracert) and I can't ...Access 2007 12-17-09
I am building a contact data base for my church. How do I get the phone field
to automatically format like this (xxx) xxx-xxxx when the numbers are typed
in the cell?
In the form design view select the phone control and open the properties
dialog. Goto the Data tab and use the Input Mask to define the format you
wish to use. If you click on the ... to the right hand side on the property
you will get another dialog where there are predefined input mask or you can
define your own.
For instance, I use
to format my telepho...Integrity Problems in PivotTables
I have used this workbook for some time and it appears the same as many
others I use, but lately after opening it a couple of times I receive an
error message that - 1, "Cannot read file", followed by
2, all my pivotTables lose functionality "Due to Integrity Problems" and I
have to reset all the ranges again.
I am using 2003 version and the range in question for the first table is in
another workbook on the server.
Hi Roger, (reply in excel.misc)
I don't have Excel 2003, but you might double check the several pa...Can Entourage be used to access Google Groups
I am in the process of switching from PC to Mac. In Entourage, I see this
news server. Can I get some of my newsgroups in Google Groups to show on
Entourage or Mac Mail?
Responses off group will be welcome if I have asked something everyone
except me knows.
On 1/31/10 3:25 PM, Michael Plog wrote:
> I am in the process of switching from PC to Mac. In Entourage, I see this
> news server. Can I get some of my newsgroups in Google Groups to show on
> Entourage or Mac Mail?
> Responses off group will be welcome if I have asked something e...Publish A Workbook Onto The Web, Then Access Using My Web Browser.
How do I access my spreadsheet, or workbook, on the web once I've saved it as
a webpage from the file menu? I've found that even though I've save my
workbook as a webpage, it does not have an http:// address which I can type
in my web browser to access the workbook from my home computer or from a
Should I have to sign up with an http:// service provider or can this all be
done from using Microsoft Office XP without going through a third-party?
You have to have a website first of all, otherwise, where do you want to host
"sigmad&q...link file from virtual windows xp to access 2007 on windows 7 plat
I am trying to link a paradox db file to access 2007 db. The paradox file
resides on a virtual windows xp platform within the windows 7 platform of the
physical machine. How do I map this field into access?
...Unhandled exception at 0x10001e80 in EXCEL.EXE: 0xC0000005: Access violation reading location 0x10001e80.
Does somebody know what's a shit is that?
I installed XP from scratch, then all service packs and update, VS etc.,
finally I installed the Office 2000. When I close Excel (and Word as well) I
get this error.
Unhandled exception at 0x10001e80 in EXCEL.EXE: 0xC0000005: Access violation
reading location 0x10001e80.
I installed all service packs and updated over the office, no results.
My friend told me that it's a big difference how did we install Office, in
what order. If I install the Office exactly after Windows main installation,
then install all other packages, updates, ...Puzzling out the Navigation Pane (Access 2007)
Been looking at the Access 2007 Navigation Pane as a replacement for
the venerable Switchboard.
Soo... I can create shortcuts to objects, put those shortcuts in
Custom Categories and Groups and Disable the DesignView property of
the shortcut. Ok. I can run an autoexec macro to hide all native
categories. Fine. What's to prevent the end user from right clicking
on the shortcut and enabling DesignView again?
I am a CRM 4.0 user and using router for both incoming and outgoing. The
incoming uses forward mailbox and outgoing uses SMTP. No user is using
outlook client for CRM.
I need help in better understanding the following scenario:
The e-mail gets initiated from CRM. It reaches the CRM external contact
(even though in CRM e-mail the status is pending). Why is this happening?
The CRM external contact replies to this e-mail and it reaches back to CRM
user. This CRM user now uses outlook (with no crm client) to reply to this
e-mail, no update happens in contact's CRM history. My ...administrator denied access to system manager
done a nice silly thing, accidentally changed the permissions on the
administrator account to deny full access in the exchange organisation. i
used the reg hack to access the security tab.
i know that's why it's hidden to prevent things like this, so please dont
remind me ;)
thing is, although i can do most things from another admin account, i cant
get access to that security tab, even with the reg hack for that user. so i
cant undo the damage. is there any way or removing those permissions using
another tool? i cant add the other amin account to the delegation wizard, it
says...Converting Access 97 to Access 2003 10-14-05
This is my first conversion. Can anyone offer tips on the easiest and safest
way to convert a multi user database which was developed in Access 97 to
You can try opening A2003, and before opening any database, choose:
Tools | Database Utilities | Convert Database.
If you run into problems, see:
Converting from Access 97 to 2000, 2002 or 2003
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jane...Access 2003 and Access 2007 on same workstation
Sorry, this has probably been asked a thousand times.
Can I install Access 2007 on a machine with Access 2003 and keep both
versions. I used to do this with Access 2000 and 2003. Since I am a
developer, I need to test and develope with the customers version.
Yes you can. However, be aware that there's currently a problem so that
whenever you switch from one version to the other, it'll take several
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Marcus Smaby" <firstname.lastname@example.org> wrote in message