Search results for query: *

Great, and you are corerct, it worked, Rainer

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...

traingamer, thank you VERY much, Rainer

Skip, no leading Zero's in either the numeric nor string ID. But, as mentioned, one field is Numeric, the other Text! In order to relate the two, one would need to be converted. Somehow, it should work to do the following: WHERE VAL(textID)=StringID However, I tried that and it didn't work.

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...

Mike and Mike, again, thank you for both of your inputs. Mike L. - you are correct - the COM was installed - I checked under my Access files and the Date/ time picker works flawlessly. Unfortunately, I can not install VFP on the boxes where I get the error as they are State computers and will...

Mike, sorry for the ignorance, but, could you tell me how? Rainer

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...

Rick, I used the menu builder. However, after the .mpg file was created, I removed the PRocedure for the web bar. Unfortunatley, the procedure is automatically inserted again each time I re-compile, and, it is NOT in the MENU designer. ? Rainer

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

Mike, After the 7 errors, when in the project, have you tried opening any of your views, if there are any? Most of my apps gave syntax errors due to the need to have SQL statements/ views redone in VFP 8, Rainer

Duane, thank you very much for your reply, unfortunately, it will not work for me. The 'background' actually is much more involved, and looks more like (even with more detail than that): _______________________________________ Field 1| Field 2 | | | | | | | | | | | |...

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...

Thank you all for your qick and appropriate responses: I ended up using '#'. Again, Thank you very much all of you, Rainer

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 | | |...

Andreas, vielen dank fuer deine zurueckschrift/ antwort - Ich werde das heute versuchen! Rainer (originally from Stuttgart, now living in upstate NY, USA) Nice Web Site - Actually, my mother and grandmother are from Kaiserslautern!

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 | | |...