Recent content by Pesteo

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

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

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?

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

What did the Window Type property Modal do????

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

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

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

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

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

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

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

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

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

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?