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!

  • Congratulations SkipVought 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. 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

    thanks for your response. However, it doesn't seem to work. Each time I run the query I am prompted that 2 rows will be updated. Indeed 2 rows have been updated the very first time I run the query but this is where it stops. there are many more records that should have been changed Am I...
  5. 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...
  6. 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...
  7. 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...
  8. 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?
  9. shopwise

    connection string

    it's been a while and i'm still receiving the error.
  10. 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...
  11. 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.
  12. shopwise

    IE javascript error only when in compatibility view

    I had the ID in the wrong case!!!thanks so much!
  13. 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 =...
  14. 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.
  15. 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...
  16. 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...
  17. 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)"...
  18. shopwise

    query criteria eliminates too many record results

    my ignorance! i tried "Is Null" and this is theeeee solution! thanks!
  19. shopwise

    query criteria eliminates too many record results

    With the added criteria of IsNull, Access gives me the error message of data type mismatch. Apparently IsNull is not used for numeric data?
  20. shopwise

    query criteria eliminates too many record results

    thanks for your responses. This is the SQL for the query that shows zero out of 268 results: SELECT images.url_img, images.alt_img, images.productid_img, Products.ProductFamily, Products.ID FROM images LEFT JOIN Products ON images.productid_img = Products.ID WHERE...

Part and Inventory Search

Back
Top