Exporting FPD DOS 2.6 reports to Excel

2015-09-30 Thread John J. Mihaljevic
Hi all, I haven't used this in forever, but a client with an old FPD DOS 2.6 system wants the ability to export their reports to Excel. They don't want any other changes, so bringing it up to VFP isn't an option. Is there a quick-and-easy way to make this happen? Thanks, John ---

RE: Exporting FPD DOS 2.6 reports to Excel

2015-09-30 Thread John J. Mihaljevic
, September 30, 2015 11:57 AM To: profoxt...@leafe.com Subject: Re: Exporting FPD DOS 2.6 reports to Excel On Wed, Sep 30, 2015 at 11:08 AM, John J. Mihaljevic <john.mihalje...@gmail.com> wrote: > > I haven't used this in forever, but a client with an old FPD DOS 2.6 > system wa

Combobox - number of items shown

2014-07-28 Thread John J. Mihaljevic
Hi all, I have several Comboboxes on my form, and each of them displays 7 items when I click on them. Is there a setting that I'm not seeing that will allow me to display more or less items at once? Thanks very much! John --- StripMime Report -- processed MIME parts ---

ComboBox question

2014-07-22 Thread John J. Mihaljevic
Hi all, I have a ComboBox on a form. When the user enters a name (rather than clicking and scrolling through the options), it works just fine. The problem is, if they pause in the middle of typing a name. For example: They're looking for JONES. They type JO (which takes them to the first JO

Re: ComboBox question

2014-07-22 Thread John J. Mihaljevic
Thanks, Richard, but that doesn’t appear to work. I’ve changed the value of _DBLCLICK and the behavior of the ComboBox hasn’t changed. Any other ideas out there? Thanks! John --- Author: Richard Kaye rkaye .at. invaluable .D.OT com Subject: RE: ComboBox question - Link Posted: 2014-07-22

Re: ComboBox question

2014-07-22 Thread John J. Mihaljevic
That helps very much, Ted. It at least gets me up to a 5.5-second delay. More would be nice, but hey...it's better than what it was. :) Much appreciated! John --- Author: Ted Roche tedroche at gmail .DOT com According to the Hacker's Guide to Visual Foxpro (tm):   Prior to VFP 7, _DBLCLICK

Preprocessor directives in a form

2014-01-10 Thread John J. Mihaljevic
Hi all, I have a form that used preprocessor directives. For example: #DEFINE LENGTH 10 It seems that no matter where I put them in my form, I get not found errors when my code tries to reference the constant that I've defined. Where should these go in my form's code so they're

Create Excel spreadsheet - Protected View

2013-12-19 Thread John J. Mihaljevic
Hi all, My application creates an Excel spreadsheet as an option for one report. When the user opens it, Excel is saying it's in Protected View and it can't be edited. My command to create the spreadsheet is very simple: COPY TO TEST TYPE XLS FOR include What can I do to make sure that

Re: Create Excel spreadsheet - Protected View

2013-12-19 Thread John J. Mihaljevic
It's not being emailed. It's happening both on my machine and on theirs, where I have the application installed. After doing some digging, it looks like it's something within the Excel settings and not the file itself. Excel opens Excel 2, 3 and 4 workbooks in Protected View. I can have them

Combobox strange behavior

2013-12-18 Thread John J. Mihaljevic
Hi all, I have a form that gets information from the user before printing a report. I have an option group for All Accounts or Select Account. If the user chooses Select Account, a combobox becomes active that allows the user to choose the account they want to print. The first time through, it

Reading Symantec QA .DTF file

2013-11-06 Thread John J. Mihaljevic
Hi all, Does anyone have a suggestion for extracting the data from an old Symantec QA .DTF file? A client has a very old system that no longer works, and we're hoping to pull the data out for inclusion in the new system I'm writing for them. Thanks! John --- StripMime Report --

VFP 7 OLE Error code 0x80040154: Class not registered. OLE object is being ignored

2013-08-11 Thread John J. Mihaljevic
Hi all, A VFP 7 application that I'm working on works just fine on my XP desktop, but I'm getting the above error on my Vista laptop when trying to run the same application. Any ideas or suggestions? Thanks very much! John ___ Post Messages to:

