User Profile

Collapse

Profile Sidebar

Collapse
rmch
rmch
Last Activity: Jul 14 '11, 11:31 AM
Joined: Jun 27 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rmch
    started a topic Getting error from OnClick Macro
    in Access

    Getting error from OnClick Macro

    i am very new to access.I have created this macro by watching few examples from different sources in form frmPendingPropo salsUpdate. Getting error when I clicks “new” in field “open” of frmPendingPropo salsUpdate. kindly help me where is problem or if this macro is right

    Code:
    Action: OpenForm
Arguments: frmContributionRegister, Form, , ="[RegisterID]=" & Nz([RegisterID],0), , Dialog
Condition: Not IsNull([RegisterID])
    ...
    See more | Go to post
    Last edited by NeoPa; Jul 14 '11, 11:08 PM. Reason: Code tags
    • rmch
      replied to how to calculate due dates of premium and update status for future
      in Access
      Thanks lot Rabbit. It is working, wowwww. I am really thankful for your kind support
      See more | Go to post

        Leave a comment:

      • rmch
        replied to how to calculate due dates of premium and update status for future
        in Access
        I am really excited about access and trying best to solve this, what i have done is....

        I used this code in query…
        Code:
        SELECT tblContributionRegister.*,
IIf([Payment_Mode]="Monthly",DateAdd("m",1,[Issued_Date]),
IIf([Payment_Mode]="Quarterly",DateAdd("m",3,[Issued_Date]),
IIf([Payment_Mode]="Half Yearly",DateAdd("m",6,[Issued_Date]),
IIf([Payment_Mode]="Yearly",DateAdd("m",12,[Issued_Date])))))
        ...
        See more | Go to post
        Last edited by NeoPa; Jul 3 '11, 04:38 PM. Reason: You must use CODE tags when posting code

          Leave a comment:

        • rmch
          replied to how to calculate due dates of premium and update status for future
          in Access
          lot of thanks for replying, i think we are on track but i am new to access and can't understand what to do with all this practically, kindly write step by step procedure. i am thankful for your kind support
          See more | Go to post

            Leave a comment:

          • rmch
            started a topic how to calculate due dates of premium and update status for future
            in Access

            how to calculate due dates of premium and update status for future

            Good Day..
            Its my very first database project and I am really excited about it, trying to make for myself… I am an insurance manager and also learning access through free resources like training videos on youtube etc.. kindly help me on my problem
            Two Tables, tblContribution Register & tblAgentDetails .
            tblContribution Register has fields like.. Prospect_Name (text), Proposal_No (text), Policy_No (text), Submission_Date (Date/time),...
            See more | Go to post
            No activity results to display
            Show More
            Working...