Search results

.saveAsText & .loadFromText Confusion I'm trying to learn how to use the 'loadFromText' feature. i've got Arvin Meyers code. do i just change the .saveAsText to .loadFromText? that doesn't seem to be working. it appears to be reloading a copy of the original module that uses the .saveAsText...

I'm trying to use the saveAsText thing. I got it to work on a good non-corrupt database. made a copy pasted the module and ran it. it was awesome. just what i need for making quick copies of all my VBA code. i'd like to try to run it on the corrupt db that i have. the corrupt db will not...

dennisk, thanks for the advice. i wasn't looking forward to the exercise, but it wasn't that bad. once i got i the groove, the conversions went quickly. i'd say almost 2 hours. not bad all things considered. I think it was good to do anyway. Now all I need to do is recover the VBA code...

thanks dennisk. i'll give that a go. I was afraid that something like that would be my only option. i wasn't really sure of the best way to do it. A query sounds good though. it'll definately work. i was just dreading having to go that route because i have so many tables. how do other...

Hello all, My db crashed and corrupted. I've managed to recover my data, sort of. I created a new db and copied the tables. I had to change the autonumber fields of the copied tables to a regular number field so I could retain my primary keys until I can figure out what to do. I'll take any...

Serious Table Problem Well, if you've been following this short little thread, you'll find that I thought I was okay. Between yesterday afternoon and last night, my database has corrupted. I've managed to recover my phsyical data (from the corrupt db) and most of my VBA code from a backup...

Okay... unlike my last post (although unintentional), this is legitimate. Whenever I do a compact and repair on my database, access crashes and offers to attempt to repair my db. IF I allow it to do that, it will blow away all of my VBA code and so everything stops working. If i uncheck the...

***Hangs head in shame*** Sorry people. My table is fine. Somehow, my one-to-many join got changed. I don't how, when, or why, but the form was unable to display the record becuase it wasn't in the recordset! the comboBox runs a slightly different query and so that's it was acting like it...

Hello All, Let me start by saying that I do not claim to be an expert database developer. I own a small company. I'm good with Access, but from time to time, it gets the best of me. I've been reading alot of the posts so please forgive me if this topic has been covered. I couldn't find a...