RE: VFP 7 OLE Error code 0x80040154: Class not registered. OLE object is being ignored

2013-08-11 Thread John J. Mihaljevic
it is, then load it and register it on the other machine. Google will tell you the registration process. (That's pretty much why I avoid using 3rd-party controls.) Dan Covill San Diego On 08/11/13 06:05 PM, John J. Mihaljevic wrote: Hi all, A VFP 7 application that I'm working on works just

VFP 7 on Windows 8

2013-06-26 Thread John J. Mihaljevic
Hi all, I've got VFP 9 working just fine on my Windows 8 machine, but just installed VFP 7 to do some work on a system that was written in VFP 7. When I start VFP 7, the splash screen flashes on the screen very briefly, then goes away. VFP 7 doesn't start. Any tips for making this work?

RE: VFP 7 on Windows 8

2013-06-26 Thread John J. Mihaljevic
That would've been my preference, but the client doesn't want that. They only have VFP 7 and don't want to get VFP 9. They just want me to make some modifications why they're in-house programmer is out of the country. John -Original Message- From: ProfoxTech

RE: VFP 7 on Windows 8

2013-06-26 Thread John J. Mihaljevic
sake. John -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Wednesday, June 26, 2013 12:52 PM To: profoxt...@leafe.com Subject: RE: VFP 7 on Windows 8 John J. Mihaljevic wrote on 2013-06-26: Hi all, I've got VFP 9 working

RE: VFP 7 on Windows 8

2013-06-26 Thread John J. Mihaljevic
Thanks for all the thoughts, everyone. I'm going non-stop right now, but will try these things tonight or tomorrow morning and report back with what I've found. John -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Wednesday, June

RE: Function argument value, type or count is invalid

2013-05-28 Thread John J. Mihaljevic
I shared it yesterday. :) Turned out that the variable in the report was logical, but it was being set as character in the calling program. I overlooked it, but noticed it right after I clicked Send on the email. John -Original Message- From: ProfoxTech

Function argument value, type or count is invalid

2013-05-27 Thread John J. Mihaljevic
Hi all, I'm working on a previous programmer's system, and am getting this error any time I try to run a certain report. I've looked all through the report at the variables used, tables used, fields used, etc., and can't seem to find anything that could be causing it. Can anyone suggest

FW: Function argument value, type or count is invalid

2013-05-27 Thread John J. Mihaljevic
Never mind. Found it. :) John --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: Function argument value, type or count is invalid

2013-05-27 Thread John J. Mihaljevic
Yes, I probably should do that. :) It turned out to be something very simple. A variable that was used in displaying text on the report had the incorrect type being sent to it. It was a logical variable in the report, but a character variable in the calling program: In the calling program:

RE: VFP on Windows 8

2013-05-10 Thread John J. Mihaljevic
I tried that. I unblocked it, but it still didn't work. And each time I went back into Properties for the CHM and it was blocked again. No matter how many times I clicked Unblock, the problem remained. John -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On

RE: VFP on Windows 8

2013-05-10 Thread John J. Mihaljevic
to where you put it. Fred On Fri, May 10, 2013 at 6:15 AM, John J. Mihaljevic john.mihalje...@gmail.com wrote: I tried that. I unblocked it, but it still didn't work. And each time I went back into Properties for the CHM and it was blocked again. No matter how many times I clicked Unblock

VFP on Windows 8

2013-05-09 Thread John J. Mihaljevic
Hi all, I just installed VFP 9 on my new Windows 8 machine. It appears as though the Help file installed and is in the right place, as I can see all the Help topics listed under Contents and Index, but I can't see any details of the Help text in the right window. No matter what I click on, that

RE: [NF] Which laptop?

2013-04-12 Thread John J. Mihaljevic
I just bought a new Dell Inspiron 15R from Dell's web site. It was around $750 with a two-year warranty. It's got 8GB RAM, a 1T HD, a 15.6 touch-screen monitor and an i5 processor. It looks like I'm gonna get 4-5 hours on one battery charge. After three days with it, I'm really liking it. It

