Search results for query: *

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

Dear Tamath, I have no SQL-Server running, so I cannot figure it out but i assume: could be your parameter is passed as a varchar and cannot be converted into sysname properly or has leading or trailing spaces. HTH regards Astrid

dear cbj, perhaps your parameter boxes do not return NULL but "". HTH regards Astrid

Hi Steve, now I am going to dive into it. When you are talking about planning in future times, are there any creteria beyond an ID to figure out which job is to be planned (perhaps creation date or due date?) as far as I got you, you will have jobs, which consists of severals processes, each...

Dear steve, 1) I would approach your problem in another way. having a table : ComboID Complexity Processname processDescription with a unique index combined index on complexity and Processname you make sure not to double entrees. for the time average, i assume you will need doubled values...

Dear michael, the usercontrol property only indicates whether the database is opened by a user or by an application it is an read-only property do set the state of warnings use docmd.setwarnings = false will turn them off docmd.setwarnings = true will turn them back on. and you should...