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 strongm 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: *

  1. paoconnell

    WRT54G Serving Up Bad IP Address

    Syquest Have you tried bypassing the router entirely? If the laptop connects correctly, there may be a conflict between your router and Safeboot (this is apparently a VPN and encryption utility) or the Active Directory settings added to your laptop (which I assume is a company machine). Ask...
  2. paoconnell

    Declare a large arary!

    What is the reason you're trying to create such a large array? There are other ways to work with large arrays other than in an array that would be too large for available memory. For instance, you could implement a sparse array (look at a data structures book) and put the array elements in a...
  3. paoconnell

    Why do you code in Fortran?

    Random number generators are all too often thrown into a compiler as an afterthought. There are a number of algorithms that work better (and are more random) than the ones that originally came with the compiler. Do a bit of research (start with Knuth's Seminumerical Algorithms, but there are...
  4. paoconnell

    compare two data list

    Some questions: Are x, y, and z arrays or scalars? Are xx, yy, and zz deeclared the same way as x, y, and z? Show the declarations also, as well as the compare code ArkM asked you for. Pat
  5. paoconnell

    Parallel Fortran

    With a multiprocessor machine, you should be writing the code in vector notation [like A(B:X,C:Y), for instance]wherever possible. This was certainly true of the Crays (I took a class years ago) and should also be true of more modern architectures. If your computer has a compiler designed to...
  6. paoconnell

    Sound stutters

    My PC is a 4 year old Toshiba laptop, with a Pentium 4 and a built in sound chip set. The chip set is soldered to the motherboard, and is not replaceable. The stuttering only started about three months ago, probably around the time iTunes was updated to support the iPhone. I assume the "Apple...
  7. paoconnell

    Sound stutters

    I have had a similar problem with stuttering video and audio on my Windows XP Home PC. It turned out to be a service installed by iTunes called "Apple Mobile Device." Disabling this service (which is needed only if you have an iPhone) made the stuttering go away. Note that my PC has a basic...
  8. paoconnell

    Data entered in a table behind a Subform doesn't display

    PHV: this is the right direction. In a VB module, this seems to work best: DoEvents Forms![folder form]![Child20].Form.Refresh 'Me![Child20].Form.Requery 'your suggestion,changed to: Forms![folder form]![Child20].Form.Requery DoEvents Pat O'Connell
  9. paoconnell

    Data entered in a table behind a Subform doesn't display

    Just played with Refresh again. 'Print Ops Logs is the form with the subform 'in question: '!!!Requery doesn't seem to work until the subform is 'clicked on: Forms("Print Ops Logs 2").Requery '!!!Refresh does work without clicking on the 'subform, but redraws...
  10. paoconnell

    Data entered in a table behind a Subform doesn't display

    There is no main form record in this case, just the temporary records saved in the table behind the subform. The table is used to create a number of reports for printing, then the subform table is cleared. Pat O'Connell
  11. paoconnell

    Data entered in a table behind a Subform doesn't display

    Strangely enough, no; I tried a requery and a refresh. The refresh code's still there, but doesn't help. I'm suspecting that some property of the subform or the underlying table is not right. Data goes right into the table, but doesn't appear in the subform until I click on the subform. Very...
  12. paoconnell

    Data entered in a table behind a Subform doesn't display

    I'm maintaining a Access 2003 application that has two forms. Each form uses a combo box (shipment prefix) and a text box (numeric identifier) which are then concatenated to create a shipment ID. An Add button puts the shipment ID into the table behind a subform on the same form. The table is...
  13. paoconnell

    Getting connected to a database from vb3

    There is a data control in VB3; look on your Toolbar. However... For most work, you'll need to connect to your database using ODBC and DAO. Furthermore, the 16 bit ODBC can't connect to newer databases, so you might need to migrate to VB 5 or 6. Pat O'Connell Visualize Whirled Peas
  14. paoconnell

    sweep.exe replacement?

    Well, that's a del feature I didn't know about--helpful! Recursing del is a part of the solution, but the rest of the functionality would help too. Anyone else? Pat O'Connell Visualize Whirled Peas
  15. paoconnell

    sweep.exe replacement?

    Wayyyy back in the mists of time (early 90s) DOS and Windows 3.x ran in 16 bit space. In those days, there was a program called sweep.exe that would start in the current directory and execute a DOS command (with arguments) on that directory and all of its subdirectory tree, e.g. sweep del *.bak...
  16. paoconnell

    combining columns from two tables

    This is how it's done in Access (roughly): SELECT [Cash_Receipts].ID, [Cash_Receipts].batch as CBatch, [Cash_Receipts].cash_amt as CCash, [Cash_Receipts].check_amt as CCheck,[accounts_receivable].Batch as ABatch,,[accounts_receivable].cash_amt as ACash, ,[accounts_receivable].check_amt as...
  17. paoconnell

    Exporting R5 address book to CSV?

    When you do an export, there are some hidden gotchas: 1. Export to a 1-2-3 file specifying the .wk4 extension, or Excel (which can create CSV files) won't import the data correctly. Also, long fields will be truncated to whatever 1-2-3 defines as the maximum cell text length. 2. The Structured...
  18. paoconnell

    VARCHAR2 field filtering

    Belated reply-- The reason I can't move the database to Oracle 9 (or 10) is that we don't have licenses for these versions. Also, the database is normally accessed from a construction management program called Maximo, and I would be changing the design at my peril. Finally, this project was a...
  19. paoconnell

    VARCHAR2 field filtering

    Mufasa, you've got a star for pointing me in the right direction, and your suggestion worked on the original field once I changed the newlines to blanks instead of nulls. However, the field I was searching was the wrong one. The right field is declared as a Long field (effectively a BLOB full of...
  20. paoconnell

    VARCHAR2 field filtering

    So far, so good. However, it seems like converting the CR and LF characters to nulls is the wrong thing to do when exporting as text; the Description is truncated at the first Null found. I think I'll try again by converting the CRLFs to spaces. Pat O'Connell Visualize Whirled Peas

Part and Inventory Search

Back
Top