RE: [NF] Which laptop?

2013-04-12 Thread John J. Mihaljevic
Sorry, but I don't. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ricardo Aráoz Sent: Friday, April 12, 2013 3:01 PM To: profoxt...@leafe.com Subject: Re: [NF] Which laptop? El 12/04/13 16:03, John J. Mihaljevic escribió: I just bought a new Dell

[OT] Touch screen laptops

2013-03-31 Thread John J. Mihaljevic
Hi all, I'm going to be needing a new laptop VERY soon as mine is breathing its last. I haven't yet chosen a manufacturer, but I have a pretty good handle on the features I'm looking for, except for one: touch screen. The only benefit I can think of to having a touch screen laptop would be if I

Error running second instance of EXE

2013-03-29 Thread John J. Mihaljevic
Hi all, I'm working on a system (VFP 6.0) that works just fine for one user. But when a second user is in the system and tries to run a form that the first user is on, they were getting the following message: Error loading file - record number 23. Form1 or one of its members. Loading form or the

Error running second instance of EXE (more)

2013-03-29 Thread John J. Mihaljevic
Correction: Two cursors aren't being created when the form loads. One is a cursor and one is a dbf. Both done using the SQL SELECT command. Are DBFs created this way made exclusive by default? Just trying to see if my problem is the DBF, the cursor or both. Thanks, all. John

RE: ProFox Digest, Vol 119, Issue 23

2013-03-19 Thread John J. Mihaljevic
Thanks for everyone's input! The problem was a result of recreating the RecordSource for the grid. Each time that happened, the grid lost its formatting (columns, click events, etc.). What I ended up doing was to use two identical tables: orderstemp and ordersgrid. I made ordersgrid the grid's

Strange grid behavior

2013-03-18 Thread John J. Mihaljevic
Hi all, I have a form that accepts an order number. When the user enters the order number, it first validates that number to make sure it exists, and then creates a grid which displays the order detail. If the user changes that field to an invalid order number, I have that grid disappear. The

Strange grid behavior (more)

2013-03-18 Thread John J. Mihaljevic
Leaving the form and returning to the form makes everything fine again. The problem only occurs when: 1) A valid order number is on the from 2) It's changed to an invalid order number 3) A valid order number is re-entered (the grid goes goofy) Thanks, John

RE: Error executing SQL commands on a SQL table

2013-01-11 Thread John J. Mihaljevic
This worked, but instead of using {...} as in {dtoc(startdate)}, it required me to use '...' as in 'dtoc(startdate)'. Everything works perfectly now. Thanks very much to all for their suggestions! All were very helpful. John -Original Message- From: Rafael Copquin

Error executing SQL commands on a SQL table

2013-01-10 Thread John J. Mihaljevic
Hi all, I'm trying to execute commands on a SQL table from with a VFP 6.0 application. Here's the section of code that's causing me problems: cnTransfer=sqlstringconnect(cnstr) cnTransfer has a value of 1, so the above command and cnstr (my connection string) are apparently fine.

FoxDOS 2.6 Screen Set

2012-11-15 Thread John J. Mihaljevic
Hi all, I'm making changes to someone's old 2.6 system. They have a screen set where they're entering a one-line memo field for a check. They'd like to be able to select from several different pre-set lines, so I'm setting up a radio button for this. If we were in VFP, I'd be able to easily

RE: Locate File errors

2010-04-09 Thread John J. Mihaljevic
Hi all, Thanks very much for the help, Tracy. The EXTERNAL ARRAY command cleared up that error, but I'm still getting the one window: Locate File Unable to find unknown TOPMESSAGE And the error report: Program c:\test\englib.prg has the following errors: Unknown TOPMESSAGE - Undefined Also, I

Locate File errors

2010-04-08 Thread John J. Mihaljevic
HI all, I'm trying to rebuild a project and am getting some errors that I can't figure out. During the build, I get two windows popping up. The first says: Locate File Unable to find unknown FIRSTARRAY I click Ignore, then get a second window: Locate File Unable to find unknown

