Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Rickinrsm
  • Content: Threads
  • Order by date
  1. Rickinrsm

    No Fill Plot Area

    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...
  2. Rickinrsm

    Printing Error PDOX 8

    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...
  3. Rickinrsm

    Link db and photos

    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...
  4. Rickinrsm

    Image Options . . ?

    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...
  5. Rickinrsm

    Failed Query Again!

    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-------------...
  6. Rickinrsm

    Query Failure Columns in all Rows

    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 |...
  7. Rickinrsm

    Import text file Crashes PDOX Ver.8

    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...
  8. Rickinrsm

    Pass Variable from Table to SQL

    Okay - I'm not very good at explaining my problems but I'll do the best I can. I have 20 small tables with one field containing approximately twenty office names. I need Access VBA code to decalre a variable, then something like, for i from 1 to endOfTable, look at tblName, assign the first...
  9. Rickinrsm

    View Queried Data After Query Finished

    I'm trying to figure out a way to automatically view the datasheet results of this query on top of, or within a single page form when the query is finished. It must be a simple thing, right? Option Compare Database Option Explicit Private Sub Command14_Click() End Sub Private Sub...
  10. Rickinrsm

    Global Tool Bar in Paradox 8 ? ? ?

    In Paradox 7 there was a Global tool bar setting that kept the icons for open Table, Form, Query, Reports, Script etc. visible even after you had one of these open already. Is there such a nice feature in Paradox 8, or a way to make it happen with a custom tool bar? Thanks much. Rick
  11. Rickinrsm

    Select Query Fails on Date

    I have a simple select query that runs perfectly when I place a date range like this in the criteria row of closeddate field; 11/??/2005. This returns all of the records for November 2005. It's great! When I place a bracketed message in the criteria field ie. [Enter Date Range] and then place...
  12. Rickinrsm

    UpdateQuery UcaSE fAILS?

    "SET [OFFICELIST_CITY]"="UCASE" This returns a 0 in he entire column in my UpDate To: row of an UpDate Query. Any idease would be greatly appreciated. Thanks Much . . . Rick ~ Access Newbie
  13. Rickinrsm

    Query Procedural Problem in Access 2003

    I download thousands of records once a month to run through calculation procedures. I need to work on a subset of these records so, if I’m correct, a select query won’t work because that produces a dynaset, not an actual table. The subset table records must adhere to field properties that I...
  14. Rickinrsm

    Make Table won't save error?

    I run a simply select (Make Table) query. the table is created. When I go to save the query I get the 3011 error. "The Microsoft Jet database engine could not find the object <TableName>. Make sure the object exists and that you spell its name and the path name correctly. (Error 3011)" The...
  15. Rickinrsm

    BOLD specific field value fails?

    For some reason for which I can't figure out, this report field code fails to set properties to bold. It works in other reports. All of the paths, etc. are correct. What am I missing here? I can't figure it out. IIF(search([:WORK:DESERT.SellName],"RE/MAX REAL EST CONSULTANTS")=1...
  16. Rickinrsm

    Acces 2003 Imprt Date Field Fails

    I have a large delimited table that I import into Acces 2003. The date format is mm/dd/yyyy:00:00:00 or something like that. If I set the Date field properties in the import to "text" it comes in fine with all of the characters as shown above. (I really don't need the time thing.) If I set...
  17. Rickinrsm

    Format DVD XP Pro

    For the life of me I cannot find a way to format a RW DVD in the Disk Drive. (E:\) Nero doesn't want to format withour picking a catagory or tast which doesn't suite my particular need. I need a formted DVD for SyncBack backup program. Any ideas . . . Rick
  18. Rickinrsm

    Access 2003 Freezes upon Launch ?

    New computer; Windows XP Pro Dual Core 64 bit Processor (Intel) New Office 2003 Professional. All programs in 2003 Professional work fine except Access freezes upon opening and I have to Ctrl-Alt-Del to close it. I can't find any way to correct this problem. Any idea? thanks . . . Rick ~...
  19. Rickinrsm

    Access 2003 Freezes on startUp!

    New dual core 64 bit processor computer. Windows XP professional (with SP2 I believe it is). NEW 2003 MS Office Professional. All works fine except Access 2003. Each time I launch Access 2003, no forms, tables or anything else, Access freezes. I must execute a Ctrl Alt Del. Once I do this it...
  20. Rickinrsm

    &quot;Save&quot; &quot;Cancel&quot; &quot;Okay&quot; etc., Buttons Invisible

    Interesting! New computer running WinXPP(2). I'm running Paradox7 and Access 97 and all of the buttons show just the outline of the button but NO button labels. If I click on the supposed button it does not function. Any ideas? Thanks Much . . . Rick ~ Access Newbie

Part and Inventory Search

Back
Top