User Profile

Collapse

Profile Sidebar

Collapse
sganesan
sganesan
Last Activity: Dec 30 '06, 12:15 AM
Joined: Nov 22 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sganesan
    replied to Updating one record at a time
    in Access
    There is no "error" message as such.
    It comes up with a interactive message box, with the catalalog number on the top and requires the user to enter a value in the parameter field.

    Thanks....
    See more | Go to post

      Leave a comment:

    • sganesan
      replied to Updating one record at a time
      in Access
      when I run the code, It just comes up with a dialog box with and says parameter value (ok and cancel are the options).

      It also send the file to my printer....
      See more | Go to post

        Leave a comment:

      • sganesan
        replied to Updating one record at a time
        in Access
        Text

        Thanks....
        See more | Go to post

          Leave a comment:

        • sganesan
          replied to Updating one record at a time
          in Access
          Thanks for the help. When I run this with the filter option, where Filter = name of query, I am getting a popo-up message asking me to enter the parameter value.

          DoCmd.OpenRepor t "R001-TEST REPORT", , "Q045-TEST REPORT", strCriteria

          Here's my code

          [html]
          Private Sub Command2_Click( )
          Dim db As Database
          Dim rs As Recordset
          Dim strCriteria As String
          ...
          See more | Go to post

            Leave a comment:

          • sganesan
            replied to Updating one record at a time
            in Access
            >>>My best guess from what you've said is you actually want to run through the records in table1 and based on the value in the primary key you want to run a report based on some query for each record in the table.

            That is correct.

            >>>>If this is the case you would do it by using recordsets and passing the value in this field as criteria to the report in a loop until all records had been gone through....
            See more | Go to post

              Leave a comment:

            • sganesan
              replied to Updating one record at a time
              in Access
              Sorry...Let me go into the details.

              I want to set up a command button on my form that

              1. Writes the first record of Field #2 (Primary Field) from Table #1 to Field #1 in Table#2
              2. Using only this one record in Table #2, I want it to run a set of queries, and finally a report is generated (steps already completed)
              3. Then I want to delete the records (should have only one) in table#2 by replacing it with...
              See more | Go to post

                Leave a comment:

              • sganesan
                replied to Updating one record at a time
                in Access
                its actually the 2nd feild in the first record.

                Thanks.
                See more | Go to post

                  Leave a comment:

                • sganesan
                  started a topic Updating one record at a time
                  in Access

                  Updating one record at a time

                  I am trying to add the first field from Table1 to Table2. Using this record in Table2, I am running a set of queries to get my end result. Once the queries are completed for the first record, I want the queries to run for my next record until EOF. Ofcourse, I want this automated using a command button on a form.
                  Any ideas ? Any help is appreciated.
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...