Problem: Got a 2 column label report. Something like this when printed.
|---------------------|
|name1 name2|
|name3 name4|
|name5 name6|
|name7 name8|
|name9 name10|
|---------------------|
Then I have a form that have 10 combo box which draw its data from a table which...
Got same problem on my cannon 8200 bubble jet too.
I realised its because the settings for the printer is at Draft printing mode.
Solution: Set the printer Print Quality to standard printing mode or hign printing mode when your ink is low.
I figure it out
Private Sub Detail1_Print(Cancel As Integer, PrintCount As Integer)
If Me![Apple] = True Then
Me![Image377].Visible = True
Else
Me![Image377].Visible = False
End If
End Sub
Oh MAN
The above solution is based on Form. What if the condition is based on Query.
If record 1(of an table) have a field Apple that is true then in the report the picture of an Apple be visible??
1) I uses Access 2002 to program a set of Query using Format("01/01/03,"ddd") which is save by default to Access 2000 file-format. However when I run this Query in another PC with Access 2000 the Query did not understand the term Format. Any ideal...I suppect its the version of VBA.
2)I know...
I was just wondering is it possible to control the color on the report if let say
Month Bank$
===== =====
JAN $100 (in black)
FEB -$100 (in red )
Is it possible?
Is there any simple query to do it, as I already converted both date and time field into date/time format.
Thanks for helping but I am really a novice.
I got this problem, I have a table full of records like these
EMP ID DATE TIME
===== ==== ====
A0001 011002 2200 (clock in time)
A0001 021002 0700 (clock out time)
==================
I would like to change them to this,
EMP ID DATE...
I got this problem
Name | Time1 | Time2 | Time3 | Time4 | Min Time|
==========================================
Tom | 12:13 | 07:00 | 17:00 | | 07:00 |
==========================================
Min Time is the Query result I need to get.
I know to Group by and sort them by...