Hi,
I've created a macro in Excel that uses the find function, here is the code it produces:
Cells.Find(What:="Saunders", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate...
Hi,
I have a 6 column grid with one combo inserted into column 3. The combo is populated with several choices that the user can make, a common scenario no doubt.
At runtime, this all works fine except for the fact that the combo looks "squeezed" i.e. the row does not seem tall...
Hi,
Does anyone know if it's possible to use the VFP Query Designer within an app, i.e. call it like a form. Am I asking too much ? I don't want to reinvent the wheel by having to write a query tool for my end users.
Thanks!
Jim Worley
jim@aits-uk.net
http://www.aits-uk.net
Hi,
Please forgive me if this question is a little elementary but I have searched this forum for ages and I haven't found anything on this subject.
I am writing a query form where a user can locate and open any VFP database. What I would then like to do is get a list of tables in that...
Hi,
I'm using getfile() to locate a file that the user wishes to import/export. In use, the first time the user browses to a particular location, the path seems to stay in memory until the program is terminated.
I'd like to be able to store the path that the user first browsed to, and start...
Hi,
I have written an app that is installed in 30 or so locations. User input has resulted in a new version which has required changes in several tables i.e. addition of new fields. Is there an easy way of inserting the new fields into the existing tables when the upgraded executable runs for...
Hi,
The Outlook junk/adult mail filter is accessible in a silly little window where you can add/remove addresses. Is there a data file with these entries in it that I can manually edit in a text editor to save messing about ?
Hope you can help :) Jim Worley
jim@aits-uk.net
http://www.aits-uk.net
I have a HP Laserjet 4500 which is connected to a D-link print server. When I set this up, everything worked fine for a while, and then it stopped working. When trying to print a test page, I get the following message in the event log:
"The document Test Page owned by administrator...
Hi,
I have a new Toshiba Satellite portable running Win 2K, and Office 2000. When I use File/Save As and try to save to A:, it reboots immediately. It does not do this in any other application when I save to the floppy drive. I have deinstalled Office and reinstalled it, still does the same...
Hi,
We have an installation of 1 NT4 Server and 34 NT4 W/station clients. On one (and only one) of the clients, you can log in as administrator when the machine is not connected to the network, and you have full administrator privileges locally. Connect the machine to the network using the...
Hi,
One of my clients had a bepoke app written, he doesn't know what language the developer used, I note that it uses an Access database and am assuming that it is VB. The company who developed it went bust and you guessed it, no source is available. Changes need to be made with it as it...
After running a dos command using run /N, my application ends up minimised. I don't want this behaviour but can't find a way to stop it. Any ideas ? Jim Worley
jim@aits-uk.net
http://www.aits-uk.net
We have implemented roaming profiles on our LAN, and store each user's Outlook PST files in shared folders on the server. This is fine for desktop workstations, but we have outworkers with portables who want to take them home, write emails and then synchronise their office-based PST files.
Of...
Hi,
I have a listbox populated by data from a cursor that is created as a result of an SQL query. The listbox is used on a form that allows a user to select single records for deletion. Having deleted the desired record, I run the original SQL query again to update the listbox. When I wrote...
Problem:
Want to move .pst file from desktop pc to network drive so that I can access them on my NT Terminal Server connection from my portable. Have set up LOADS of anti-spam email rules.
When .pst file moved from local to network drive, everything OK except all rules disappear when I access...
Hi,
I have scheduled 3 jobs on on our NT4 SP6 box, the first runs ntbackup at 11:59pm each day, with exceptions being written to a backup.log text file. However, if the backup.log file is not cleared the following day (i.e. the contents of the file deleted, not the file itself), the backup...
Hi,
Does anyone know of a good FTP control that I could plug in to a VFP application to perform background transfers of a simple text file to a Unix box ??
Any help/addresses would be much appreciated.
Jim Worley
jim@aits-uk.net
http://www.aits-uk.net
15 years practical IT experience from...
I would like to run a form on it's own without the main VFP window when compiled into an .exe Anyone know if this is possible ?
Jim Worley
jim@aits-uk.net
http://www.aits-uk.net
15 years practical IT experience from sales to support to development plus B.Sc. (Hons) Computer Studies, fluent...
Hi, I have no room on my form for a list box, so I've used a combo box instead. An SQL query creates a cursor that I then use as the data source. What I really want is for the user to type the first character of a stock code they are looking for into the combo box. This should open the combo...
Hi,
Does anyone know of a way I can distribute reports across a LAN without having to go around each workstation running the Setup for the normal CR distribution ?
BTW, each workstation already has the runtime installed (V7)
Jim Worley
jim@aits-uk.net
http://www.aits-uk.net
15 years...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.