User Profile

Collapse

Profile Sidebar

Collapse
Terryvanduzee
Terryvanduzee
Last Activity: Nov 20 '09, 01:23 AM
Joined: Oct 30 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Terryvanduzee
    replied to #Deleted on Form
    in Access
    Well,
    After some going through the comments here, I will agree that my design is flawed.
    I understand the importance of a customer table.
    I am not clear on a different path of logic for the sale though. I display a form/subform. The user selects the criteria in the main form. The subform displays the results. If there are 2 records in the subform, either or both have the possibility of being sold. The reason for the checkbox...
    See more | Go to post

      Leave a comment:

    • Terryvanduzee
      replied to #Deleted on Form
      in Access
      Thank you for the comments and solution.

      The reason behind the checkbox is as follows.
      A person opens the form and selects criteria. When the recordset is displayed, it is possible that the item(s) in the result could be sold. To sell the item, the checkbox is clicked. At this point it prompts for Customer information via inputbox. It then takes the collected data, including the data from the record on the form that was clicked...
      See more | Go to post

        Leave a comment:

      • Terryvanduzee
        replied to #Deleted on Form
        in Access
        Thank you for your response
        I did try the requery, but I get an access box saying I must save the field before performing the requery action.

        Any ideas about that?

        Thank you
        Terry
        See more | Go to post

          Leave a comment:

        • Terryvanduzee
          started a topic #Deleted on Form
          in Access

          #Deleted on Form

          Hello

          I have a form where i have a checkbox. When the checkbox is clicked, it checks to see if the value is true (checked). If it is, it takes the current record in the form, prompts for some information (input boxes) and writes the values to a table via sql insert. Then deletes the record from the form.
          The form data displayed is based on values selected from 2 combo boxes. The records set could have more than 1 record....
          See more | Go to post
          • Terryvanduzee
            replied to Wrong record count
            in Access
            Thank you...
            Works great. I had forgotten about the movelast

            Again, thank you
            Terry
            See more | Go to post

              Leave a comment:

            • Terryvanduzee
              started a topic Wrong record count
              in Access

              Wrong record count

              Hello

              In my form load event, I have the value of a text box that displays the count of the records in the form. The number always displays 40, where a physical count of the records is 73.

              Code:
              Me.Text7.Value = [Forms]![frm_All_Mattresses_Main].[frm_All_Matt_frm_subform].Form.Recordset.RecordCount
              Any suggestions?

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