Search results for query: *

Using a VFP6 compiled app with Adobe Distiller 5 as a printer. Using the REPORT FORM TO PRINTER command, a PDF is supposed to be created with the name of the FRX file that was run. Usually this works, but sometimes it sends the output to a "Visual FoxPro.pdf" instead. Any ideas? TIA, mmund

Have a form in a VFP9 app that I inherited from a previous programmer. Cannot open the form in the project. Further examination reveals the SCX file is blank, but the SCT is not. Anyone have any suggestions? TIA, MMund

Years ago, before I started working for my current employer, an Excel VBA app was written that writes a text file to the user's C:\ . When I hired on, this was one of many apps for which I assumed responsibility. The program has worked with little in the way of work from me for years, until...

I support over 100 VFP apps currently running on Windows XP. Most of these are VFP 6, a few VFP 3, and a few VFP 9, all of which were written by programmers who left before I was hired. We are getting ready to make the jump to Windows 7. My question: Generally speaking, will these apps run...

Have an app compiled in VFP6 that had been working, yet even though no changes have been made to it, is now throwing the following error: Class definition TEST.MYCLASS is not found Have tried recompiling it to a different name and have even tried recompiling to a different name using VFP9, to...

Having a problem getting data from a DB2 database to a cursor using VFP6. Here's my code: c_query = " SELECT Associate.ASSOC_NUM, Associate.STORE, Associate.DEPT,Associate.Norm_hours, "+; " Associate.LAST_NAME, Associate.FIRST_NAME, Associate.MIDDLE_INIT, "+; " Associate.HIRE_DATE...

I'm using some VBA with Excel 2003. My VBA contains the following code: Private Sub txtAssocID_Change() If strCategoryChoice = "SUPPORT" And Len(Trim(Me.txtAssocID.Text)) = 6 Then With frmAccountability .Label2.TextAlign = fmTextAlignCenter .Label2.Caption =...

I have an Excel 2003 workbook with five worksheets and VBA macros running in the background. What I'm wanting to do is copy one of the worksheets to a new Excel workbook, while leaving the macros off the new workbook. I've figured out how to keep the other four worksheets from copying over, I...

I'm using VFP 9 to call a SQL Server 2005 SP. I'm setting up an optiongroup with 4 radio buttons, containing the quarter ending dates for a year. I'm sending the results of the selection to a variable as follows: local QtrEndDate as DateTime DO CASE CASE THISFORM.optiongroup1.VALUE =...

Is there a way to get Crystal Reports XI reports to print to the user's default printer? We have several reports that continue to print on out printers in IT when they should be printing in other departments. Other reports print correctly. If you set another printer as the default printer...

Have VFP9, and my command window will not appear, even if I Ctrl-F2. The option is present on the drop-down window, and is not grayed out. It just doesn't respond. Ideas, anyone? TIA, MMund

Have several Crystal Reports printing off a Visual FoxPro form. All of them will print except one. The report is getting built, and I can print it from a PDF or directly from Crystal. Nothing happens from Fox. I then told Fox to preview the report instead of printing, and got a "Logon...

I need a way to summarize employee records into one totalled record by SSNo where any given employee may have more than one employee number. This is because they may have quit and been rehired during the year. Each employee number record has numeric field1 field2 field 3 field 4 and we have to...

I am attempting to export several SQL Server tables to txt or CSV files using VFP's COPY TO command. Most of them work, but there are a few that instead of writing the data present in the table, it writes a blank line for each record. I'm using SQLEXEC to put the SQL data into a cursor, and...

Is there a way to auto-refresh report data when the report is executed from an external program? Several times now, I've had reports come out with outdated data, but if I go into Crystal and hit F5, all is well - for a while. TIA, MMund P.S. Hope this was the right forum

I need to populate a numeric field hours with data from a varchar string s. To do this, I use the following code, which is contained within an INSERT statement: hours = convert(numeric(7,2),replicate('0',7 - len(ltrim(substring(s,14,7))))+ltrim(substring(s,14,7))) This works UNLESS the...

We have several instances in our project where we have to read into our SQL Server 2005 database from outside files using TSQL. To make a long story short, this works: create table ##Thrgl02(s varchar(8000)) set @as_bcp = 'bcp ##Thrgl02 in (path and file name) -T -c -S ' +...

Is there a way for TSQL to determine if a .TXT file exists? TIA, MMund

Does anyone know of a non-kludgy way in TSQL to left-pad zeros onto a numeric field to export into an SDF file? For example, 45000 would show in the SDF file as 00045000 and 1500 would show as 00001500. I am making the switch from FoxPro 2.6 to TSQL. In FoxPro, I had the PADL function that...

Trying to run the following query: select @ytd2 = sum(a.cur) from py_ehearn a join py_ehmast b on b.ehmast_id = a.ehmast_id join py_earn_rule_id c on c.earn_rule_id = a.earn_rule_id where c.cf_disearn = 1 and (b.paydate between @hiredate and dateadd(year,@hiredate,1)) and b.ee_id = @ee_id...