Replies

I do have to work sometimes.

LOL, I thought this was work John. Ha-ha, thanks for taking time out to address this. I did as you said, but I still get the “No supporting . . .” result even when there is a document in the folder. Trying RG’s suggestion again. While you did actually address my question I kinda like the check-box idea for future sorting of records with docs, but we’ll see.

I think I may like your idea better RG, but I just don’t understand it, or where the code goes.
Is bjFiles the name of a check-box?
I don’t see in the code anywhere where the [ID] is defined

I tried John’s idea . . .

Code:

Private Sub Form_Load()
If Len(Dir(“C:UsersBryanDocumentsMy ApplicationsAccess ApplicationsPersonal JournalDocuments & Me.ID”)) = 0 Then
    MsgBox “No supporting document(s).”
Else
    MsgBox “Supporting documents exist.”
End If
End Sub

. . .but I get the same results regardless of [ID] number (“No supporting document(s)”)

Thanks so much for the suggestion RG, I’ll try working with it this evening when the phone isn’t driving me nuts. But honestly I’m already a bit baffled; no matter, my signature explains it all.

1. ID (I’m not very creative) :rolleyes:
2. C:UsersBryanDocumentsMy ApplicationsAccess ApplicationsPersonal JournalDocuments

Wow, I’m really sorry about not getting back to you John. I was out of town for a few days seeing family and totally forgot about the post when I returned; I don’t know why I didn’t get an email on your post, I thought that was automatic.

But, in any case, and being a VB dunce, I appreciate your links but I don’t know enough to write my own code. Hans helped a bunch a few years past but I’m only now getting back to looking at it again and pretty much have forgotten everything (and I’m not just talking about code either). If you had some sample code I could adapt, that would be awesome, and truly appreciated. No expectations here of course, I am grateful for all that you (and so many others) do here in the Lounge.

Sorry Wendell, it’s in 2007 and was just created (.accdb). It’s not a huge deal, but it is curious. At this point I’ve checked every object, and there is no rhyme nor reason (i.e. continuous form, single, etc) to this behavior. I’m thinking gremlins at this point.:unsure:

Thanks. I looked there and there weren’t any files. I also ran a few different undelete utilities, but didn’t have any luck there either (I guess it wasn’t “classically” a deleted file). I suspect that when one clicks “No” on “Do you want to save . . . ” MS has no reason to save anything. Aside from the loss of work, the sad thing is that I was about to click “Yes” when my wireless mouse took a jump onto “No”. Ha-ha, and I’m one of those guys who always complained that Mr. Gates wasn’t listening to me (Dang it Bill, when I say yes I mean yes, except when I mean no, or was that yes?)

Thanks for the input!

Can you post the actual sample data and your query rather than just a picture of it?

Not in any way to discount your request John, but I found the problem. The default values were just as I described and I thought the only input method was by the default value in the table settings, but I have since discovered FrmJournalNew where, as you suspected, the default value is Now(). Going through the records I see (by clicking in the cell) where the vast majority are short time, but that some contain date and time to the second. There’s only a few hundred records to sort through so I’ll just edit manually and disable the date and time entry in the form.Thanks for the help!

According to Access 2007 help the sort order is as I suspected; it sorts the first field first, the second field second, the thir . . . .But that’s not what I’m getting (all the time anyway). Check out these expanded results; everything looks good until you hit 7/20, and then it looks OK until 7/13. If I run the query again, the results remain the same. I also checked the input mask and found that it is “Short Time”, but no input mask for date because the Date Picker is utilized.

The default values are Date() and Time()Sample date from query attached

:^_^: No worries mate!

Thanks John, as I mentioned, I already was using the permissible three (3) Conditional Formatting options, so I guess I will have to abandon the least vital one to utilize this.

Thanks again for the input (and lesson); also, a tip of the hat to everyone else as well. Much appreciated!:clapping:

Thanks Pat, that resolved the issue as I described it.
Unfortunately I forgot, and therefor neglected to mention, that this is a continuous form. So, all of the records have the text box hidden regardless of the Null factor. Krap!

Vista Ultimate version has a grayed out “Upgrade” on screen. I can’t go any further in the process.