Search results for query: *

Hi All, I've written a multiuser program in VFP8 but apparently multiuser programming is not my forte. All users are locked out of the data table now. And when I go in to edit the program, I'm told the database is locked when I try to use it or any of the tables. How do I unlock it, please...

Hello All, I would like to call my main program, SCHEDULE, from a login screen after I have checked for valid username and password. When I simply call the SCHEDULE form from the LOGIN form, I immediately get an error say that the object SCHEDULE cannot be found. However, if I run the...

Hello all, Is it possible to substitute multiple variables into a statement such as: thisform.text1.value = m.columnX_rowY where X and Y are the variables? I have tried something like: thisform.text1.value = m.column&X.._row&Y.. but it doesn't work. Can anyone help, please. Thank you. Stan

Hello All, My form has a combobox pointing to a table. My table is as follows: Field1 Field 2 01 | Option 1 02 | Option 2 03 | Option 3 04 | Option 4 I want field2 to be displayed to the user, but have field1 stored in my data table when I save the data on the form. I...

Hi there, Since the Keyword search is down I can't check if this has been answered before. Is there a way to print a form as it is displayed onscreen. I have written a scheduling program and the users want to be able to print the schedule as it appears onscreen in case of a power failure or...

Hello All, I have a modal form with a 2-page pageframe and a Private Datasession. Each page contains a number of check boxes. All the check boxes use memvar variables scattered from a single file as their controlsource. My problem is that the memvars for the check-boxes on page two keep...

Hello All, Looking at the code below, can anyone explain to me why, when I suspend execution at either of the "DO FORM" statements, I am not at the file named APPT (according to ALIAS())? I am absoulutely stymied by this. APPT has buffering set to 2 in my MAIN program using: Use...

Hello All, The following code is the beginning of a program that is called from the Click Event of the textbox control in a single column grid. *************************************** PROCEDURE EditAppt PARAMETERS pGridNumber PRIVATE mDay,dtCurrentDate, mThisGrid, mMonth, mYear, mSeek...

Hello, When calling Form 2 from Form1 with "DO FORM APPTDISPLAY" I get the error: 'field' Phrase Not Found Anyone know why, please? Thank You.

Hello All, I need help understanding a concept. I have two forms. On the first form, I added all the files I needed to the Data Environment to have the files available to connect to fields through the RowSource Property as I added the fields to the form. Now, as I create my second form, do I...

Hello Everyone, I have a form with 1 text box and 1 combobox. The combobox RowSource is set to a clientfile. I want to enter an initial into the text box and then set a filter on the clientfile so it only displays last names starting with that initial when I click on the ComboBox. I've placed...

Hello all, Just out of curiosity, I placed two text boxes on my form and placed code in my grid.click event as follows: ********************* thisform.text1.value = thisform.grid1.activerow thisform.text2.value = thisform.grid1.activecolumn thisform.refresh() ********************* But when I...

Hello All, I am using the code below to clear a number of text boxes on my form. I tried the eval because I heard that a &variable will only be evaluated once in a loop. The eval seems to be working the same way. Does anyone know of another way to accomplish this task, that is, performing...

I'm wondering if there is an easier, 'better' method out there for processing a number of text boxes using VFP 7.0 SP1. Say you have five text boxes on a form. Each box holds a name. They are Text1 through Text5. Currently I would use: For countname = 1 to 5 STORE...

Hello All, Can anyone tell me why COUNT would work correctly in a program when run from the Project Manager but give only 0's when compiled? Thank you :)

Hello, In the code below, I am filling a grid of text boxes with the number in mCountTotal. When I run the program in Foxpro development, it works fine. When I compile and run, the counts all come up 0. Any ideas please? *********************************************************...

Hello All :) The code below is in the Click Event of a Delete button on a form that shows appointments in a grid. When I click the Delete button, the grid does not refresh to show that the appointment is deleted. SET DELETED is ON. If I close the form and reopen it, the deleted appointment is...

Hello All, I am using an Edit Box on a form. When I click anywhere below the first line in the Edit Box to give it focus, the cursor appears to be on the second line. If I enter text there and save with a Gather, the text is not saved to the record. If, when the box receives focus, I move the...

Hello all, I have a form with a grid. The recordsource for the grid is a(n) SQL statement. RecordsourceType is set to SQL Statement. The SQL statement is: Select x.clientid, x.apptdate, x.appttime, y.counname, x.appttype from appointments x left join counsellor y on x.counname = y.counname...

I am using a(n) SQL generated cursor to populate a cursor with all the appointments for a particular client from an Appointment table. Then I open a form and display the grid with the Recordsource set to the cursor. The fields displayed are clientid, apptdate, and appttime (for Client ID...