Recent content by jackmcg

I'm trying to do the same thing.... have you gotten any answers from anyone anywhere? If so, I'd appreciate hearing. If I learn anything, i'll let you know.

Thanks, chergh... I asked the question badly.... your solution works, but it has to be in the db itself. I should have asked if there was a way to create the directory when the install is run. It's possible to include a vba sub in the install procedure, but it runs every time the application...

Is there some simple way, using the new runtime for Acc2007 to create an empty directory at the setup? Right now, I'm inserting a small, almost empty .txt file in the directory I want to create, but I'd rather just present the user with a genuinely empty dir.... I'm not very well schooled on...

I assumed that you were actually enclosing the logical test within the quotes... which is certain to fail given all else. This will work: Public Sub test() Dim condition As Boolean Dim msg As String condition = 4 = 4 And 5 = 5 And 6 = 6 If condition Then msg = "it is ok" MsgBox msg End Sub

done it again... Thanks missinglinq... that was exactly the prob.... the field in the underlying table had a format attached... took it out... right on the money! i owe ya one! if you see a sign with your name on it by the side of the road at the intersection of I64 and I295 a day or two...

last night I installed Office 2003 Service Pack 3, which solved a major problem in a one db, and I'm praying it didn't cause the problem I have now in another. here's the problem: one listbox control lists degrees (ba, bs, etc.) the other lists majors (agriculture, computer science, etc.) in...