Recent content by spysab

atlopes - im using csv format, but any format comes out the same result tho. APPEND FROM ? TYPE CSV i've tried APPEND FROM ? TYPE CSV APPEND FROM ? TYPE XL5 ** another problem here is this didnt upload all rows. i have 71,000 rows. only csv covers all Mike Gagnon - date setting, how...

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?

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

so meaning i cannot use an auto-increment field as memo series or invoice series for it will really skip. how can i put a sequence +1 every new entry to become a transaction reference? that if i cancel the attempt to create new, sequence will remain +1 to last entry.. to be specific, it is...

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

Mike! Thank you! Problems is fixed! Thank you Thank you

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

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

Hi Olaf Doschke, where should i place my code here? ON ERROR MESSSAGEBOX(Textmerge("<<ERROR()>> <<MESSAGE()>> <<LINENO()>>")) should this comes after or before my codes?

I just follow the code from youtube tutorial. He doesnt proceed upto building exe but i follow exacly what he puts. https://m.youtube.com/watch?v=4qi9WetSic4 But i try to remove HIDE WINDOW STANDARD and SHOW WINDOW STANDARD then my exe works perfectly :) Thanks pal.. i learned a lot.

Do you maybe have two menus named the same in different folders? FOUND IT!!!! my bad!!! though its not in different folder, i put that shortcut.mpr under PROGRAM and the other one is under MENUS Though not exactly, you give me the idea how to the error works and found it!! last i need to...

If it's not because it's running, then perhaps you made it readonly somehow (file attributes)? Or the MPX? - i will try to figure this out. If removing an MPR helps, then that's at least a temporary solution. Is the MPR existing again after the build? - i can't answer coz even though the...

Hi Olaf Doschke, Already did that several times (unless im doing it wrong). Even my computer has been restarted. Then have done the following freshly open foxpro in command window, set the path SET DEFAULT TO c:\tutorial\lesson5 SET PATH TO data;forms;reports;prgs;menus then open the...

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

Olaf Doschke! thanks again. a very simple solution to a very simple problem that seems hard for a beginner like me. Having this, i would be able to create multiple types of forms and data extract applying same principle. 2 thumbs up!