I have a series of tables in MS Access 2003 and would like to export a subset of the data out in an XML format. I have come accross the Application.ExportXML facility in MS Access 2003, but is this applicable if I need to export 2 fields from Table A, 3 from Table B and 1 from Table C. My question is, should I write a VBA module to export the data I require or are they an example on how to use Application.ExportXML in the way required. I cant find much documentation on this facility. Sorry if this is the wrong forum. Many thanks

When using DOM to process an XML file, I need to get hold of the attributes when present. Now I can get hold of them if I know there names, but what about when I do not know the attribute names? Set objAttributes = objDOMNode.Attributes 'check that there are attributes. If objAttributes.length > 0 Then 'we know that we've named our id reference as ''PERSONID', therefore tell the NameNodeListMap to get 'this node by using the getNamedItem method Set objAttributeNode = objAttributes.getNamedItem("PERSONID") 'store this value in the tag of the treeview tvwElement.Tag = objAttributeNode.nodeValue End If The above code is OK for when you know the attribute name, but its the case when you dont know the number and names. Any suggests please.

When using DOM to process an XML file, I need to get hold of the attributes when present. Now I can get hold of them if I know there names, but what about when I do not know the attribute names? Set objAttributes = objDOMNode.Attributes 'check that there are attributes. If objAttributes.length > 0 Then 'we know that we've named our id reference as ''PERSONID', therefore tell the NameNodeListMap to get 'this node by using the getNamedItem method Set objAttributeNode = objAttributes.getNamedItem("PERSONID") 'store this value in the tag of the treeview tvwElement.Tag = objAttributeNode.nodeValue End If The above code is OK for when you know the attribute name, but its the case when you dont know the number and names. Any suggests please.

I have just started to learne about XML and need to write some software to help managed the exchange of data between different complaines. I am unsure what to use for processing XML, i.e. Visual Basic 6 or using Visual Studio .Net and perhaps an MFC C++ application. Any advice please and a site of a good example. I am quite happy with either.

I need to import into my own database an old Foxpro 2.6 database. I can copy this datadate to a tabbed delimited file, but its missing the Memo data. From the past, I remember you needed to do something special with the Memo fields. Can anyone tell me how to get the Foxpro database into a complete tabbed delimited file - with the Memo text included. Note I am using the Command Window of Foxpro to do all this.

This resource does not exist in either project that created or used the ActiveX. The default Icon that appears in the ToolBox is OCX (thats the project using the ActiveX), but get the silly Rectangle with cirle on the dialog at the design time.

Is it possible to change the boring Icon when you create an ActiveX control in VS 7.1 The default - rectangle with circle is pants!

I have a Arcom Digital I/O PCI card installed in my PC. Now I would like to create a ActiveX control to set and read a few of these I/O channels. What I would like is use this card in both an MFC application and Web Pages, so never need to use the cards API. What type of ActiveX do I need to create and how with Visual Studio 7.1. All ActiveX examples I hav seen are done in Visual Studio 6.0 Any comments or links please.

Did not find anything. When searching for new h/w did see a USB Human Interface Device, but no options for calabrations.

In WIndows 2000 where is the option to calabrate a UBS joystick. The Joystick works OK, but ranges a bit out!

I have been developing my first ActiveX called MyJoy , which will use the Joystick and mouse as pointers. Snips of code in the MyJoyCtrl file is shown below.

BEGIN_MESSAGE_MAP(CMyJoyCtrl, COleControl)
    ON_OLEVERB(AFX_IDS_VERB_PROPERTIES, OnProperties)
    ON_MESSAGE(MM_JOY1MOVE, OnJoy1Move)
    ON_WM_MOUSEMOVE()
END_MESSAGE_MAP()

Now I get the MM_JOY1MOVE messages but not the ON_WM_MOUSEMOVE, have I ommited something? I have like for the Joystick included the OnMouseMove handler.

void CMyJoyCtrl::OnMouseMove(UINT nFlags, CPoint point)
{
	x_m_pos = point.x;
	y_m_pos = point.y;
	if(capture == VARIANT_FALSE)	// No Joystick operational
	{
		x_pos = x_m_pos;
		y_pos = y_m_pos;
		z_pos = 0;
	}
}

Any suggestions please.

Am I correct in thinking that all the functions of an ActiveX is placed in the Class (e.g. Message Maps, Events etc) and the Prop provides the Methods & Properties for accessing the control. Do you use the Dialog form on the Prop to place indicator controls( static labels, edit boxes etc) - How is this dialog used? Not quite sure how to expose properties ( can see how to add them) but how do you tie them to Class vaiables. Not been able to find a simple example using VS 7.1

The only examples I have found are for VS C++ 6.0; e.g. Circle, Button, CIRC1/2/3 etc. Are they any articles/tutorials for VS .Net as the Wizards hav gone on .Net Cheers,

Can someone point me in the right direction for doing my first ActiveX control in Visual Studio .Net (MFC C++). I have a MFC application that uses the USB joystick port, but would now like to convert it to an ActiveX. Many thanks,

I can use the 8 data lines of this port OK, but when it comes to using the other 4 output lines on the control section of the port I have no luck. I keep getting 0x0C back when I read these lines (no matter what I set it to):- Note Using PortTalk for Windows 2000: Code: int ReadPortLPT1C(void) { int value = inportb(0x37a); return value; } void WritePortLPT1C(int newData) { outp(0x37a, newData); } As I said it works fine for the data lines (8) at address 0x0378.

What about Serial ports, do they chatter during start-up. Also is USB an option?

OK thanks for the info.

I have been using the parallel port to switch a few relays. I use PortTalk to acces the parallel under Windows 2000 (and XP later - still TBD). However during WIndows 2000 startup the lines chatter, i.e. some sort of self test (or access) taking place? Once the PC is up and running they are no problems using the parallel port. My question is are they any way to stop the lines of the parallel port being accessed during startup? Many thanks,

I tried 0x8000000 and it worked OK. But thanks for your post.

Still the same compiler warning.