Search results for query: *

Judi you did not mislead me, I learned alot. Tamar it worked exactly as I wanted. Just by properly setting the data sessions. Thanks everyone.

I have made a couple simple applications for friends that have vision issues and I use the VFP9 Resize Object Foundation class. It automatically resizes all controls and contents. I use two monitors each having a different resolutions for graphics work and when I change a form from one to the...

Tamar, I understand your confusion, however I am learning how to articulate the problem better thanks to all the pros in the forum. The calling form is the form named "change" it is a simple navigation form with a grid. It is called from a cmd button captioned "Find Record." The grid shows the...

Judi, I did not suspect the autointeger field to be the problem I just looked at your variable name of lcKeyValue wherein I believe L=local, c=character, and KeyValue = the name Since my index field is an integer I was wondering if liKeyValue would be correct instead, but it doesn't work...

Judi, Thanks for all the help first of all. I am so new that I am trying to take in so much info. I am learning a tremendous amount thanks to this forum. I have all text fields on the called form. And I try everything but I get an error 9 Data type mismatch. is that because my index on the...

Ok I kinda follow you Judi, both forms are set at private data sessions. Both share the same data environment table of "contact" where the primary key is "contactid" which is an autointeger field. SO I guess the Parameter issue is what I am having the issue with. The DO FORM myform with...

Judi, I do not have it working ...Yet, but the record source for the grid, is the table "contacts" and the form has a data session of 3. The data environment for the second form is the table "contatcs" also and it has a data session 3 also.

Geoff I think you are correct. However both the grid and the form it calls are bound to the same table. And when I try to point to a record by highlighting it in the grid, I cant figure out how to make that record show up in the "contact" form. I worked on the parameter deal and all it did was...

Ok let me back up for a second. The form "contact" is the data entry form or the "called form." The form "change" is the form with the grid or the "calling form." in the called form, "contacts" I have made a new property called "firstname" and in the init for the "contacts" form I have...

This is a problem re-visited I have a better understanding but still am struggling with this issue. I have two forms, the first is a data entry form named "Contacts." The second named "Change" is a form with a grid that shows all the contacts which is read only. I am trying to select a name in...

That might work with the WITH this.value but I get an eror saying "No Parameter statement is found" so being the new kid I am still lost.

I have a grid in a form that reflects all of my reports. I need to be able to doubleclick on the first field in the grid which is text1 under column1 in the grid. I have placed a DO FORM in it's doubleclick event and it does start the correct entry form however I am trying to figure out how to...

Thanks Craig I guess I should have said each ticket has a serial number, all numeric no alpha. The corporate office issues the numbers out to us so we can get our receipts printed. They have them in lots of 25. It is from the old days I was told.... Being a new days kinda guy I cant see why we...

I can make numbers all day but does anyone know a way to generate a bank of numbers? My sales office makes sales recipts in batches of 25. they keep track of these and will issue them to us if I can just make them show up in a foxpro application. I have tried resetting the autoinc but I still...

Thanks everyone. I already have and am using Sql2000 dev. I just nned to know how to get the tables on the customers computer if I make an EXE for the front end in VFP.

I have an account that wants a Sql2000 backend. I have used VFP only in the past. I want to know if I am starting from the ground up should I, A. design it and upsize it? or B. design tables in Sql2000 and link to it from VFP9. Either way how will I get the resulting tables on the customers Sql...

Thanks again everyone and yes I just put the dashes in to illustrate the date not to include it in the number.

I have a table called "report" and I am trying to reset the autoincrement value for the coming of a new year I did get some valuable advice from the forum so I made this statement; ALTER TABLE REPORT ALTER COLUMN report_num i AUTOINC NEXTVALUE 1 STEP 1 and for all my work I got this error...

Thanks Mike. Or would you use the "nextid" method like I have in the past and just cause it to restart using the system clock as a trigger when it turns over to the new year. I cant tell which is easier now. But thanks very much.

Yes but can you programmatically reset this at the new year 01-01-2005 0001 hrs?