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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kq

  1. kq

    Test for existence of file, try again every nn minutes if not found

    oooh -- sounds like I could do some damage! Thanks! I'll give it a whirl! appreciate your assistance ...
  2. kq

    Test for existence of file, try again every nn minutes if not found

    Thanks, CMP & everyone! That would've taken me quite a while to figure out! Is there any way to avoid using the timer event on the form? Can do, but would love to avoid for some reason....
  3. kq

    Test for existence of file, try again every nn minutes if not found

    I'm working in Access -- haven't even begun the code because I didn't know where to begin!
  4. kq

    Test for existence of file, try again every nn minutes if not found

    MS Access Database A produces a file every morning which, when finished, exports a text file to f:\mydirectory. Database B (mine) imports the file. OCCASIONALLY the file is not in f:\mydirectory at the expected time. I'd like to automatically check for the existence of the txt file using the...
  5. kq

    Using a Case Statement in the Where Clause

    Thanks! Took your suggestions about simplifying the code, and everything works like a dream!
  6. kq

    Using a Case Statement in the Where Clause

    Hi - I have a query that runs automatically on weekdays to pull in the previous day's activities -- which I get by sysdate-1. On Monday's, I'd like to change that to sysdate-3 to get the previous Friday's data. Here's my original criteria. AND ( TO_CHAR(EVNT_CORP_RECVD_DT, 'YYYY-MM-DD')...
  7. kq

    Find/Replace to insert a manual return in a memo field

    Thank you both for responding ... AceMan1's solution did the trick (with the added bonus of all the code written).
  8. kq

    Find/Replace to insert a manual return in a memo field

    I have a memo field that contains the character " / " to separate the text into categories. Specifically, it's book readings where each day has page readings from different sections of the book. My original intent was to create the readings and import them to Outlook which would then show up...
  9. kq

    Mask details of private appointments possible?

    The CEO of our company would like to synchronize his PDA with MS Outlook (the company standard); however, due to the nature of some of his appointments, he'd like to mask any details of "private" appointments and just show the time as busy for people who have access to his calendar. Secondly...
  10. kq

    Migrating from Lotus Notes to Outlook

    Thanks -- but as a lowly "user" I'm prohibited from downloading anything onto my company's PC. Yikes.. Thanks for your reply!
  11. kq

    Migrating from Lotus Notes to Outlook

    Our company is making the switch from LN to Outlook. Our instructions for synching up our PDAs is to ERASE THE CONTENTS so we can re-load the synch software. HELPPPPPP! There must be some way to preserve the data??
  12. kq

    Export recordset - create new tab on break

    I have an Access recordset that contains data (too many rows for Excel to handle in one month). I'd like to export the data and create a new tab for each month. Any way to do this on the fly? (Programatically speaking, that is). Thanks! Example tab 1 2004-01 blah blah blah...
  13. kq

    Acrobat 5.0 - Insert Page Break

    Is there any way to split text in Adobe Acrobat 5.0 so that the selected text goes to a new page??
  14. kq

    Report Tab Order not the same when published to PDF

    Yes -- we'll be using SDK. This is part of a project to automate sending ReportX to N number of clients and the brokers who represent them. It's quite fun, actually!
  15. kq

    Report Tab Order not the same when published to PDF

    Thanks for your reply. It seems saving the report before printing corrects the problem (?!?). I really don't know why this was happening. We're publishing pdf files to non-Business Objects external customers -- that's why we're going outside the program. Again, Thanks -- I believe you've...

Part and Inventory Search

Back
Top