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!

Register Log in
  • Congratulations derfloh 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. Sawatzky

    Disable Replace in Access 2000 Find/Replace

    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]
  2. Sawatzky

    Conditional Formatting - multi conditions

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

    Pivot Table Question

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

    Excel Freeze!

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

    Printing slows when called from VBA

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

    outlook properties of emails

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

    remember where a user has clicked

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

    Hyperlinks in Ms Word

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

    Hyperlinks in Ms Word

    did you controle the setting?
  10. Sawatzky

    Hyperlinks in Ms Word

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

    Problem withOffice 97 in Windows XP

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

    Excel Listbox column filling

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

    string to array???

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

    Brainstorming: help on opening a cursor doing a fetch in a more effici

    Dear Steve, add one :-)) regards astrid
  15. Sawatzky

    Brainstorming: help on opening a cursor doing a fetch in a more effici

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

    SQL Stored Procedure Cursor help needed please

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

    ISNull Problem

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

    Insert a record in one table & a field in another table

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

    Insert a record in one table & a field in another table

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

    Prevent Error messages from being displayed (switch UserContol to Fals

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

Part and Inventory Search

Back
Top