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 Mike Lewis 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. denisedosp

    Converting from Corel

    I just did this last week. when you get external data, import, file type .txt, you should get a wizard. Corel will use commas, but if there are commas in the actual data, You will need to do a find and replace on the .txt to swap out the field deliminators to another character like ^. If that is...
  2. denisedosp

    animation

    Are you trying to add a video clip, etc.? Use your activex on the insert menu. Are you trying to have one object move on the form? use your form's timer property. Some VB code is required here to let the form know where to move your object from and to. Unless you are creative, simple animations...
  3. denisedosp

    Type mismatch in expression error

    I am going to take a guess. Your employee ID is probably a soc. or similar. You are trying to link 2 different (data)type fields it sounds like. You need to use, for ex. a name to a name or a soc to a soc., etc. Is there an Hours.E_ID? What is the primary field in both tables? What is the...
  4. denisedosp

    Database keeps corupting

    Donkey1, that is great to know. We had similar problems that the SPs took care of. I would have NEVER thought of that one though. Denise
  5. denisedosp

    Hi I don't understand what it me

    She has upgraded from a 97. 2000 was pretty bad. Especially for the upgrades. :)
  6. denisedosp

    find single word in multiple word field

    I don't know you but I think you are wonderful!!!!! It worked. I went back and forth with * and " before not both. hahahahahaha ciao and thanks Denise
  7. denisedosp

    Hi I don't understand what it me

    When upgrading to 2000, you lose the ability to make structure changes in the converted DB. If you had upgraded to 2002(XP), you can make changes. I suggest trying to copy the data only, and reconstructed the db with new tables and then pasting the data in. That may or may not help. I am 90%...
  8. denisedosp

    Hi I don't understand what it me

    Hey there :) I get the feeling you recently upgraded. You can have the 2002 format also. When you work in one of those formats, you cannot do certain things from the other format if DB was converted. We just did 2 very quick upgrades in our org. 97->2000->2002. That line tells me what the...
  9. denisedosp

    find single word in multiple word field

    I posted to the wrong forum, so now I am posting again here. :) I need to return a list of records based on finding one or two words in a field containing phrases. I have tried many SQL statements with no luck. I cannot use find and find next, as I need a view of ALL records fitting the...

Part and Inventory Search

Back
Top