Search results for query: *

My mind says this should be simple, but I am drawing a blank: I have two tables, both with exactly the same fields: Table_New and Table_Old Table_Old is an archived table of Table_New How do I connect the two into a query getting all records from both tables? Any help would be appreciated...

Hi, I need to build a query in which two tables are connected. However, one table uses the ID field as a text, the other as a numeric expression. I am not able to change the field expressions, as both tables are used in seperate programs, but DO use the same numbers ( i.e., an ID may be 20002...

My program makes use of several DateTime picker objects. They run great under the VFP machine, but not in machines which do not have VFP installed. I did, BTW, copy MSCOMctrl2 into the Windows/System32 folder of the non-VFP machine The error is as follows: "OLE IDispatch exceptioon code 0 from...

If this is a copy of my post, my apology - the first caused an error while sending: Is it possible to stop VFP 8.0 from auto-inserting a Web Help Menu Bar in my app menu upon compilation? Thanks in advance Rainer

I really need help with this, it is a recurrent problem with many reports I need to generate: Example ( not what I need but same idea for simplicity): Regular sized page should be filled with a line every inch with labels of: 'Name'.... 'DOB'.... 'Attitude'.... Each Report should be grouped...

Hi all, I have a report which prints the contents of stock items in certain areas, such as: Room #1 Room #1-Cabinet #1 Room #1-Cabinet #2 etc. etc. If I construct a where condition such as "Stock_Location = Room #1" then only items specifically labelled Room #1 will be found. I would like a...

Hi all, I am writing a little program for nurses which allow patient medications to be printed on a sheet of paper. The report, will allow 3 medications per page, each with a grid of 31 days by 4 time periods: ------------------------------ Medication |am | | | info |noon | | |...

having a label in a report detail band, is it possible to have the label caption change according to the value of a field? In the table, I have a text field called 'am' In the report, I have a label with the following entered into the caption choice: =IIF(isEmpty(am), " ", [am]) However, the...

One of my databases is linking to tables from another computer on a LAN. That child computer has an access User Name and Password. Can I either: 1) Access the tables and give user name and password in the access module 2) Ask for User Name and PAssword when the table is first opened? Any help...

Hi all, I am writing a little program for nurses which allow patient medications to be printed on a sheet of paper. The report, will allow 3 medications per page, each with a grid of 31 days by 4 time periods: ------------------------------ Medication |am | | | info |noon | | |...

I know this must be simeple, but I can't get it to work: I have a file (ROS.txt) with general text type info When inserting a record into one of my tables (using INSERT INTO SQL), I would also like to have the content of ROS.txt inserted into a memof field called ROS. What is the simplest way...

Using two tables, 'patient' and 'visits' I created views, two examples: 'view_return1' using PATIENT only, and 'view_patient_visit' using PATIENT and VISITS PATIENT and VISITS are in the DataEnvironment of a form with NO buffer. Both views are addid with Optimistic Row buffering. view_return1...

Using a table which has patient data and return visits, I made a page on a pageframe which shows return visits per week for 5 weeks, using 5 seperate Grids, each populated with SQL results (see below). The grids work fine, but I can't come up with a good method of refreshing the grids in the...

I have a table with a "occuranceDATE" DateTime field I would like the report to print all records which fall between two dates. How can I build the date into the Report Query builder and have it be a parameter (i.e.: dates will change) I don't mind having the parameter window pop up asking...

Is it possible to specify a custom Text Box class to be used as the default in a custom Grid Class? i.e.: Custom class IT_Grid Custom Class IT_GridTextBox How can I change IT_Grid to use IT_GridTextBox by default? Thank you in advance Rainer

My current program has 3 main tables which need to be synched, via Access, to a Pocket PC. The data is being used by a program written with eVB ( I don't know of any other way to program with the PPC!). My question: How can I establish a remote connection with an Access Table which can be...

having a one-to-many view derived of two tables, how do I add a record to the 'Many' table and not the primary? Example: table One - fields Code(primary key), name table Many - Fields many_Code (primary), one_code, some_date View relates table one and many by Inner Join Code=Many_code Now...

I have three tables: Patients - KeyIndex 'Code' - no buffer Visits - KeyIndex 'Auto_ID' - no buffer Codes - KeyIndex 'c_Code' The three tables are combined via 2 views: 1) 'View_Patient_Visits' (Left INNER join)tables 'Patients' & 'Visits' (Buffer = 1) 2) 'View_Patient_Visists_Codes' (Left...

Hi all, can someone explain the sequence of events when one clicks on the 'deleted' column/ tab in a grid? I know it triggers the grid.deleted method. Here is what I have in mind: User clicks on Deleted tab/ column in grid. It calls the deleted. method Code asking if sure to delete (Messagebox...

Does anyone know/ can someone figure out how to make changes to voice settings? I am including Text-to-speech in a program via the speech agent. Manipulating the agent is fairly straight forward, but I can't find out how to change the actual voice (i.e: selecting between 'LH Michelle', 'Sam'...