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 TouchToneTommy 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: *

  • Users: BRADLEY21
  • Content: Threads
  • Order by date
  1. BRADLEY21

    inconsistent state

    My database is at an inconsitent state, I am not sure if I should restart computer. I just created it from a backup. The database seems to be working fine but am unable to create a new backup. Have I missed a process after the backup in order to remove the current state from "Inconsistent"...
  2. BRADLEY21

    Backup to new install

    I have the backup image but cannot figure out how to restore the image to a new databas? I tried to create an empty one but failed. Can this be done, does the backup have the table structures? I am lost any help would be greatly appreciated.
  3. BRADLEY21

    EXCEL

    DOES ANYONE KNOW HOW TO OPEN AND EXISTING EXCEL SPREADSHEET FROM INSIDE FOXPRO. THANKS
  4. BRADLEY21

    program as a service

    I would like to run my invisible program as a service, does anyone know how I can do that. Muchas Gracias.
  5. BRADLEY21

    Automation

    From VFP 8.0 I have opened an excel spreadsheet insert data and formated the sheet, all which I have done effortlessly by copying the VBA macro code in VFP and tweaking it here and there. Now I want to save the spreadsheet with a name but can not do it I tried XLApp.WorkBooks.saveas() but I...
  6. BRADLEY21

    RemoveItem

    Why does this not work? This.RemoveItem(this.ItemIdToIndex) I know the above is wrong but I figure this will tell you what I am trying to do. I have this in the DBLClick method.
  7. BRADLEY21

    List object

    Here is an easy one that I can't figure out. I am using a listbox object and have the multiselect set to true. Now I want to use the multiple selection in a query. For example: Select * from mytable where mfield in ('a,b,c,d') Proble: how do I access the array or variable that contains the...
  8. BRADLEY21

    access stored procedure

    I tried to pass a variables to a stored procedure on MSSQL however it does not work. The code looks like this. Anyone have ideas? =SQLEXE(MyConnection,"myproc(var1,var2)")
  9. BRADLEY21

    COMBO BOX Easy question.

    I created an array that populates the items for a C0ombo box. However I would like the user to have a selected item to be selected when the screen intializes. I tried thisform.listitemid=3 Any ideas. Thanks
  10. BRADLEY21

    DynamicForecolor

    I have read every thread on this subject. This is quite frustrating. In my grid I have one column that has a dollar amount. I want it to be red if negative or black if >= o. I tried &quot;IIF(amount<0, RGB(255,0,0),RGB(0,0,0) )&quot; in the dynamicforecolor property but it does not work...
  11. BRADLEY21

    Update SQL in Foxpro

    This does not work in foxpro, for those who know what I am trying to do, your help would be appreciated. UPDATE table_1; SET field_1= (SELECT field_1; FROM table_2; WHERE table_2.key=table_1.key) Thanks
  12. BRADLEY21

    DELETED EVENT IN GRID

    I am using a grid that is reading a view set to optimistic buffering. I want to warn the user that the record will be deleted when the delete column of the grid is tagged. However I do not know how to programatically un-delete the marked grid. I tried recall but it does not work. The ideal...
  13. BRADLEY21

    embarassing Question

    I am killing myself trying to change the color of the command button in my form. I have read all of the FAQ and countless pages help documentation. I want to make my command button white. any help would be apreciated
  14. BRADLEY21

    UPDATE SQL

    I am trying to use the update command to update a field with data from another table. example: update mytable1 set field1 =(select field1 from table2 where mytable1.key1=mytable2.key1) Of course the above will not work, just trying to get accross what I am trying to do. Thanks
  15. BRADLEY21

    need help with update sql

    I am trying to update a field of table1 with a field from table2. something like this.. Update table2 set field1 with (field1 of table2) both tables have a common key to join Any help would be appreciated
  16. BRADLEY21

    app wizard _topform

    I am unable to change the back color of the the _topform from the subclass that is created with app wizard. It only uses my change when the screen is refreshed. Any help?

Part and Inventory Search

Back
Top