Recent content by Sawatzky

Dear Avacha, you can give your DB a customized menu via tools/start. Be carefull when testing ;-) I know there is a key to bypass the customized menu but I do not remember it. (Perhaps someone else knows??) kind regards Astrid PS: It's cowardish to backup before testing [tongue]

Dear osx99, I assume the conditional formatation bails out on the first met condition. If you first define condition1 if A4>0 and X4>Y4 then format cells color yellow and change text to red condition2 cells color yellow if cell A4>0 condition3 and change text to red if cell X4>Y4...

Dear Margeret could you please be more exact about what "ugly things" means. what do you mean by gross profit formula? is it just the sum??? regards Astrid

Dear Jane, maybe the file is just corrupted, which happens to office-files being changed a lot. there are several tools to repair corrupted files, so you can at least rescue your data and the formulas. Afaik none of these tools is able to recover the macros. Microsoft also describes a way to...

Dear Kbieber, what you do here: Dim crpApplication As New CRPEAuto.Application ... Set crpReport = crpApplication.OpenReport("M:\crystal\meritec rpts\SFRLPPRTSQLrev4test.rpt") is creating a new instance of the CRPEAuto.Application. Which is (as I assume) already opened when you do the report...

Dear sannas, after the first glance at your problem, I wonder if you ever thought about using the worklow designer for exchange, which you can download at the MS-Homepage As far as I know that tool it could be perfect for that job. kind regards A. Sawatzky

dear faxof, inform yourself about: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) kind regards Astrid PS: perhaps the VBA forum would be more adequate

It is called field codes in english and must be deactivated. regards Astrid

did you controle the setting?

Dear Bud, if you just type it, it wont work. Try using menu/insert/hyperlink. If you still see the formula. change the setting "field formula" in tools/options/(view). I am not really sure about the names of the menus as I have a German version. regards Astrid

Dear habn, this seems to be another 'feature'. I also receive this error message. If you just enter 't' all files containing a 't' will be shown. HTH regards Astrid

Dear Bob, I assume your code should add items to your listbox, if so you need to use the .additem() method of the listbox to do so. regards Astrid

Dear Autumnblues Have a look at the functions Split and Join regards Astrid

Dear Steve, add one :-)) regards astrid

Dear Steve, am I right that you want to update allways the very row you just fetched? If so , the FOR UPDATE part of the Declare cursor statement could be helpfull. regards Astrid