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

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

...strSQL = "UPDATE [" & strTableName & "] " & _ "SET [CorePartNumber] = NumPart(manfPartNum) " & _ "Where manfPartNum LIKE '*[0-9]*' " db.Execute strSQL sExit: On Error Resume Next Reset Exit Sub E_Handle: MsgBox Err.Description...

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

...AS FirstOfCorePartNum, Sum(pull_inv_BRE.Quantity) AS Quantity FROM pull_inv_BRE WHERE (((pull_inv_BRE.ManfPartNum_NP) Like "am27128a" & "*") AND ((pull_inv_BRE.Description)<>"MENTOR")) GROUP BY pull_inv_BRE.ManfPartNum_NP; From this query, I would like to sort by pull_inv_BRE.ManfPartNum...

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

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

This worked very well for my test of 15,000 records. When I try to process the full table of 90,000 records, I receive an error message stating "Overflow". Is there a limit to how many records can be processed at once? Is the machine just running out of memory? Any ideas? Thanks for all of...

I am attempting to update the value of the "Prefix" field on the current record in the recordset. See the area highlighted by "****" below. I receive the following error message: "Update or CancelUpdate without AddNew or Edit". Any help would be greatly appreciated. intCountRecords =...

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

I should have been more clear. The ManfParNum is not always prefixed by three letters. It varies between 0 and 4 letters. Any ideas? Thank you very much for your help. -Charlie