Search results for query: *

For what it's worth this late... We had the same issue opening ANY excel file from the web. The only way we could find around it was to change the individual client's Folder options. Oopen Windows Explorer Tools -> Folder options -> File Types Find the XLS extension. Click the 'advanced'...

Thanks for the reply. Yes, it is most likely a driver causing the problem. I need to figure out which one. Off to Kernel debugging mode I go. Yes, It does boot into safe mode without the BSOD. No, I don't use NOD32. I'll keep you posted. Steve

I've been researching this but so far no luck. Here is the breakdown: 3 HDDs 1- 32 GB Sata XP primary drive 2- 250GB Sata Storage drive 3- 250GB IDE Vista primary drive Originally has XP Pro on it which works fine. Vista installed to the 3rd drive just fine. The problem I'm having is that...

I noticed a glaring error as soon as I posted. the string line should be more like: strMonth+"_amt" = wmsTC.stMonth

I'm stumped with the syntax for the following scenario: I'm trying to get i to step through the months and to plug amounts into Jan_amt, Feb_amt as string(i)_amt depending on what month it is on. var Jan_amt,Feb_amt,Mar_amt,Apr_amt,May_amt,Jun_amt...

I've been struggling with this one the past few days. Mostly, trying to find the best way to do it. I'll try to explain: I have a table that can have multiple entries of the same member ID #. When multiple entries occur, there is a different FROM and TO date for every entry. There could also...

A thing of beauty. Thanks once again Tony.

I have a field where the first name and last name are in this format: Smith, Adam The following code correctly breaks down the name into seperate first and last name fields in my new table, but I encounter a substr error when the process comes across data in the field that is missing the First...

Okay, I think I understand. The SCAN has it's own built in While loop.

Thanks Tony. I did try it with a query and 'calc count all' but I was missing the 'as numberFound' syntax. That did the trick! -Steve

I am working with a table that may have duplicate CONSTITID numbers in it. For the field 'CONSTITID' I need to start by counting how many times the ID occurs and write the count to a table. Right now I am ending up with a count of one everytime, even though I can see duplicate numbers because...

The title bar is reading: Restructure Paradox 5.0 for windows table. Funny you should mention table level. I am just now getting an error that reads "Table level has changed".

Paradox 8. Alias Manager will not allow me to change the PRIV directory. I'm not sure what you mean by the table level.

No, neither.

I could plainly see because of the error thrown when the WORK directory is pointing to a sub-directory within my :PRIV:. "Table does not exist File: C:\Corel\Paradox\Priv\Recruitment\...DDSUpdate_ON54_Dec122003_Jul052005.DB The table name is correct but the path is my working DIR. The...

IT's creeping in somewhere, maybe here at the beginning: Tbl.attach(sourcefile) or at the end: Tbl.attach(sourcefile) dynNewStru["FIELDSTRUCT"] = ":PRIV:field_struct.db" Although the variable sourcefile example is exactly: :SOURCE:DDSUpdate_QC61_Dec122003_Jul052005.DB Possible...

Hi Tony, Thanks for the troubleshooting tips. It did now display an error and I can plainly see that it is reverting to using :WORK: in the file path, even though I don't ever specify it. I changed the working directory and that should be an easy fix. -Steve

I am trying to change the structure of a table with Objectpal. Tony helped me greatly in this post: http://www.tek-tips.com/viewthread.cfm?qid=1002986&page=9 but I can't figure out why the :PRIV:Field_struc is the perfect structure but it is not using that example to restructure the actual...

Hi Tony, Yes, when they do occur, they are at the very end of the string. rTrim did the trick, Thanks! I didn't know about that function before. Cheers! -Steve

I am trying to search a string for an errant space at the end of a name, and then replace the record with the name minus the space at the end. This will help in some record comparisons later down the line. I'm pretty sure that I am missing only something small, Thanks in advance...