I've got the save thing down now, but how do I get rid of the pesky save problem that keeps coming up when i run it.
I am erasing all instances of the file then saving, but it still wants to give me the save warning before i close the excel list. Here is the code...
no, i am talking about a dbf that has a field called name. it is populated with people's names. (ex: Doe, John)
i want to delimit this field into two fields. (ex first field will have John in it and last field will have Doe in it.)
I might not be explaining this right.
--- original file
name...
OK finally got vfp9 and trying the animation again with little success. i am creating the form with the form editor. it is to complex for me to build it with code. i am adding an image and i am selecting a gif but when i run the form the gif just freezes. no error just a solid image not a...
i am using this code to save an excel document to a csv.
loExcel = Createobject([Excel.application])
With loExcel
STORE 'mcInFile = "'+GETFILE('XLS')+'"' TO excelfile
&excelfile
loExcel.workbooks.Open(mcInFile)
loSheet = .activesheet
With loSheet
.Range([A1]).Select...
I am trying to get an excel sheet into vfp, however there is one column that the customer keeps sending over with carrige returns in it. when i try the IMPORT from ... TYPE xls, i get a "Microsoft Excel file format is invalid." error. I was wondering if it had something to do with the carrige...
you hit it right on the head craigsboyd. I used your second code. It worked perfectly. Mike, I never thought to use the load event, i will also do things a lot different from now on thanks.
Building a form based on customers database that comes in from week to week. i created a list box that uses the dbf that was sent.
Here is what i have so far.
i created a form and added two command boxes and a list box. The code for the first command box works just fine...
You were right about the settings, here is what i did for all dbf and fxp files.
Open explorer and click
Tools
Folder options
File types
Then choose dbf from the list and click
Advanced
Edit
In the "Application used to perform action" window copy and paste this...
Trying to clear myself up here. if i have a session of vfp open, and i double click on a dbf in a folder in explorer somewhere, a new session of vpf opens with the dbf in it and now there are 2 sessions open. if i click on a second dbf a third session opens up with that dbf in in. in the old...
I just upgraded to 9.0 from 6.0. every time i douple click on a prg or dbf, a new session opens up. is there anyway i can get it so only one session is open at a time. Also how do you clear the command box.
Just insalled vfp9 (I was using vfp6) and now when i double click my shortcut program on my desktop, the prg does not run, it opens for editing. Is there something I have to do to get this thing to run when I double click the mouse, rather than actually tell it in the command window to do...
i think i miss explained. the file called A01_temp is already populated with names and stuff. i need to assign those people values, but only assign a certain amount of values randomly.
I have a file that i need to populate. For example.
530 of the records need to have '25'
264 of the records need to have '50'
211 of the records need to have '100'
The numbers have to be exact, but they have to be random. i am doing it a rather wierd way, however it does work just slow. any...
I am getting the error on this line:
Set Library to foxtools additive
This is the error:
File 'foxtools.prg' does not exist
I just figured that vfp6 did not support this command
Sorry it took so long to get back, things were kind of hectic the past week and I had to move to another project. I am back to it now and thank you to all for the posts.
Unfortunately I am using 6.0 and I am having problems with the code myearwood, mmerlinn, OlafDoschke and rob444 are using...
I have a field that sometimes has multiple blanks in the data. for example "myfirst mylast" and it needs to be "myfirst mylast". i am using this command but i do not know how to look for more than one character at a time. is this even possible?
REPLACE ALL cField WITH...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.