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!

Register Log in
  • 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. Akourou

    how to set what a combobox displays in the textbox area

    actually Criss solution worked fine and I omitted some columns as they are not needed BoundColumn = 2 ColumnCount = 2 ColumnWidths = "231,0" RowSourceType = 6 RowSource = "guest.lastname-(', '+guest.firstname), employeeid" BoundTo = .T. ColumnLines = .f. thank you all for the info
  2. Akourou

    how to set what a combobox displays in the textbox area

    hello, I have a combobox that is used to select a guest from a table of guests some of the properties of the combo: boundcolumn=.3 boundto=.t. rowsource = guest.last, first, g_no rowsourcetype = 6 fields the combo works fine my problem is that when i select from the dropdown list then in the...
  3. Akourou

    set all rightclick method of all textboxes in a form

    thank you Chris and Mike
  4. Akourou

    set all rightclick method of all textboxes in a form

    hello, Is there a method like setall to set all rightclick method of all textboxes of a form? for example i want to set all rightclick of all textboxes to copy the value to the clipboard thank you
  5. Akourou

    keep focus on a form

    I will agree with Chris that the modal mode is not very convenient. I would need to switch to modeless mode once the save button is clicked. I will describe a bit more my concern / problem. This is the way I work with forms for editing dbf data and correct me if it seems wrong or...
  6. Akourou

    keep focus on a form

    hello to all I want to always keep focus on a form when I am editing fields on it. Not to be able to click anywhere outside of the form unless I save my changes. is that possible? thank you
  7. Akourou

    select statement trims results

    thank you Chris very optimized approach
  8. Akourou

    select statement trims results

    thank you all for the solutions. it worked fine. I do the formatting during the select query because I present this info in a grid afterwards.
  9. Akourou

    select statement trims results

    hello i have the following select statement: SELECT bdate, platforma.descr, CDOW(checkin)+" "+DMY(checkin), ALLTRIM(STRTRAN(strtran(booking.notes,CHR(13)," "),CHR(10)," ")), guest FROM booking ....... I noticed that when the field contains an expression like...
  10. Akourou

    best way to do stats from a select statement

    thank you Tamar, your article about crosstab is very informative and solves many of my issues. The only problem is that the link for Alexander Golovlev fastxTab is no longer available. Do you know if there is another link to that download? thank you Andreas
  11. Akourou

    best way to do stats from a select statement

    thank you Tamar, this select statement is very clear. is it possible to include more analysis in the same statement? for example the above statement calculates total nights per house. can i have more sum() in the same statement to analyze these total nights according to platform type? for...
  12. Akourou

    best way to do stats from a select statement

    hello to all! I hope you're getting on ok in the current crazy situation. my question: i have a select statement that collects data from several tables into a cursor. SELECT bdate, platforma.descr, house.h_name, guest.descr, CDOW(checkin)+" "+DMY(checkin), nights...
  13. Akourou

    SELECT command and table record position

    Mike, thank you. that was it! i had forgotten tables in the data environment of the form. I deleted these entries and now it works as it should. thank you Mike and Olaf
  14. Akourou

    SELECT command and table record position

    what i want to achieve is the record pointer in booking table not to move each time i open the guest form. Mike, i do not know what you mean by private data sessions but i do not open any tables from my forms. I have a procedure that run at the start of my application that opens all tables, and...
  15. Akourou

    SELECT command and table record position

    It is true, the grid has nothing to do with it. I deleted the grid and still i have the following behavior: I have guestform that uses guest table to manipulate guest info. I have bookform that uses booking table to manipulate bookings of guests. Bookform has a combobox bound to the guest...
  16. Akourou

    grid and readonly columns

    thank you. good hints
  17. Akourou

    SELECT command and table record position

    is it possible that it has do with combobox in the form, bounded with a table? does a combobox bounded to a table move the table pointer?
  18. Akourou

    grid and readonly columns

    hello i have a grid that is populated from tables. At start i have the readonly property to true and allowcelselection to false and i have a checkbox on the form to check it and make the grid editable. (readonly = f and allowcellselection .t.) but this makes all columns editable even if i have...
  19. Akourou

    SELECT command and table record position

    Thank you Mike and Olaf. Very informative. But i have to search more because my "tableA" goes to top after the sql query. And worse, it does not do that in all cases. sometimes it stays at the current record.
  20. Akourou

    SELECT command and table record position

    haha, yes because i try to understand why it goes to Top on table-A even when i store recno() in a variable and issue goto varW at the end of the select statement sometimes it goes TOP

Part and Inventory Search

Back
Top