Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. esteiner

    Default page for URL pointing to missing folder/file

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

    User defined function in Access query??

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

    User defined function in Access query??

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

    Recordset update causes

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

    Recordset update causes

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

    Recordset update causes

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

    Recordset update causes

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

    Edit/Update results in badly fragmented file

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

    Edit/Update results in badly fragmented file

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

    Edit/Update results in badly fragmented file

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

    Capture Keywords Error

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

    Sort recordset before aggregating

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

    Sort recordset before aggregating

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

    Capture Keywords

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

    Capture Keywords

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

    Capture Keywords

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

    Split 1 field into 2

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

    Split 1 field into 2

    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 =...
  19. esteiner

    Read from Access queries and write to text file

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

    Split data from 1 field into 2

    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

Part and Inventory Search

Back
Top