Search results

Yes, the files are stored on a Unix server and Samba is used to connect the windows machines with the Unix servers. No I am not using option compare binary.

My current code is basically this: fpath = <absolute path to file> if not xmldoc.load(fpath) then <print error message> end if

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

that would work. Does your code work no mater what product/categories are populated inside the database?

The reason I don't want the user to have be there to click yes is that it the e-mail sent details things of interest to the higher ups and the info varies with the day. In order to have this sent, someone has to come in early to write the e-mail before others arrive and start working. This is...

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

I've attached a sample database. The sample table has 3 fields, an auto number, Unique ID to represent the unique identifier for each product, the product code, and the category. I need to the final product to be something along the lines of: 5 board game: 2 monopoly, 3 sorry 2 video game: 2...

Haven't tried your suggestion, but from reading the query, it sounds like it won't work. The database doesn't store a numerical value for the products produced. Instead, it product produced has a unique identifier and occupies it's own row in the database along with the appropriate product...

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

My code is: Dim con As ADO.Connection Dim SQLstr As String con.open CurrentProject.Connection set SQLstr=[SQL Query]

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