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 Rhinorhino 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: spysab
  • Content: Threads
  • Order by date
  1. spysab

    IMPORTING FROM EXCEL - DATE FORMAT

    Hi guyz! What do i missed? i import data to table from excel but date column appears "/ /" in mytable. how do i fix this? should i format the excel date column as text first?
  2. spysab

    MULTI CRITERIA FILTERING

    Hi Guyz! I have this code as my filter LPARAMETERS tcFieldName, tcSearchText tcSearchText = ALLTRIM(UPPER(tcSearchText)) && use macro expansion to implement search filter SET FILTER TO "&tcSearchText" $ UPPER(&tcFieldName) GO TOP thisform.Refresh() and have this in my textbox search...
  3. spysab

    INTEGER (AUTO INC) - SERIES SKIP

    Hi! i have a field which is integer(auto inc). so upon making new entry, new index will be assign. but why when i cancel my attempt to create new entry, table is being revert but the index series skip its sequence? how can i maintain its sequence when i cancel my attempt to create new entry...
  4. spysab

    CODE ERROR - TROUBLE SHOOT

    Hi guyz! What is the possible reason why this code is having an error in 1 FORM but perfectly working in another? this code is the one which is working perfectly. (deleting entries) #define CMSG "Are you sure you want to delete customer ("+ALLTRIM(customers.company)+")?" #define MB_YESNO 4...
  5. spysab

    COLUMN 1 TABLE VALUE IS A MERGE OF COLUMN 2 AND 3

    Hi! How can i combine table column "name and surname" into one column "full name" stafflist.dbf column 1 = name column 2 = surname column 3 = the value of column 1 and 2 combine to become a full name Thanks
  6. spysab

    ERROR BUILDING .EXE

    Hi! Im encountering error building .exe. "cust_shortcut.mpr is already used by another program in the project" how do i fix this? "HELP" says select another filename. Thanks!https://files.engineering.com/getfile.aspx?folder=6a6e06ba-3321-408b-8c05-bc51f4377b8a&file=Capture.JPG
  7. spysab

    FIND WITHIN TEXT STRING "LIKE"

    Hi Guyz! Need some help to maximize search filter of my program. Im new in foxpro. Just reading codes and hows it working. i have the following employee.dbf form1 grid1 cboField txtsearchText in form1, grid1 combo textbox are there. combo is for the fields of form1 (example: name, company...
  8. spysab

    UNIQUENESS OF INDEX ID IS VIOLATED

    guyz please help!. I followed a tutorial in youtube. i followed everything. works perfectly aside from table ID index. In all my tables, if i set its index as ascending (column "ID ") and INDEXES type is CANDIDATE as per youtube tutorial, this is the error whenever im adding new entry...
  9. spysab

    USING TEXT VALUE IN FOXPRO

    Hi Guyz! Im new in foxpro and just relying on modification of whatever codes i see working. Can you teach me how use textbox value for this code : SELECT brand,type1,description,group from itemlist WHERE description LIKE '%XXL%' AND TYPE1 = "Modular" i want '%XXL%' and "Modular" to came from...
  10. spysab

    USING TEXT VALUE IN FOXPRO

    Hi Guyz! Im new in foxpro and just relying on modification of whatever codes i see working. Can you teach me how use textbox value for this code : SELECT brand,type1,description,group from itemlist WHERE description LIKE '%XXL%' AND TYPE1 = "Modular" i want '%XXL%' and "Modular" to be a value...

Part and Inventory Search

Back
Top