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!

Recent content by jspellman

  1. jspellman

    how do you get a scrollbar on a table

    theogary, try using the <cfgrid> function. <cfform action=&quot;&quot; method=&quot;POST&quot; enablecab=&quot;Yes&quot; name=&quot;name1&quot;> <cfgrid name=&quot;grid1&quot; align=&quot;MIDDLE&quot; query=&quot;jsales&quot; insert=&quot;No&quot; delete=&quot;No&quot; sort=&quot;Yes&quot...
  2. jspellman

    Simple Bar Chart.....Please Help....

    Mobsterz, Take a look at this. I think your difficulty might be in the <cfchartserie>. <cfquery name=&quot;myquery&quot; datasource=&quot;dsn&quot; dbtype=&quot;ODBC&quot;> Select max(inv_no)as minv_no, max(cust)as mcust, max(style)as mstyle, SUM(units)as munits, SUM(amount)as mamount...
  3. jspellman

    Copy To xxx.xls XL5 truncating to 16384 rows

    Rob, Try this procedure. ********************** *procedure reccount ************************ procedure reccount use (filename) go bott store recno() to m.reccount if m.reccount >= 16,382 copy to file (filename).csv &&EXCEL WILL ONLY OPEN 65536 RECORDS else copy file to (filename).xls type...
  4. jspellman

    Report Snapshot?

    mcoupal, one suggestion would be the following. use [filename] order [indexname] copy to [backup filename].[backup extention] for [fieldname] = [filter information] then create the report with a file you can zap and replace the information in the file with the following. use [filename] order...
  5. jspellman

    How to copy data to XLS for more than 65536 records...(with formats)??

    You could set up a use dsn on the machine and link excel to it that way. I currently use this option for a 300k record file from dbase to excel. Then I analyze it in a pivot table. >data>pivot table> external data source. John
  6. jspellman

    How to copy data to XLS for more than 65536 records...(with formats)??

    agit72, ********************** *procedure reccount ************************ procedure reccount use (filename) go bott store recno() to m.reccount if m.reccount >= 16,382 copy to file (filename).csv &&EXCEL WILL ONLY OPEN 65536 RECORDS else copy file to (filename).xls type xl5 endif end proc
  7. jspellman

    Export data to Excel .txt or .frx

    Shangrilla, The one issue I had with export to excel was the record limit of 16383 records. I overcame this by exporting to file type CSV using the following in my program. store [filename] to mfile use &mfile excl go bott store recno() to mnum if mnum < 16383 copy to &mfile type xl5 else...
  8. jspellman

    Need web-based scheduling/reservation solution

    Try this link. http://www.webtricks.com/downloads/index.cfm then click on the link for shop in the right upper corner.
  9. jspellman

    VFP 8.0 Beta Public Release

    To all, The link is active. http://www.microsoft.com/downloads/release.asp?ReleaseID=44987 273mb download 30 min over dsl
  10. jspellman

    relationship for listbox

    great thanks for the help. Knew I was forgetting something.
  11. jspellman

    relationship for listbox

    Mike, I have used a grid. It works like I want. However, it can still be edited. is there a way to not allow this. is it as simple as deactivating the object? Thanks
  12. jspellman

    relationship for listbox

    I am kind of new to relationships. In the data environment of the form there is a relationship. However it still shows all records. Thanks, John
  13. jspellman

    relationship for listbox

    I have a form. It has po top information. I created a list box. of the detailed information. However, the information in the list box displays all the records in the po line information. I want to set a relationship to allow for only the information with the same po number to be reflected in the...
  14. jspellman

    Passing values from form to report.

    I will try this. It giggle my memory. Seems I did something like this before. Thanks for the help.
  15. jspellman

    Passing values from form to report.

    What I am looking for is a way to open a form and select the location say (Dallas, TX). When I close the form I would like a report to run called (sales by location). When the report runs I only want to see the location (Dallas, TX). For some reason I can not get the variable to pass to the...
See more

Part and Inventory Search

Back
Top