Search:

Type: Posts; User: an_unchosen_name; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    10
    Views
    728

    Re: Bloated Excel Workbook (2000)

    macropod, hans, jan:

    I want to thank all three of you for your valuable information. Since there were no objects that I intentionally added to my worksheet, I tried Jan's suggestion, using the...
  2. Replies
    10
    Views
    728

    Re: Bloated Excel Workbook (2000)

    macropod --- I did find that there are several 'Pictires'... now I need to find out how to find them in the spreadsheet. Thanks!
  3. Replies
    10
    Views
    728

    Re: Bloated Excel Workbook (2000)

    Thanks Macropod... is there a way to detect such objects?
  4. Replies
    10
    Views
    728

    Bloated Excel Workbook (2000)

    I keep having a problem with Excel workbooks suddenly shooting up from perhaps 250kb to 6-8MB. It has 5 worksheets, with a max of 200 rows in each. I've checked to make sure the last cell is not...
  5. Can set up Windows Explorer via Command line?

    In my role, I frequently have to access various users PCs, and their Windows Explorer. Most of them have never changed any of the settings in Explorer, and probably never will. The first thing I do...
  6. Re: PrtDevMode Property to change printer for a form (2000)

    Hans - exactly what I was thinking. I've spent several hours researching these properties, and it's opened my eyes to some interesting possibilities for them, but the drawback is that the form /...
  7. PrtDevMode Property to change printer for a form (2000)

    I am becoming familiar with the PrtDevMode property, specificially in order to give the user a choice of printer or fax when printing the selected record. I will have one button for each one on the...
  8. Usoing RightFax from Access (2000)

    Does anyone have any experience using RightFax from Access? I am trying to open RightFax from a button on a form. Any tips will be greatly appreciated.

    Thanks,

    Howard
  9. Have Access print to specific printer (2000)

    The answer to this may already be in a post, but since I can't search, I will ask it now. My users have installed three printers - they would like to have a button on their form for each of the...
  10. Replies
    2
    Views
    276

    VB code flows randomly (2000)

    I'm trying to modify some VB code that's in the 'On Lost Focus' event for a field. The code that I am providing here has been reduced in complexity for illustration, but still reproduces the...
  11. Re: Compacting resets 'Modified' and 'Created' details (2000)

    Thanks Charlotte - I have 2000, and have one db with a very large number of coded forms, and modules. Users have experienced record corruption at times, and it seems to be getitng to be a more...
  12. Re: Compacting resets 'Modified' and 'Created' details (2000)

    (Edited by HansV to make URL live - see <!help=19>Help 19<!/help>)

    Thanks for your reply Charlotte

    Actually, I was just able to find this in Microsoft's site...
  13. Re: Compacting resets 'Modified' and 'Created' details (2000)

    Steve,

    Thanks, I was living with it too, but sure hope there's a way to stop it from happening. By the way, why do you de-compile your database(s)?

    Howard
  14. Re: Compacting resets 'Modified' and 'Created' details (2000)

    Hans,

    I just compacted one of my databases that has a variety of objects in it. Although I'm pretty sure that every type of object was reset before, this time all Forms, Reports, Macros and...
  15. Compacting resets 'Modified' and 'Created' details (2000)

    This has bothered me for a while, and I'm finally taking a minute to ask about it. I was glad to see Microsoft add the Date and Time stamp for objects creation and modification, but have been...
  16. Re: Problem with null criteria in an IIF statement (2000)

    Well, the new problem with this is that surrounding the criteria with asterisks like *criteria* returns everything with the criteria within the field; for instance *2* returns 2, 22, 23 26, etc.
    ...
  17. Re: Problem with null criteria in an IIF statement (2000)

    You know, Pat, that works, but I wouldn't have guessed that for a while. I guess that the [Forms]![frmQueryCriteria]![txtClearedBy] Is Null part returns sort of a 'True' condition? Hope I remember...
  18. Problem with null criteria in an IIF statement (2000)

    I have an unbound form, that I'm using for query criteria - it has a field called [txtClearedBy].

    If I have a value in [txtClearedBy], the following criteria works OK:
    ...
  19. Re: How to state an improvement in errors (2000)

    Thanks all for your input.
    Howard
  20. Re: How to state an improvement in errors (2000)

    Thanks for your input Cecilia. I guess that's why they say that statistics can be misleading if the one providing them wants them to be.

    Howard
  21. How to state an improvement in errors (2000)

    Although this isn't actually an Access question, it's one that I have while using Access. I realized that I'm not sure how to state an improvement in an error rate. For example:

    First, I...
  22. Re: Subreport produces blank pages if no records (2000)

    Hans - Thanks!

    I was making it difficult, trying to use the OnNoData property of the subreport to make it Not Visible on the main report. I appreciate your help.

    Howard
  23. Subreport produces blank pages if no records (2000)

    I have a report that has a subreport. The subreport that breaks on Company Number. It all works fine, except that when there are no records for a company on the subreport, it produces a blank page...
  24. Re: Syntax trouble using IIF in a query (2000)

    Thank you, thank you, thank you! I hadn't thought of that (obvoiusly), but probably tried everything else but that. I appreciate your quick response.

    Regards,

    Howard
  25. Syntax trouble using IIF in a query (2000)

    I would be pulling my hair out right now... but I'm already bald! I am working on a database that has an amount field - the users enter an amount, and then use a combo box to choose DR or CR to...
Results 1 to 25 of 48
Page 1 of 2 1 2