Search results for query: *

I have an Excel worksheet that tracks hours worked on a job. The jobs often require overnight shifts (this is a tugboat company) and sometimes even shifts longer than 24 hours. (You can sleep some as long as a proper watch is kept.) When I try to calculate the number of hours by subtracting...

Is there some reason that I can't release a form from within its load event? I have identified a situation in which I want to do that but the release() doesn't seem to do anything. Suggestions? Shanachie

I am having a strange problem with my app. A form has a grid used to enter lines for a purchase order. One of the columns of the grid contains the item number, another contains the color number, and another the size number. When the user enters the color number or the size number, the valid...

Is there a way for a program to determine if it is running as a compiled version or within the VFP IDE? (Is that the right acronym? IDE = Integrated Development Environment) I have a feature (come to think of it, several) that I want to turn off for the users, who run a compiled version but I...

I have a need to check the file size and date of some files to compare for updating. (If the file is not the same as the one on the server, update it.) How do I do that in VFP? TIA, as usual! Shanachie

Oddball problem: I develop the app at my office and periodically copy the source files to a Zip disk and take them to my client's place. I copy them to a machine there and compile an executable for their use. One form has a pageframe with 8 tabs. Every time I move from office to client or back...

In my app, there are several text boxes for users to input special instructions. When they click on the box, I insert the user's name and the date and time, to document who and when. (That settles a lot of arguments about who screwed up the customer's order.) When they do that, however, the...

The background: Pretty stable application, running for several years, frequently unpgraded but not huge changes. One feature that the client wanted was the ability to run multiple sessions. That way, while working on one customer's order, if another customer calls, the rep can minimize the...

I am suddenly getting a "Too Many Variables" error in a program that's been running without problems for six months. No changes at all have been made since January. What would cause this to blow up now? The compile time message shows 139 symbols, which doesn't seem like a whole lot...

I've noticed some behaviour by the VPF interface that I don't understand. If I have several program files open and minimize them, sometimes one or more of them will be minimized off the screen. It seems to still be open as I can restore it through the Windows menu selection but I can't see it to...

When is a REPLACEd value reflected in the table? I have a situation in which two similar routines are opening tables (different tables) and REPLACE-ing a value but when I BROWSE the tables (during execution), one of them does not reflect the change. Later on, I can BROWSE and find the change...

Client wants report to show dollar amounts like: 123.45 For detail bands, I've used: str(value,10,2) For group summary bands, how do I show the totals in that format? If I calculate group sum on str(value,10,2), I get stars. If I use the "currency" format, I get: $123.4500 How can...

I have a form with an edit box that requires some unusual behavior. The box contains various comments and instructions about orders that can be added by several different users: the account rep, the warehouse scheduler, the order picker, etc. We have encountered a problem where someone puts an...

Another one of those "there's got to be an elegant way of doing this" problems. I want to SELECT some records from a table and INSERT them into another table. I could do it with SCAN as follows: select table1 scan for field = rightvalue insert into table2 (field1...

I expect that this problem is simply my inexperience with menus. I inherited this application and it's different from anything I've ever written. It was written ten or so years ago. It has always been run within the development environment. The program starts initializes some variables, opens...

This is one of those "There's got to be a way to do this; I just don't know what it is" kind of problems. I am in the US Coast Guard Auxiliary. I have an Excel spreadsheet that tracks the Safety Patrol schedule. One column gives the vessel's name for that patrol; the next has the...

My app has a grid to show the detail lines of a purchase order. One of the columns is a dropdown to allow the user to choose from a list of services. When chosen, the dropdown assigns values to columns containing the service number, the description (name) of the service, and the unit price of...

I have a need to be able to use FILE() with long file names (quite long, actually, some are 40 chars). It appears only to recognize the first 8 chars. Interestingly, RENAME TO will rename a file to a long name but then FILE() doesn't see the difference between...

I find it annoying to have to navigate to my project directory every time I fire up VFP6. I don't want to keep the project files in the default directory. Is there a way to record the navigation to just go there? Or to reset the default directory? It's the little things that drive you over the...

It would be helpful to me if I could print the entire source code for the main program, all of the forms and their objects and all of their methods. I can't be the first one to want to do this. How? TIA, Shanachie