.NET and other languages for a VFP developer

2010-02-11 Thread John J. Mihaljevic
Hi all, I've been working in VFP (and earlier versions of the product) for years, but with my company probably being sold this year, I feel it's time to begin educating myself in other languages. So, what does everyone suggest? What's easiest for a VFP person to learn? What languages are

Refox issue

2009-03-25 Thread John J. Mihaljevic
Hi all, Is anyone using Refox 8.x? It supposedly works up through VFP 6.0, and I'm trying to use it to pull some source from a 6.0 EXE. I'm seeing all the files inside the EXE, selecting the file I want to extract, extracting them, seeing the Extract ... completed message, but the file is nowhere

Not a database file in FPD 2.5

2009-03-19 Thread John J. Mihaljevic
Hi all, Someone I know who is still using FPD 2.5 had some tables get damaged. Lots of them. And when trying to open them, we always get the Not a database file message. Back when I used to use 2.5, I remember this happening occasionally, and I had a PRG that fixed them. But that's long gone.

RE: Multiple reports, side-by-side, same page

2009-02-05 Thread John J. Mihaljevic
I ended up creating a new table that I called REPORTDETAIL and added all the fields necessary for the side-by-side reports: R1field1 R1field2 R2field1 R2field2 R2field3 Etc. I then filled that table with the data from each of the two reports, and printed one report from that REPORTDETAIL table.

Multiple reports, side-by-side, same page

2009-02-03 Thread John J. Mihaljevic
Hi all, I have a request to produce several very short reports, but they can't be on separate pages. In fact, they need to be side-by-side on as few pages as possible using different sets of data. For example, imagine the left side of the page has a report called Customers and lists

Error when running form

2008-10-30 Thread John J. Mihaljevic
Hi all, I have a form that was running perfectly. For reasons I won't get into in order to save time and typing, I issued FREE TABLE on one of the tables in the form. I then added the table back to the database. When I run the form now, I get this error: Error loading file - record number 5.

RE: Error when running form

2008-10-30 Thread John J. Mihaljevic
Answering my own question: I just did REMOVE TABLE and then ADD TABLE to put it back. Problem solved. Sorry! :) -Original Message- From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of John J. Mihaljevic Sent: Thursday, October 30, 2008 2:04 PM To: [EMAIL

Combo Box questions

2008-09-08 Thread John J. Mihaljevic
Hi all, I've got a combo box in a form that's behaving strangely in two ways: 1) When I click on the combo box to view the options in the dropdown list, moving the mouse over the options highlights them. This makes sense for the option the mouse is currently over, but when I move the mouse to

Sending database changes off-site for views

2008-08-13 Thread John J. Mihaljevic
Hi all, We've got an app running off-site. Whenever I make changes to the structure of tables on my end, I've been writing little programs using commands such as ALTER TABLE to make the changes to the structure of the tables on the user's end. But what if I make changes to a view? How do I

Ignoring deleted records in a view

2008-08-05 Thread John J. Mihaljevic
Hi all, Something strange happened in a system we have that I can't figure out. I have a view (BACKLOG) that references three base tables (ORD_LINE, ORD_HEAD, CUSTOMER). It used to ignore records in the base tables that were marked for deletion, but suddenly isn't doing that anymore. All

RE: Ignoring deleted records in a view

2008-08-05 Thread John J. Mihaljevic
And SET DELETED is ON in the session where the view is open/created? SET DELETED ON is one of the very first lines of code in the system. Hmmm.local view (all VFP tables), right? Yes. And the strange thing is, I honestly can't recall making any changes in the system that would've done

RE: Ignoring deleted records in a view

2008-08-05 Thread John J. Mihaljevic
Remember that SET DELETED is scoped to the current data session. I've seen this kind of thing when people change classes from CUSTOM (or other) to SESSION. That's why I suggested checking the setting of DELETED right before you open/requery the local view. Thanks for mentioning requerying

RE: Ignoring deleted records in a view

