Search results for query: *

I am needing some UDF's that will return the 1st and last day of the month for a given month. I had some written in FP2.x but they no longer function correctly in VFP9, I think since dates are handled differently. I could rewrite them, but I thought someone may have already done this or maybe...

I have a simple form that runs 1 report, creates a couple of free tables and accesses some other tables which are part of an another application (written in foxpro). The other tables are associated with databases. I need an executable that will run with the vfp runtime files on another...

I have a weight field for which I would like to a "#" (pound) sign to the end of The existing mask is 9,999,999.99 When I make it 9,999,999.99# it just adds a decimal, which is expected since the pound sign is a valid character for the mask..

I'm trying to do a simple query on an employee table named Workforce1. I need to filter out all the records where lastname starts with an "*". I need help with the WHERE clause. This is for MS Access. Is this possible? SELECT Workforce1.EmployeeNo, Workforce1.LastName, Workforce1.FirstName FROM...

I have created a report using the report wizard from a free standing dbf. I create/update the dbf from an excel spreadsheet. It seems the report is using a VFP data environment where it automatically opens the associated DBF/CDX. When I update the DBF from excel and try to run the report I get a...

For some reason I cant get this simple report to work, am I missing something? I have simplified the info for easy reading. I execute a query on a table to get the following datasheet. Table (datasheet) Field Data Type JobNumber Number, Long Interger Department Number, Long Interger Time...