User Profile

Collapse

Profile Sidebar

Collapse
SourceOfAccess
SourceOfAccess
Last Activity: Dec 4 '15, 12:01 PM
Joined: Nov 28 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • SourceOfAccess
    started a topic Run-time error '3464' - Data type mismatch in criteria expresssion
    in Access

    Run-time error '3464' - Data type mismatch in criteria expresssion

    So...I'm trying to create a field that automatically calculates a value by gathering data from multiple tables.

    My code seems to be fine, but MS Access returns with an error:

    Run-time error '3464' - Data type mismatch in criteria expresssion

    My code is as following:
    Code:
    Dim AccommodationType As String

AccommodationType = DLookup("AccommodationType", "Accommodations", "AccommodationID
    ...
    See more | Go to post
    Last edited by zmbd; Dec 3 '15, 11:10 PM. Reason: [z{code formatted}]
    • SourceOfAccess
      started a topic Run-time error '2465' - System can't find the field '|1'
      in Access

      Run-time error '2465' - System can't find the field '|1'

      So...I've wrote up a block of code calculating the total charge of a sale. However, it doesn't seem to be working, as whenever I try running the form, MS Access returns with a:

      Runtime error '2465' - System can't find the field '|1' referred to in your expression.

      The below is my code - it's pretty self explanatory, but I'd be happy to run you through each line if it's hard to understand:

      Code:
      Private Sub Form_Current()
      ...
      See more | Go to post
      Last edited by Rabbit; Dec 2 '15, 04:34 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
      • SourceOfAccess
        replied to Formatting with Lookup Fields
        in Access
        Thank you so much for your responses.

        I was able to resolve the first problem by formatting the fields in the form, as both of you suggested.

        However, I'm still unsure how I should go about solving the second issue, where I'm unable to format the values if multiple values are selected through Lookup - even if I try doing so in the forms/reports.

        Ideas?
        See more | Go to post

          Leave a comment:

        • SourceOfAccess
          started a topic Formatting with Lookup Fields
          in Access

          Formatting with Lookup Fields

          If I've got an AutoNumber field formatted as: \C0000 000 in Table A. If I attempt to create a Lookup field in Table B that targets the formatted table in Table A, 2 issues arise:

          1) If the Lookup field does NOT allow multiple values: The formatting carries over and is treated as Text, hence creating an error as it does not meet the data type of the Lookup field (which is always Number)

          2) If the Lookup field does allow...
          See more | Go to post
          • SourceOfAccess
            replied to How should I go about editing a public variable in a subform from a completely separa
            in Access
            Thanks for your reply Nico. But I don't think you understand the issue at hand - I apologise for not being clear enough.

            Essentially what I'm trying to do is input the ID of the user into a text box on a subform that's under a navigation form which opens when the login process is successful.
            See more | Go to post

              Leave a comment:

            • SourceOfAccess
              started a topic How should I go about editing a public variable in a subform from a completely separa
              in Access

              How should I go about editing a public variable in a subform from a completely separa

              I have 3 different forms:

              - Login
              - Navigation
              - Welcome

              The form Navigation has a Navigation Control that displays the form Welcome as a subform.

              In the form Welcome, there is a public variable as following:

              Public trueLoginName As String

              While is the form Login, there is a Dim bariable as following:

              Dim trueLoginId As String

              ...
              See more | Go to post
              No activity results to display
              Show More
              Working...