(NF) Set up DSN in an Inno Setup - is it possible?

Hi all, As part of my install for my app, I need to install qodbc.exe (so I can connect to the QuickBooks Data), but then also need to set up a data source name. Can I do that through Inno? Tina --- StripMime Report -- processed MIME parts --- multipart/alternative text/pl

RE: (NF) Set up DSN in an Inno Setup - is it possible? - SOLVED

led" ) EndIf Happy coding! Tina DataHouse www.datahouse.com.au -Original Message- From: Ted Roche [mailto:tedro...@gmail.com] Sent: Wednesday, 14 September 2011 11:37 PM To: profox@leafe.com Subject: Re: (NF) Set up DSN in an Inno Setup - is it possible? On Wed, Sep 14, 2011 at 12:

SouthWest Fox 2008 ... code search

Hi crowd, Found a great white paper online from 2008 written by Rick Borup called "Automating QuickBooks with QODBC". In it he references the code samples for the session he did on this at SouthWest Fox. Anyone out there attend back then and want to share the code samples (if they still h

RE: SouthWest Fox 2008 ... code search

You know I realised that his email was there about ten minutes after sending that post out Rick :-) It was late at night. Problem solved - I did email him and he was very happy to oblige. Mike - thanks for the link - will check it out. Tina Currie DataHouse www.datahouse.com.au -Original

RE: [OT] - Male Fairy Story

all the time to everyone. She always had the remote control and never ever had to explain why she owned so many shoes. The End Tina Currie www.datahouse.com.au -Original Message- From: Adam Buckland [mailto:adam.buckl...@eurohill.com] Sent: Wednesday, 26 October 2011 8:21 PM To: profo

RE: [OT] - Male Fairy Story

Hi Pete, Poor Christine! Rest assured that I don't post [OT] very often - just couldn't resist that opportunity. Also, I am allergic to "hard left". You (and your thinking) are safe for now. :-) Tina Currie www.datahouse.com.au -Original Message

[NF] Inno - Quiet Install of QODBC and registering CD Key

Hi all, Has anyone done this before? I'm running out time and guessing how to get the syntax right is really starting to sh*t me! This link tells you how to pass a CD Key to the QODBC DLL: http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails

Refresh Issue

This should be a no-brainer, but today I've got no brain... I have a form called CLIENTS. This has a search button that when pushed, invokes another form called SEARCHCLIENTS. >From this second form, user enters a string, and pushes an OK button. That goes and searches the DBF and finds

RE: Refresh Issue

Thanks all - all fixed. I don't know why but as soon as I made the client form modal, it all worked. All your advice was valuable though especially the "DO FORM CLIENTS NAME CLIENTS" from Stephen. I've been using Fox for years and didn't know you could run a form and refer to it with a differen

RE: Interesting XLS File

I encountered this recently and battled with it for a while trying older versions of XLS - but still got some curly results. I found it easier to just save the XL file to TXT tab delimited and bring it in that way. Far safer in my opinion. Tina -Original Message- From: Pete Theisen [mai

VFP Rounding

Hi all, Hoping you can shed some light for me. I've got a calculation that I'm doing over 4 fields and then I convert the result to character by applying STR() function - doing this to a length of 20 and decimal places of 2. This rounds UP my result. I don't want this to happen. Just want i

RE: VFP Rounding

multiply by 100, apply the integer function, then divide by 100. Richard E. Quilhot C.N.A. quilh...@gmail.com On Tue, May 4, 2010 at 6:00 PM, Tina Currie wrote: > Hi all, > > > > Hoping you can shed some light for me. I've got a calculation that I'm > doing over

Re: Requirement! Need FoxPro expertise]

Darn... if I didn't live in Melbourne, Australia... I'd jump at it. :-) - Original Message - From: "MB Software Solutions,LLC" To: "ProFox Email List" Sent: Wednesday, September 02, 2009 3:43 AM Subject: [Fwd: Requirement! Need FoxPro expertise] > Got this...I'm committed here at Sy

Re: How to detect if digits in phone field?

I had to do this once for a data file of over 700k records. The data import someone else had done hadn't worked as they had planned and some phone numbers had wound up inside the "Name" field. Obviously these needed shifting back to the correct "Phone" field. Easiest and quickest way to find

Re: VFP9SP1 report -- need suggestions on alternative approach

whether that number element exists in the array. Something like that... or am I as clear as mud also? :-) Tina Currie www.datahouse.com.au > - Original Message - > From: "MB Software Solutions,LLC" > > To: > Sent: Tuesday, September 08, 2009 5:26 PM

