Hi -
This is my first time posting, so please bear with me. I appreciate anyone who reads and has any advice they can offer
Two years ago, I created a database (~3700 records) of original construction drawings for a company as part of a digital archiving project. Earlier this year, the company acquired a large scanner. My next task was to scan the drawings, save as .pdf, and somehow link the drawings to the original database. I tried to create hyperlinks and point to the folder where the .pdfs are stored, but the folder keeps getting moved around by the network admin and with such a large amount of data, it is way too time consuming to relink each drawing. My solution was to embed most of the major metadata of a scanned drawing into the filename of its corresponding .pdf such that appropriate/related drawings could be located given a record with similar metadata. So the overall search algorithm proceeds as follows:
1) Enter search criteria,
2) Find relevant records using a query and generate search result list,
3) Find relevant drawings for each element in the search result list given the metadata of the record.
What I would like to do is take some search criteria, execute a query based upon the given criteria, and populate a list box with the query results (I want to suppress the actual query window, I just want the results). I can execute the query, but the listbox automatically fills with arbitrary results unrelated to my query (it grabs the first 255 records). I also can't figure out how to clear the multicolumn listbox as the version of VBA I'm using doesn't have the .ClearList method (and I don't understand why!)
Any ideas?
Thanks in advance!
mc - Philadelphia, PA
This is my first time posting, so please bear with me. I appreciate anyone who reads and has any advice they can offer
Two years ago, I created a database (~3700 records) of original construction drawings for a company as part of a digital archiving project. Earlier this year, the company acquired a large scanner. My next task was to scan the drawings, save as .pdf, and somehow link the drawings to the original database. I tried to create hyperlinks and point to the folder where the .pdfs are stored, but the folder keeps getting moved around by the network admin and with such a large amount of data, it is way too time consuming to relink each drawing. My solution was to embed most of the major metadata of a scanned drawing into the filename of its corresponding .pdf such that appropriate/related drawings could be located given a record with similar metadata. So the overall search algorithm proceeds as follows:
1) Enter search criteria,
2) Find relevant records using a query and generate search result list,
3) Find relevant drawings for each element in the search result list given the metadata of the record.
What I would like to do is take some search criteria, execute a query based upon the given criteria, and populate a list box with the query results (I want to suppress the actual query window, I just want the results). I can execute the query, but the listbox automatically fills with arbitrary results unrelated to my query (it grabs the first 255 records). I also can't figure out how to clear the multicolumn listbox as the version of VBA I'm using doesn't have the .ClearList method (and I don't understand why!)
Any ideas?
Thanks in advance!
mc - Philadelphia, PA
