Recent content by foxrainer

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