User Profile

Collapse

Profile Sidebar

Collapse
buddydasari
buddydasari
Last Activity: Jan 30 '09, 08:53 PM
Joined: Mar 9 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • buddydasari
    started a topic how to lock mouse wheel
    in Access

    how to lock mouse wheel

    Hi
    I want to lock the mouse wheel cause scrolling takes to next record in my application.I tried to find online but no use.I found some article
    http://www.lebans.com/mousewheelonoff.htm
    but i don't want to use thirdparties.

    Is there any other way to implement it?Is it difficult to implement one?

    thanks
    Sree...
    See more | Go to post
    • buddydasari
      replied to Insert DISTINCT Records
      in Access
      DonRayner
      But my query is in the coding part and moreover its not a selection query its an insertion query.


      thanks
      Sree
      See more | Go to post

        Leave a comment:

      • buddydasari
        started a topic Insert DISTINCT Records
        in Access

        Insert DISTINCT Records

        All

        I want to run an insert query to insert new records but only distinct one's.Is there any direct query syntax to do that.I have an idea to write a function to check the records one by one but that will be cumbersome if dataset is large.any other ideas??


        thanks
        Sree
        See more | Go to post
        • buddydasari
          replied to ListBox On Click Event
          in Access
          All

          Got it worked using listbox.listInd ex property instead of listbox.Selecte d property on OnClick event


          thanks for ur help
          Sree
          See more | Go to post

            Leave a comment:

          • buddydasari
            replied to ListBox On Click Event
            in Access
            missinglinq

            I tried that too.Didn't work either.the listbox.selecte d returns false in any event except in double click evnt.

            thanks
            Sree
            See more | Go to post

              Leave a comment:

            • buddydasari
              started a topic ListBox On Click Event
              in Access

              ListBox On Click Event

              Hi all

              I wrote a listbox onclick event.On a click i want to get the selected row details but the listbox.selecte d(i) always returns false ,it returns true only in
              double click event.Are they any other events on which i could do this.I want to populate a textbox based on the row selected from the listbox.Its working as i want when i add the code in a double click event but it doesn't make much sense doing it on a double click...
              See more | Go to post
              • buddydasari
                replied to ListBox Row Click Event
                in Access
                Megalog

                I tried to use the command

                DoCmd.OpenForm "Individual_Inf o", , , "[UserName]='" & rs!UserName & "'"

                and i get this error on double click

                "run time error 2491 :the action or method is invalid because form is not bound to table/query"

                any idea what i am doing wrong??

                thanks
                Sree
                See more | Go to post

                  Leave a comment:

                • buddydasari
                  replied to ListBox Row Click Event
                  in Access
                  I laid out a basic prototype and it seems to work on the double click event but i still have to do some more background work to populate the form details which i can do.

                  thanks for your help
                  Sree
                  See more | Go to post

                    Leave a comment:

                  • buddydasari
                    replied to ListBox Row Click Event
                    in Access
                    Megalog

                    Yes UserName is the primary key.Its the same as the email id without the domain name so its always unique(somethin g like for outlook exchange).

                    thanks
                    Sree
                    See more | Go to post

                      Leave a comment:

                    • buddydasari
                      replied to ListBox Row Click Event
                      in Access
                      don

                      thanks for the help.i'll try that.

                      Megalog

                      i am populating employee info in the list box and each record refers to one employee.What i am trying to do is open the selected employee details page/form when i click on the particular record/row.I have Employee Last Name ,First Name ,UserName(prima rykey),Email in the listbox.I want the specific form to be opened on some double click event rather than a single...
                      See more | Go to post

                        Leave a comment:

                      • buddydasari
                        started a topic ListBox Row Click Event
                        in Access

                        ListBox Row Click Event

                        Hi all

                        Is there any event for list box row click/double click.I want to open a new form based on the row selected and when it is clicked.I know there's one for the whole list box but i am looking for a row click event.I want to know if there is such an event or any other way to implement this.


                        thanks
                        Sree
                        See more | Go to post
                        • buddydasari
                          replied to Displaying search results in a list box
                          in Access
                          oops

                          got it working.its the ' * ' thing instead of ' % ' in Like operator.
                          God this took me 4 hrs..cause one version with ADODB record set works with ' % ' and basic vba works with ' * '
                          See more | Go to post

                            Leave a comment:

                          • buddydasari
                            started a topic Displaying search results in a list box
                            in Access

                            Displaying search results in a list box

                            Hi All

                            I am new to VBA also have little knowledge of access.I am trying to write a search app. which searches the table based on some criteria(combo boxes) and displays the results in a list box(everything in a single form).I wrote the event procedure for this and set the listbox.RowSour ce to the query(its a dynamic query build from the search criteria)

                            I know the query works cause i've tested that but i cannot figure...
                            See more | Go to post
                            • buddydasari
                              started a topic Kegg webservice-using perl
                              in Perl

                              Kegg webservice-using perl

                              I am trying to generate images for pathways of an organism using the kegg webservices.I have to color the nodes according to my choice but it is giving the default colors in the image,Want to know how to hide these default values..I am using the method 'get_html_of_co lored_pathway_b y_objects(path, obj_list,fg_col ors,bg_colors)' provided by kegg web service.It has to color the graph according to the bg_colors list but it it is not .help me if you know...
                              See more | Go to post
                              No activity results to display
                              Show More
                              Working...