Search results for query: *

Hello rgbean, Thanks for the reply. I had this project in a database with the whole ball of wax. Problem was the "wizard" generated pageframe grids kept getting corrupted and the data environments were kicking my tail up and down the block. Every structure modification affected the grids...

Hello, I need to set some relationships in a 3 tiered relation between several free tables. All of the records have unique integer identifiers in each of the tables. I'm not clear on exactly how to: 1) Set the relationships up and... 2) Can they be used to perform cascading updates and...

Hello johnmw, Will installing an older version of mdac interfere with any of the newer software running on the XP's? Thanks, Dave The 2nd mouse gets the cheese.

Hello, We recently upgraded to XP's with Access 2002 in our building. I have a number of large VB5 (SP3) projects running using DAO and Access '97 databases with security. Since I can't adminstrate an Access '97 table from Access 2002, I converted the database to both Access 2000 and an...

I placed the following lines of code into the control's click event (in the first EXE) that calls the other EXE. PUBLIC TF_str * DO C:\Progra~1\test\testfire.EXE WITH tf_str I placed the following line of code : PARAMETERS TF_str as the very first line of code in the "called&quot...

Hi Again, Actually, I need to pass a first name, lastname, & a case number to the "scheduling" exe and return the appointment date and time back to my exe. Thankls, Dave The 2nd mouse gets the cheese.

Hi, I have an existintg EXE that needs to launch another EXE that does client scheduling. 1) How do I launch the EXE from mine? When the client has been scheduled, I'd like to pass the appointment date and time from the scheduling EXE back to my original EXE. Anyone have suggestions - any...

...On Error GoTo ErrHandler ' Dim sqlCommand As String datCrystal.DatabaseName = mstrRptSpec sqlCommand = "Select * from Report" datCrystal.RecordSource = sqlCommand datCrystal.Refresh ' With datCrystal.Recordset...

...On Error GoTo ErrHandler ' Dim sqlCommand As String datCrystal.DatabaseName = mstrRptSpec sqlCommand = "Select * from Report" datCrystal.RecordSource = sqlCommand datCrystal.Refresh ' With datCrystal.Recordset...

Thank you... a simple solution to the problem. Dave The 2nd mouse gets the cheese.

Thanks, that helps. But a similar problem has occurred. I can't replace a text box value on Page1 of my pageframe control from Page2 of the same pageframe control. The actual replace statement is executed from Page2 control which is running a .prg... How Come? Is it because textbox is not...

Hi, I have tried that but that's where the error comes from. Since its actually running in a seperate .prg I'm using frm_Client.PageFrame1.Page1.txtWorkCode.text = gcWork I think the error is because Page1 is no longer the "active" page in that pageframe control. Any more ideas...

Hello, I have a project in VFP 7.0 (Win XP) where I have a Client Form with a PageFrame Control with multiple pages on it. On Page1 of the PageFrame, I have client's data and a text box containing his work code. Now The User moves onto Page 2, 3, 4 etc. of the pageframe control on this form...

Hi, Thanks Dave The 2nd mouse gets the cheese.

Hello, I've been trying to make a combobox open automatically for the user from the combobox's GotFocus Event. I've tried MESSAGEBOX("GotFocus") KEYBOARD '{-3}' and This.comMaritalStatus.DownClick in the comboboxes GotFocus event but it doesn't do the job. I get the...

Hello, The Install Shield Express that came with my VFP 7.0 disks is not set up for XP installations. We recently upgraded some of our users to XP's. This is my first VFP 7 app installation and I'm not sure how to set up and install to Win '95, 98, and XP's. Which files do I need to...

Thanks Ramani, this helps. I am validating the records and prompting user to take action before they can exit. The only thing I need to do is deal with someone deleting a pre-existing HH member. Dave The 2nd mouse gets the cheese.

Hello, I'm automating a grid to automatically assign a unique ID number (1 - 15) to each new household member in my grid. During the form's init event, I capture the next available ID number (gn_NextID) for the first new record added to the household. I have placed gn_NextID in the table as...

Hello, Can't explain why this was happeneing but I added an index on HHMemsID field to the IncRes table, (but not using it) and it went away - the IncRes records now appear in the detail line. Thanks For Your Time, Dave The 2nd mouse gets the cheese.

Hi DSummZZZ, Posted before I saw your question. The relations exist between the PSForms and the two other tables via the PSForms unique ID number. The HHMems have the PSFormsID and their own HHMemeID. The IncRes actually has both the PSFormsID and the HHMemsID as fields in the record. No...