Recent content by jrpope

Thanks, It worked like a champ.

I have a new 20gb USB hard drive and win 2000 recognizes it and loads the drivers. The problem is the drive light does not go out and I cannot access the drive at all. It doesn't assign a drive letter to the drive. The drive is a FUJITSU model mht2020at notebook hard drive installed in a...

I'm getting pig-headed in my old age. I've been beating my head against the wall on this for a while. I think I finally stumbled on the answer. (I'm new to access, the last database I wrote was in Dbase IV) All you have to do is replace: Dim myRs As DAO.Recordset with: Dim...

I've been having the same problemand I've tried your code. This comes up with a compile error(user-defined type not defined on line "Dim myRs As DAO.Recordset". Do you have a fix for this?

First I want to thank you for your help and I'm trying all three options to see which works best for my needs. I normally wouldn't even screw with something this obscure but the database I'm writing is for the military and as much as I've tried not to use it, they want it and have been using...

I have been trying to compute julian dates in VBA and hve only had limited success. When I change years, this becomes a big problem. The success I've had is with computing the julian date off of the date in number format. This works well but I can't seem to get the year right when the year...