Deserialize an XML file with multiple namespaces...
Hopefully I can ask this question without regaling you kind people in
too many gory details. Here's what I'm trying to do:
- I have a local XML file with a .GPX extension which I downloaded from
- The file contains a bunch of elements called <WPT>
- Within the WPT elements are a number of other elements <time>, <sym>,
- The non-qualified elements come from a schema/namespace at
- The qualified elements come from a schema/namespace at
- I ran xsd.exe with th...problem with multiple SMTP domains in Exchange Server 2003
I have added a second SMTP domain to the Email Addresses (Policy) as
> Recipient Policies
> Default Policy
> Email Addresses (Policy)
> New ...
> SMTP Address
> (checked) This Exchange Organization is responsible for all mail delivery
> to this address
When I do so, I no longer receive external emails on the first SMTP domain
Is this related to relay settings, or perhaps something else?
...Multiple Sessions of Outlook
Is it possible to run multiple Outlook sessions at the
same time with different profiles?
Author, Special Edition Using Microsoft Outlook 2003
***Please post all replies to the newsgroups***
"Sid" <email@example.com> wrote in message
> Is it possible to run multiple Outlook sessions at the
> same time with different profiles?
...Select multiple adjacent cells of multiple cells without selecting
Select multiple adjacent cells of multiple cells without selecting adjacent
cells one by one. those cells looks like;
|adjacent cells |cells|
|some characters | A |
|some characters | B |
|some characters | A |
|some characters | A |
|some characters | B |
I am trying to select adjacent cells of A cells without selecting adjacent
cells one by one.
Thank you for your help.
Adjacent in this case, means?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgr...Change cell background color based on content that results from li
This could be very simple, but I will lay the groundwork first. I have a
schedule spreadsheet that I import data to from a web based program. There
are existing filters to remove all formatting of the data and remove that
which we do not use. What remains is a non formatted sheet that other
workbooks link to so we can produce daily sheets. Now the data that is
linked on the other sheets may be for example the number 150. It appears
throughout the sheet and I would like to color any cell that contains the
number 150. The problem is I can't search for 150 because it reall...entering multiple costs for an item
I am very new to Retail Management, and am trying to enter inventory, and
create a purchase order. I can't figure out how to enter various costs for
the same item from the same supplier. For example, when we purchase in lots
of 50 pcs., the item cost is .50 per item (total cost of 25.00). However, if
we purchase in lots of 100 pcs, the item cost is .47 per item (total cost of
47.00). We can also purchase the item in boxes of 10 (5.50 per box for a
cost of .55 per item). How can I enter these costs so when I place a
purchase order, the cost will be correct according to the quant...Pull Data From Multiple Tables ????
I will have 4 tables name "TblCostomers","TblVendors","TblAccounts",
Now i have a for name "FrmDrVouchers" that has a table "TblDrVouchers" in
This form has two TxtBox Control name "TxtAccountNo" and "TxtAccountName"
If User enters a Account No., It pulls the Account Name from Any One of these
I can do this if I have only one table.
But tell me how can i do it while I have 4 tables for One Field of a table
Message posted via AccessMonster.com
http://...Query emails coming to a specific domain
We have about 5 domains on our exchange server that we receive email
from. We are in the process of not renewing one of our domains but
would like to check to see if email from that domain is still coming
through. Is there any way to do that? I tried the Message Tracking
Center with the *.domain.com but it didn't like that. It wanted a
Check SMTP logs as well.
MVP - Exchange
NEW blog location:
<firstname.lastname@example.org> wrote in message
news:...view multiple public calendars
We have seven public folders set up as calendar for room appointments.
How can we view them side by side as shared calendars?
The only way I can think of implementing this is to set up 7 user
accounts and share their calendars.
Posted via a free Usenet account from http://www.teranews.com
version of outlook?
if 2003 or 2007, add them to the public folder favorites and they'll be in
the calendar list.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipst...vb script for opening notepad
I am a newbie to vb...Can somebodyprovide me a simple vb script for
opening notepad in vista using windows shell
"Melvin" <email@example.com> wrote in message
> I am a newbie to vb...Can somebodyprovide me a simple vb script for
> opening notepad in vista using windows shell
What version of VB are you planning to use? This group is for VB classic(VB6
or lower) which is very different from VB.Net(sometimes called VB
2005/2008). If this ...RMS--Multiple Loyalty Clubs
Does anyone make an add on to allow for multiple loyalty clubs per client?
I would like to be able to set it up so that I can either print out a
certificate every month and send the customer a voucher for their reward
points for the particular club, or set it up so that certain levels of points
trigger certificates for redemptions for certain SKUs of product vs. a flat
cash credit to their account.
contact me at secure payment systems for some really cool options regarding
our loyalty card program that we are integrating with microsoft's retail
management system right now. It's...Calling a checkbox control with VB
Is there a way I can reference a checkbox item that I can manipulate
I have a series of check boxes that I would like to change the
properties of with a loop
So my checkboxes are called:
and I want to be able to reference them like so:
For i = 1 to 20
"CheckBox" & i.Value = true
By the format of the name, I assume that they are control toolbox
Dim oOLE As Object
For Each oOLE In ActiveSheet.OLEObjects
If TypeName(oOLE.Object) = "CheckBox" Then
...Viewing multiple excell spreadsheets on the task bar
Why is it that when I have 3 or more excell spreadsheets open they are not
all listed on my task bar the only way I can get to them is by going to the
window button and selecting the one I want to see, I want to be able to ALT
TAB between them and they are not listing them for me in the task bar only
the current one I have open?
Are you using XP? Sounds like that feature of XP which groups several
windows of one application into one spot on the task bar. There may be a way
to shut this off in taskbar properties. Click on the task bar and select
...Outlook security features in VB
I am using MAPI in VB to access outlook to sent email out
based the email ID in excel file.
When every new email was sent, the popup box shows "A
program is trying to access e-mail address you have stored
in Outlook. Do you want to allow this? ...."
Is there any way to turn off this feature?
I am using W2k and Office XP.
Thanks in advance.
...query to make a list of products based on delivery history
I have a table which lists all deliveries made of our product. From this
table, I'd like to make a list of all products. My problem is the products
will have many duplicates as they can be ordered multiple times and I just
want a list showing all the individual products that we offer.
Try something like:
SELECT DISTINCT [our product]
FROM [which list all deliveries made];
If you can't figure this out, come back with table and field names.
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Def...Lookup returning incorrect results
Anybody have an idea why I keep getting incorrect lookup results.
In sheet 1, I have a list of "Sales Codes" in col A. In sheet 2, I
have a list of data that with column A for "Sales Codes" and column B
for associated "Sales Reps".
I want to insert a column in sheet 1 that contains lookup formulas to
pull the correct sales rep for each sales code . Both sheets are
sorted in ascending order by Sales code.
My lookup formula in sheet 1, Lookup col B:
The returned results from the above lookup formula are incorrect....Update Query based on Current Recordset
I have a continuous form with filtered records. I want to run an update
query on a field in a table based on the current filtered records on the
form. What code would I use to accomplish this task? Any help appreciated
in getting me started.
Without a wee bit more information, like what are you trying to update,
field names, table names, do you want this attached to a button or an event,
etc... The best I can do is...
UPDATE SomeTable SET SomeTable.SomeField= WhateverValue
Of course, the above would be an ...Web hyperlinks: default browser and resulting browser window size?
Am using Excel 97 (I know it is old but I like it!) with Windows XP Pro
Have a series of web hyperlinks in a worksheet, that load the current
chart for a specified chart, from Yahoo Finance. For example:
http://chart.finance.yahoo.com/c/1y/c/tls.ax will load the chart for
the Australian telco "Telstra".
All the links work just fine but have two questions:
1) My default internet browser is Firefox but the links always open
Internet Explorer. Is there a way to ensure that Firefox is used?
2) The loaded chart appears in a maximised IE window. Which is a bit
silly as t...IIF Query for Numeric Values in Text Field
I’m attempting to flag interest rate spread errors and omissions in a file
from a sales database using IIF statements I adapted from another database
(I’m a novice at this). The field I’m querying is text format and contains
both alpha and numeric values. When I test for a null value the IIF works
fine, but when I test for a numeric value I get an #ERROR.
Spread Error1: IIf(([Tbl 1 Eligible Closed Deposit Opps Appended]!Spread Is
Spread Error2: IIf(([CCC Fall 2007 Eligible Products]![IB/NIB]="NIB" And
[Tbl 1 Eligible Closed Deposit Opps Appended]!Spread<4),1,0...Using multiple databases
I have three seperate databases - all do a differnt function using a seperate
database that holds all the data in tables (i.e. one uses queries to export,
one to import, one for reporting only) - and I want to keep all of the
databases seperate. Can I create another database that just has a form that
works as a dashboard and connect to the other three to do functions.
Essentially, I want to be able to select an option to open reports, import
data, or export data and do it without opening the other databases seperatly
(a function that each database will perform on it's own w...Print multiple tabs on one page
How to print multiple tabs in excel onto one page in one print job? Tab1 and
tab2 have different format and cannot be combined into one tab. Need to
print the two worksheets one on top of each other is the same direction.
Tried Report Manager but printed on two pieces of paper. Any suggestions?
One way to accomplish something like this is to play around with "pictures".
I'm on an XL97 machine now so,
When you hold down <Shift> and hit <Edit>, you get a different dialog box
.... one that contains "picture " options.
So, select an entire sheet, or p...Printing a Purchase Order to Multiple Destinations
Is it possible to print a PO to a text file on the local machine or network
in addition to the local default printer?
It is possible to print a text file to any single location you want in
addition to the local default printer.
Our system currently prompts users requesting this information. Giving them
their choice of 3 formats:
These can be selected in any combination but only one destination per format
can be specified. I am hoping that this thread will explain how/if one could
deliver one printed report to multiple printers. Eventually I would lik...Can VISIO 2007 work on multiple pages of an org chart simultaneous
I created an org chart with over 100 pages using the Org Chart Wizard and
Excel, I’m assigning colors to various shapes using the Data Graphic feature.
To apply the colors I choose “Edit” then “select all” which selects all the
shapes on the current sheet, then I select “Apply To Selected Shapes” from
the Data Graphics pane, this works fine for the current sheet but is there a
way to apply this to all the sheets at once. Thanks
I've written a macro for you to try in my blog...
See Applying Selected DataGraphic to the Whole Document -
http://bvisual.spaces.live.com/...Insert query with two left outer joins gives "Record is Deleted" m
I have built an insert query to combine data from 3 tables into one table
based on a key value (RA_ID) on a form. Two of the from tables may or may
not have data associated with the main from table. So I have coded the
select from statement using left outer joins. When I run the query with a
row in the first child table but not in the second it works fine but when I
run the query with a key value that exists in the 2nd child table but not in
the first I get a message saying "record is deleted". Anybody have any ideas
what is causing this?
Here is the query.........
...Filter by multiple colors
In Excel 2007, I am trying to filter by two different colors. I can see how
I can filter by just one color - can I filter by two colors?
Thanks for your help,