Re: Has anyone used this tool to integrate Quickbooks with your apps?

Haven't used it Mike - and I have started to do a lot of work integrating my apps to Quickbooks. Currently using http://www.bigredconsulting.com/AboutCreator.htm?gclid=CPbYh8XG45wCFR4Hagodi0jIGg but I've been looking for an object like the one you listed for a while - so thanks for posting the

Re: [OT] What Obama Found in his Cracker Jack Box Today

People please...! As an active developer in Fox, I love that I have access to a WORLDWIDE network of like-minded developers that I can call on for assistance if need be, or just follow along with other's requests for assistance and now and then find a nugget of knowledge that I didn't realise

Re: [OT] What Obama Found in his Cracker Jack Box Today

o read the FAQ before you join a list, nitwit. --- On Sat, 10/10/09, Tina Currie wrote: > From: Tina Currie > Subject: Re: [OT] What Obama Found in his Cracker Jack Box Today > To: "ProFox Email List" > Date: Saturday, October 10, 2009, 1:37 AM > > People please...!

Re: [OT] What Obama Found in his Cracker Jack Box Today

band of OT > hooligans. It's kind of like a water cooler where you don't have to > introduce yourself all the time, "everybody knows your name" (for good or > ill) like a cyber version of the sit com Cheers... :) > > Ironically, if I really were into proselytizing

Re: [OT] What Obama Found in his Cracker Jack Box Today

Changed my mind - [OT] conversations can be a bit interesting to watch can't they? Just like a ping-pong game. Oh wait, I hate ping-pong. Can't believe this one is still going, and you're now up to names like Willie Wankstain. Had to just thank you all personally for the entertainment factor. T

Re: [OT] What Obama Found in his Cracker Jack Box Today

>> Be careful. With all this excitement, Ricardo is likely to hit on you. He >> fancies himself a kind of Latin Casanova, being, as it were, recently >> divorced, or in any case exiled to the couch. :) >> > Nah! Don't worry, my preferences are towards latin women. Besides which, I > have a couple

[NF] Quickbooks IIF file - Need 1 field name

umber. Anyone done this before an know what the hell does QB call the field? Is there anywhere I can get a list of the field names? TIA Tina Currie www.datahouse.com.au --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text

Re: [NF] Quickbooks IIF file - Need 1 field name

al Message - From: "MB Software Solutions,LLC" To: "ProFox Email List" Sent: Tuesday, November 10, 2009 7:51 AM Subject: Re: [NF] Quickbooks IIF file - Need 1 field name > Tina Currie wrote: >> Hi all, >> >> Have developed a routine that finds invoices

Re: Appending problem

Is it worth putting getfile( ) in there instead of the filename??? - make the user point out the file they need - don't know if this would change the way Fox looks at the file? It shouldn't make a difference, but if I was you and going nuts, I'd be trying it. Also for comma delimited

Re: Appending problem

Michael's echoing my thoughts. Do share. - Original Message - From: "Michael Madigan" To: "ProFox Email List" Sent: Monday, November 23, 2009 7:41 PM Subject: Re: Appending problem So what was the problem? ___ Post Messages to: ProFox@le

Re: Appending problem

We've all been there... well, I have that's for sure. Good to know it's working and it was the best kind - a simple fix. :-) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version

Double click line in Grid to show order details

Hi everyone, I have a form that has a combo box with a list of clients. Choose a client and it does a little select into a temp cursor and then displays all orders for the client in a grid below. I want the user to be able to double click any one of these orders (rows in the grid) and brin

RE: Double click line in Grid to show order details

Thank you all - lots to think about now before I get started. Glad I asked. :-) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/p

RE: ProFox Digest, Vol 80, Issue 54

Perhaps it's our terminology. Wouldn't just the word "climate" cover it a lot better than "climate change". After all, that's what climates do - they change. http://books.google.com.au/books?id=dkD69N_o42sC&pg=PP1&dq=climate+change:+a +natural+hazard&cd=1#v=onepage&q=&f=false -Origi

Is a FoxPro Generated Exe an IPC enabled application?

Associate of mine needs to know. IPC = interprocess communication. TIA, Tina ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/pro

RE: ProFox Digest, Vol 81, Issue 130

While we're on the subject of COM controls - has anyone had dramas with the MsDateTimePicker Control moving from VFP7 to VFP9? I'm getting an error 0x80030109 which means the doc file is corrupt. Which means bugger all to me. Suggestions or experience appreciated. Tina -Original Message-

