Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    428

    Unfortunately, I need the cells to contain text,...

    Unfortunately, I need the cells to contain text, rather than simply formatting it as text on the fly (for reasons I won't go into here). Luckily, I've found a solution that seems to work under both...
  2. Replies
    41
    Views
    2,666

    An alternative suggestion... If the formatting...

    An alternative suggestion...

    If the formatting depends only on whether the number is positive, zero or negative, you can do it directly in the cell format. This is simpler than using conditional...
  3. Replies
    2
    Views
    428

    I have a spreadsheet that is used in both the UK...

    I have a spreadsheet that is used in both the UK and France, and I'm having problems dealing with the regional differences in presenting numbers and dates.

    Specifically, I need to use the TEXT...
  4. Thanks for everyone's advice! One of my...

    Thanks for everyone's advice!

    One of my colleagues found another solution before I got to try any of your suggestions. In case anyone gets a similar problem, here's what my colleague did...

    You...
  5. Thanks for the suggestion, John, but it didn't...

    Thanks for the suggestion, John, but it didn't resolve the problem.

    The Sent Items folder is still in Deleted Items, and it still refuses to move.

    Does anyone have any other ideas? If not, I'll...
  6. Hi All! We're running Outlook 2003 (recently...

    Hi All!

    We're running Outlook 2003 (recently upgraded from 2000, though I don't think that's related to this problem) and Exchange 2003.

    One of our users has somehow managed to move several...
  7. Re: Show Report Header and Footer for Empty Subreport (Access 97)

    Yes, that did the trick.

    And you're right, it is easier done than said!

    Many thanks!
  8. Re: Show Report Header and Footer for Empty Subreport (Access 97)

    Thanks, Hans, but that's not really what I'm after.

    I would like to force the subreports to appear on the main report, even if they have no data (i.e. the report header and footer to show,...
  9. Show Report Header and Footer for Empty Subreport (Access 97)

    Hi!

    By default, access hides the report header and footer for subreports that have no data. Do you know of any way of forcing it to show them always?

    Thanks!
  10. Locked User Account Notification (Windows 2003)

    Our network's security policy is to lock user accounts after 5 unsuccessful logon attempts. Although it creates a bit of admin work and user frustration, it generally works well. However, some...
  11. Replies
    2
    Views
    313

    Re: ODBC Set-up (2000)

    I'd started looking at a solution for this a while ago, albeit for ODBC connections to SQL Server. I got as far as creating an Excel spreadsheet where you could list the connection details, and some...
  12. Replies
    8
    Views
    863

    Re: IIF query (Access 2000)

    Here's another idea: could you have another table linking the various sizes to the related value? This table could be included in the query, linked by the size, to return the required value, thereby...
  13. Re: Formatting Pivottable Objects with VBA (Office 97)

    Yes, it does work in Excel 97, but only if you remove the ", True" argument at the end.

    I was really hoping to modify the object directly, rather than have to make a selection, but it really does...
  14. Replies
    7
    Views
    1,131

    Re: waiting for a batch file to finish (XP)

    In case it's useful for anyone, here's a stripped down Access 97 database with the code.
  15. Replies
    7
    Views
    1,131

    Re: waiting for a batch file to finish (XP)

    I can't remember where I got this code (I'm certainly not clever enough to write it myself) but it does work well.

    The test subroutine opens Notepad and waits until you close it before continuing...
  16. Formatting Pivottable Objects with VBA (Office 97)

    Hi!

    I have a spreadsheet with several pivottables and some VBA that performs various operations on them, including changing the source of data and resetting the formatting.

    One of the parts of...
  17. Re: Use of variables in MsgBoxes (VBA (Access etc.

    Thanks for your responses everyone. Very interesting!

    I think everyone learns the importance of "ease of maintenance" the hard way, by getting horribly burned when an old project rears its ugly...
  18. Re: Use of variables in MsgBoxes (VBA (Access etc.))

    Thanks, Hans, that's reassuring.

    One of my university tutors always advocated laziness (at least in the sense of taking the most efficient route to a good end result), so I can now happily...
  19. Use of variables in MsgBoxes (VBA (Access etc.))

    Just out of curiousity...

    When making a MsgBox, I usually construct the strings all on the same line. I've noticed that many people declare variables even for the elements that don't change. For...
  20. Re: Cannot access certain documents (XP Pro SP-2)

    Well, the problem's been resolved for now by rebooting the server (which is running Windows Server 2003, not XP).

    The server has a RAID array, so it's unlikely that a disk error could cause a...
  21. Re: Cannot access certain documents (XP Pro SP-2)

    Yes, I wasn't very clear on that, was I? Sorry!

    They are stored on a network drive. Everything I mentioned in my first post was tried whilst logged on to the server as an administrator.

    One of...
  22. Re: Cannot access certain documents (XP Pro SP-2)

    I've got this problem for a PDF in a certain folder on our domain (Windows Server 2003 with NTFS). We've had files in the same folder loose all security permissions, but I was able to sort these out...
  23. Re: Code to pull existing info into new record (Access 2003)

    In case it's useful to anyone, I've got the following code for copying all fields (except for AutoNumber):

    <pre> Dim rst As Recordset
    Dim fld As Field

    Set rst = Me.RecordsetClone
    ...
  24. Replies
    6
    Views
    407

    Re: 'Date Updated' field (MS Office 2000)

    That did the trick.

    Thank you very much, Hans!
  25. Replies
    6
    Views
    407

    Re: 'Date Updated' field (MS Office 2000)

    I've used a similar code to record the "last updated" date (except I've used Now() to give the time as well). This works well under most circumstances.

    However, I also have a ListBox (lstSelect)...
Results 1 to 25 of 39
Page 1 of 2 1 2