function to Import- change field to memo or text

[mchadwick]

I just verified it. How do you run the function without a macro?

[rpeare]

You just copy the code wherever you want it, if you've been using a macro on a button click you can change the ON CLICK event of the button from the macro name to "EVENT PROCEDURE" then paste code that happens between the function name and end function or you can call it with

call csvImport (again using the EVENT PROCEDURE rather than a macro)

as long as it's a public function

[mchadwick]

Okay, I double checked and it was setup correctly. I went in and made the changes based on your suggestion before, but thought perhaps I missed something. I took your db and opened it and added a macro to run it from. The zip code worked fine, but the 2 memo fields did not. Im assuming becuase you only looked at the zip code. which is totally fine, becase one will fix all three. It did work just fine in the directory the other db is in. My only conclusion is that the DB is not connecting to the file properly in the db. I think I may try to recreate that part of it in a seperate db and test it out and then recreate the other more simple steps from there.

[rpeare]

which fields are your memo fields, a memo field is really just a text field with more room so I'm not sure why an import wouldn't work. Just let me know which ones are the memo fields and I'll give it a go.

[mchadwick]

It works fine when I created a new DB. I think I'm just going to add to this one and make it work. Thanks for your help today. Mitch

[mchadwick]

THat worked for me by the way. Thank you for your help.