Search results for query: *

Thank you Remou, It was exactly what I was looking for. :-)

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

Hey anotherhiggins thanks for the macro suggestion. I totally forgot this was a VBA issue. Sorry. :-)

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

Hi, How can I automate the results of an Access (2003)PivotTable and export the results to a particular spreadsheet? Much appreciated.

Oh my goodness, you the the BEST! Thanks PHV. :-)

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.

Thanks Zameer. I will take a look at the link.

Hmm, I do not see the "Recall" option in my Action tab. I wonder if this is a feature that is not automatically loaded. Okay, thanks for your help.

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:&nbsp; Working on a solution to resolve the migration...

Oh, I was looking for it, but I was unable to locate it. Can you tell me how to access it. Thanks.

Hello, is it possible to recall an email in Outlook 2003 after it has been sent? Thanks.

Yaaaaa! It worked. Thank you so much for your time and support on this frustrating issue. :-)

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.

Hi PHV, I added "WO: Mid(WON,1*InStr(WON,”-“))" to the field grid and I get this error. Cingular reference caused by alias “MSC” in query destination’s SELECT list. I do have two joined tables in my query. I don't know if that may be the issue.

Hi PHV, Can I use this expression in the Criteria section of my query?

Hello, I would like to remove all numbers before the dash "-" using a query. For example, I have a field that has "036-WONUM" and I would like to output just "WONUM" and remove th numbers and dash in front of the word. What criteria can I use to get my results? Appreciate your help. Thanks.

Duane, I think I figured it out. Thanks for responding. :-)

Hello, How can I query two tables with exact data? I want to output matching data from two tables.