Search results for query: *

Is there a sample, FAQ, or something that shows a simple form where the user choses a path & dbf file, and then it populates a data grid on the form for him. I can easily use the wizzard to create a grid & bind it to an existing table, but I want it to be dynamic for whatever dbf file is...

I have 2 files that are the result of a cursor from a select cnt of a state field. One is ran the 1st of the month, and the second is ran the 30th of the month. I want to generate a file from the 2 files and add 2 fields Difference, and Percent. FileA.dbf (1st of the month) State Qty AZ...

I need to create a report that shows a tables growth, that I can run once a month. I was thinking of running some counts on a few standard fields like state, city or zip, maybe phones etc. and show a previous qty, a new qty and a percentage. Does anyone have any helpful tips on the best way...

I am trying to replace a field called SEL with a flag ('Y') for up to the value in a matched field (IDcode). Everything seems to be working ok, but when the idcode changes I can not figure out where to clear my counter. Mental block here please help. here is the code: select Input go top...

I need to select all records in tableA where the name matches the name in tableB, but I want the match to be as loose as it can be so I can still match after MAJOR spelling errors. Can I adjust the matching degree? and is there a way to veiw both fields in the querry window? thanks in...

I have created a template called X.XLT & X.XLS and placed them in XLSTART. It works great, the new spreadsheet has all my formating that I want standard. My only problem is when I chose save as, it trys to save all new documents to XLSTART, unless I change the path back to my documents. How...

I use this code to run a frequency: select county,city,zip, cnt(*) as qty from testfile ; group by county,city,zip into cursor mike My problem is I get duplicate city names in my select file. like this: COUNTY CITY ZIP QTY ORANGE ANAHEIM...

This is what I have: select piecedesc,pieceid,county,litcode,litcode2,litcode3,phonecnt,nophonecnt,totalcnt, cnt(*) as qty from AgeinOutput ; group by piecedesc,pieceid,county,litcode,litcode2,litcode3,phonecnt,nophonecnt,totalcnt into cursor mike What I need is a report with all those...

This code will not work, it says unhandeled exception. Private Sub btnState_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnState.Click Me.OleDbSelectCommand1.CommandText = "SELECT Name, [Company Name], Address, City, State, Zip, Telephone, PubID FROM...

Help! I received a print ready dbase file with fields called line01, line02 etc. on some of these the data is indented a few charaters with spaces to line up some totals. mailmerge is stripping off the leading spaces, how do I change that? thanks in advance

I have seen in some programs at my new job code with REPLACE ALL on a FOR condition. I thought it was either ALL or conditional but not both ways, they seem to work both ways. We did have an issue where the program was not doing the conditional replace, say every 1000 times it was executed...

I get a critical error everytime I try to do anything in frontpage 2000. I have completely removed Office 2000, and reinstalled it, but with the same results. I can't find anything online explaining this problem, except on one forum, a person has the same problem, but nobody answered his post...

My sorting software will not allow numeric fields, so I have to convert all numeric fields to char. But when I print my output, I need to have 1000 seperator comas in the numbers. Id there a easy function to add the comas to a number?

I used to have some code that would split a field on the HEX value of a comma (2C), but I cant find it. I need to split a address field that has HEX 0D 0A in it. I thought it was X0D for Hex 0D, but I can not get it to work. Anyone know the correct format? thanks in advance, Mike actual...

what would make it so when I goto format cell, border and put a line on the right side, it shows the line in the dialog, but I dont see it on the screen, or in the print preview, and it does not print. I imported the doc from wk4 format into Excell 2000.

I have this set up with the option in word, and when i merge it, or toggle it on the screen, it still shows blank lines. how do I make it supress these blank lines?

i am having a problem, i have a numeric variable (99999999991) with 11 digits, and when i pass it to a charicter variable it comes out: 009.999E+10 this is the code: cCert2 = padl(alltrim(str(nCert)),11,'0') ncert value is 99999999991 ccert2 comes out 009.999E+10 how do i make cCert2...

is the best way to conditionally redirect my page based on the value of 2 radio buttons, to make the action on the submit goto a asp page and just pass the request.form(&quot;value&quot;) to a variable, and then make a if statement to redirect based on the if statement? radio: <input type=radio...

How do I cange my ole saveas to save as type MAC csv? this saves as excell oleApp = CREATEOBJECT(&quot;Excel.Application&quot;) oleApp.Visible=.T. oleApp.WorkBooks.Open(&quot;S:\State.Xls&quot;) oleApp.ActiveWorkbook.SaveAs((cpath)+&quot;state.XLS&quot;) oleApp.Quit thanks in advance, Mike

I have a document that is a mail-merged file in a label format (5163), and I need to convert it back into a database I can use... either into excell or dbase. I tried save as dos-text, but is is pretty unusable. any ideas / tricks? thanks -Mike