RE: MsDateTimePicker Control [Was: RE: ProFox Digest, Vol 81, Issue 130]

ginal Message- From: Tina Currie Sent: Sunday, January 31, 2010 6:26 PM While we're on the subject of COM controls - has anyone had dramas with the MsDateTimePicker Control moving from VFP7 to VFP9? I'm getting an error 0x80030109 which means the doc file is corrupt. Which means b

RE: VFP9SP2 app copied onto Windows 7 64-bit machine

ers\public seemed to be a nice home for my apps." Is this where I should be installing instead? What sort of problems come of installing to C:\MyApp ? P.S. Mike: We of the fairer species are never "easy" but always worth it. ;-) Tina Currie -Original Message- From: M

Delete IDX files on Shutdown

Hi everyone, This should be a no-brainer, but I'm pregnant so got no brain right now. Throughout my app if I need a temporary index then I usually just issue INDE ON FIELD TO SYS(3) - knowing that will give me a whole bunch of .idx files to delete when app closes. In my shutdown.prg I put:

Re: Delete IDX files on Shutdown - Retracted

Der. Talk about pregnant slushy brain! I lost the IF statement and just issued ERASE *.idx Wow... only 35 more weeks of no brain...THAT's gonna be fun for my clients J --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) t

RE: Delete IDX files on Shutdown

Thanks Jack and Rick - I've not used adir() before - will put that in place now. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/p

RE: Delete IDX files on Shutdown - Retracted

Thanks Tracy - this one is number 4 so I've got the parent thing pretty much down now... - this kid aint getting away with anything! Tina Currie DataHouse www.datahouse.com.au -Original Message- From: Tracy Pearson [mailto:tr...@powerchurch.com] Sent: Saturday, 24 July 2010 1:37

RE: Excel import

uot; ElseIf Application.Version = "7.0" Then MsgBox "You are using Excel 95." End If End Sub Is the Application.Version stuff available with the oWorkBook object you've got? If it is then maybe you could convert the above to VFP code and do different Save As

Print FRX to PDF

Hi, I need to send an frx straight to a pdf - would rather not go through the choose a printer - and have a PDF Printer installed etc. Are there any neat little programs out there that work with VFP 9 on Win 7 ?? I've tried Print2PDF but had problems. TIA, Tina --- StripM

RE: Print FRX to PDF

Thanks - have downloaded trial and will give it a go Tina Currie DataHouse -Original Message- From: Richard Kaye [mailto:rk...@artfact.com] Sent: Saturday, 31 July 2010 1:20 AM To: profox@leafe.com Subject: RE: Print FRX to PDF XFRX. Integrates with VFP and has many output options in

RE: Print FRX to PDF

Thanks Dave - I downloaded it this morning (as well as a few other goodies from that same blog) Have put it into the project and now the purchase orders are printing to PDF perfectly, ready to email directly to supplier. God (or whoever floats your boat) bless the FoxPro community - I am a happy

RE: Bulk PDF Printing

DF after creation Report Form reports\toc_page To Printer Prompt Object loRptLsnr Tina Currie www.datahouse.com.au -Original Message- From: Jeff Johnson [mailto:j...@san-dc.com] Sent: Tuesday, 3 August 2010 10:29 AM To: profox@leafe.com Subject: Bulk PDF Printing Greetings: I have an appl

Source Code Ownership

Hi all, We have a client that has a major problem with our trading terms and conditions document and won't sign the contract as it states what we've always considered as standard - we maintain ownership of the source code. I was contacted by their lawyers last night quizzing me on this "peculi

RE: Source Code Ownership

quot;. Just wanted to make sure I was on the right page with regards to software source ownership. I'll leave it on hold at the moment and wait for their lawyer to get back to me with their terms for the contract. I think the dangerous assumption they have made is that we will automat

Change the colour of rows in a grid based on data

Hi all, I'm displaying a grid of some stuff the user wants to see from a search screen. They put in the criteria and it selects to a cursor. Based on a status field in the data, I want to colour code each line in the grid so they can easily see which jobs are at which status. I've done th

1680 x 1050 resolution in Win 7

Hi again, I have a great form that schedules jobs for a client. It was built back when myself and client were on Vista and was coded specifically for client's 1680 x 1050 screen resolution. Client (and myself) are now running Win 7 machines and this resolution is no longer available!! Max we

RE: 1680 x 1050 resolution in Win 7

