Hello,
I use this function to open an existing Excel workbook, clear the contents and paste new data. This has been working great for the most part. The problem is the "ClearContents" is erasing all of my data and formulas and I would like to start at a specific range. Can I specify the range...
Hello,
I use this function to open an existing Excel workbook, clear the contents and paste new data. This has been working great for the most part. The problem is the "ClearContents" is erasing all of my data and formulas and I would like to start at a specific range. Can I specify the range...
Hello, My Access (2003) PivotTable results do not export to Excel. Do I not have something set in my Options? I can create the PivotTable from a query, but when I click on the "Export to Microsoft Access Excel" button it exports the first field and I have to drag the rest of the fields to the...
Hello,
How can I truncate the last 3 characters in a query? I only need the first 4 characters in the following field.
ALPAB02
ALPAB03
ALPAB04
BKCAB01
BKCAB02
Thanks.
Hello,
I import HTML data into my Access table, but the data is Imported with the HMTL tags. How can I setup an sql query or some other method to find and replace these annoying tags?
[SAMPLE]
<div><font color="#ff0000">3/10: Working on a solution to resolve the migration...
Here is my query.
SELECT Mid([WON],1*InStr([WON],[”]-[“])) AS WO, WO_EOS.Vendor, WO.Region
FROM WO RIGHT JOIN WO_EOS ON WO.WON WON = WON_EOS.WON;
I accidently sent you the error message from another query (MSC) I was testing, but the error is the same with the query above.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.