Here is an example of a similar coding I used in a report, this set both the background and foreground colour depending on criterea.
<snip>
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Const WHITE = 16777215
Const YELLOW = 65535
Const Ghost = 8388608
Const BLACK = 0...
There is an article (Q129397) that explains how to change printers for a report
http://support.microsoft.com/support/kb/articles/Q129/3/97.asp?LN=EN-US&SD=gn&FR=0
Its a bit involved, best of luck.
Loz
[This message has been edited by Loz (edited 05-23-2000).]
The "close" Button can be deisabled by setting the close button option to "no" in the form properties.
To remove the Main menu bar you should create your own and replace, search help on toolbars it should help.
HTH
Loz
Try this code in the OnCurrent.
It was used for another application, but you should be able to derive your requirements.
<snip>
Private Sub Form_Current()
' set colour of background depending on live or decomissioned
Const ltblue = 16776960
Const ltgreen = 65280
Const red = 255
If...
I have a database that requires one form that can be driven from serveral different queries, is there any way of creating a form that can be used by several queries.
depending on certain actions my users need to open a form but with a different query driving the data.
The present solution is...