Recent content by Dreamboat

Did you ever get this taken care of? Here's an article, tho a bit outdated: http://www.mcgimpsey.com/excel/lookuppics.html If that doesn't work, you can probably contact McG and he'll tell you how to work it.

Yes, also in 2007, Bryan. :)

Iiiiiiiiif the form is based on a query, put it in the query. If it's based on a table, put it on the form's textbox. I'm no coder, soo... :)

The attachments were removed from this thread at GarageFlower's request. :)

You may need to go into bro's system and make sure all those references are checked on his system. Did you do that yet? Also, maybe send a PM to Mile...

Something else wrong with your query then. But the one you have there isn't any good. It's like not having ANY criteria 'cause you're asking to have it whether it's null or not... Need to send your DB? I'll give it a go. anne@vbaexpress.com I'm not very good without seeing the DB...some people...

=isnull([field name 1]) or isnull([field name 2]) (I think!) You don't need the AND, because if they're BOTH null, then the OR already handles them.

Oh, not at all! I love to hear it!! . . . oh...I see. you're talking about Mile... hmph. ROFL!

Can you give an example of an exact calculation you're using?

Well, just for the record, www.ev1servers.net is the cheapest to buy domain names. I've never had a problem with them either.

1. I don't see a problem with having the domain registrar different from the host, but... 2. The absolute best, bar none... www.lunarpages.com I have two webs hosted there, and I love their service. 800MB, unlimited emails, DB, FP, etc., for less than $100/year.

It's never about the version of Windows, but the version of Office that's installed. Anyway, likely he just doesn't have the calendar control object installed. I forget the name of the file required, but if you open it on his machine and go to the VBE and hit Tools-References, you'll likely...

Before your code closes the workbook, try adding this line or something similar: Windows.Arrange ArrangeStyle:=xlArrangeStyleTiled

What do you mean by formatting? Text files don't save formatting...

Mile-O Quite right. Sorry 'bout that!