Database

Lets try this again.

I would like a way to extract file by the file number. What I am using give me errors.

Now what I use is.

RRR.Movefirst
RRR.Move -1

Is there another method of geting the files by number?


As far as me posting code its too big to post.

It's totally unclear what you realy want to do. Perhaps you can ellaborate?..

Is this post relates to some other thread?

Quote:

---

Originally Posted by Dbee

Lets try this again.

I would like a way to extract file by the file number. What I am using give me errors.

Now what I use is.

RRR.Movefirst
RRR.Move -1

Is there another method of geting the files by number?


As far as me posting code its too big to post.

---

What are you trying to do? Where are you extracting the files from?

Are you referring to the record's ordinal position within the table itself?

My Database is sequel order. Not random.

So you are actually talking about retrieving a record based on its position within a table, right?

Interesting...what database are you using?

I Use Access.

I Found the problem When I reopen the database it screws up.

Why I don't know!

All I am Doing is reopening the database.

Let me ask another question how do you attach a ZIP file.

Then I will send the code for the program.

Are you closing the connection to the database, before re-opening it?

Never Closed it ran the move statement twice and thats what I got.

Got to be a corrupt database I am creating what gets me I been using this program for 2 years.

I never did do this before.