Search results

  1. S

    2 column label report (advance)

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

    jpeg in Sub Report

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

    Conditional Labels??????

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

    Conditional Labels??????

    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??
  5. S

    Format("01/01/03","ddd") Acc2000 cant read

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

    Different Color

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

    Punch Card

    Thanks alot guys It works, it works though I am still trying to understand what Jon K wrote. Thanks Jon K Thanks also to Raskew. How you guys did it?
  8. S

    Punch Card

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

    Punch Card

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

    Sorting Problem

    thanks Guys Thanks for your Advise. The_Doc_Man and Jon K. U gus are super... Sonnie
  11. S

    Sorting Problem

    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...
Back
Top Bottom