Recent content by mpastore

Hi, Just a follow-up to last week's duplexing question. I found that if I do not save printer environment settings and keep the following in the .expr field of row 1 of the .frx file, any printer I point to will duplex, if it has that capability. ORIENTATION=1 PAPERSIZE=1 COPIES=1...

mgagnon, I also see this in my report. I think though the tag/tag2 binary fields also need to be updated in order to have duplex go dyanmically to other printers. The link stella gave me speaks to this. I'm doing additional testing and will post my results. Thanks Mike Pastore Hats off to...

No, that did not work. The VFP documentation makes reference to the NOPAGEEJECT command for duplexing, but I can't figure out how to put it together. Mike Pastore Hats off to (Roy) Harper

Duplex is when the report prints on both sides of the paper. Mike Pastore Hats off to (Roy) Harper

Hi, I have a report that I would like to make duplex. Can this be done programatically? Thanks Mike Mike Pastore Hats off to (Roy) Harper

Thanks for the feedback, Rick. Mike Pastore Hats off to (Roy) Harper

Hi, Hope this is the appropriate forum for this question. I would like to avoid doing a full VFP 8 intall on a workstation for development purposes. Would rather be able to access required executables from a network folder so that I can write code and compile. Is this possible? Thanks Mike...

I'd wager it is the size. In the past I have taken 2 routes to handle files of this size: 1) Partition the file into a series of smaller files based on something like date. i.e. FY96, FY97, FY98, etc. The shortcoming here is that your queries will have to account for different files. 2)...

nix my example, it does not work, should have tested before posting. Mike Pastore Hats off to (Roy) Harper

select agentid,agentname from mytable group by agentid,agentname having count(*) > 1 Mike Pastore Hats off to (Roy) Harper

Why not just: select left([myfield],len("Mac Industries")) from mytable? This assumes all the fields have "Mac Industries" as the prefix. Mike Pastore Hats off to (Roy) Harper

You can do it in 2 steps: docmd.RunSQL("alter table table1 add column myfield text(10)") docmd.RunSQL("update table1 set myfield ='KLONDIKE1 '") Mike Pastore Hats off to (Roy) Harper

I would just use a reference table called tbMonthsBack like: monthsback desc 0 0-3 1 0-3 3 0-3 4 4-6 5 4-6 etc... Then you can just join to this table to get your description... Mike Pastore Hats off to (Roy) Harper

It looks like that is where we may head...but job scheduling can really get pretty intense, we have over 200 jobs that run at different intervals and have multiple dependencies. Mike Pastore Hats off to (Roy) Harper

Does not have job dependenciy, reporting capability Mike Pastore Hats off to (Roy) Harper