Search results

So I have an access database that I use to load xml documents and extract the info I want. I currently use a form to interact with the vba modules to accomplish the task. You check a box, push a button, and several queries are run against local databases to get all the necessary info, use it to...

Different users generate different xml files every day and, every day, I have to have to summarize what is in the xml files. I wrote a small script using loadxml command to load the xml files and extract the information I want from them. However, in order to load the files, I must pass on a file...

I'm trying to write a DSN-less connection to an oracle database. Here's what I've got so far. DIM cnn AS New ADODB.Connection DIM strOra AS string strOra = "Provider=OraOLEDB.Oracle;Data Source=Prod;User Id=<username>;Password=<password>;" WITH cnn .connectionstring = strOra .open...

I need to fully automate the sending of an e-mail from within access. So far, I've used the .sendobject and outlook.application/outlook.mailitem/etc... Both of those methods work, but the both give me a pop-up telling me that access wants access to outlook and I have to click "Yes" in order to...

Here's my problem. I need to generate a report that says how much of each individual product was produced and as well as the total produced for a specified category in a time period. Something like the following: 05 Catagory A: 02 Product AA, 01 Product AB, 02 Product AC 10 Category B: 07...

I currently have the following query written: DELETE * FROM TABLE1 When runs, it tells me the number of rows to be deleted and I have to click "Yes" for it to run. Is there a way to run the query and not have the prompt so it will run without human input?

Here's the scenario. I've queried data from an oracle database and want to save it locally. The local table needs to be wiped clean or recreated before the results of each query is appended to it. I also need to save the number of returns the query gives in yet another locally stored table that...

How do I create a table with VBA using the results of a query? Also, I want to use ADO to access a table in the current access database that's linked to an external database table. However, whenever I try to run initiate the connection, it says that the file is currently open and being edited...

I've linked access to an external database and created a query to pull results from the linked access table that was between certain times on certain dates (i.e. between 11/12/2007 11:01 AM to 12/13/2007 12:01 PM). The query I have thus far is "SELECT * FROM TABLE1 WHERE DATETIME >= #11/12/2007...