User Profile

Collapse

Profile Sidebar

Collapse
Jamen98
Jamen98
Last Activity: Sep 1 '10, 02:30 PM
Joined: Jul 30 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Jamen98
    replied to Error: No Current Record
    in Access
    Figured it out... Stupid quotes!!! I was missing the ' on the second query criteria... Thanks colintis, that was a helpful troubleshooting technique. I'm a newby (I'm sure it's obvious) at VBA...

    Thanks!
    See more | Go to post

      Leave a comment:

    • Jamen98
      replied to Error: No Current Record
      in Access
      Here's the SQL lines:



      sql = "SELECT Membership_Cred it_Table.FILING _STATE, Membership_Cred it_Table.Member ship, Membership_Cred it_Table.Member ship_Rate FROM Membership_Cred it_Table WHERE (((Membership_C redit_Table.FIL ING_STATE)='" & [Forms]![Credit_Debit_OC C_Form]![Filing_State] & "' ) AND ((Membership_Cr edit_Table.Memb ership)=" & [Forms]![Credit_Debit_OC C_Form]![OCC_ADA_Combo] &...
      See more | Go to post

        Leave a comment:

      • Jamen98
        started a topic Error: No Current Record
        in Access

        Error: No Current Record

        I'm running into a problem with running multiple queries. I have two tables that look like:

        Risk_Mgmt_Table
        Fields: (Values)
        Filing_State: (CA)
        Membership: (Yes)
        Membership_Rate : (.95)
        Filing_State: (CA)
        Membership: (No)
        Membership_Rate : (1)

        When I run the query, I get the error "No Current Record" when "No" is selected from a combo box. My code...
        See more | Go to post
        • Jamen98
          replied to Populate text box from Variable
          in Access
          Found the error... Got it working...
          See more | Go to post

            Leave a comment:

          • Jamen98
            started a topic Populate text box from Variable
            in Access

            Populate text box from Variable

            I have a global variable that I need to populate a text box with. The message box comes up with the correct variable, but I'm not sure how to populate my "RiskFactor_Txt " textbox. I have tried several variations to the "Forms!xxxx " statement without success.

            Code:
            Private Sub Form_Load()
    Dim TestMsg As Double
    TestMsg = Me.OpenArgs
        
    MsgBox TestMsg, vbOKOnly, "Test
            ...
            See more | Go to post
            • Jamen98
              replied to How to pass a variable in one form to a variable in another form?
              in Access
              NeoPa - Thank you! That worked!!!
              See more | Go to post

                Leave a comment:

              • Jamen98
                started a topic How to pass a variable in one form to a variable in another form?
                in Access

                How to pass a variable in one form to a variable in another form?

                I'm trying to pass the "ADA_Member_Fac tor" variable from on form to another. The first form that puts a value in the variable is below:


                Code:
                Option Compare Database
Dim ADA_Member_Factor As Double
Dim final_amount As Currency

'---------------- ^is in the General Dec's section----'

Private Sub Calc_Final_Rate_Btn_Click()
On Error GoTo Err_Calc_Final_Rate_Btn_Click
                ...
                See more | Go to post
                No activity results to display
                Show More
                Working...