having trouble retrieving/using xml string from database field
I save a fairly small xmlDocument to a single db field, xDoc.OuterXML
using a SQL insert statement...this works fine.
However, I then need to select that field (xmlWF) into an xmlDocument
to add nodes, etc., but haven't found the correct way.
I've also tried just saving it as a session variable, but still get
errors when I try to use it, so I know I'm doing something wrong!
Dim xDoc As New XmlDocument()
xDoc.Load(varWF) 'uses the session variable
this gives me a "path too long" statement
Ideally, I'd like to know the ...customizing contact fields
CRM 1.0 when we remove unwanted fields in contacts and
accounts it does not show the updated view for users but
when going back to customize it shows the fields as being
removed. Any suggestions as to why this is and how to make
Are you referring to changes in the form? If so, did you publish the
changes and issue an IISRESET?
On Thu, 5 Feb 2004 15:14:31 -0800, "Bernie" <email@example.com>
CRM 1.0 when we remove unwanted fields in contacts and
accounts it does not show the updated view for users but
when going back to customize it shows...Pivot Table Total
I have a pivot table that pulls data from 2 places. One is
a list of categories and the est. cost amount. The second
is a pivot table that tracks the cost of each category as
the job goes on. The new pivot table lists the categories
then has two columns with the est. price and the actual.
Is there a way to have the Grand Total subtract the actual
from the est. amount instead of adding them?
...PUTTING NUMBERS IN A CELL
I AM TRYING TO ENTER A NUMBER THAT BEGINS WITH ZERO'S AFTER I ENTER IT THE ZERO'S DISAPPEAR, HOW DO I KEEP THEM IN
Please turn off the CAPS Lock, more than two lines would
be extremely difficult to read. Reading caps is annoying.
Format the column as text, if the leading zero is important to
you then it is an identification not a number. The default
alignment for text is left aligned which is also better for
most identification "numbers".
Credit card numbers are 16 digits, are identification and
can not be entered as numbers, ever, because Excel only
retains 15 si...tabbing through fields
I have a form in Excel and I'd like to be able to tab
from one field to another. Is there a way in Excel I can
do this within and ONLY within my form? As it is, I tab
right past the form all the way to the end of eternity!
This post might help.
Please keep all correspondence within the Group, so all may benefit!
"Dan Nash" <firstname.lastname@example.org> wrote in message
news:email@example.com....Table Default Values
Is it possible to set the default value of a field in the table to either a
value entered into a message box or a value entered into another table?
I'm importing data from a text file into an existing table. I have been
manually changing the default value for the report date field each time I
import a new report, but since I won't be doing the importing anymore, would
like to automate or simplify this process.
If you want the current date you can just use =Date(). If some other
date, you can do something like this:
Public Function Lo...Percentage between two numbers
Hi, i have this two situations:
2394 34 -98,58%
34 2394 6941,18%
This is the formulas i used:
I need a formula to calculate the percentage of differences between two
numbers even if the first is bigger than the second or the other way around.
This is how i need the final result to look:
2394 34 -98,58%
34 2394 +98,58%
Can this be done?
Percentages don't work that way. If your investment portfolio drops 50%
(from $10,000 to $5,000), you need a 100% increase to get back to your
starting position. Similar...Microsoft Management reporter migration from Frx
I ran the Microsoft Management Report migration wizard. Several reports
have an entry in the Row definitions for CBR as a format code and in the
"Related Rows" and entry for 195 the row for our Net Sales.
In the column definitions we have a formula of B/CBR%. CBR% is generates
an error that % is an unexpected character and removing the % I get an error
that CBR is not a valid cell reference.
The help file seems to indicated that BASEROW should replace CBR but BASEROW
is not a selectable option in the Row definitions as a format code.
...Nulls in Access 2007 Fields
Here is my issue:
I have to generate a report which breaks down specific information,
specifically a count derived from when the information was created. I have
accomplished this. My problem is when I run a specific query for one piece
of information it returns what I am looking for. When I run a different
query with the same information looking for the other data I need - it does
not give me anything. Now the problem is there is nothing for the database
to pull up because the answer is zero, but I can not get Access to give me a
zero in the field to show there were no new enrollie...Drop down field
I have a drop down field in each entry of my budget which
has many option. I also have a total amount for each
option. I want the expenses of each option to be deducted
automatically from the totals when the option has been
chosen. Here is my formulas, but I am having a problem
with it. Can someone help me with this matter?
=IF(Sheet1!E1=1,'2106 - Travel - Locally!'D306-M9,0,IF
(Sheet 1!E1=2,'2106 - Travel - Locally!'D308-M9,0))
In the column next to the option on sheet 1, I have
entered number 1 to 8 (As I have 8 options) and when I set
up my drop down field I ent...How to add SY03900 table in the Sales Report?
Dynamics GP Sales Order line item descriptions are limited to 100 characters
only. Our company needs more than that and we decided to enter it in the Item
Notes field. We are not using the Line Item Notes field when we create
quotations as we have other usage for that as well.
My question is, how do I add and print the Item Notes field in the
customized Quotation Form when I can't seem to add table SY03900 in the
Since you have mentioned that you want to show the Item Notes in Customized
Quotation Form, I assume that you are working on a 3rd ...Field Codes
I'm doing a calculation in a word document using field codes (office 2007) but
I'm trying to represent the result in Hex. Although I am able to do the
I want to if the result is bigger than 16 bits (65535) then when I try to
as Hex the field code says this is an error "Number cannot be represented in
specified format". Does anyone know if it's possible to display a Hex number
a field code bigger than 16 bits ?
You may need to split the source value into two (or more parts), using INT and MOD functions (presumably using ...How can I parse or Loop a list based on single field to Googlemaps
This is some code that will parse each sequential field [Point_#) into a list
"http://maps.google.co.uk/maps?f=q&hl=en&q=" & "from: " & Me.Point_1 & (" to:
" + Me.Point_2) & (" to: " + Me.Point_3)
The table/form is laid outlike this:
[Route_No] [Point_1] [Point_2] [Point_2]
5 North St, N1 East St, N3 High Road, W6
And the code will give this style of parsed list:
from: North St, N1 to: East St, N3 to: High Road, W6
That works just ...Parameter Make Table Queries
I have an excel spreadsheet that establishes a link to an Access 2003
DB. I need to be able to run a pre-saved make-table query with 4
parameters that is stored in my DB, and then use excel to run a pre-
saved crosstab query off of this table and a few other queries. The
results of this crosstab will ultimately be pulled into Excel. I
tried changing the make-table into a select and modifying the cross-
tab, but because of the parameters and complexity of the cross-tab, it
The first problem is:
I "dummed" down my make-table query to eliminate all parameters. Upon
...Can you put white space outside a textbox?
When I put pictures in my publisher file, sometimes I want captions
for the pictures. So I make a tiny textbox that I put under the
picture, and type in a caption into that textbox. The problem is that
I can make the picture have some space to left and right of it so that
text doesn't crowd into the picture, but I can't do that with the
textbox containing the caption. Is there any way to prevent outside
text from crowding the borders of a textbox?
You can move that textbox wherever you need. You don't need to leave space
inside when you can steer clear of the textbox itself.
...Linking Tables 06-01-07
When I link tables - File > Get External data > Link tables..., I can change
information in the Excel sheet and the change is reflected in the access
table; however I am not allowed to make any changes to the access linked
table - anyone know why?
Microsoft lost a lawsuit last year, and was forced to remove the ability to
update linked Excel spreadsheets from Access.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Sandy" <sandy_stephen@DELETEhotmail.com> wrote in message
> Whe...Table Place settings design
We are having a company dinner party to say goodbye to the oldest member of
company. 70 yrs old
We want to print a place card with photograph and some words on it for 50
Sounds like a Tent Card would meet the need.
If you were using Publisher 2000 (your version may be similar) it would be,
Tent Card (From the Choose a Special Fold menu)
Choose an Orientation Portrait or Landscape, your preference
If you plan to use other than 8�"x11" stock, do first, select
Provide the stock size as you follow the Setup steps.
--...Opening a filterable report from a form
I am building an access database and am attempting to create a form (menu at
startup) that I will use buttons to open other forms and reports.
I am using a blank form and adding buttons (links to the other forms and
reports). I have chosen in the wizard to Open Report under Report Operations,
choose my report, and finish the wizard. But the button I have created does
not do anything. I checked the Macro settings and it is missing a line.
Here is the code:
Private Sub Command7_Click()
On Error GoTo Err_Command7_Click
stDocName = "Deficiencies Report"
(missing sta...Query. How to add this calculated field?
Add a calculated field for ExitDate, which is when the renter will leave the
unit based on the date the rental started + the length of stay * 7 (to
convert the total time in unit from weeks into number of days)
Hint: StartDate + (Length * 7)
---StartDate, Length are data columns. How can I do this!? I tried: Design
View on the Field row typed:
[StartDate + (Length * 7)]
But it's not working it shows a windows "Enter Parameter Value". Maybe I'm
How can I do this!?
Try this --
[StartDate] + ([Length] * 7)
Build a little,...Save record order in main table
I have a form which displays four field from a table. On the form I have 4
sort buttons which sorts the form based on the field selected. My table also
has a field for a sequence number. Based on the sort order selected I would
like the sequence number field for each record in the table to correspond to
the record number shown on the form. In other words, based on the sort the
first record shown on the form would get a sequence number of 1 in the table,
the second record shown would get a 2, etc.
Is this possible and if so could someone help with the code.
Your help woul...Where to put SQL statements in VC++ Application
I am wondering if putting all my SQL statements in the string table is
a good idea. Is there a better place to store these statements?? Thanks
in advance for any responses.
Inline in the code, they arnt particually helpful to put in the string
- Mark Randall
"Those people that think they know everything are a great annoyance to those
of us who do"
<firstname.lastname@example.org> wrote in message
>I am wondering if putting all my SQL statements in...modify drop down table associated to vlookup
I've been given a vlookup formula, that is associated with some drop down
list... The formula is:
when I go into the name box or the area that would dictate which cell is
active the "JobID" is available as a drop down.
After clicking on "JobID" 4 cells are highlighted in one row / 4 consecutive
This is new to me, how can I modify what area is associated with the "JobID"
list? Does this List start at a specific row and goto the bottom of the
any assistants would be appreciated.
You must be thinkin...Two Languages
I am currently trying to create a web page in Publisher 2003. I have created
the English Version of the page but I would like to make another version in a
different language giving links between the pages!!! How do I do it??
Mary Sauer MSFT MVP
"AK" <AK@discussions.microsoft.com> wrote in message
> Hell...DCdiag reported test failures. What next? Hpw to fix them?
I ran this on our two domain controllers. Several test failures. Can anyone
help figure out how to fix these errors?
DCdiag Test Run On Domain Controller CGDC1 from TCGNS2K3
/c switch is for comprehensive test
/s: <domain controller> names the target DC for the test
C:\Program Files\Resource Kit>dcdiag /c /s:cgdc1
Domain Controller Diagnosis
Performing initial setup:
Done gathering initial info.
Doing initial required tests
Testing server: Default-First-Site-Name\CGDC1
Starting test...Put app and icon in task bar?
I have an MFC application that I want to be able to
put in the task bar as a small icon and have it pop
up the dialog when selected from the task bar.
This app is intended to be run from the start up menu
and be minimized in the task bar along with all the other
Pointers on how to please...
By default app goes on the task bar. Do you mean system tray (that by
default appears on the bottom right of the screen)?
Ajay Kalra [MVP - VC++]
"ShipHead" <GoAway@SpamBoy.com> wrote in message