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

  1. Pesteo

    Trouble with Fox Pro Indexes....

    Answer to the first question, yes, the record source type is set to 'SQL Statement" I tried using your solution, but it did not solve the problems at hand. I am sending the query to a cursor, so that another search screen does not pop up. When I did have that extraneuos screen pop up...
  2. Pesteo

    Trouble with Fox Pro Indexes....

    I am writing a database application that searces the database based on criteria given for one of three fields. The user is first required to selected the field to search, and then enter the criteria to search for. When the criteria is entered, the user clicks on search. The runs a procedure...
  3. Pesteo

    Adding the DAO library....

    Thanks for the help, that worked great.... Now just because I'm inquisative, how would you hve added that library if it was not there in the first place?
  4. Pesteo

    Adding the DAO library....

    I am working with access....and trying to declare a database variable using... Dim db as database but there is no database option, how do I add the DAO library so that this option will exist.... Thanks, Pesteo :)
  5. Pesteo

    Fox Pro Executable

    What did the Window Type property Modal do????
  6. Pesteo

    Fox Pro Executable

    I am working on a FoxPro Database project. The project is built and runs fine from the main screen. I built an application file, and that runs and works as desired. I build an executable, and when I double click on the execuatble, It opens the program, and automatically closes it. I have...
  7. Pesteo

    Fox Pro Table Update....

    The reason for those lines of code is to distinguish between the live database, and the backup - play with it database.... We never make any changes to the live until everything is in working order....It is currently pointing at the database I can screw up, add random records, etc... They are...
  8. Pesteo

    Fox Pro Table Update....

    I'm still a little confused, first off, what is your differintiation between "actual" and "fake" data. When I run my updates from the text file, I can can close everything, shutdown my system and come back a half hour later, search for the record in the table, and all the...
  9. Pesteo

    Fox Pro Table Update....

    Main Program with _screen .visible = .f. .caption = "South Dakota Geological Survey" .windowstate = 2 .visible = .t. endwith set sysmenu off set century on set deleted on close database all *!* *!* * development database open database V:\Lab_Transfer\db\wq shared set default to...
  10. Pesteo

    Fox Pro Table Update....

    Here's the deal, I am working with a Fox Pro Database that has seven tables, I wrote a program that takes that a comma delimited text file, puts it into a cursor, and then from that cursor updates the record in the table... The update procedure is works as follows, One of the employees is in...
  11. Pesteo

    DataType Mismatch Error

    Set rst = db.OpenRecordset(SearchString) equivocates to: Set rst = db.OpenRecordset("SELECT * FROM XRD_Sands_All_Upgradeable Where XRD_Sample Like '*C017*';") and I still get the datatype mismatch error.... The funny thing is that I copied my original code from a search routine I...
  12. Pesteo

    DataType Mismatch Error

    Zemp, Due to your inquiry/suggestion, I found one error, I had an extra clause in there... SearchString = "SELECT * FROM XRD_Sands_All_Upgradeable WHERE " & gstrWhereRec & ";" gstrWhereRec should combine to: XRD_Sample Like "*C017*" This is formed dynamically...
  13. Pesteo

    DataType Mismatch Error

    I am working on an access database, writing a dynamic search form. Code that builds that dynamic search query... *.........................................................* Private Sub cmdSearch_Click() Dim db As Database Dim rst As Recordset gstrWhereRec = "" If...
  14. Pesteo

    Referencing....

    I have a cursor with which I am trying to update an existing table with the primary keys already entered. What is the proper way of scaning through the cursor, selecting the matching table in the permanent table, and then passing the values from the cursor into the permanent table... I am...
  15. Pesteo

    Updating a Database Table from a cursor.

    What does the routine that you gave me do? Is there anyway that I can select the exact record from the table, and then replace the null values with the new data that is in the cursor?
  16. Pesteo

    Updating a Database Table from a cursor.

    The primary key that is used to reference the record is already in the table... I just need to add the rest of the data to that record.... The bigger problem that I am also having the problem of keeping the cursor open while opening the database to update the records.... Thanks....
  17. Pesteo

    Updating a Database Table from a cursor.

    Here's the deal, I have got a text file that contains information that needs to be inserted into a table embedded in a database with 500,000 records... The text file is set up as follows: "PK", "Date", "ID-Name", "Column_name1", "Data1&quot...

Part and Inventory Search

Back
Top