Recent content by jspellman

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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