SelectSingleNode returns nothing. Namespace manager issue
I have the following code snipet:
Dim manifestNSManager As XmlNamespaceManager = New
m...Speed issues with large volume of serial numbers
Has anyone had issues auto assigning/posting a receipt with 100,000+ serial
numbers in Dynamics GP? We were testing with the GP10 4/08 VPC (which I know
isn't perfect), but it seems to take 15 or 20 minutes to assign. And 3rd
What kind of Hardware are running this on?
It sounds like the SQL server is having an issue and not he client.
> Has anyone had issues auto assigning/posting a receipt with 100,000+ serial
> numbers in Dynamics GP? We were testing with the GP10 4/08 VPC (which I know
> isn't p...external link values
is there a way to stop excel saving external link values when saving a
i know i can copy then paste as values but the doc needs naming and saving
at the outset.
I don't know if this will do what you want, but you can
use Tools; Options and uncheck the save external link
values on the Calculation tab.
>is there a way to stop excel saving external link values
when saving a
>i know i can copy then paste as values but the doc needs
naming and saving
>at the outset.
>...RPC over HTTP connecting issue
I am having issues with users connecting to exchange 2007 (Via RPC over HTTP)
with outlook 2003 using comcast. Works with verizon and at airports just does
not work with comcast. Any suggestions would be helpful. I also use ISA2004
...W2K3 Site Links question
I am learning about AD sites and I am confused about how to link two sites
As a practice I have created two sites, Columbus and KC, and when I created
them I assigned them the DEFAULTIPSITELINK object.
I have now created a second site link, called 'columbus-2-kc'.
My question is: How do I link my two sites, Columbus and KC, to this new
site link, columbus-2-kc?
Do I just change the cost of the columbus-2-kc site link to a value lower
than DEFAULTIPSITELINK? Or do I have to physically link the Columbus and KC
sites to the new site link?
Regar...HTML link to a specifed worksheet
From an HTML page I would like to add a link to an EXCEL file but on a specific worksheet? I s this possible
I think you just have to save the Excel file when you
have active the worksheet that you want to show. I don't
know of any other way.
>From an HTML page I would like to add a link to an EXCEL
file but on a specific worksheet? I s this possible?
try a link like the follwoing:
> From an HTML page I would lik...easily changing a linked reference
I am building a report spreadsheet that links into and pulls
information from another spreadsheet i.e LabourWk49.xls.
I have quite a lot of links into LabourWk49.xls and wondered if there
was an easy way of wholesale updating the weeks so the links can be
changed to LabourWk50.xls. Is there a macro or something that could do
this easily. I want people to be able to change the links easily.
You could use:
or if you're very careful, you could use:
Make sure you give it enough information so that just the file name will be
...Access Data Base linked to Excel needs to be moved
I have an Excel workbook that is linked to an Access data base.
User's enter data into Access and Managers use the Excel spreadsheet to
filter the information.
We need to move both the data base and the workbook to another location on
our network, but it looks like the person that created all this stuff 3
years ago (and who is no longer with the company) hard coded the link
between Access and Excel.
Is there any way to change the path without re-creating everything?
I can use either Excel/Access XP or 2003
Thanks in advance for any help
I think you'll need to pro...[Excel] How do I change the default import external data settings.
I need to change the default settings for importing .csv files into Excel so
that I don't have to change the settings every time I do the action.
Is this possible?
Many thanks to anyone who can help me!!!
Maybe you could rename the .csv file to .txt and record a macro when you do it
Then just rerun that macro the next time you need to import that file.
(Keep recording while you add headers/footers/filters/etc and make it really
> I need to change the default settings for importing .csv files into Excel so
> that I don't have to change the se...Find formulas w links to other files and paste values #2
Just to let everyone know that I found the solution:
bjare's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1619
View this thread: http://www.excelforum.com/showthread.php?threadid=27617
...Linking Between Workbooks
Excel hasn't been preserving my linkage between
workbooks. Any idea why this is the case?
For example: I open a July Returns Analysis workbook and
save it as August Returns Analysis. I then update all
the workbooks that the August workbook will be linked
to. I go to Edit, Links, Update Now for each link, then
I save the file. Sometimes, after the workbook has been
open for a while the numbers revert back to what they
were before I went through the link update process (i.e.
they revert back to July's numbers). I noticed that this
occurs specifically when I open July&...Delete Command Button Issue
I am having a small issue with my delete command button. I have several
valadation rules currently in my database. I also have a delete command
button. The form has about 60 fields with lets say 15 required. If a user
enters in 3 fields and then realizes they want to delete the record the
delete button since the other valadation rules are seeing fields have not
been filled out. Is there another command button i can put on the form to go
along with delete? My button works fine on existing records. Any
suggustions? Below is the code on the click:
Private Sub DeleteRecord_Cl...Finding the link from a commited PO item back to the SO
We are generating POs from SOP to handle some special order situations (so
we force a backorder and generate the PO). And then things get really
complicated with various thrid party add-ins and e-Connect.
What it boils down to is that we need a way to identify the Sales Order that
is linked to the item on the PO (from SQL Server, not from within GP). I know
the information is actually at the item detail level or below, but we have no
idea what tables to examine to discover the links that will lead us back to
the original Sales Order number.
Do any experts out there have a clue/hint/...Style 304 (Change item price) worksheet issue from 1.3 refresh
We currently encountering issue on RMS 1.3 refresh. This issue is from
issuing Style 304 (Change Item Price (regular)) worksheet on our client
branches. When we try to issue this worksheet, it hangs all the HQ Manager
application that are open everytime we approve this worksheet.
Does anyone can't help us to troubleshoot this issue. We highly
appreciated your reply. Thank you!
This is a multi-part message in MIME format.
Content-Transfer-Encoding: quoted-printa...Linking to email...
I want to be able to automatically create an email with an attached text
file. I don't necessarily want to link to Outlook, rather just whatever
email software they use. I have tried a ShellExecute using "MailTO", but
that won't allow an attachment, so I tried the following code, but simply
nothing happens! The following code appears to run OK, all pointers look
valid and the message box pops up at the end saying email sent, but nothing
arrives. Here is the code I have tried:
logPathName = filePath.GetBuffer(0);
MapiFileDesc attach...Access 2003 ODBC linked to SQL 2005
Not sure if this is the right place to ask this question. I'm using SQL 2005
for data and connecting to the server using Access 2003. I have one table for
stored images and the data field is set to Varbinary(max). I can link the
table to Access, but when I try to open the table, Access shuts down without
any error messages. If I change the Varbinary(Max) to Image data type, Access
2003 has no problems. My question is - is there a fix or a work around or is
Access 2003 just too old for SQL 2005?
And, Mike, is there some problem with converting the varbinary that you want
to use to ...External email address in Distribution list
Is it possible to add an external email address to a Global Distribution
List? I have tried creating a "Contact" in the User list and adding that,
but that gets returned.
"John" <firstname.lastname@example.org> wrote in message
> Is it possible to add an external email address to a Global Distribution
> List? I have tried creating a "Contact" in the User list and adding that,
> but that gets returned.
The AD contact is the only (I...Outlook "OFFLINE" issue..
Since we upgraded the Exchange 2003 to SP2, some of our users encountered an
issue where their Outlook client 2003 were "Offline" by itself. The users
need to manually uncheck the "Work Offline" to reconnect the server.
Is there any issue with SP2 ?
If there is an issue with an Exchange patch, it will most likely be =
covered in an Exchange news group.
Microsoft.public.exchange.admin is a good place to start your inquiry.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail se...vlookup issues
My really be a "data" issues not a vlookup issue - but here is the problem;
1st column of my table_array:
These will NOT sort in proper order.
Does not matter if the cell is formatted text.
Does not matter if the cell is formatted Number
Does not matter if I clear all the data and type them in proper order by
why won't my data sort properly?
Any help here will be appreciated.
Thanks in advance
Formatting text to numbers won't change anything, you need to force
th...External mail from the command line
I hope someone can help with my exchange 5.5 problem.
In the environment we have 2 IMC servers which are both giving different
results when sending mail via a command line to external recipients only,
internal is fine.
Both machines are windows 2000 with exchange 5.5ent both at the same patch
and SP level (4) and have been configured the same and to forward mail to a
host (our mail appliance).
The one that is concerning me is the one that just returns the mail back to
the sender stating that it cant find the recipient (external recipient). Now
surely it should just be forwarding...Linking workbooks #4
I've got a huge problem.... I've been working on a
financial model for a month... basically a large budget in
Excel... multiple files (150) with multiple sheets. All
the files are placed in folders representing a hierarchy.
I'm trying to "rollup" summarized statements that are
consistent within all files to one Total file.
My problem is that everything is carefully linked and now
when I look at my linked cells, the data is there but when
I F2 calc I get a #ref. The data looks o.k. but now I
think I might have a problem. Does anyone know if there is
a limit to th...Verizon email issue
Running Exchange 2000 and not using a smarthost (our isp doesn't offer
this). Mail server has a reverse DNS entry and have no problems
emailing any other domain. The problem is that some of our users
cannot email verizon.net addresses...bounces with a "550 You are not
allowed to send mail" message. I submitted a Verizon whitelist form
for our domain and recieved the response:
After investigation, Verizon Online Security has determined that
e-mail from your IP address will not be allowed access to the Verizon
Online e-mail domain due to one or more of the below reasons:
Yo...outlook Over RPC STRANGE issue
I have an issue where OORPC seems to work for users who were already set up
for OORPC yet new configurations of outlook do not work.
I have verified that certificates etc are in place and working.
It seems that outlook /rpcdiag is getting to 'directory - connecting' then
closes after a few seconds with an 'exchange server is unavailable' type
I suspect this was introduced with the recent round of microsoft updates we
went through with DST2007.
Anyone having similar issues?
Can you check to see if these new accounts work from a machine from a
It is very critical for my business to learn the basics
and the backbone of links in Excel. Are there any
tutorials or articles that gives wealth of information
about MS Excel links? (in Excel 9.0.6)
Web addresses are also welcome.
You can also post to my e-mail above.
Thank you in advance.
You have additional answers in excel.links
You have asked the same question several times in the Excel
newsgroups. Basically you are not reaching more people but
are asking the same people who may visit different newsgroups
at different times. Please stick to o...Outlook link opens browser, but page cannot be displayed.
When I click an url in Outlook, it opens IE fine. But it shows "The
page cannot be displayed". More curious: if I have a working
browserwindow open, and click the link, it works fine. This makes me
think that I'm dealing with multiple instances of IE on my machine.
Outlook 2003 11.5608.5606
Windows XP 2002 SP2
Thanks for your help! This problem has been hunting me for months.