2008-08-05 Thread John J. Mihaljevic
REQUERY() fixed the problem, but for those who are curious: I'll ask again to reinforce what others have asked already... Is SET DELETED ON in the datasession where you are opening the view? I only SET DELETED ON in one of the first lines of code in the PRG that calls the rest of the system.

Creating a ZIP file from within VFP

2008-08-01 Thread John J. Mihaljevic
Hi all, Is there a way to create a ZIP file from within a VFP app? If so, how can it be done? Preferably without having to pay for any utilities. Thanks much! John ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: Creating a ZIP file from within VFP

2008-08-01 Thread John J. Mihaljevic
I just grabbed this and love it. Very easy to use and works great. Thanks for the info! -Original Message- From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Michael Oke, II And it works very well. ::michael Brian Abbott wrote:

RE: Entering field in the first character position

2008-07-23 Thread John J. Mihaljevic
Thanks for everyone's thoughts on this. I agree with all of you who said it was a bad idea, but had to investigate it anyway so I could give the users what they wanted. In the end, I pretty much told the plant manager what all you you said: It is the way it is. If the users want the whole field

Entering field in the first character position

2008-07-22 Thread John J. Mihaljevic
Hi all, I want to enter a field and have typing automatically begin in the first character position. By putting a K in the Format property, the entire field highlights when I tab to it, but not when I enter the field by clicking in it with the mouse. How can I make the typing begin at the first

RE: Entering field in the first character position

2008-07-22 Thread John J. Mihaljevic
in the first character position On Jul 22, 2008, at 12:10 PM, John J. Mihaljevic wrote: How can I make the typing begin at the first character position regardless of how I enter the field (tabbing or mouse click)? So if a user deliberately clicks in the middle of the text, you're

RE: Simplifying my earlier problem

2008-07-01 Thread John J. Mihaljevic
-Original Message- From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Paul McNett zip that up, post it on the web somewhere, and then restate your problem with a link to your zip bundle. Perhaps the process of making the simple test case will help you find

Simplifying my earlier problem

2008-06-30 Thread John J. Mihaljevic
Hi all, I posted this last week with two detail bands and haven't been able to make it happen. So, rather than dealing with two detail bands right now, I'd like to simplify things. I want to group the data twice, based upon one table (RAWMATERIAL) and have detail lines based upon another table

RE: Setting up a complex report

2008-06-25 Thread John J. Mihaljevic
Hi Cathy, Here is a screen shot of the report definition: -Original Message- From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Cathy Pountney It sounds to me like the target alias isn't right and the parent and relations aren't right. Make

RE: Setting up a complex report

2008-06-25 Thread John J. Mihaljevic
Sorry, all. Didn't know embedded images would get removed from the email. Cathy...I also sent that to you directly. If you didn't get them, let me know and I'll send them as attachments. Thanks, John ___ Post Messages to: ProFox@leafe.com

RE: Setting up a complex report

