Search results

  1. A

    Solved input mask report and print

    its wroking tq...
  2. A

    Solved input mask report and print

    it show like this
  3. A

    Solved input mask report and print

    i have 2 value to show on single textbox if null 1. PsPortGuru 2. NoKP i using query to combine 2 value if one of that null my query is compass: Nz([PsPortGuru];[NoKP]) on report i use "compass" now my problem is for NoKP i want to show input mask 999999\-99\-9999;;_ by using this...
  4. A

    Solved auto number id format on vba

    hi again Private Sub NoPermit_GotFocus() NoPermit = "XXXX/xxx/xxx/xxx." & tahundaftar & "/" & noidtext & "" End Sub above my code noidtext = this item i use format "0000" on noidtext on left i want using 0003 how can i get 0003 thaks
  5. A

    Print page footer only on the first page

    Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer) Me.PageFooterSection.Visible = (Me.[Page] = 1) End Sub problem solved remove above code use only Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer) Me.PageFooterSection.Visible =...
  6. A

    Print page footer only on the first page

    for print preview it work... when i hit print button no value on "PageFooterSection" print
  7. A

    Print page footer only on the first page

    hi, i have some text in footer section but i want to show only page 1 and hide on page 2 on print preview it got like what i want but when print the report on footer text not show anything.. the code i use Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)...
  8. A

    hide table design when no value

    hi in report, how to hide table gridlines if no value check the picture thanks
  9. A

    hide text if field is null

    hai this is my current code for report access ="RM " & Format([YURANPROG1];"Standard") & " " & [yrnsujek1] &"" output : RM 50.00 / subjek yuranprog1 = 50.00 subjek = / subjek how can i hide "RM" if yuranprog1 and yrnsujek1 is empty or null on report thanks
  10. A

    Solved replace null field to another textbox value

    PROBLEM SOLVED BY USING SQL comkp: Nz([NOKP];[PSPORT])
  11. A

    Solved replace null field to another textbox value

    ="Ini adalah memperakui bahawa <b>" & [namapp] & " ( " & Nz([NOKP], [PSPORT]) & " )</b> telah disertakan." GOT SYNTAX ERROR
  12. A

    Solved replace null field to another textbox value

    ="Ini adalah memperakui bahawa <b>" & [namapp] & " ( " & [NOKP] & " )</b> telah " above is my current code. is there another where if i want replace "NOKP" with another fields "PSPORT" if "NOKP" is null hope you understand
  13. A

    Solved MS Access print form instead of report

    already try this code but.. it will direct print the report. i want open the print preview first to check all data is correct.
  14. A

    auto number format on form

    the long text is autofocus fields
  15. A

    auto number format on form

    yes but part of autofocus fields not follow 00001
  16. A

    auto number format on form

    hai, i have set my auto number format as "00000" so my auto number will be 00001,00002 but on form textbox auto number still use 1, 2, 3 example for wat i want to do TGuruIPS.noid = IS AUTO NUMBER tahundaftar = year output ZXCV/XXX/CC/AAA.2022/00001 ZXCV/XXX/CC/AAA.2022/00002...
  17. A

    Go to Record when select on listbox

    Private Sub List71_AfterUpdate() DoCmd.SearchForRecord , , , "noid=" & Me.List71 End Sub this my code it will go to record i select for second. but it will back on last record. my forms open code Private Sub Form_Open(Cancel As Integer) Me.List71.SetFocus DoCmd.GoToRecord , , acLast End Sub...
  18. A

    Go to Record when select on listbox

    "id=" is my table primary key ? or my first column query ?
  19. A

    Go to Record when select on listbox

    hi, forms record will show data when select on listbox When i select data on listbox record will show on forms.
  20. A

    Solved MS Access print form instead of report

    TQ for the reply.
Top Bottom