Recent content by Loz

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...

On the forms properties set the ALLOW EDITS=No ALLOW DELETIONS=No ALLOW ADDITIONS=No This will make the form read only. HTH Loz

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...