User Profile

Collapse

Profile Sidebar

Collapse
onyris
onyris
Last Activity: May 19 '10, 11:53 AM
Joined: Aug 12 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • onyris
    started a topic Using user input in a query to select different table
    in Visual Basic

    Using user input in a query to select different table

    Hi

    have this query which works ok now :

    Code:
     SELECT *
FROM [Table]
WHERE (((Table.published) Like '*'&[Forms]![Search_Records]![Combo7]& '*' And (Table.published) Like '*'&[Forms]![Search_Records]![Combo9]& '*' and  (Table.address) Like '*'&[Forms]![Search_Records]![txtcity]& '*'  ));
    and instead of using the default table which in this case is [Table] , i want to let...
    See more | Go to post
    • onyris
      replied to External XML into Flash (AS2)
      in Flash
      There is another option under File > Publish Settings >Local playback security > and set that to access network files only .

      Not sure if is your case , but it might help u.
      See more | Go to post

        Leave a comment:

      • onyris
        replied to Help with unload images from movieclip
        in Flash
        guys ..this is getting me crazy ..

        i have added a new button on the stage and i've placed the " unloadMovie ( thumbnails)"
        there .
        When the button is clicked its emptying the movie clip and is ok , then i click next and is loading the next images ,
        BUT if i place the code so that when i press next to empty the images ..is just emptying the movieclip and is not dispalying the next images WHYYYY...ANYONE...
        See more | Go to post

          Leave a comment:

        • onyris
          started a topic Mouse over action for a item in a list box
          in Flash

          Mouse over action for a item in a list box

          Hi guys , just a quick one, if anyone knows

          I have a listbox that contains some items .
          Is there mouse over action for that when i go over the item from that listbox to do something?

          Thanks.
          See more | Go to post
          • onyris
            started a topic Help with unload images from movieclip
            in Flash

            Help with unload images from movieclip

            Hi guys ,

            I have a problem trying to unload some images from a movie clip , not sure what i'm doing wrong , if anyone can help me please..

            What i have is a movie clip called " thumbnails" on the stage which loads some images from an array . the movieclip "thumbnails " , holds at the begining the first 4 images , then i have a button called "next_btn" which loads the next 4 images .basically...
            See more | Go to post
            • onyris
              replied to Help with arrays
              in Flash
              Hi guys , found a solution for that , for creating a 2d array
              basically this 2 lines of code , first creates the main array , then for each index of that arrya i assign more values for it .
              Not sure if this is the right way to do it , but it works for me .
              Code:
              images[i]=i;
		images[i] = [this.picHolder.attributes.title, this.picHolder.attributes.price,this.picHolder.attributes.main,this.picHolder.attributes.thmb]
              ...
              See more | Go to post

                Leave a comment:

              • onyris
                started a topic Help with arrays
                in Flash

                Help with arrays

                Hi guys ,
                I have got lost a bit with this flash i am doing at moment , i will try to explain the best i can and i'll post the code as well so u can see what i've done .
                I am using Action script 2, i have an XML with photos , at the moment are 7 photos in there. The code i have at the moment just simply reads from the xml all the photos adn display them in a movie clip .

                This is the code so far :
                Code:
                 step_sel_img.onRelease=function(){
                ...
                See more | Go to post
                • onyris
                  replied to Error passing string
                  in Access
                  My Macro is doing this at the moment:

                  OpenQuery - query to search
                  OpenForm - searched form [searched_form] (where i want to pass the string)
                  Close - query to search
                  Close - names form [names_form]
                  See more | Go to post

                    Leave a comment:

                  • onyris
                    replied to Error passing string
                    in Access
                    In design View of the Macro , i have a set of actions .

                    Can i use one of those actions to put the code in there and if yes which one do i have to use?
                    See more | Go to post

                      Leave a comment:

                    • onyris
                      replied to Display the number of records found
                      in Access
                      right , i have changed a bit , and on the List49 click event i have added this code:
                      Code:
                      Me![Label37].Caption = Me![List49].ListIndex + 1
                      It is working now.
                      See more | Go to post

                        Leave a comment:

                      • onyris
                        replied to Display the number of records found
                        in Access
                        Had a look again over the names and the code , everything is ok .
                        Why is it not working?...
                        See more | Go to post

                          Leave a comment:

                        • onyris
                          replied to Error passing string
                          in Access
                          Right , it makes sens now ,but the only problem is that behind the button i run a Macro which opens the Second Form.
                          How do i put the cod in there??
                          See more | Go to post

                            Leave a comment:

                          • onyris
                            replied to Error passing string
                            in Access
                            Still not working.
                            ??...
                            See more | Go to post

                              Leave a comment:

                            • onyris
                              replied to Error passing string
                              in Access
                              no . sorry now is this error:

                              you can't refference a property or method for a control unless the control has the focus.

                              and is pointing on this line
                              Code:
                              text = Forms![names_form]![txtname].text
                              See more | Go to post

                                Leave a comment:

                              • onyris
                                replied to Error passing string
                                in Access
                                Not working .
                                The same error again .
                                See more | Go to post

                                  Leave a comment:

                                • onyris
                                  replied to Display the number of records found
                                  in Access
                                  Yes , 100%.

                                  The code is in Form_current().
                                  this is the right place or it should be in the Form_load()?...
                                  See more | Go to post

                                    Leave a comment:

                                  • onyris
                                    replied to Error passing string
                                    in Access
                                    I have to say sorry again to NeoPa , tried to use the [code] tag ,but i can see that i got it worg again .
                                    Do u mind sending me a message explaing how to use those tags , please ,cose i don't want to be banned or something.
                                    Thanks , and sorry again!
                                    See more | Go to post

                                      Leave a comment:

                                    • onyris
                                      started a topic Error passing string
                                      in Access

                                      Error passing string

                                      Hi all

                                      Trying to pass the value from a textbox to another form and i get an error .
                                      The error is this :

                                      Microsoft Office Access can't find the field "|" referred to in your expression.

                                      What i have is a form called " names_form", with a textbox called "txtname" and another form called "searched_f orm" , with a label called "lbl_searchedte xt"
                                      ...
                                      See more | Go to post
                                      • onyris
                                        replied to Display the number of records found
                                        in Access
                                        I have added an "end if " at the end and is not giving any errors now , but is not displaying the number on the label.
                                        Code:
                                        Private Sub Form_Current()
If Me![List49].ListIndex = -1 Then
Me![Label37].Caption = Me.CurrentRecord
Else
Me![Label37].Caption = Me![List49].ListIndex + 1
End If
End Sub
                                        Anything wrong with the code?
                                        See more | Go to post
                                        Last edited by NeoPa; May 21 '09, 01:31 PM. Reason: Please use the [CODE] tags provided.

                                          Leave a comment:

                                        • onyris
                                          replied to Display the number of records found
                                          in Access
                                          Yes it is i've checked again.
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...