Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. risslsu

    mail merge with .dbf

    I'm trying to merge a word document from a foxpro .dbf file. It works fine on some machines, but on others Word wanted to confirm the data source. How do I make the Confirm Data Source Dialog box not appear? I have tryed to set confirmconversions to false in my opendatasource statemnt, but...
  2. risslsu

    Word Dialogs

    Thank you so much. I found all of them!
  3. risslsu

    Word Dialogs

    How do I define dialogs? Mike gave me this one: #DEFINE wdDialogFileSummaryInfo 86 How do I know what number to put behind them? For Example, I need to know how to define wdDialogFileSaveAs. Is there somewhere I can find this information? Marissa
  4. risslsu

    wdDialogFileSummaryInfo

    Just for reference I figured it out. oWord.ActiveDocument.ActiveWindow.Caption = l_newtitle This command changed the filename in the title bar.
  5. risslsu

    wdDialogFileSummaryInfo

    oWord.Dialogs worked. But I didn't solve my initial problem. I do not want the name of my document to be "Form Letters 1". I want to change the name, but without issuing a saveas because I still want to user to have the option to save or not. Is this possible?
  6. risslsu

    wdDialogFileSummaryInfo

    Yes, it is defined in my program. Should I reference Dialogs as oWord.Dialogs where oWord is my Word object? Is this even valid code to use in VFP?
  7. risslsu

    wdDialogFileSummaryInfo

    I am trying to change the name of a word document that had been merged. I can't use saveas because I cannot assume the user wants to save the document, but I would like to change the title of the document for the suggested name if they should chose to save it. I have found the folling example...
  8. risslsu

    OLE error 0x80040154

    OLE error code 0x80040154: Class not registered I installed my software on the new laptop we just received and I am getting an error on a createobject statement. But what is strange is that it is not the first createobject statement. Many others are executed before this one fails. I do not...
  9. risslsu

    Messagebox

    Thanks for all the replies, but I made my own messagebox in a form and now everything works great. Marissa
  10. risslsu

    Messagebox

    All: I am using a messagebox in a private data session and it seems that my messagebox is delaying the form's controls to refresh. I am using refreshes and LockScreens and this doesn't help. Does anyone have any information about messageboxes that will help me solve my problem? I definatly...
  11. risslsu

    SQL SELECT vs. SEEK

    I am currently trying to obtain 2 records out of a table that consist of 1 million records. I want the person with the highest last name and the person with the lowest last name. Using BETWEEN or <> operators in my where statement seems to take longer than a SEEK comand. Which is more...
  12. risslsu

    Classes vs. Stored Procedures

    Thanks for everyone's help, but I figured it out. At first I put Class1 on the parent form and attempted to call a method in the class from two children. This didn't work because the parameters couldn't be redefined. Now, I am executing an AddObject to add the class to the parent. After...
  13. risslsu

    Classes vs. Stored Procedures

    Please Help. I have many routines that are used by multiple programs in my system. I am currently classifying these procedures and doing AddObjects to add them to form/formsets. I am getting an error saying that I cannot redefine the parameters in Method1 in _class1. This error occurs...
  14. risslsu

    Closing a cursor

    How do I close an SQL Server generated cursor? I am currently trying: CLOSE xCursorName REALLOCATE xCursorName Program Error when the follwing code is reached: IF USED('xCursorName') SELECT xCursorName USE ENDIF This error lead me to believe that the cursor is not released. Any help...
  15. risslsu

    SQL Pass Through

    How do I reference a remote table so that I can use a SELECT statement and put the results into a cursor? I have already established my connection with the server.(SQL Server) This is my code using a local table: SELECT TOP 1 * FROM table INTO CURSOR table_cur ; WHERE ALLTRIM(table.field1)...
  16. risslsu

    SQL Pass Through

    How do I reference a remote table so that I can use a SELECT statement and put the results into a cursor? I have already established my connection with the server.(SQL Server) This is my code using a local table: SELECT TOP 1 * FROM table INTO CURSOR table_cur ; WHERE ALLTRIM(table.field1) ==...
  17. risslsu

    SQLEXEC

    Help Please! What am I missing? Do I need to open the table or create a cursor before my SQLEXEC? Am I allowed to name the cursor the same as my remote table? SQLEXEC(chandle, 'SELECT TOP 1 * FROM testtable ; WHERE ALLTRIM(test1) == m.xyz','testable') Any help or extra information would be...
  18. risslsu

    Updating Remote Views

    I am trying to update a remote view. I am currently using UPDATE(), SET(). How can I use the TABLEUPDATE so I don't have to set the fields in the SET()? I am using a GATHER MEMVAR then a TABLEUPDATE, but it slects the first record in the view and changes it, not the record that is being...

Part and Inventory Search

Back
Top