Search results for query: *

The cursor is created by CREATE CURSOR and then populated from a table with just the records that the employee has for the week already. Lockscreen is used no where. No relations are set. I did SET STEP ON and watched the code. As soon as a phantom record appeared I browsed the file. The...

I have a grid displaying a cursor for timesheet entry. I have command buttons for duplicating a record or making a new entry so that I have more control over what the user does. I also display the time totals on the screen so the command buttons allow a snapshot of time values before and after...

Control Panel - Administrative Tools - Data Sources (ODBC)

I've made sure that each record in the report set has the data for that header in it. The data prints, ie the Job # and/or Work Request#, just the box doesn't print. Here is a link (http://home.comcast.net/~lsavana/tektips.html) to an example of the report, page 4 and page 6 do not have the...

I have a report that has columns of info and when it prints it looks like a grid. Therefore, I want the column headings' boxes to only print if there is data contained in them. I have the boxes set up to print when "NOT EMPTY(thatfield)". It works great except on 2 pages of about 6 pages of...

Never mind everyone, I kept playing with settings in the report controls and set the field to stretch with overflow. This resolved the problem, although, I don't know why. Since the report was sorted on a work date field and that field was printing every other time. Thanks, Laura

I have recently upgraded to VFP 9 and I am having a strange occurence in a report. It is a straight-forward, simple report of one table that is indexed on job#, work date, action, and employee. I have groups set up and the employees dump in the detail band. The very first page, the very first...

Thanks, that got me thinking in the right direction and we managed to get our results in the following way: SELECT userid,saidtime,actualtime,punchtype, ; descriptio,returntime ; FROM c:\matt\data\punches ; WHERE saidtime >= DATE() AND ; userid+TTOC(saidtime) IN ...

I have the following code that is giving me an invalid Group by clause error: Set adoPrimaryRS = New Recordset -> adoPrimaryRS.Open "SELECT userid, max(saidtime) AS saidtime, actualtime, punchtype, description, returntime FROM punches WHERE saidtime > DATE() GROUP BY userid", db...

It will not work with the new system that we have to dial into. We've tried everything, they won't say what has changed and there is no longer any support for Procomm anyway. Procomm doesn't work efficiently with all our modems. It appears to be unstable even if we say to run it in an older...

I have an Aspect script sending files thru Procomm. The system we dial into is changing so that we must move to Hyperterminal to dial in and send the files. Hundreds of files are sent daily and doing it manually is impossible. Only one file at a time can be received at the other facilty and...