User Profile

Collapse

Profile Sidebar

Collapse
rawled
rawled
Last Activity: Feb 11 '18, 04:58 PM
Joined: Dec 18 '17
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rawled
    replied to How to Set Focuse to a subform control from other subform controls??
    in Visual Basic
    Best way for this is to seek help from the expression builder. At first I did not know about that. I hope it will help other newbies in future.

    Thanks for your reply twinnyfo.
    See more | Go to post

      Leave a comment:

    • rawled
      replied to Updating table data with SQL statement
      in Access
      Thanks twinnyfo.
      Looks like I messed up with the quotes. It works fine now. And there will be two double quotes at the end of the sql statement... Cheers!!
      See more | Go to post

        Leave a comment:

      • rawled
        started a topic Updating table data with SQL statement
        in Access

        Updating table data with SQL statement

        I am trying to update data in a table named tblTest using an unbound form and SQL statement. I will type the data in unbound text boxes on the form. Then I will use those data in SQL statement and finally that SQL will update the data in the table. All fields in the table are of Short Text format except the ID field which is Autonumber.
        Code:
        Private Sub btnUpdate_Click()
    Dim sql As String
    Dim A As Database
    Dim rCount
        ...
        See more | Go to post
        • rawled
          replied to Printing Report from a button on a Form.
          in Access
          Thank you and sorry for replying late. I was on a vacation.

          Your suggestion worked but it exposed the report. Anyway I had to write some more codes to make it invisible.

          Cheers!
          See more | Go to post

            Leave a comment:

          • rawled
            started a topic Printing Report from a button on a Form.
            in Access

            Printing Report from a button on a Form.

            Its not that easy to me that it sounds. I am working hard to make it work.
            The form name is: frmTest
            Button on form: btnPrint
            Name of the report: rptTest
            Initially the report is not opened. I will open the report with btnPrint and keep the report hidden. Then change the record source of the report and open it again (will keep it hidden this time too becase this is the requirement of the project). Then I will bring the...
            See more | Go to post
            • rawled
              replied to Using the value of a boolean variable in two forms without automatic reset to false
              in Access
              Thank you all for your nice cooperation. This is a great community. Sorry that I have to choose one answer as the best. You all are great people.
              See more | Go to post

                Leave a comment:

              • rawled
                replied to Using the value of a boolean variable in two forms without automatic reset to false
                in Access
                Thank you all for your replies.
                It seems i couldn't state the situation properly. Sorry for that. Here is some more info:
                I just want to know a way to declare a variable which will not be reset to default until i close the ms access program. It must hold its value assigned by any operation(i.e. by a code) and if i use that variable anywhere in my database it will give me that value.
                I am giving a simple example:
                Suppose,...
                See more | Go to post

                  Leave a comment:

                • rawled
                  replied to Using the value of a boolean variable in two forms without automatic reset to false
                  in Access
                  Well, I am doing a lot of trial and error on this. It worked once then again the same. The variable must keep the value unchanged set by the button. Problem is it always changes to false automatically no matter I set the value with the button or not.


                  Please reply someone.
                  See more | Go to post

                    Leave a comment:

                  • rawled
                    started a topic Using the value of a boolean variable in two forms without automatic reset to false
                    in Access

                    Using the value of a boolean variable in two forms without automatic reset to false

                    I have a subform1 and it has a nested subform2. there is a button in subform1 which will set the value of a boolean variable (say the variable name is MyVar) to true. Thats the task for the button on subform1.

                    Now, in the before update event of the Source Object(which is a form) of subform2 I want to check the value of MyVar. If MyVar is true then set it to false and do something if not then do some other thing.

                    My objective...
                    See more | Go to post
                    • rawled
                      started a topic How to Set Focuse to a subform control from other subform controls??
                      in Visual Basic

                      How to Set Focuse to a subform control from other subform controls??

                      I have created a navigation form which contains a few nested sub forms. They are like this.

                      frmNavigation is the main form which has navigation buttons and a sub form named NavigationSubFo rm.

                      NavigationSubFo rm: Its source object is a form named sfrmNavigation.

                      sfrmNavigation has a sub form named subAddNewStuden t.
                      subAddNewStuden t: Its source object is a form named sfrmAddNewStude nt.
                      I want...
                      See more | Go to post
                      No activity results to display
                      Show More
                      Working...