Two medium level questions

[jritchie]

1. How do l colour the title bar of a window, i.e if l set the backcolour of a form to black, can l set the title bar of the form to black as well. Also toolbars??

2. Using an SQL statement to select data from an Access database. You can do something like SELECT * FROM Table WHERE Name = "Smith", caren't get this working when selecting records that fall in a date range, ie WHERE Date >= 21/12/1999 AND Date <= 31/12/1999, any suggestions?

[Lyla]

Hi..
I'm not sure, But try this:
WHERE Date >= #21/12/1999# AND Date <=# 31/12/1999#

Good Luck.

Lyla

[This message has been edited by Lyla (edited 01-03-2000).]

[Bob Baddeley]

I'm not sure if you can do it with code, but I know you can change the colors from the display settings of the computer. That changes the colors of ALL the programs you run, so it's probably not what you want.