User Profile

Collapse

Profile Sidebar

Collapse
moonrb
moonrb
Last Activity: Sep 20 '18, 05:41 AM
Joined: Nov 10 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • moonrb
    replied to Database stoped responding when a report fails to open?
    in Access
    Dear Friend

    Thank you so much for your reply. Your given link helped me to solve the problem. I set to Break on All Errors in Tools / Options / General of VBA Window whereas it was set to Break on Unhandled Errors by default.

    Thank you again
    Moonrb
    See more | Go to post

      Leave a comment:

    • moonrb
      started a topic Database stoped responding when a report fails to open?
      in Access

      Database stoped responding when a report fails to open?

      Hi,

      I have some reports in my database where i put the following VB code to display a No Data message.
      Code:
      Private Sub Report_NoData(Cancel As Integer)
    MsgBox "There is no data to display", _
           vbExclamation, _
           "No Records"
    Cancel = True
End Sub
      The code works fine but after getting the Message "There is no data to display" The database...
      See more | Go to post
      Last edited by NeoPa; Sep 16 '18, 04:53 PM. Reason: Added mandatory [CODE] tags.
      • moonrb
        started a topic Process of Data exporting from Access & import the same to other Access database.
        in Access

        Process of Data exporting from Access & import the same to other Access database.

        Hi
        I am using Access 2002.
        I am creating a database to store and manage some data of farmers in different area of my country. I will give the MDB file to different users. They will collect data and post data in this database. I need them to send me an extracted file daily after updating their database from their end. On the Other hand I want to import these files to my master database programmaticall y.
        So i want to learn how...
        See more | Go to post
        • moonrb
          started a topic Run time error "3008"
          in Access

          Run time error "3008"

          Hi

          I am new in access. Ihave a form "RecMonthlyInst allment" created from Table "RecMonthlyInst allment". In the form I have command button which executes a macro named "POST MONTHLY INSTALLMENT". When click the command button the error message arrives. The macro individually works good but when i use the form it does not work. If I delete it then comes the message "the table is exclusively opened...
          See more | Go to post
          • moonrb
            started a topic how can I autogenerate value for a text field
            in Access

            how can I autogenerate value for a text field

            Hi,

            I have a customer table with a Primary field name "CustomerCo de" .

            I want that the value in the field should generate automatically, like A001 To A200 and then B001 to B200 and go on

            Is it possible?

            Thanks
            See more | Go to post
            Last edited by NeoPa; Jan 5 '14, 12:25 AM. Reason: TextSpeak (disrespectful) and asking for direct solutions are not allowed on this site.
            • moonrb
              started a topic How can disable window close button for an MDB file?
              in Access

              How can disable window close button for an MDB file?

              hi

              How can disable window close button for an MDB file. because when a user closes application by clicking on window close button (right top corner), unsaved & incomplete data on the form gets saved in respective table. i want to prevent this from happening.

              plz give me a good suggestion

              thanx a lot in advance.
              See more | Go to post
              • moonrb
                replied to How can i disable right click on report ?
                in Access
                thanks

                but can u tell me , how can i get data from an MDE file, when i make changes to the database by original MDB file.

                i want to know the backup process from MDE file & restore process.

                i have another problem, that is if i give the MDE file to a user, he can easily copy it and give it to others. How can i prevent this from happening

                thanks

                NeoPa & Rabbit
                See more | Go to post

                  Leave a comment:

                • moonrb
                  started a topic How can i disable right click on report ?
                  in Access

                  How can i disable right click on report ?

                  hi

                  How can i disable right click on report that a user can not change the design of the report.
                  i am using access 2002

                  Thanks.
                  See more | Go to post
                  • moonrb
                    started a topic How Can I View Datasheeet On Form When Using "Select Query" By A Command Button.
                    in Access

                    How Can I View Datasheeet On Form When Using "Select Query" By A Command Button.

                    Hi

                    How Can I View Datasheeet On Form When Using "Select Query" By A Command Button.

                    I am using access 2002

                    Thanks in advance



                    [z{Moderator's edits{Placed both the title and the post body in proper letter case. Please do not use all upper case letters. It is hard on the eyes and, by convention, is the equivalent of YELLING -Things that are generally unacceptable}...
                    See more | Go to post
                    Last edited by zmbd; Dec 23 '13, 06:43 PM. Reason: [z{Please do not YELL at us, thnx}]
                    • moonrb
                      started a topic how can i prevent users deleting the record when they are viewing datasheet view
                      in Access

                      how can i prevent users deleting the record when they are viewing datasheet view

                      Hi
                      Every one
                      how can i prevent users deleting the record but edit on table when they are viewing datasheet view through "SELECT QUERY"

                      I am using user & password table with VB CODE for securing the database.

                      thanks In Advance
                      See more | Go to post
                      • moonrb
                        started a topic How to prevent saving data on form in access 2003 when user clicks close button?
                        in Access

                        How to prevent saving data on form in access 2003 when user clicks close button?

                        Hi.
                        Can any one tell me----
                        how to prevent saving data on form in access 2002 or 2003 when user clicks close button of the window or during abnormal shutdown ?
                        See more | Go to post
                        • moonrb
                          started a topic How can i disable mouse scroll wheel in access2003?
                          in Access

                          How can i disable mouse scroll wheel in access2003?

                          How can i disable mouse scroll wheel in access2003?
                          See more | Go to post
                          • moonrb
                            started a topic How can i solve the problem?
                            in Access

                            How can i solve the problem?

                            Hi
                            I am making a database for a diagnostic lab.

                            I am using tables with field like below
                            TABLE1-DOCTORInfo
                            Name (value: Dacter x, Dacter y, Dacter z)
                            Address

                            TABLE1-DOCTOR x
                            FIELD-Percentege of TestX
                            FIELD-Percentege of TestY
                            FIELD-Percentege of TestZ

                            TABLE2-DOCTOR Y
                            FIELD-Percentege of TestX
                            FIELD-Percentege of TestY
                            FIELD-Percentege of Testz
                            ...
                            See more | Go to post
                            • moonrb
                              replied to Process of creating user account & password for ms access database
                              in Access
                              yes i am using access 2003. i do not know how to use "access security" plz explain.......
                              See more | Go to post

                                Leave a comment:

                              • moonrb
                                started a topic Process of creating user account & password for ms access database
                                in Access

                                Process of creating user account & password for ms access database

                                Hi.......i want to create two account & password for my access database. One account should have the right for operate the db & edit data only in case if wrong data posting but cannot delete the record or data. Other account should have all the rights including design changing of the db (that is me).

                                Plz give the proper suggestion.
                                See more | Go to post
                                • moonrb
                                  started a topic How to create setup file for ms access db ?
                                  in Access

                                  How to create setup file for ms access db ?

                                  I am creating a db with access 2003. I want to install it in other computer instead of copy the db file. How can i do this. I don't know any programming language. Plz give me an easy way to create set file for ms access database.

                                  Thanx.......... ..
                                  See more | Go to post
                                  • moonrb
                                    replied to How can i hide menu bar & restore it again?
                                    in Access
                                    Thanks a lot friend. Now it works.....
                                    See more | Go to post
                                    Last edited by NeoPa; Nov 14 '13, 02:26 AM. Reason: New questions must be asked in separate threads.

                                      Leave a comment:

                                    • moonrb
                                      replied to How can i relate one field in a table with an other field of another table?
                                      in Access
                                      THANK U SO MUCH
                                      BUT I CAN NOT UNDERSTAND THE BOLD PORTION BELOW. PLZ EXPLAIN


                                      (change names to suit - txt... refers to the name of the control on your form):
                                      1. Dim rst as Recordset
                                      2.
                                      3. set rst=currentdb.o penrecordset("S ELECT quantity FROM Stock WHERE [Product id]=" & txtProductID)
                                      4. if rst.fields(0)-txtQuantity<0 then
                                      5. msgbox "Only " & rst.fields(0)...
                                      See more | Go to post

                                        Leave a comment:

                                      • moonrb
                                        replied to How can i hide menu bar & restore it again?
                                        in Access
                                        Thanks to you friend. Actually I am new in MS ACCESS. I want whenever I enter in my database, menu bar should not show. Please tell me where should I place this code provided by you.....
                                        See more | Go to post
                                        Last edited by NeoPa; Nov 12 '13, 05:51 PM. Reason: Please don't use upper case (shouting) or text-style abbreviations.

                                          Leave a comment:

                                        • moonrb
                                          started a topic How can i relate one field in a table with an other field of another table?
                                          in Access

                                          How can i relate one field in a table with an other field of another table?

                                          I have two table named 'stock' & 'delivery' with following fields-

                                          stock-
                                          1.product id
                                          2.date
                                          3.quantity

                                          delivery
                                          1.memo no
                                          2.product id
                                          3.date
                                          4.quantity

                                          I need whenever i input value in 'quantity ' field of "delivery" table it should search automatically, is that quantity available in "stock" table or not. if not available,...
                                          See more | Go to post
                                          No activity results to display
                                          Show More
                                          Working...