XML to XML Using XSLT
I need to transform one xml document into a second xml document. They
both have many nodes so xslt works fine, but there is one node I have
not figure out how to transform.
Here it is:
Node in Input File.
<FullAddress>JOHN SMITH@19495 BISCAYNE
The Result should be:
<Address>19495 BISCAYNE BLVD</Address>
It seems to me I have to "Split" or "Par...How to check if mouse wheel has been used, system-wide?
I have the following task - I need to check time to time if mouse
wheel has been used by the user, in ANY application. I have some
kind of user activity detector, to do certain actions in application
when user is idle for some time. It would be nice to have the
ability to check if mouse wheel has been used. I already know how
to check for keyboard (GetKeyboardState and compare with previous
call's result) and mouse (GetCursorPos and compare with previous
I know how to set up a hook, and can achieve what I need via hook.
But, customer says sometimes system runs slo...want to turn PT row data into column data
name win loss score
paul 1 325
Jane 0 1 225
walt 1 400
nancy 0 200
jane 1 300
nancy 1 200
paul 1 365
walt 1 350
when i create p.t. I get (or a vague approximation)
but this is what I would like:
name win loss avg
Paul 2 0 345
Jane 1 1 260
walt 1 1 375
nancy 0 2 200
Grab the g...Formula to calculate time
I was wondering if anybody knows of a formula to allow you to do calculations
based on time. In other words, say I want to put a list of songs on a CD and
their durations. Then, I want to add up the durations to get the full time of
the CD, or my specific play list. So for example, using the information below:
Ghostbusters - Ray Parker Jr. --- 5:23 (Just a guess)
Phantom of the Opera Overture --- 3:55 (Another guess)
Instead of 8:78, I'd want to see 9:18
Can this be done? Any help would be greatly appreciated. Thank you!
Have a nice day!
Charting the futu...revisions to documents
Help. How can I place a revision date in a document, to change to the
current date if and when changes are made to a specific page?
You will need to be a bit more specific about what you are doing. However I
suspect http://www.gmayor.com/save_numbered_versions.htm would be a better
approach. If not, it is difficult to come up with an automatic solution that
will not apply universally to date fields throughout the document - i.e. on
pages that have not been changed.
<>>< ><<> ><<> <>>< ><<> <>>< <>...Forms - Call Data from Another Table
I'm used to using lookups and forms etc but need to do something that I
think links queries, VBA (completely new to) and forms:
I have a form for creating new applicants
I want to build a form that allows the user to search a contacts table on
FirstName, MiddleName, Surname; receive a list of matches and then either
1. Select one of the matches which would then populate the applicants table
2. Reject the matches and create a new record as normal
Can you anyone point me in the right direction?
Sounds like you are asking how to do callbacks.
Open a sub form ...Update Worksheet data to other worksheets Data
I have two Excel file. One Excel (A) create by User and other Excel
(B) is shared version posted on company shared directory.
I need update Worksheet B base on Worksheet A.
In Worksheet A, the key is Col A + Col B + Col Cm matched to Worksheet
B, the key is Col A + Col D + Col E
Below Column need to update WS A to WS B. The column may be changed.
After each Updated.
Work Sheet A -> WorkSheet B
I - > P
Any suggestion to using VBA to Update Excel B ?
If Records not f...Strongly typed dataset for hierarchical data
I'm trying to create a simple XML structure for storing tree-stryle data for
a forum-like software, e.g. each post will have a body field, the ID of the
user who posted the message, and zero or more subposts(replies). Thus it
would allow for unlimited depth of subposts.
I also need a simple table to store UserID, Full Name, etc of the users
I've created a schema in VS.NET 2003 as follows. However, now I need to add
a relation between ID field of User table and UserID field of Post table
(one-to-many). If I try to add such relation, I get "Failed ...Copy data from different columns of multiple sheets
I have to summarize the latest sales number from different offices, more than
40 of them. The numbers are sitting in one Excel file with each office having
one sheet. On each sheet the sales numbers for that office are listed
monthly. The latest number for some offices are for Nov, some Oct, and some
terminated offices with numbers as early as a couple of years ago.
Here is what I have to do: I have to go to each sheet (named "office 1" to
"office 50"), find the last column with data in that sheet and copy the
column to a new sheet (say Sheet "Summary&q...Importing external XML Data
I have data in the form of data tables stored in and being passed around in
XML using WFC but being serailised as XML files.
I would like to simply show this data via a Word template. Formatting the
data into Word tables, this would very much a kin to using word as a
I have looked at varoius examples but I can't find anything without
droppping into code that can take an XML file , transform it into a word
table. I prefer to find a way that user can modify the look and feel without
having to resort to code.
It would be great to use a custom control com...Open procedures in a form using vba
How can i retrieve the procedures in a Form, make changes to the
procedures and save all within a vba script. Particularly the onclick event
...Will Access print data to a blank hard copy form?
I have blank printed forms that I want to print data from an Access report.
The positioning of the report data on the blank form is important. Each
record must print on a new page. Is this within the capabilities of Access,
and if so how do I get instructions to set it up?
Thanks in advance,
Pride Runs Deep
I'm not sure what you're asking.
Since Access uses the Windows printer driver(s), when Access prints, Windows
Can you do what you need to from Word (get the print to happen in the right
If so, you can adjust where Access starts printing to line ...Use that update
Content-Type: multipart/related; boundary="tscfwovfm";
Content-Type: multipart/alternative; boundary="fbsqpmek"
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to protect your computer.
This update includes the functionality =
of all ...How to create and use the Handle philosophy in a Homemade class?
I have a non-derived homemade class with basic variables, I want to pass
this class to a homemade ActiveX class. I think the best is to pass a handle
pointer in the argument. But I don't know how to build a handle in my class?
what is it anyway? I guess that is make easier the data transfer between
complex ressources, I that is what I want to do. So how to handle the handle
let say my class is like that :
i need your special knowledges for converting a table.
I have a table with special format having values for last
year data, budget and actual of this year. (3 columns) and
there are 2 columns of having as a percentage the
difference bteween thos three columns.
The values are in a local currency for each shop. i.e. USA
There is anyway that i can transform those values
automatically to Euro. Either by coping the tables, or
using currency converter, or doing a "tric"?
Any good suggestions?
Thanks in advance
Assuming your US$ value is in...Import Data from Access
I want to create a membership booklet (5.5"x8.5"). This means folding an 8.5"x11" page in half.
As you know that means the page with the A's will also be the page with the Z's
So I need to import the data from Microsoft Access (or Excel) then printing it out so that the pages line up properly.
Anyone know how to accomplish this?
What version Publisher?
If you have 2003 use the catalog merge.
Mary Sauer MS MVP
"DES" <dstand_53146_no_Spam@yahoo.com&g...Passing data to worker threads
I'm trying to make an application that use CAsynchSocket class (derived to
my class CMySocket);
i've put a button "Connect" on my formview (CMyView) and when it is clicked,
i show to the user a modal dialog form (CWaitDlg): this dialog starts a new
worker thread that make the connection in background.
The problem is that the CMySocket object is a member of the CMyView so the
code i use is:
m_waitDlg.m_sConnectSocket = &m_sConnectSocket;
m_waitDlg.m_wParentView = this;
m_waitDlg.m_strName = &m_strName;
error = m...Formating excel multiple paragraphs and colums using one source of data
column #1 product names separated by category names.
column#2 prices corresponding to products.
Final sheet is basically all product pricing.
To print this out i need to create lay out on sheet # 2
This sheet would have three vertical frames.
this frames would have two columns(one for product names one for
Sheet #1 would project the content to sheet #2 in such way that if
sheet #1 content changes all the content would get formated in number
#2 sheet accordingly .(This content will have multiple pages within a
How can I achieve that?.
...Creating scientific data collection form
Is access right for me?
I am a natural resource and environment management specialist and I would
like to create a data collection sheet for an ecological survey. I have used
access in the past for data management, however, I am still a beginner. I
understand that I can use access to create forms that can be used to collect
and enter data. But I am not sure how to do this as it has been a while since
I have used access. Are there tutorials available for this?
I wish to collect scientific data on a number of ecological characteristics.
Are there examples of forms that have been...Laptop Client Synchronisation
Hoping somebody can shed some light on this. When I click the Go
Offline button on my laptop to synchronise the CRM data it's get's to
Synchronising 56 Letters to offline database
and shows the following error:
Failed move data for entity 'Letter' during action saDelete,
countRows=56. Contact your system blah blah blah.
I have deleted the campaign the letters were part of (this is a
relatively new installation that I'm now starting to use) and all
traces of the letters that I can see, but no joy. I even deactivated
any entries with the 'Letter...Linking Sharepoint data to Visio
I am looking into the Database possibilities of Visio Professional 2007.
I managed to connect Sharepoint to Visio, but only in one way. So Sharepoint
is leading and Visio follows. Is there a way to make the connection two
ways, so that is Visio is changed, Shairepoint will follow ?
I'm going to assume that you have linked data to sharepoint via
datarecordsets. Data recordsets can roundtrip information but it has to be
done with custom code. Data recordsets can be read/updated in the document
using xml. The export then has to be coded based upon the target yo...Data from several worksheets
I've read some of the existing questions/answers ..... and I'd like to ask.....
I'm using Excel 2002/XP. I currently have one file (Task List) with 6
worksheets (Areas of Responsibility) and four columns (Name, What, Start
Date, Deadline). Each row is a different task.
I would like to be able to retrieve my file and request that it gives me a
new screen with all the tasks with a deadline of a specific date.
Can this be done? If yes, how?
I'm relatively new to Excel and do not know much about visual basic codes.
Any help would be appreciated. Thanks.
So I have about 10 fields, no spacing between them on the window. I need to
add a few more fields in the middle of them. My worry is that the data in in
the fields wont move along with the field. I figured I could use modifier to
move the fields but that is not licensed either. Any suggestions to ensure
nothing gets missed? I was thinking of updating the field data info on the
extender table but was hoping a better way.
You move the fields using Extender 'Move Field' option. Open the window you
want to modify and then select the field you want to...Data Query on the Fly
Does anybody have a Data Query on the fly example?
I would like to query a Microsoft Access database and stuff the results into
a new table. Can anybody help? I have used the External Data Function but
would like to customize the SQL with data from the XLS sheet to return
Thank you in Advance,
Not exactly sure what you want to do, but perhaps
How To Use ADO with Excel Data from Visual Basic or VBA
will be of some help.
Tom ...open database to input data
When a user opens the file for the database in Windows, how do we make it so
the form for inputting data is already pulled up, so the user will not have
to remember which form we want?
One of the easier methods is to use the AutoExec macro. Create a macro;
name it "autoexec"; then set its actions to open the form you want; and
maybe minimize the database window, hide the toolbars, etc. When the mdb is
opened, the autoexec macro is called and all its actions are run.
A slightly more involved approach would be to create a Switchboard type form
to serve as an on-scree...