Access 2000 question

[James Stanich]

OK, I can write basic code to add,edit delete records.

Can someone explain what indexs are? I see alot of reference, but I still don't know their purpose. Please provide examples, if possible...

[Lethal]

Indexes are basically files that contain info about the physical location of records in a database file. When searching or sorting the database, the prog uses the index rather than the full dtabase, which speeds up record retrieval.

[James Stanich]

Do you know anywhere that I can research on how to create them? I have a database that increases by 350 to 500 entries per week, and would like to know how to implement.

By the way Lethal, how are those Software with Brains controls working for you?

[Lethal]

View your database in design view. In the general tab, there is an option for an index, you can set it there. I love the controls, here's a pic of my app so far.

[James Stanich]

I know this is off the intended subject but do you actually scan from your app?

[Lethal]

I just did a print screen and pasted it into microsoft paint. Then saved it as a .gif

[Lethal]

Oh wait, do u mean the invoice? We scan them in using a xerox scanner, with software that incorporates OCR technology.

[James Stanich]

The invoice you display, was that scnned from your app, or supplied to your app from another location?

Anyways, thanks for the index advise. Gettin tired...break it tommorrow. Later.

[Lethal]

what happens is after a batch is scanned in, they are dumped into a database, where I read the imagepath fields for the location to display the image, using the wang control. the wang control displays .tiff images.