Search results

Look further down the post theres a sample xml file starts <mycomputer> and the code is there to read through the xml file.

You can use code to delete the file after use

Search for xml under user john.woody. I have posted an example of what you are looking for. John:D

What I do is use the outputTo command and output the report to html format, attach that file and send it. HTH John

In my example Your Example pc row = xNode.parentNode.nodeName type VerifyUser = xattr.BaseName "laptop" "summitftsuper" =xattr.Value If you run the sub DisplayNode line by line you...

Have a look at this post http://www.access-programmers.co.uk/forums/showthread.php?t=116258 The last post gives code which will work its way through an xml doc and read the attributes. You can capture the data you need and drop it in to the correct fields in a form or open a recordset and drop...

You could build a static html template and then search for info on the command. Using this you could add db data to the template before uploading it to the website. I have used this method to build thousands of html pages in to a catalogue to be burnt on to a CD which then doesn't need a db...

Create the function Then in your code at the point you want to pause HTH

Have you looked at the code in the visual basic editor in the spreadsheet to see if you can manipulate that?

Patrick to get the db to work you have to enter some info first. Open the main menu and click on email addresses and enter the information for your emails and the address you want to zip files to go to, then click on dbOptions and turn on the email option, next click on files and folders and...

Here is a copy of a file I have put together which zips and emails a db. Well any file, or a whole folder. Have a look it might be helpful for you. John

speculative thoughts Althoug you say "It's on a server - all permissions ok and not read-only" Favorite reason would be permissions not OK. May be something has changed on the server. I had a case where XPPro was serving a db and all of a sudden it went read only, I checked permissions and all...

I save a hard copy first, either as an html doc or as an Excel spreadsheet. The user doesn't need to attach the file, its handled automatically, they just complete the email address and click send. The file name I use is the same as the report name. You could always delete the created file once...

Try looking at this http://theillustratednetwork.mvps.org/RemoteDesktop/RemoteDesktopSetupandTroubleshooting.html

Its that simple... as long as you have a fixed ip address at work or sign up for a dns forwarding service. You also need to control the router to allow traffic through the router to the correct PC.

And finally the solution for vista business for me Locate OSPfilelist.txt Make a backup copy, then open it Find the lines which contain the following files DBMSADSN.DLL DBNMPNTW.DLL SQLOLEDB.DLL MSXML.DLL and delete them. You should then be able to create an install package, include the...

At last a solution I think. I've only done limited testing but if you find your opsfilelist.txt file that the packaging wizard uses, open it and delete all of the contents (make a backup copy first). Then when you are creating your package uncheck the "Yes, include system files" complete the...

you can write what you want using the above method by building your information into a string i.e Print #1 strMyString ' for each line you want to add I doubt you're going to get the output you want without using VBA though.

You could try using the print #1 command and programmically create and then add the text to the file. When you create it give it a .xml file extension. Open "FileName.xml" For Output As #1 ' creates the file Print #1 "your text" ' for each line you want to add close #1 ' closes the file hth John

As a temperary measure I have found that if I run AccessRT.MSI from the runtime folder of my package Runtime 2002 installs. I can then copy my database files accross, create my own shortcuts and I can get programs to run. I had to remove a couple of references first though (which I wasn't using...