Search results for query: *

Hey Glenn . . . that worked like a charm. Thanks Much! Rick

Does anyone know of a way to make the plot area of an Excel Chart transparant? ie., "No fill." There is no option for a "no fill,", just a "None" when selecting the plot area. I really need this as I paste the chart onto another page that has a special business backgroung that I would like to...

Hi Bob. I often download and works with tables that have over 306,000 records with over 241 fields, and this is not an indexed table! Queries and such run slower. I could index this table but I just haven't found a need to do that yet. I think the table limit has much to do with your computer...

I'm not very good aat fixing things here but when I get that BDE error it is usually because I already have Paradox running. Rick

I keep getting this error when I try and print from Paradox 8. Simple Report landscape mod letter sized Sum Acg Count calculations on each page. Never had this problem before. WIN XP-PRO SP2 One Gig RAM Two 200 Gig Drives ERROR . . . AppName: pdxwin32.exe AppVer: 8.0.174.0 ModName...

I have a text file that I download and inport into Paradox 8. No problem here. When the text file is finished downloading another portion of the code downloads pictures for each record in the in the downloaded text that I imported. Each picture has an unique number but they are stored in...

Windows XP Professional Dual core procesor 1 Gig Ram 2 200 Gig Drives; C:\ and D:\ Nero 7 Ultra Edition Can I burn an "image" of Drive C:\ and use it for a complete startup AND restore of the drive (including the operating system) from a DVD if there is a problem? Would it be a better to burn...

Hi Tony . . . As always, you're right there when I need you. Kewl! Your first answer fixed the problem and now it's working great. Taks care Tony. We would all be lost without you. Rick

Okay . . . here I go again. I didn't have a method pushButton(var eventInfo Event) I fixed that but now I get this error: "expecting a column seperator in table header." Ideas . . ? Rick

Rats! Can't figure why this fails? The query doesn't run. The pop up data entry window (Xdate) doesn't open. Knowing me its got to be something stupid! Any ideas . . . ? Thanks much . . . Rick method action(var eventInfo ActionEvent) var;----------------Declare Variables-------------...

Okay . . . I found the problem. I had one too many | in the the query fields after _ID. Learn from my mistake! Rick

Hi All . . . When I run this query I get the following error: Expecting consistent number of columns in all rows of table; :Scmls:Scmls.db Everything looks good to me. Any ideas? Thanks much . . . Rick qbe=Query :Scmls:OfficeRosterUpdate.bd | UID | OFFICENAME |...

Okay Tony . . . This is what happened. The settings for the delimiters somehow changed. The moral of the story; ALWAYS check the import setting before clicking "start." Thanks Much. Rick

Hi Tony . . . "What is the name of the text file?" OCDownloadRES.txt This is a comma delimited ASCII file. "Do any/all have a .txt extension?" Not sure what you mean. "Are there any .job files in the directory?" No. Just the text file. I now getting an error that says "file is in use."...

Don't know what has happened but ever time I try and import an ASCII comma delimited text file nothing happens and Paradox 8 freezes up. I've tried smaller, and different text files. Same problem. I've reinstalled Paradox 8. Problem still exist. Access 2003 imports same text files fine. Any...

Ginger . . . Those are two items that I do understand. I've been programming in Paradox's Opal for a long time. Sort of a self taught method but I started with Paradox Version 2.5 in the old DOS days. But I never had any formal training so now I'm trying to understand application design and...

Andy . . . I like that idea. I do understand table relationships but I'm not sure how to proceed with the rest of the program. Just so you know, I run three queries for each office name and dump the results in a linked table on the last page of a report. In using the customer ID, how would...

Hi PHV . . . FROM OCMonthlyData INNER JOIN tblA ON OFFICELIST_OFFICENAME = tblA.field1 Does this establish a link to tblA . . ? If so, how does it go through each office listed in tblA, or does it do that automatically until it reaches the end of the table/field? WHERE...

Okay . . . I said I couldn’t explain this well . . . I have 20 clients. Each client has a set of offices that they want me to rate each month. So for each client, I create a small table that stores the office names that they want rated. If they want to add or delete offices all I need do is...

Jerry - Okay I was able to drag and drop the query onto the form. This does work. But each time I run the form the query runs and shows the results. What I'm really looking for is to run the code I have shown in my original post above and THEN show tthe resaults in a datasheet on top of the...