Search results for query: *

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

Hi, Hope this is the appropriate forum for this question. We are looking at switching our daily job scheduler to another product. We use a lot of VFP and would like a product that uses .dbf file structures to manage job queues. We are currently using a btrieve-based product. The product...

Add the primary key to the second table. Mike Pastore Hats off to (Roy) Harper

If you just want to know what table a records are not in table b select * from tablea where stuid not in (select stuid from tableb) ...do the opposite to find tableb records not in tablea. If you want to find records where the stuid's match between tables but there is at least one...

Does each table share the same primary key? Mike Pastore Hats off to (Roy) Harper

Yes, eash "," is considered a pseudo-column on the bottom query, You could put place-holders on the top query in order to make them match, the widths will have to be the same. Mike Pastore Hats off to (Roy) Harper