User Profile

Collapse

Profile Sidebar

Collapse
pfm721
pfm721
Last Activity: Jul 18 '08, 01:33 PM
Joined: Jun 9 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pfm721
    replied to coding issue
    in Access
    Almost there I think, no I am getting a syntax error. The code now reads
    Code:
    Dim varIncompleteProject As Variant
    varIncompleteProject = DLookup("[AppID]", "tblAppointment", _
    "[ConsultNumber]= " & Me.ConsultNumber & _
    "' And IsNull[CompletedDate]")
  If Not IsNull(varIncompleteProject) Then
    MsgBox "Appointment " & varIncompleteProject
    ...
    See more | Go to post
    Last edited by NeoPa; Jul 9 '08, 01:55 PM. Reason: Please use the [CODE] tags provided

      Leave a comment:

    • pfm721
      started a topic coding issue
      in Access

      coding issue

      Form frmInfo with a subform frmAppointment. I want to check to see that all appointments have a complete date before I allow the user to check complete on a check box on the main form. My code (which was written by someone else) is as follows. I am getting error 2001 you canceled the previous operation. I am unable to figure out why. The references are all correct. If anyone can see whats wrong and help me with it, it would be greatly appreciated....
      See more | Go to post
      Last edited by NeoPa; Jul 9 '08, 01:53 PM. Reason: Please use the [CODE] tags provided
      • pfm721
        started a topic Form Based on a Query help
        in Access

        Form Based on a Query help

        I have a form that is based on a query. There are multiple tables in the query. the parameter in the query is VetSSN. My problem is that if there is no data in a particular table the form text boxes won't allow me to add the data. For instance user enters a SSN. The four tables that the query returns data for are

        tblVeteran
        tblConsult
        tblDoctor
        tblVendor

        If there is no data in tblDoctor the text...
        See more | Go to post
        • pfm721
          started a topic Help Reading Code
          in Access

          Help Reading Code

          I can read and follow most code. However I am having trouble borrowing code from another database. it is working correctly but so that I can understand what is going on I need someone to tell me what the code in this sub header is doing if they can.


          Sub CPRSLaunch(Opti onal SSN As String = "", Optional Template As String = "")

          Thanks,
          Patrick
          See more | Go to post
          • pfm721
            started a topic Help with an Error
            in Access

            Help with an Error

            Can anyone see something wrong with this code?

            I am getting an error @ the Me.RecordsetCol e line in the AfterUpdate event.

            Run-time error 7951

            You entered an expression that has an invalid reference to the RecordsetClone property.

            Private Sub Combo0_AfterUpd ate()
            With Me.RecordsetClo ne
            .FindFirst "[VetSSN] = """ & Me.Combo0 & """"...
            See more | Go to post
            • pfm721
              started a topic Open form w/ input from cbo on other form?
              in Access

              Open form w/ input from cbo on other form?

              I know this is probably on the forum somewhere I was unable to find a solution because I didn't really know how to search for it. I have a form that has a combo box on it. The user types a # in the combo and if the number doesn't exist in the record source it asks the user if they would like to create a new record. If the user clicks yes a form frmEnterVet opens for them to enter the new record. What I would like to do is take the value that was...
              See more | Go to post
              • pfm721
                replied to Mouse move event question.
                in Access
                Thanks, worked like a charm.
                See more | Go to post

                  Leave a comment:

                • pfm721
                  started a topic Mouse move event question.
                  in Access

                  Mouse move event question.

                  I know the control tip text will display information about a text box. However I was wondering if there is a way to change it based on the value of the text box. Is it possible to create a mouse move event that will do the same thing?

                  i.e. value of txtStatus

                  If [txtStatus] = A then "good"
                  If [txtStatus] = B then "bad"

                  something to that effect. I don't really know if it is possible...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...