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 derfloh 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: *

  • Users: shopwise
  • Content: Threads
  • Order by date
  1. shopwise

    drag n drop from outlook

    i'm running act 2008 version 10 and outlook 2003. Wondering if I can drag an outlook email attachment directly from Outlook into an Act's contact document list other than first saving the Outlook attachment and then dragging. If this can be done in a later version of any of these applications...
  2. shopwise

    domain name alias?

    i am trying to direct customers to the following webpage: www.canchair.com/remove.asp but would like them to only have to type: www.canchair.com/remove (without the .asp extension). What is this technique called or how is this accomplished?
  3. shopwise

    query runs extremely slow

    the following delete query runs extremely slow that it does not progress past one bar on the progress bar. any ideas on how to correct this issue? perhaps changing the data type or compression of the underlying table? if yes, in what manner should this be done DELETE * FROM table_query WHERE...
  4. shopwise

    update query

    I have these 2 tables of the identical structures: current_removals, faxnumbers and would like to create an update query that would accomplish the following: update the faxnumbers.Remove field to the value "True" for every value that is equal by these 2 fields: current_removals.SoldToFax and...
  5. shopwise

    uploading database containing linked table

    I have uploaded a database1 containing a linked table (to another database) thus creating a remote copy of it in addition to the one residing locally on my machine. Online users will be modifying this databas1e and I would like to download it periodically and replace my local copy with the...
  6. shopwise

    changing records in simple select query

    I have 2 tables both containing identical structure and that include a "fax number" field and a "remove" yes/no checkbox field. I have created a simple select query with the following SQL: SELECT faxnumbers.SoldToFax, faxnumbers.Remove FROM faxnumbers INNER JOIN current_removals ON...
  7. shopwise

    registry scan

    would you say doing a registry scan and cleanup is necessary maintenance for pc performance? If yes, what is a recommended utility for accomplishing this? Any precautions to be noted such as backing up the registry prior to performing any actions via the software?
  8. shopwise

    connection string

    my connection string is as follows: Dim MM_Custom4_STRING MM_Custom4_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/access_db/Custom4.mdb") apparently there is an issue with it as every time I upload my access database, I receive either one of the following two...
  9. shopwise

    changing the color of a portion of an image

    verion 7.0 I have an image of a red plastic chair and need to change it to a black chair. I have a clean seletion of the plastic portion of the chair. What is the easiest way to change the chair colour? I have attempted a color overlay but that discards all the highlights of the image.
  10. shopwise

    IE javascript error only when in compatibility view

    I receive this error: 'document.getElementById(...)' is null or not an object on IE only when not in compatibility view. This is the code that the error is alluding to: var ccurrentImage; function cshowBigImage( cisource,cbigImage,cheader ) { var ctheImage =...
  11. shopwise

    dvd drive freezes on double click or right click - new virus free syst

    right clicking or double clicking on the d drive (dvd) drive on my new Lenovo desktop freezes the My Computer dialogue box. I have ruled out virus suspicions by running several utilities. OS is XP Pro.
  12. shopwise

    Invalid use of Null: 'Replace' error

    why is the following code giving an Invalid use of Null: 'Replace' error even though I have placed in an if statement and even when the field is not null? dim myVar myVar = (products.Fields.Item("CustomMemo01").Value) If myVar <> "" Then dim script dim note dim texting...
  13. shopwise

    repeated field query question

    my database contains a listing of products. some products are members of a productfamily as they are the same product except for a different size etc and some are not productfamily members. the "products" table indicates which products are associated with which productfamily, if any, with the...
  14. shopwise

    simple syntax question

    I am receiving Expected ')' error when using the below syntax. As I do not know asp too well, I'm not sure how to fix it: <%if Not Isnull("products.productfam")then response.Write("<a href="productfamily_processor.asp?productfamily=(products.Fields.Item("productfam").Value)"...
  15. shopwise

    query criteria eliminates too many record results

    I have created 2 identical select queries except that one should display records with a value greater than zero and the other should display records less than or equal to zero in the products.productfamily field. The first query works fine and eliminates all records with a value less than or...
  16. shopwise

    filter recordset parameters not effective

    WHERE Not IsNull(CustomText10) AND Not IsEmpty(CustomText10) When using the above code in my recorset to eliminate any records where CustomText10 does not contain any value, I am not being successful. The records that contain no value are nevertheless being displayed. I also tried adding...
  17. shopwise

    simple sql syntax

    My Asp recordset contains the following SQL code: Recordset5.Source = Recordset5.Source & " WHERE ManufacturerPartNumber IN (" & Replace(varPartNumber,"|", ", ") & ") AND (Query1.CustomText04="3") " An error message is generated as follows: Expected end of statement Recordset5.Source =...
  18. shopwise

    eliminate records based on certain criteria

    products.Source = "SELECT ID, Price, ProductFamily, CustomText08, ManufacturerPartNumber, Description, Sort, CustomMemo02 FROM Products WHERE (products.CustomText08 <>'Yes') AND ProductFamily = " + Replace(products__MMColParam, "'", "''") + " ORDER BY Sort ASC" with the above recordset...
  19. shopwise

    Provider error '80004005'

    I receive the following error EVERY time I upload my access database to my asp site and attempt to view an asp page: Provider error '80004005' Unspecified error /new_web_product_detail.asp, line 16 line 16 reads: Recordset2.ActiveConnection = MM_Custom4_STRING
  20. shopwise

    SendUsing configuration value is invalid

    when attempting to send an email from a webpage using the below code, I am now prompted with an error message which reads: CDO.Message.1 error '80040220' The "SendUsing" configuration value is invalid. /customer_locator/send_email.asp, line 15 This has not occurred before and there was no...

Part and Inventory Search

Back
Top