Search results for query: *

I have searched for tips on how to format a Social Security Number or a phone number using xls when the xml is such as this: <ssno>123456789</ssno> <phone>1234567890</phone> The SSno should appear on a web page as 123-45-6789 and the phone number should be, of course, (123) 456-7890 I can't find...

In FPW26a, I am writing a program using SET ALTERNATE and ?/?? to write transactions to a text output file to send to a vendor (darn mainframe-y vendors). In the middle of one of these output lines, I had occasion to do a calculation with SUM hours TO mhrsworked ... Then later on I did a ...

I have to change some of our company's scripts to bring in a login password from an external text file, because the host system does a periodic password change and the user community does not have write access to the folder where our production scripts are kept. After much RTFM'ing and using an...

I want to create and maintain a log file for the user that shows the most recent entry on top. I am adding a date and time stamp to the log file entry. This is a pure text file. I _WANT_ CR/LF's. I find that for whatever reason, adding TEXT to fopen does not add CR/LF with fputs. I tried...

We send a file to our bank by modem using PCPlus, and at the end of my script I move the file to an archive folder and add the date and time to the filename. Whenever the file transfer fails, the archive portion of the script still runs and it takes a bit of doing to put the file back to where...

I am struggling a bit with a line of code I have to modify in a program that generates Cobra letters from an HR system that I support. I have a series of logical fields in my work database that say which benefit they have for which a letter should be printed. One of them is just plain...

We have a commercial payroll application written in FPW26a. I support it, and we have been running it for a decade. Only recently have I encountered problems with a couple .Dbf's where as soon as the command to USE the file ORDER 1 is invoked, BAM! they get an error Record out of range. I have...

We have FPW26 and run a number of programs against our payroll system. We keep an audit text file of what gets run by our user community. Each program passes parameters to this function, which writes to the audit text file: FUNCTION LogWrit PARAMETER lcText, lcLog IF PCOUNT() < 2 .OR. lcLog =...

Our shop still uses FoxPro for Windows 2.6a. The screen display for such things as DISPLAY STRUCTURE and DIR is tight and appears one print line on one screen line. When I use Visual Fox 6, DISPLAY STRUCTURE and DIR will wrap on the screen. The columns are spread out for no apparent reason...

This is not a fair problem to pose to this group, but perhaps someone has run into this already... One of our power users has VBA in Access developed on his NT machine (Access 2000 v. 9.0.4402 SR-1) that was distributed to other users throughout our office and has run fine for quite a few...

My company connects to a bank to send a file every day, and they changed the service we dial into. I am supposed to WAITFOR &quot;Host Name: &quot;. However, after my script connects, the host sends Host Name in garbage characters. Their tech people said to key in a + and Enter. Then it...

Simple VB6 app, made a small change, works on all developers' PCs, works on the Users' Win2K PCs, except for the user Department Head. (yikes!) When we click on the File Open button in the app, we get: &quot;The common dialog function failed during initialization (Error 32765) This error occurs...

We write programs (Fox 2.6a) that go against a production multi-user system, and we have good success using &quot;USE filename SHARED&quot; so that everyone doesn't have to exit the application when the programs run, and continue to have these .Dbf's open. However, whenever we write something...

Our production payroll system is written in FoxPro for Windows 2.6a. The paycheck is a report form. I have to add a &quot;California disclaimer&quot; to it, saying what bank it is payable at, depending on values in the supporting .dbf. Since I have to be able to say 2 different messages eg...

I have to APPEND FROM a text file delimited with semicolons. When I say APPEND FROM ... DELIMITED WITH ; or DELIMITED WITH &quot;;&quot; or DELIMITED WITH SEMICOLON or DELIMITED WITH CHR(59) I just get Unrecognized phrase/keyword in command. What is the syntax for a non-standard delimiter...

Here at our IS shop, I commented that I got a notebook for my son for college and that it comes with XP Home. This machine will be going out to USC shortly and connect with USC's ResNet network available in all dorm rooms. So my boss says that another programmer here had the same situation with...

Sorry for these elementary questions, I frequent other Tek-Tips programming forums and found this one on XP and hope some small problems can be answered. Kid is going to college. Mom sez go get him a notebook computer. We come home with a top of the line Sony with XP Home preinstalled. I do...

I have a user who puts out budget reports in Access, and wants a way to highlight an item in bold or italics or something to call attention to an exception, that being an amount or percent that has exceeded some limit. Is there a way to have conditional formatting in the report form design...

I need to change my VB6 program to run in the wee hours of the morning on an unattended machine, probably through task scheduler. I want to know how to re-arrange my VB code. We are taught to create a form, put on a command button and write code behind that to do stuff, then put on another...

On more than one PC here at work, the IntelliMouse wheel will not scroll the code editor window in VB6. It works in the properties window...Is this a bug? I can find no setting for this anywhere.