ss it's a driver problem. Are these new Windows 7 boxes that have a different video adapter in them from the Vista box? You'll need a card capable of displaying the required resolution, you can't make it do something it's not designed for or doesn't have a driver capable o

RE: Change the colour of rows in a grid based on data

may be you can use the ICASE function for multiple cases in your SetAll if you're using VFP9. Fred On Wed, Sep 22, 2010 at 9:48 AM, Tina Currie wrote: > Hi all, > > > > I'm displaying a grid of some stuff the user wants to see from a search > screen.  They put in th

RE: Change the colour of rows in a grid based on data

LOL - It didn't occur to me to cater for those of the world that are challenged with colour recognition - maybe I need a field for status in my grid too. :-) Thanks all for your help. I'm a happy camper and have it working with this: * Set the backcolor of the records, based on their status

RE: 1680 x 1050 resolution in Win 7

Hi Alan, I haven't tried it - but will give it a go. Only thing is then I have to do the same thing for all the computers on client network... I think Windows 7 CAN handle it - it just chooses not to. LOL :-) Tina -Original Message- From: Alan Bourke [mailto:alanpbou...@fastmail.fm]

RE: 1680 x 1050 resolution in Win 7

I do have this option - and yes, running I'm running from a notebook and it is unavailable too. -Original Message- From: Tracy Pearson [mailto:tr...@powerchurch.com] Sent: Saturday, 25 September 2010 3:07 AM To: profox@leafe.com Subject: RE: 1680 x 1050 resolution in Win 7 Dan Covill wr

Setting backcolours in grid ... AGAIN

Hi there, Can anyone see a major flaw in this code? I've got baby brain remember (4 months pregnant) and have moments of extreme fuzziness these days LOL If I only use 4 different cases in the ICASE() function, it's fine - but it whines when I do any more than that. Is there a limitation

RE: Setting backcolours in grid ... AGAIN

Thanks Fred, that makes sense. I'll give it a go. Tina Currie DataHouse www.datahouse.com.au -Original Message- From: Fred Taylor [mailto:fbtay...@gmail.com] Sent: Tuesday, 12 October 2010 11:40 AM To: ProFox Email List Subject: Re: Setting backcolours in grid ... AGAIN A s

RE: [NF] Malware as M$ anti virus Security Essentials

Just removed this one from a friend's PC. Right royal pain in the butt, but MalwareBytes (free version) did the trick to get rid of it. If I could just now convince him to PURCHASE a security product Tina -Original Message- From: MB Software Solutions, LLC [mailto:mbsoftwaresoluti

RE: win7

I had exactly the same problem recently when client changed to win7. Putting the ocx in the same dir as VFP file didn't work and I had to register the ocx (and I had a few to register too) as admin on each of the client machines running the app. App lived on the server, but I had to register the o

RE: [OT] 100 people I hate on Facebook.

Facebook is sooo 2009. :-) Tina ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.

Quirks of using controls within a grid

Hi all, First time posting to ProFox - hoping someone can help me as I've wound myself into a bit of a knot with this challenge. I have an order table and I'm grabbing a subset (by SQL query) into a cursor that is readwrite. I use this cursor as the recordsource for a grid on my form. Purpos

Re: Quirks of using controls within a grid

t it to the cursor you have queried. > > If this isn't the reason then is the combobox source an SQL Select or > another type such as alias or fieldlist? Knowing will help to solve the > problem but personally I would make the source an SQL select statement > into > a dis

RE: RE: FPW2.6 Question

I have a copy of 2.6 for DOS. Not sure if you wanted this one or the Windows version. I think this one is that LAN version from memory. I've put it here if anyone wants it: http://www.fileserve.com/file/pAacNEY (8 weeks to go before I'm not pregnant anymore!!) Tina Currie

RE: RE: FPW2.6 Question

Der... Pregnancy Brain. The W in FPW would imply Windows version right? Man I can't wait to stop being a life support system for a foetus and claim my brain back. :-) Tina -Original Message- From: Michael Oke, II [mailto:oke...@gmail.com] Sent: Wednesday, 26 January 2011 8:09 AM To:

Excel 07/10 import

Hi all, I have an app out there with a client that I never hear from. Good sign ... it's working a treat. Heard from them just recently however because they want to upgrade to Excel 07 or 10. The start of the app is an "Import your Data" feature and one of the options is to import XLS files.

RE: Rushmore

