Search results for query: *

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

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

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

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

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

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')...

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

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

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

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

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??

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

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

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!

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

I've tried a couple of times to either a) print to pdfwriter and b) publish through broadcast agent to pdf -- but here's what's happening: The report has tabs 1, 2, 3, 4 (they have names tho, not numbers) When printed to pdf, it's coming out in 2, 3, 1, 4 order ! I'm thinking maybe there's a...

Thank you both Bridgeconsultant and Lysen for your assistance. Now the job will be to get something past "Dr NO" as we call our IT guys!

This thread has been amazingly helpful. How would this look if I wanted to print to PDF (I have Acrobat blah blah blah) instead of emailing?

Here's the original language: sum(CASE WHEN ((D.covg_typ_cntg_ind = 'Y' and C.sub_mth_cnt in ('-1','1') )) THEN C.sub_mth_cnt ELSE 0 end) AS CNT Here's the change: sum(CASE WHEN ((D.covg_typ_cntg_ind='Y' and C.sub_mth_cnt in ('-1','1') and D.prod_var_age_cd ='1' )) THEN...

Our DBAs have made a change in logic to one of the dimension which, when used through BO is not an issue; however, many of our queries are in freehand sql and we're having to manually update each one (approx 100). Is there an automated tool of any kind that could do a find/replace function?