I have created a template in word which I call through a VB script from
excel. The excel data is populated in the word every time I run this script.
Everything works fine and the data get populated.
I have a header in the template which is represents one of the fields in the
excel sheet. The header shows the correct linked value for the first 10 pages
but then on shows the variable name instead of the value. I have no idea why
it does that?
can someone help
The code is as follows:
For iCurrentRow = 1 To iLastRow
If ActiveSheet.Range("B" & iCurrentRow...Extra cover page when report exported to PDF
I am using SQL Reporting Services for SQL Server 2005. I have a report
that uses a page header as a cover page. When the report renders in
the browser, the cover page prints once (as expected) and then the
data begins on page two. When the report is exported to a PDF, I get
two cover pages. The first cover page does not print the report items
fields so I can identify it as the "extra" page. The second cover page
is identical to the cover page that renders in the browser. Does
anyone have any ideas what I can take a look at?
figure out why your page is too wide? that's th...event ID 9153 Microsoft Exchange System Attendant reported an erro
Guys I am receiving 9153, Microsoft Exchange System Attendant reported an
error '0xc00706fc', when setting DS notification
I am not in mixed mode Exchange envorinmed, Native mode clustered exc 2003
server, active passive.
we did not have any domain controller demoded, whic was primary internal DNS
for the exchange server.
our smtp q is clear,
Exchange boxes are able to locate the DNS and GC servers,
MsexchangeDSAaccess is showing all the servers are succesfully discovered.
We are receiving 8213 along with this error,
"System At...RMS should be able to handle multiple serial numbers easier.
When you have to enter many serial numbers , either to take itmes into stock
, transfer stock from store to store or even sell, it is not very fast .
I think simply if when you scan a serial the code just places a tab or enter
so the cursor will automatically move to the next line . In this way the
scanning process will be much much faster .
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this ...How do you copy multiple pictures to a publication?
You don't copy them, you insert them.
MVP Microsoft [Publisher]
"sidneyl" <email@example.com> wrote in message
I never tried copying (inserting for Jo) multiple pictures into a
Publication before but this seems to work in Pub 2000.
Open an existing or new Publisher file; go to the folder with the pictures
and gather as many files as you want; do a Edit, Copy; go to the Publisher
file; do a Paste. You will now need to arrange the pictures to your liking.
Do...Outlook issues after Exchange migration
We recently migrated Exchange 5.5 mailboxes to Exchange
2003 on a new domain. This was performed with the exmerge
utility in a 2 step process. Now there are 2 issues with
1) When a user types a recipient name into the address
field, the name autocompletes as normal. But when the mail
is sent, a message returns saying it is undeliverable.
However, if the user goes into the Contacts folder and
from there selects the same user to send a message to, it
2) If a user shares a calendar, specifying the user with
whom to share and the level of permissions, all users in ...multiple link criteria in sql statement
Can you help? The scenario: Click on ID # in a subform and the form opens
with the information tied to the ID, by the Item Desc. What I want to know
is........how do you add to the criteria? I'd like to use Item Desc AND
Customer in the "stLinkCriteria", but not sure how to code it.
Private Sub ID_Click()
On Error GoTo Err_ID_Click
Dim stDocName, stLinkCriteria As String
stLinkCriteria = "[Item Desc]='" & [Item Desc] & "' "
stDocName = "Face Sheet to be reviewed"
DoCmd.OpenForm stDocName, , , st...Integration Manager XML Adapter?
Where can I find the XML adapter for the Integration Manager? We just
upgraded our Integration Manager and GP to V10 and we cannot find the XML
adapter on the new IM. Please let me know
If you're looking for the XML Source adapter, I think you'll find it with SP 2
Leslie Vail, CPA, MCT, MVP
MCBSP-Application for Microsoft Dynamics GP
MCBSP-Installation and Configuration for Microsoft Dynamics GP
> Where can I find the XML adapter for the Integration Manager? We just
> upgraded our Integration...Taskbar issue
I'm hoping someone can help me with this long-standing problem with both XP
and Vista on separate laptops and every computer I've had (except I think
Win98). I'm thinking there may be no solution, but what it's worth a try.
With both of my machines, I have the taskbar (as well as other toolbars) set
out to maximum size - typically half the screen - and to auto hide. (This
makes a great program and file launcher)
The issue is that the operating system decides it wants open the taskbar on
its own from time to time on its own. Various things prompt this, ma...DST issue
I entered the catalog item:
<Feature Name="Item" CatalogItemId="Item:MS:sysgen_timesvc_dst" />
and confirmed that the device has the registry key:
HKLM\Software\Microsoft\Clock\AutoDST = 1
But the device still does not automatically adjust for DST. I set the
timezone to Pacific, set the time to 3/14/2010 at 1:59AM, waited for one
minute...and the time changed to 2:00AM instead of 3:00AM.
What am I missing?
which OS version are you using? have you updated it with the relevant qfes
which deal with the changing in DST starting day?
-...multiple instance of CRM on domain
We have a situation where two divisions want seperate instances of CRM. It
is important to note, each division has it's own domain.
While I know we can manage that, my question concerns the exchange router.
Since the email for both divisions come through the same exchange server (and
through a third domain), my assumption is there would only be one exchange
Has anyone done this before and what are the potential issues I may need to
address to make this work?
This will probably answer your question (or some parts of it anyway):
http://blogs.msdn.com/crm/archive/2006/10/0...Outlook/EX Email Issue
I'm running Windows XP with XP Professional. I cannot send email but I can
recieve it using Outlook. There error says that Outlook was unable to access
the SMTP server. I cannot access my email at HOME through the web email. What
I can do is send/recieve email using Outlook Express AND I can access my
email through my web email client outside my home. My ISP (SBC) says its not
them and I'm somewhat inclined to agree with them? They say I could have a
corrupted kernel32.dll file. I have turned off my Norton, deleted my account
and set up a new one and re-installed XP professiona...naming cells in multiple worksheets #2
cparsons's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1286
View this thread: http://www.excelforum.com/showthread.php?threadid=26681
...Multiple Promotional Credit Card Rates
Is there a way in Money 2004 to have more than one
introductory rate? My wife has transferred so balances to
her credit card account using balance transfer checks
over time and the rates range from 2.90 to 6.90% for the
life of the transfer and since the credit card company
uses the payments that we send in to the lower interest
rate, just would like to know how the finance charges are
being applied to each individual rate, if that is
possible to do on Money 2004 that is
Not possible AFAIK.
Microsoft MVP - Money
For UK tips & fixes see
http://su...MSX 5.5 isinteg report
Recently the private IS on our MSX 5.5 server (SP4) went
over the size limit and crashed. One admin ran an offline
defrag and was able to get the IS service going. We then
had users clear out about 4GB of space, and we defragged
again. Priv.edb is now down to about 12GB.
Since the crash, there have been a variety of random
problems with variuos users' email. I ran isinteg -pri -
test, and the report gave over 1,000 WARNINGS, but no
ERRORS. We are wondering if we should run isinteg with
the -fix option, but there is not a lot of good
documentation on it.
Any suggestions would be h...Extender Install Issues
GP 8.0 Extender install - I'm encountering the following:
*Login to GP brings up screen: "Great Plains Extender needs to finish
installing. This may take a few minutes". It has an OK button and clicking
on this gets you into GP but it comes up everytime. How can we stop this
from popping up all the time.
*When creating a new Extender Window and I get select the Form, I get the
following error: "A remove range operation on table
'PT_User_Defined_Window_Keys' failed accessing SQL data." Procedure or
function zDP_EXT40101L_1 has too many arguments spec...Possible Report Issue
Hi. I'm working on a database for a safety audit. The auditors would like to
be able to use some of the tables and subtables as a sort of checklist for
the audits. The table/subtable structure is as follows:
I decided to create a report that will output that data. However, the report
is only outputting information if there are ProgramRequirements already
entered for a given ProgramArea. Is there a way to get it to output the
ProgramArea and ProgramRequirement even if blank? Or am I going about th...Adobe issues
We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are
unable to send documents to PDF from GP - the PDF option remains grayed out.
We have folowed the KB articles that are available, no success. Do we need to
install Adobe 9.0 due to running Windows 7? Is GP 9.0 compatible with Adobe
9? Thank you for any assistance..
I have a client using Adobe 9 on Windows 7. However, they are on GP 10.0
It is working succesfully.
> We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are ...Report vanished in Money 2000-WHY??
I have been using Money 2000 and print the MONTHLY CASH FLOW report every
month with out problems...until now. Now, it doesn't show up....the
information isn't there, but is available for every other report. I have
recently set up another money file for a seperate checking account for my son
to learn on....and that is all stored under a seperate Money file and the
report will open for his accounts...
Any suggestions to regain access to this report would be great appreciated.
In microsoft.public.money, SugarAndSpiceAccessories.Com wrote:
>I have been us...Issue with formula is Pivot table
I have the following formula in a pivot table:
First to the issues that I am experiencing. First, the formula wa
originally added as the one below but then updated to the formula abov
to correctly reflect what I was trying to accomplish.
This issue is the original formula appears in the very first cell o
the pivot table and then periodically through out the column. So, yo
see ...view in XP from single window to multiple
In XP all of the open windows use to appear in the bar at
the bottom. Now Excel just displays as one item on the
bar below and I must use Excel's "Windows" menu item to
switch b/t them. How do I switch it back?
In Excel: Tools | Options | View tab | Windows in Taskbar
"firstname.lastname@example.org" <email@example.com> wrote in message
> In XP all of the open windows use to appear in the bar at
> the bottom. Now Excel just displays as one item on the
> bar below and I must u...Hyperlink Issue #2
I have an issue with hyperlinks. When you click on the hyperlink on a
webpage it returns an error stating that the the "item could not be
created". Outlook 2000/Windows 2000
...Free Experian Credit Report #2
The link to sign up for Experian doesn't work for me. I get a "the page
cannot be displayed" I'm useing M2005 Premium and running XP with SP2. Has
anyone else been able to sign up for this free service?
In microsoft.public.money, Zach Rose wrote:
>The link to sign up for Experian doesn't work for me. I get a "the page
>cannot be displayed" I'm useing M2005 Premium and running XP with SP2. Has
>anyone else been able to sign up for this free service?
The link from Tools->FinancialServices clicking on Get Started
brings up a w...Outlook Web Access OWA Issue - Login Prompt for Images
Dear Outlook 2003 / Exchange 2003 Users,
Starting over the last two weeks (possibly after an update on the
Exchange server), all of my users are starting to encounter the same
issue when using Outlook Web Access (using IE6 on XP Pro systems). We
have images in our signature block, and now when someone replies using
Webmail to an e-mail originally sent via Outlook 2003, a login prompt
appears for each image in the e-mail. Every time you cancel the login
box, a red x image box appears, until all of the images that should be
there are represented by the red x boxes. For the record, this has
w...page # on MRP exception report
Anybody know how to get page numbers on the MRP Exception Report? I tried
adding the page number field but all it prints is a 0. The existing page
number field that prints in the RH is called Page No. but i can't find it in
the Tools to select and I dont think you can copy and paste a field from the
report. The only selection is from Globals and that is "Page Number". Doesnt
seem to work the same. Any help is appreciated.
This is an issue that we are addressing in the next release (8.5) that is
due out later this year. In the mean time, I was able to get the page...