Search results

Changing the word Text didn't fix it. Changing the word Text didn't fix it. But thanks.

Nope no reserved words When I perform a File / Export and select the Save Formatting check box while saving it to a Text file, it allows me to export it but it then includes all the extra formatting grid lines which of course I don't want because I am importing this text file into another...

I have the following query that runs fine where SKU_GP_EXT_DSC is a memo field. SELECT Formatting(SKU_GP_EXT_DSC) FROM SKU_GROUP The custom module Formatting works fine. Public Function Formatting(Text As String) As String Dim outString As String outSring = "" If...

Actually I figured it out. In the export dialog under advanced, even though it looks like you can only inlude the name, if you click very carefully to expand column that don't appear, you can change the data typ to memo

I have a query that is displaying exactly the correct results. However, when I export this to a text/tab delimited file (or even and XLS file) it truncates the memo field to 256 characters in the export file. I am sure it has something to do with this memo field being defined in part by a...

Thanks Keith. The part I was missing was that I could use that Function in a Query (yeah, I am pretty Access green). This is perfect. Thanks for your help!!!

Thanks for your response. The problem that I am struggling with is how to perform that function on each row in my MS Accesss Data file. I assume I somehow need to read in each row from my data file, lets call it (myfile), and update the field called (myfield). In SQL I would simple perform...

Thanks, My file is already in MS Access. I already imported my text file into MS Access and now I just want to run a routine that updates a field in the current file. For example purposes, what I need to do is to change the following Text field from "abc#def#ghi#" to = "3". "3" indicates how...

It has been many years since I have done any Access programming. I typically use SQL but I have some rather complex string manipulation that I need to do to one column in a file and the file is larger than Excel can handle. The problem is that I don't remember the first thing to creating a...