Search results for query: *

I realize what I am going to say will not make a lot of sense why I want to do this, but after I gave you long explanation, it would. I want to put a number of NON-SQL tables into XML documents. Then, I want to inert the data from the XML documents into existing SQL tables. The format of the...

I realize what I am going to say will not make a lot of sense why I want to do this, but after I gave you long explanation, it would. I want to put a number of NON-SQL tables into XML documents. Then, I want to inert the data from the XML documents into existing SQL tables. The format of the...

This driving me nuts. SQL’s automated DTS does not work with the ODBC driver I am using. So am forced to do it manually. Below is the code. I have the connections working correctly, but when it comes to the actual transfer part, I am at a loss. My coworker’s have tried to help but no luck...

This driving me nuts. SQL’s automated DTS does not work with the ODBC driver I am using. So am forced to do it manually. Below is the code. I have the connections working correctly, but when it comes to the actual transfer part, I am at a loss. My coworker’s have tried to help but no luck...

This driving me nuts. SQL’s automated DTS does not work with the ODBC driver I am using. So am forced to do it manually. Below is the code. I have the connections working correctly, but when it comes to the actual transfer part, I am at a loss. My coworker’s have tried to help but no luck...

I have a piece of code that is associated to a button on a simple form in Access. When I press it, it looks at a table for which tables to import from an AllBase database and then imports it/them. DTS’s Import Function does not work in this application because it doesn’t work with the ODBC...

I apologize if this has been addressed in another thread, I didn’t see one that does. It’s kind of an age-old problem and was kind of surprised not to see a thread on it…designing a report to print in black and white/grey scale. I have a line chart that has six elements on it. The report will...

This is a complicated thing to explain, but I’m going to give it a try. I have two columns of values that I would like to chart. One has a value in each record where the other one has a value only for one type of record (BP). This chart uses filters to show the values for each type of record...

I have a real challenge on my hands. The hospital I work at has a program called CareVue. It has an AllBase database that we have successfully linked to Access. CareVue has many flaws. The one that I am attempting to deal with now is when a nurse or a doctor enters a note; CareVue chops it...

I have a piece of code that I wrote in VBA that I need to convert to VBScript. DoCmd.TransferDatabase acImport, "ODBC", "ODBC;DSN=CareVue;UID=xxxxx;PWD=xxxx", acTable, "tablename", "tablename" Could someone please help me?

I have a piece of code that I wrote in VBA that I need to convert to VBScript. DoCmd.TransferDatabase acImport, "ODBC","ODBC;DSN=CareVue;UID=xxxxx;PW­D=xxxx", acTable, "tablename", "tablename" Could someone please help me?