Search results for query: *

HI: I have a an approach database but I want the users not be able to use any of the smarticaons and/or menu bars; just the form I have written. Does anybody know if - and how - this may be acheivable? Thanks!

Please excuse my ignorance but I am trying to set all components of a form (including a grid) to be editable (ie can add or amend records), and save the record. My users are used to simply keying in data and the edit/save process is causing problems. I have at least 4 vfp manuals and not one is...

Hi: Still using a variant of the magnificent thread401-249399 to email reports, I populate the email address with field data. What I am trying to do now is warn the emailer when the field is blank; along the lines of "If strRcp is blank then (message or report) else send"...but I am not getting...

Hi: VFP 9, SP2, remote view against Oracle 8. I want to filter against one field (orderno, number(38),not null) but 'no result set' returned. However, applying filter to other fields of similar type (albeit shorter) returns data. Is the difference that orderno is a key? However I get the same...

Hi there: I have a database that reports on production batches, with a specified batch date. Some batches cannot be made on the date specified so I want to reschedule forwards by 1 day those that are not complete. However I need to exclude weekends and bank holidays. I am using a separate...

Hi there: I am getting a 'Table in use. The table may already be opened exclusively ' error when I run an application. I use queries to get data from Oracle then load a second form from the tables that result. Running this second form generates the error. However, when running VFP itself, not...

Hi there: I am trying to bring together 2 completely disparate databases into one. The data is essentially similar but the data types are different; thus 'order number' is an integer in one and text in another. I am pulling the data from one into a paradox table, ready for import into the other...

Hi there: I have a button on a form that interrogates an oracle database several times, in the form of queries. Each time I am required to log in manually. Is there any way of writing code that logs the user in automatically? I found this: method pushButton(var eventInfo Event) var q Query dbSQL...

Hi: I have a MySql table 'customer' containing 2 columns: code (integer) and name (String). I want users to find details about the customer by calling from the drop down comboBox, but if the combo box is a list of names the SELECT query returns a SQL error; if the combobox comprises codes then...

Hi: I am trying to create a drop down list using a 'SELECT DISTINCT' from a table to give me available customers; and then pass the selected customer to a second page that allows me to view the details (address, phone, etc) of that customer. Am I right in thinking with the second page carrying a...

Hi: I have been tasked with creating a barcode from numbers.An example element is qty where a qty of 5 should read 005 within the string. My cunning plan was to add 1000 to the qty, export to csv as string, then reimport, 'somehow' trimming off the leading 1. But I am tying myself in knots here...

Hi: I use VFP to create a stand alone database of sales orders from a SQL database. I append new sales orders from SQL each day. My problem is that as sales order records in SQL are closed, then I need to close them in the VFP database, too (ie set the Field value 'Status' from 'O' to 'C'...

Hi there: I am trying to write a VFP routine that pulls from MSSQL orders processed today. Is there any way of defining 'today' as a default parameter in the view? Also the parameters I use for a similar process elsewhere prompt for a date - which is American style MM/DD/YY. Is it possible for...

Hi there: I am trying to add a button to a purchase requisition form that picks up data from vfp, loads it into Word and emails the doc via Outlook to Purchase clerk for placing with supplier. however I get an intermittent error as above, with text 'the server threw an exception'. I hate...

Hi there: I thought it would be really clever to install a second hard drive on my PC with SUSE Linux on it, primary being XP. My intention is to install MYSQL on the linux drive, then use apps on the XP drive to read the MySQL tables (I want to experiment with databases on the web, treating the...

Hi there: I am trying to run an avi file automatically within a director movie. However, the avi will only play if I Hold on the frame containing that avi. If I hold on the frame then the rest of the Director movie will not run. And I require no user intervention! So how can I write an avi into...

Hi there: I am trying to run a scan on a table where I need to look up the record of order number AND line in one table that matches the order number AND line in another. All the help in scanning refers to only scanning on one field; can i scan on more than one? Or should I be looking at a...

Hi: I am trying to write a little utility that deletes all pdf files in a given directory over 14 days old. remove() can delete specified files; but does anybody know how to delete a range, and over a given age? Thanks!

Hi there: I would like users to be able to access a calendar so as to select a required by date. My guess is something like Activex to open the calendar? But how do I get the selected date back to the field? I have bought a book on Activesx and am none the wiser! Thanks!

Hi: I have a large number of stock items in a requisition system. These can be grouped by department. When placing a requisition I would like a user to be able to select a department (not always his own) and the drop down list of stocks available would then be filtered as a result of the...