Search results

Hey, Making the records through VB was taking really long but it wasn't a problem with how I wrote the code, just the fact that letting make each individual record while parsing through the xml was slow. EDIT: I checked and I found that I fixed the problem using a .XSL file to transform the...

Thanks for the advice everyone. I'm sure they'll be of use in the future. Right now I got it to work by telling Windows Scheduled Tasks to "Only Run When Logged On".

I'm simply running it on my computer. I currently have the macro security set to low for this database. I'm testing the windows scheduler while I am still logged in (I'm setting the Schedule to run 1 minute from 'now'). I tried opening other things with my Windows Scheduler in the same fashion...

Hi, I'm trying to automate a few things with Access 2003. I have the code working fine in my .mdb file, including the AutoExec macro to run the code. The issue I'm having is when I set Windows Scheduled Tasks to open my .mdb file, it doesn't get opened. It simply says "Could not start" as the...

make a module and name it "nub", type copy/pase this in: sub jaja() const strPathToXML as string = "C:\Path\To\File.xml" Application.ImportXML strPathToXML, acAppendData end sub Note: you change "C:\Path\To\File.xml" to whatever the path is to your xml file. Then make a macro, name it...

Yeah, I saw the "MISSING:..." one, and unclicked it when I got the error again; I forgot which library it was for. It didn't solve anything :(

Hi, I am having a weird problem with my VB code in Access 2003. I made a module which parses through an XML file. I added these 2 references: Microsoft XML v6.0 (msxml6.dll) and Microsoft XML, version 2.0 (msxml.dll) I wrote the code, and everything was working fine. I moved the Database to...

From what I understand, you have the solution right there. This line of code imports and appends to existing tables (if they exist, if not it creates the tables automatically): Application.ImportXML strPathToXML, acAppendData the only variable is "strPathToXML" which is a string holding the...

My current solution is to not let Access import the XML and create the tables, but instead I parse through the XML in VB. I'm making the records myself while getting the data from the XML tags (aka nodes). This method takes way too long (about 20 minutes for 25,000 different nodes in the XML)...

Hi, I'm importing an XML file into Access 2003 to make a table but I'm having problems with the tables that are automatically being created. The XML tags have this format: <?xml version='1.0' encoding='ISO-8859-1' ?> <Companies> <Company> <ID></ID> <Name> </Name> <Address>...

Thank you for your input. I was planning on using KillProcess("Excel.Exe") as a last resort. Is there any way to check if Excel is open so the user has the option to save his files?

Hi, I am using MS Access 2003 an dhaving an issue involving an error when opening a table while MS Excel is open at the same time. Is there any way to check which processes are open? My solution is to see if Excel is open and if so, a msgbox comes up asking the user to close Excel. A better...

Thank you for your reply. I completely forgot about modules...

Hi, What I'm looking to do is update certain fields in a table without replacing the entire field. Currently the field holds strings and I want to change all entries starting with either "abc", "abc ", "abc -", "abc - ", and "abc-" to start with "123 - ". So for example I might have records...