Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    7
    Views
    2,422

    The person in question has told me she was using...

    The person in question has told me she was using DoCmd (presumably DoCmd.OpenQuery). Searching on the web does suggest a series of these can run asynchronously. (Presumably because each opens a...
  2. Replies
    7
    Views
    2,422

    I was asking on behalf of somebody else. (That's...

    I was asking on behalf of somebody else. (That's why I said "Apparently...", since it didn't actually happen to me.) I'll see if I can get more details as to how they think this is happening.
  3. Replies
    7
    Views
    2,422

    Access VBA: Running queries synchronously

    Apparently in Access VBA, if you're running a query in a line of code, control may be passed to the next line of code before the query finishes. If the next line of code starts another query that...
  4. Replies
    2
    Views
    667

    Hi Ruth, Behind the scenes, dates are just...

    Hi Ruth,

    Behind the scenes, dates are just regular numbers. 1 is equal to Jan 1, 1900, 2 is Jan 2, 1900. Not surprisingly, 61811 days later is March 24, 2069. So that's normal.

    There must be...
  5. Replies
    2
    Views
    3,458

    I ran across an old reference somewhere that...

    I ran across an old reference somewhere that suggested this might work if you move your mouse pointer over to the second screen (the large monitor) and click on the links there. (If that's something...
  6. Replies
    7
    Views
    6,005

    The quick answer is that COUNT only counts cells...

    The quick answer is that COUNT only counts cells with numbers - not blank cells, or cells with text - just numbers. You might have had numbers in B1 to B20, so COUNT(B:B) equals 20. Now you've...
  7. Yep, that method you linked to is more or less...

    Yep, that method you linked to is more or less what I did. There was only one link that the Edit -> Links process didn't work for and that turned out to be buried in a chart.

    So this was all...
  8. I ended up basically copying everything to a new...

    I ended up basically copying everything to a new workbook. Had to weed out some external references the copying introduced, but it still didn't take very long. And now the formulas work as expected....
  9. Yes, copying down to Row 50 - in the new...

    Yes, copying down to Row 50 - in the new worksheet but in the original workbook - still does give the desired result.

    I'm not sure how old the workbook is - several years old at least and used in...
  10. That's one I forgot to mention. I tried both...

    That's one I forgot to mention. I tried both Fixed (1 decimal place) and General and neither changed anything.
  11. Simple version: There may or may not be a value...

    Simple version: There may or may not be a value in cell A50. Cell B50 contains the formula =IF(A50="", "", A50). The desired result is that B50 stays blank if A50 is blank - otherwise it displays the...
Results 1 to 11 of 11