Thank you. I do already have this working within Access. What I'm looking for is if someone has used VB or VBScript to automatically load XML into an .mdb file, bypassing the Access interface.
Thanks for the reply though.
I'm need to import an XML file into Access 2002 automatically every night, creating and overwriting a table. Has anyone done this using VB or VBscript?
The answer:
I had a javascript subroutine that was doing the submit of the page after checking some fields - function checkdata(), document.chmodify.submit.
I had also copied a submit button tag from another page to change a former button that was an input type="button". The one I...
Oh, you're gonna love this!
I declared a session variable (called dcount) on the main page, then did a count on it in the zupdate routine where the mail code resides. I added 1 to dcount everytime it was supposed to go through the routine. Get this - on submit of the page, most of the time the...
I've got a MS Word 2000 document with all of the code in it if you want to sort through it. It's a lot of code. Still generating two emails. Can't figure it out. Thanks.
http://www.jircitano.com/this.asp
I've written ASP code to send mail using the default SMTP server on a Windows 2000 Server box. My problem is 99.9 percent of the time the mail messages are being sent to each recipient twice. Less than 1 percent of the time a message will get sent only once.
My ASP code is simple (see below)...
I've written ASP code to send mail using the default SMTP server on a Windows 2000 Server box. My problem is 99.9 percent of the time the mail messages are being sent to each recipient twice. Less than 1 percent of the time a message will get sent only once.
My ASP code is simple (see below)...
Oh, and I forgot one thing:
mminuteid is simply a variable set to the text field in your database. You set that earlier before executing the statement, of course.
Chris
I've had the same problem today. What I found out is that you have to execute an entire separate SQL statement to get it to work.
I did this:
<textarea name="txtmtext" id="txtmtext" rows="28">
<%
mydsn="dsn=chconn"
mysql="select minuteid, mtext from...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.