Search results

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...

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...

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>...

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...

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...