2008-06-20 Thread John J. Mihaljevic
] [mailto:[EMAIL PROTECTED] On Behalf Of John J. Mihaljevic Sent: Thursday, June 19, 2008 1:18 PM To: profox@leafe.com Subject: Setting up a complex report Hi all, I'm having trouble creating a pretty involved report. It is to list our different raw material types and sizes. Under each type

Setting up a complex report

2008-06-19 Thread John J. Mihaljevic
Hi all, I'm having trouble creating a pretty involved report. It is to list our different raw material types and sizes. Under each type and size, it's to list any outstanding purchase orders we have for more of that size. And under that, it's to list any customer orders we have open for

Saving printer destination

2008-06-06 Thread John J. Mihaljevic
Hi all, We print several copies of our invoices, each with something slightly different on it. When printing the first copy, I ask the user where the printing should go: Report Form invoice To PRINTER PROMPT NOCONSOLE After that copy of the invoice is verified to be okay, I then print

Relationships and referential integrity

2008-05-30 Thread John J. Mihaljevic
Hi all, In a one-to-many relationship, I can easily see how to automatically delete any child records when the corresponding parent record is deleted. But how is this done in reverse? When the final child record of a relationship is deleted, can the parent record automatically be deleted in

Auto-recentering forms when main window is resized

2007-12-18 Thread John J. Mihaljevic
Hi all, I see that the AutoCenter property makes a form display in the center of the screen when it's first displayed, but is there a simple way to have a form automatically recenter itself when the main VFP window is resized? I'm sure I could set something up to determine the size of the form,

[NF] Randomly getting Google Image Search results page

2007-12-05 Thread John J. Mihaljevic
Hi all, Every once in a while, when clicking on a Web link or refreshing a Web page, I don't get the page I want. Instead, I get a Google Image Search results page (showing lotsa pictures, as if I was doing an image search on Google). It's happening on three machines on our network. Has this

Decimal-aligning data in reports

2007-11-29 Thread John J. Mihaljevic
Hi all, I have the following three fields listed one underneath the other in a column: Quantity UnitPrice ExtendedPrice Examples of those values may be: 100 0.0525 5.25 We don't want the numbers left-aligned or right-aligned...we want them to be aligned by the decimal. Is there a way to

RE: Decimal-aligning data in reports

2007-11-29 Thread John J. Mihaljevic
. Then you can place the text boxes the way you want. HTH Andrew Stirling 01250 874580 http://www.calcpay.co.uk HMRC Accredited UK payroll program John J. Mihaljevic wrote: Hi all, I have the following three fields listed one underneath the other in a column: Quantity

Updating views

2007-11-27 Thread John J. Mihaljevic
Hi all, I've got a form that uses a local view called Orderprintout. One of the fields it contains is Orders.flag. The Orders table and the Orderprintout view are both set to Buffermodeoverride=5. I've got a command button on the form that prints all orders that have Orderprintout.flag=.f.

RE: Updating views

2007-11-27 Thread John J. Mihaljevic
There ya go. Obviously, my first time working with these. :) Thanks Brian! -Original Message- From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Brian Abbott Sent: Tuesday, November 27, 2007 11:20 AM To: [EMAIL PROTECTED] Subject: Re: Updating views

FPW2.6 printing black bars instead of labels

2007-10-09 Thread John J. Mihaljevic
Hi all, One of our plants is using an old FPW2.6 application that we wanted to look at here. We copied it from the plant onto a USB drive and put in on several machines here. Everything works, but when printing reports, we're not seeing the text in labels...we're seeing solid black bars. This

RE: FPW2.6 printing black bars instead of labels

