Recent content by esteiner

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...

That fixed the problem! Thank you very much. I guess it makes sense that two objects cannot share the same name.

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...

It looks as though I am running into a problem as Access will not allow a user defined function to be used within the query. Have you ever been able to run a query with user define funtion embedded into the SQL statement? See this MS knowlege base article that I found here...

Thank you, this solved one problem, but I am still receiving another (I assume syntax) error. I receive the Error: 3085 Undefined funtion "NumPart" in expression. I created a separate module as you suggested. I checked spelling and syntax and everything seems correct. Any suggestions...

Thank you for your help, but I am having a problem with this code. I apologize for my ignorance, but I am new to VBA. I received the following error: "Error 3265: Item not found in this collection" This error usually indicates that the code references a field name incorrectly. I double...

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 have one other scrubbing routine that I run. I tried to make the same changes that were suggested above. Once this second routine is complete the file is badly fragmented(my original problem). Below is the code for this second routine. Private Sub cmdSplitMPN_Click() On Error GoTo...

Thank you, These minor but very important changes resulted in the routine running 20x faster with virtually no fragmentation of the file. Does the 'With rs' statement operate on the recordset that has already been loaded into RAM? Does it only write to disk once the operation is complete...

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...

No, some of them also have other special characters like "/" or "#" or ":" etc. I want to use the values for the records that have the special characters. That is why I want to sort the recordset first so that I can use the 'First' function. the special characters appear at the top of the...

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...

Thank you very much for you advice. Will this identify all search engines, not just Google, Yahoo, and MSN? The majority of our users are from outside our country. Thanks again, you have been a great resource. -Charlie

Thank, Chris, I appreciate the tip. I would like to a follow up question if you don't mind. Where did you learn this? I would like learn more about how to interact with search engines using ASP. I am able to get by (with examples) in ASP, but obviously do not have alot of experience. We are...