Search results for query: *

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

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

Hello, I'm running an "in-house" system with VB 5.0 SP(3) and Access '97 that employs the Crystal Reports 7.0 OCX as the reporting mechanism. Since we moved from Win 95/98's onto new XP machines, I've noticed a small glitch in an area of a program that as been operating reliably for...

Hello, I'm running an "in-house" system with VB 5.0 SP(3) and Access '97 that employs the Crystal Reports 7.0 OCX as the reporting mechanism. Since we moved from Win 95/98's onto new XP machines, I've noticed a small glitch in an area of a program that as been operating reliably for...

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

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

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, I've got a table of household members (HHMems) which contain all the household members for each family's application. I have another table with all of the incomes and resources (IncRes) that these household members included on the application. One of my reports has a detail section...

Hello, I have a combobox which slects and stores ID numbers for household members in an application process. The field is an integer in the household member's table. I'd like the user to be able to see the contents of this combobox (Style = 2) when they tab onto it in a grid. Because the...

Hi, I'm using VFP 7.0 (SP1) on a Win '98 machine. Here's my problem. Each person in a family is assigned an IDNum in the Household Member's table (grid) on a pageframe. I have a grid on another page of the pageframe where the household member's Incomes are entered. Since the user may not...

Hello, I'm having trouble with date formats in a VFP 7.0 report. I'm getting 2 digit years but I want 4 digit years. The database's date fields have input masks (mm/dd/yyyy) already and the dates are stored and displayed on forms with 4 digit years.. I have SET CENTURY ON and SET STRICTDATE...

Hello, I'm having trouble with a grid that is embedded in a pageframe. The grid was created with the "wizard". It has combo boxes and check boxes, and text boxes. It works perfectly. When I go back and delete a column, all of the control sources for the controls "shift...

Hello, I'm using VFP 7.0 (SP1). Where would you place the code in a grid to validate fields that you want to require an entry - IF the user never got "focus" on that particular control? 1) Would I want to make the field in the database use a "rule" ? 2) Is there a way...

Hello, I have a grid with several combo boxes. On one of them, pressing the down arrow key does not change the combo box's value and the focus moves to the next record down in the grid. On the other combo box, pressing the down arrow key changes the value in the combo box to the next value...

Hello, I'm looking for code to place in the Valid Event of a ComboBox in a Grid that would validate a users entry. When the criteria is not met, I want to cancel (or exit) the Valid Event, give the user a Messagebox with info on the problem, and then keep the focus on that same ComboBox so the...

Hello, I've got a set of mvars to store .T. or .F. if a value is found in the corresponding field which is constructed in Scan While loo . I can't quite get this to work. The hhmemsid field can be any number between 0 and 15. I need to capture which numbers are in use in the child table's...

Hello, We are establishing eligibility for a program. I have a large PageFrame with 4 pages. Page 2 has a grid for household members - each receives a unique ID number. We use 1 as the applicant, 2 would be a co-applicant if there is another adult, 3 would be the next household member - even...

Hello, Does anyone know if there is an Auto Number Field available in any versions of VFP after VFP 7.0? Will VFP 6 & 7 apps run on the same pc as a later version(s) of VFP? Thanks for your time, Dave The 2nd mouse gets the cheese.