records now and this gives me one more place to look for speeding it all up. Sometimes I really think I'd be lost without you ProFox guys - so, thanks. Tina Currie www.datahouse.com.au P.S. 3 weeks to go till I'm not pregnant anymore! (can you guess I don't dig "confinement

RE: Rushmore

en I supply a new build - but have I got that right? Is there any impact on network traffic doing it this way or should I move the exe to each local machine also? TIA, Tina Currie www.datahouse.com.au -Original Message- From: Stephen Russell [mailto:srussell...@gmail.com] Sent: We

RE: Rushmore

Might be worth mentioning that exe is 5.2MB. Big enough to be a drain? Tina Currie www.datahouse.com.au Grigore, Speaking from seeing it on our clients environments, the exe, when large enough, is a drain on network traffic. Tracy Pearson PowerChurch Software

OT - We had the baby!

Hello ProFox Community! Just a quick one to share that our daughter Hayley was born 4 weeks early by emergency C Section on Monday night. Mum and Bub both doing great and Hayley should be out of Special Care Nursery tomorrow. Yes - I have my laptop with me in hospital ... LOL Chee

RE: Icon maker program that came with VFP

If it is what you're looking for Ken - I'd love access to it to. I've thought of that little app fondly over the years also. Tina Currie -Original Message- From: Michael Oke, II [mailto:oke...@gmail.com] Sent: Saturday, 12 March 2011 8:53 AM To: ProFox Email List Su

RE: VFP8 End user label design

*Applauding* Well said Styze Tina -Original Message- From: Sytze de Boer [mailto:sytze.k...@gmail.com] Sent: Thursday, 24 March 2011 10:36 AM To: profox@leafe.com Subject: Re: VFP8 End user label design Well, you're probably right However, I've always placed a MORAL right above a LEG

RE: Grid Cell Question

ource = 3,RGB(174,174,255)," + ; "curScheduler.source = 4,RGB(255,255,128)," + ; "RGB(255,255,255))",[Column]) Tina Currie www.datahouse.com.au -Original Message- From: Jeff Johnson [mailto:j...@san-dc.com] Sent: Saturday, 26 March 2011 2

RE: I'm back...Just

> You may (or probably didn't ) have noticed that I haven't been around for about 3 months. Unfortunately I had a bad accident which I am now slowly recovering from and trying to get back into "work mode". Welcome back and feel better soon Tina Currie DataHou

RE: VFP9SP2 Error 11 ("Function arg value, type, or count is invalid") on SCATTER FIELDS ... NAME oTemp ADDITIVE

My favourite kind of error. PICNIC error. Problem in Chair Not in Computer. :-) Tina Currie www.datahouse.com.au -Original Message- From: MB Software Solutions, LLC [mailto:mbsoftwaresoluti...@mbsoftwaresolutions.com] Sent: Tuesday, 12 April 2011 1:51 AM To: ProFox Email List

RE: VFP9SP2 Error 11 ("Function arg value, type, or count is invalid") on SCATTER FIELDS ... NAME oTemp ADDITIVE

P.S. No disrespect intended to you of course Mike. I just thought I'd share the new phrase I use instead of "Operator Error". LYW (that's "Love Your Work" I found out recently...) Tina -Original Message- From: MB Software Solutions, LLC [mailto:mbsoftwaresoluti...@mbsoftwaresoluti

Page Numbers - Data Grouping in Reports

Hi all, So at the bottom of a report I can put a field that says: ' - Page ' +trans(_pageno) + ' of ' + trans(_pagetotal) But if I want to set the page number to reset back to 1 whenever the datagroup DRIVER changes, how do I do that? _pagetotal is no longer valid and I get things l

RE: Page Numbers - Data Grouping in Reports

Thanks Jean - I had already tried that and while it sets _pageno back to 1 for each group, the system variable _pagetotal is not valid for the amount of pages for that group. Tina Currie DataHouse 0414 576 453 www.datahouse.com.au > > Data grouping -> reset page to 1 for each group

RE: [OT] Proof that Bin Laden raid was timed to campaign.

Well of course you can make that up... You can buy the domain gutsycall.com and redirect it to Obama's 2012 campaign yourself. It's not rocket science. Tina -Original Message- From: Michael Madigan [mailto:mmadi10...@yahoo.com] Sent: Thursday, 5 May 2011 9:55 AM To: profox@leafe.com

RE: Copy Protection Schemes

Looking forward to that :-) Tina Currie -Original Message- From: Dave Crozier [mailto:dcroz...@flexipol.co.uk] Sent: Tuesday, 10 May 2011 5:31 PM To: ProFox Email List Subject: RE: Copy Protection Schemes For all those who are waiting on the protection code I promised, I am going to