Search results for query: *

The big thing you'll have to do is change your program so that it accesses all the data via views rather than directly. This will allow you to access the SQL data just as though it's a VFP database (with a few problems due to differences in how SQL Server and VFP treat some data types). I'd...

I'd say it's best to start with VFP, but you need to plan for the upgrade by making all your data connections via local views so that you don't need to change the code when you upsize. Of course if it's just for in-house use and you've already got a data server available for exclusive use then...

I might add that while you might not care particularly for VB for programming, it's not all that hard to learn enough of it to be able to translate from VB into VFP, with the added advantage that if someone has a VB program which isn't doing working properly, you can offer to change it into a...

Unfortunately I haven't had to use fonts for foreign languages, but I'm a bit confused by your question. Where are you trying to 'key in'? If you place a text box, for instance, on a form in FoxPro try placing this code in INIT method of the form: thisform.MyTextBox.FontName =...

Well, I know nothing about PCOMM, but a quick perusal of the IBM blurbs on the package indicates it can be used with VB automation, so I'd find an example of how to use it with VB, post the sample here and someone can probably tell you how to translate that into VFP. Or you might be able to get...

Are you talking about the drivers themselves or the connection. I'd assume you could delete the driver from your system and then reinstall it from whatever disks your MS Access came from or from the MS website. I admit I haven't had to do so. Contrawise, if it's the connection which is...

Have you checked all the fields you want updated in the Update Criteria tab in the view? And did you remember to check the send SQL checkbox? And what sort of buffering, if any, do you have (I'm not sure what the default might be when browsing). Dave Dardinger

The simpliest way is just to try creating a remote view using the DSN. Open up a database in a project manager (project doesn't matter) and click Remote view / new and then select Available Data Sources Find your DSN and select it. If things are working as they should, the tables in the...

Have you checked the VFP database itself to make sure it's ok? That is, did you go to the server (or have someone go to the server if it's not close by) and actually open it an make sure the data, indexes, etc. are ok? It seems unlikely you haven't, but I don't see you've actually said so...

Well, that's a nice simple message producing code. But can you also send the message without having the have the user click the 'send button'? IOW something like: ShellExecute(0,"send",lcMail,"","",0) That is, where do I find the details of the ShellExecute...

Well looking in the help file (VBAWD10.chm) under "What's New for Microsoft Word 2002 Developers" they say: "Extensive changes have been made to the Microsoft Word 2002 Visual Basic object model to support new and improved features in the application. "Visit the Office...

Well, it looks like CompanyName property is associated with a ContactItem object which you can create, for instance with: myOlApp = CreateObject("Outlook.Application") myItem = myOlApp.CreateItem(olContactItem) For phone number there are several possibilities including...

Here's what I'd do. At each local server produce a preliminary record number where the preliminary record number is like '040017736' telling the local server that this isn't a permanent record number and so don't do anything with it. When the master server gets the record it will know that on...

I might add that from my observation recent Stars count for more than the total number of stars. This makes sense since if someone was a big expert for a while but has been gone for a year, it makes no sense to show him as a top expert. I've made the list a couple of times when I've got 2-3...

Actually you should create your own navigation bar as a class and use it whenever you need one. Of course there are navigation classes available in the samples which come with VFP, and they should be consulted as to how to code them, but they tend to have a lot of stuff you don't need or want...

I'm not certain, but you may be trying to add a form in the Form Designer and as you say this requires a form set. but you don't have to have a form set in order to have more than one form, you just need to do a DO FORM formb... from within your form or a program. In the development...

I think there are some third party programs to do that, but you could write a program to do it if you wanted. The objects in your forms are stored in the form table and you could create a program to search for each object and change the requisite values by whatever % you want. Seems to me...

Why not set up a website or helpline where the customer enters a customer ID number and his computer #, or the date or whatever you think will work and after checking that he has installs remaining, you calculate a key which he can use with whatever you've selected to unlock the software? The...

If you're just making repairs, why not shut off the buffering while doing it? Dave Dardinger

Have you tried playing with putting dodefault() after your code in the refresh and or the click events, just to see what happens? Otherwise all I can suggest is to a) post some code for us to look at, b) copy your code somewhere and start over either from your base classes or your subclass, c)...