Search results for query: *

Hello, We are interested in reducing the amount of space that we use on the web server. We currently have 100,000+ files on the server, one for each part number. We currently use the following URL format for each file: www.domain.com/12345.shtml We are considering using the following new...

I have been trying to solve performance problems with some of my VBA code. Several members have suggested using the following user defined public function within an Access query. I did create a separate module for this function: Public Function NumPart(fld As String) As String Dim n As...

This is a follow up to thread http://www.tek-tips.com/viewthread.cfm?qid=1309921&page=1 I was able to receive some great help for my initial problem, but have hit a snag when trying to apply this new method to a similar subprocedure. I have a second scrubbing procedure that I run. The routine...

I am scrubbing values of a field1 in an Access table and updating the results in the same table. The routine runs OK but the size of the database goes to 600+ MB. I must run the compact and repair database operation each time I run the routine. The amount of data to process will continue to...

This is a question related to archived thread333-991814 The code provided by ChrisHirst was working beautifully the first time I tested it. I used Google.com, MSN.com, Yahoo.com, etc. I also began to test on interational sites like google.de, yahoo.fr, etc. The search term that I used to...

Hello, I would like to sort the results of my select statement before using aggregate functions such as the 'First' or 'Last'. How do I accomplish this? Here is my current SQL: SELECT pull_inv_BRE.ManfPartNum_NP, First(pull_inv_BRE.ManfPartNum) AS FirstOfManfPartNum...

I have noticed that several of our competitor sites are somehow able to "capture" a user's keyword phrase used to generate the search engine results pages and populate the exact phrase into a textbox on a form. I would like to do the same thing as it would greatly improve the usability of our...

Hello, I have data in an Access table that I would like to export to multiple HTML tables. I would like to split the data in the Access table (about 92,000 records) into multiple HTML tables/files to reduce download time and bandwidth usage on my web server. That way, the user can select a...

Hello, please excuse my ignorance. I would like to split the values of a field called "ManfPartNum" into two fields ("Prefix" and "BaseNum"). I have an Access 97 database of about 50,000 records for which I would like to perform this operation on a weekly basis...

Hello, please excuse my ignorance. I would like to split the values of a field called "ManfPartNum" into two fields ("Prefix" and "BaseNum"). I have an Access 97 database of about 50,000 records for which I would like to perform this operation on a weekly basis...

hello, I have a table that includes part numbers from several different companies. Because of this, there are duplicate entries for some of the part numbers. I would like to combine the records and sum the quantity field where the partnum, manfufacturer, and location fields are identical...