2007-10-09 Thread John J. Mihaljevic
, MI 48823 517.333.2680 x 102 (phone) 517.333.2596 (fax) [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John J. Mihaljevic Sent: Tuesday, October 09, 2007 10:16 AM To: profox@leafe.com Subject: FPW2.6 printing black bars

RE: DBFs disappearing when PACKing

2007-10-02 Thread John J. Mihaljevic
Hi all, It looks like we have a solution to my issue. This took care of both issues (DBFs disappearing when PACKing tables, and also being unable to save any Office 2007 files to the network). Our network genius came out today and changed two settings on everyone's Vista machine: 1) UAC is now

RE: DBFs disappearing when PACKing

2007-10-02 Thread John J. Mihaljevic
-Original Message- From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Paul McNett Tracy Pearson wrote: The genius probably changed some network settings too, but won't mention it, and is going to blame it on the UAC of Vista. Well, that would be easy to

RE: DBFs disappearing when PACKing

2007-09-27 Thread John J. Mihaljevic
Hi all, Just did some more testing on this, so here are some answers to the questions that were asked of me yesterday. First off, it's apparently not a VFP9 problem, as it's also happening with VFP6. That leads me to believe there's some kinda networking issue (Server 2003 on our server) or a

DBFs disappearing when PACKing

2007-09-25 Thread John J. Mihaljevic
Hi all, I'm using a DBF in VFP9 on a machine with Vista Business: USE parts ORDER 1 EXCL When I issue the PACK command, I get a window that reads: File f:\prices9\parts.dbf does not exist. And when I go to use the file again (or to simply browse for it in Windows), it's gone.

RE: DBFs disappearing when PACKing

2007-09-25 Thread John J. Mihaljevic
disappearing when PACKing Is there a tbk with the same name? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John J. Mihaljevic Sent: 25 September 2007 16:45 To: profox@leafe.com Subject: DBFs disappearing when PACKing Hi all, I'm using

RE: DBFs disappearing when PACKing

2007-09-25 Thread John J. Mihaljevic
Thanks for all the suggestions, everyone. I'm still looking into this and will check out everything everyone has said. I'll get back to you with a solution when (if) I find one. I'm also suspecting there's something wrong with our network configuration. We recently got Server 2003 installed,

Printing from Print Preview in VFP9

2007-08-08 Thread John J. Mihaljevic
Hi all, I've just brought some VFP6 apps into VFP9. My boss has two printers installed on his computer: Local: Samsung ML-2010 (set as default) Network: HP 2550L When he prints from anything but VFP9 (Excel, Outlook, etc.), the output goes to the Samsung (his default printer) as it should. I

Problems running system copied with GoToMyPC.com

2007-07-18 Thread John J. Mihaljevic
Hi all, I have a system on my machine that I wrote in VFP9. I copied it to a computer at one of our plants using GoToMyPC.com. The copy seemed to go fine, but whenever anyone tries to run it (by double-clicking on the EXE), it just beeps and goes no further. I copied the exact folder from my

RE: Problems running system copied with GoToMyPC.com

2007-07-18 Thread John J. Mihaljevic
: Problems running system copied with GoToMyPC.com If your 'system' is a complied exe, did you put the runtimes on the target pc? Rick Q -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John J. Mihaljevic Sent: Wednesday, July 18, 2007 8:28 AM

RE: Problems running system copied with GoToMyPC.com

2007-07-18 Thread John J. Mihaljevic
having these issues. Thanks, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Bourke Sent: Wednesday, July 18, 2007 9:16 AM To: [EMAIL PROTECTED] Subject: Re: Problems running system copied with GoToMyPC.com John J. Mihaljevic wrote: Yes, I

RE: Problems running system copied with GoToMyPC.com

2007-07-18 Thread John J. Mihaljevic
Hi all, Looks like I figured out the problem, and man, do I feel like a moron... I had the VFP6 runtimes set aside in a separate folder so they'd be easily accessible to me anytime I made a new application. Out of force of habit, I was copying those runtimes into my VFP9 applications. I

Placing movable textbox and captions. Captions move, textboxes don't.

2007-06-10 Thread John J. Mihaljevic
Hi all, We have some code set up to place a movable field on a formset page. It places the textbox and a caption. The textbox is created from a class we created called mobilebox and the caption is create from a class we created called mobilelbl. The fields are placed on a page tab within a form

Starting Outlook from within VFP

2007-06-05 Thread John J. Mihaljevic
Hi all, Using VFP 9, I'm using the following code: loOutlookApp = CREATEOBJECT(Outlook.Application) I get an error that says: OLE error code 0x8007007e: The specified module could not be found. Any ideas what I need to look for here? Thanks! John

Visual FoxPro on Vista

2007-05-07 Thread John J. Mihaljevic
Hi all, All of our PCs are running XP, but we're considering new ones that run Vista. Has anyone had any issues running VFP on Vista machines? We've got one system on 6.0 and another one on 9.0. Thanks, much! John The difference between a successful person and others is not a lack of

RE: [NF]Jerry Wolper...

2007-04-12 Thread John J. Mihaljevic
Hi Jack, Pens fan, here... The Pens have a great offensive punch but if you saw the game last night their goaltending was shaky. Actually, it seemed to me that Fleury played well...it was the defense overall that hurt them. That, and the fact that the Senators were just plain relentless.

Preventing .null. Values in a view

2007-03-21 Thread John J. Mihaljevic
Hi all, I created a view in which some fields are giving me a null value. For example, if customernumber 100 isn't found, customername is .NULL. instead of giving me an actual customer's name from my Customers table. This is correct, but is there a way to have this field show me blanks instead

RE: Class library causing compile error

2007-03-16 Thread John J. Mihaljevic
This did the trick. Thanks much! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Dibble Sent: Thursday, March 15, 2007 9:26 PM To: [EMAIL PROTECTED] Subject: RE: Class library causing compile error The following lines, executed in the

Class library causing compile error

2007-03-14 Thread John J. Mihaljevic
Hi all, I've got some classes in a library called myclasses.vcx. When I first start VFP9, I can modify my project, compile, and life is good. But any other time I go back into the project to make changes, I get the following error when building: Compiling c:\mercer9\myclasses.vcx File

Click vs. Double-click in a listbox

2007-02-28 Thread John J. Mihaljevic
Hi all, We have a listbox that's being populated by an SQL command. We want to click on a record in the listbox to populate the rest of the form with data based upon which record was chosen. When the code to do this is in the Click event, it does not work. Even though the record is found

Disabling a key

2007-02-20 Thread John J. Mihaljevic
Hi all, I want to prevent a certain key (in this case, DNARROW) from being used by my users in a certain column of a grid. I was going to set up a simple procedure called DONOTHING.PRG that contained only RETURN .T. and put ON KEY LABEL DNARROW DO DONOTHING.PRG in the WHEN method and ON KEY

Adding a button to the report viewer (REPORT FORM ... PREVIEW)

2007-02-01 Thread John J. Mihaljevic
Hi all, Whenever someone creates a report in my VFP9 system, I send everything to the screen with REPORT FORM ... PREVIEW. That way, the users can just look at the report before deciding if they wanna print it or not. If they wanna print it, they can just click the printer icon at the top of

Creating Word DOC files from VFP

2007-02-01 Thread John J. Mihaljevic
Hi all, Actually, rather than creating a PDF file from my application, is there a way to send the report output to a Word DOC? Or any other file that can be emailed and printed? There are graphics in these reports that we don't want to lose, so I can't do this with straight TXT files. Thanks,

RE: Pageframe tabs on Left

2007-01-29 Thread John J. Mihaljevic
Wouldn't changing the value of PageOrder on each page do what you want? John In a perfect world, every dog would have a home and every home would have a dog. - Craig Wilson, USA Today, 12/31/98 * All mail scanned by Norton AntiVirus. No AV software on your computer? Remove me from your address

Printing groups conditionally

2007-01-24 Thread John J. Mihaljevic
Hi all, I have a report that is going to be sorted one of two ways - either by Order Number or by Machine Number. When it's sorted by Order Number, all the data is just to be printed sequentially with no breaks. But when it's sorted by Machine Number, the users want a break and subtotals by

Determining the type of active index

2007-01-16 Thread John J. Mihaljevic
Hi all, I've got a Search box on my form that will let the user search the active table based upon whatever the current sort order is (the currently active index tag). For example, my Customers table. I want them to be able to enter either a Customer Number or a Customer Name, and have it

RE: Determining the type of active index

2007-01-16 Thread John J. Mihaljevic
I just re-read my post and am not sure I was clear enough in the question I'm asking here, so lemme try again: I realize vartype() will tell me if a field is numeric, character, etc., but what can I do to determine what type an index tag is? For example: Number N(5) Name C(25) ZipN(5)

Strange error message

2007-01-09 Thread John J. Mihaljevic
Hi all, When building an EXE from my project, I'm getting two errors. Here's the .ERR file: Compiling c:\pontotoc\pontotoc.dbc dondondonENDIF it's locked already, or i was able to lock it Error in line 36 (record 3): Unrecognized command verb. Error in line 40

Saving and restoring data environments - and variables

2007-01-02 Thread John J. Mihaljevic
Hi all, In this project I'm working on, my users wanna be able to have several forms open at once. For example, if they're in the Finished Goods form, they may wanna open up the Customers form. If I open the Customers form and then close it, when I return to the Finished Goods form, the tables

Slow refreshing

2006-12-20 Thread John J. Mihaljevic
Hi all, I've got several forms, all with pageframes on them. This one form in particular has a good bit of information on each of the first two pages, but not really all that much more than on any of my other forms. When I switch between the first two tabs of this form, I see the input fields

  1   2   >