Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. FlashMax

    Help with "anti" Join

    Thank you so much for being patient with me. That worked perfectly. I'm not sure if one is preferable to the other as far as speed goes, but I think that I like the simplicity of the NOT EXISTS. In my quest to learn SQL I will try to take as much from those two examples as I can.
  2. FlashMax

    Help with "anti" Join

    Based on a little research, this is what I tried (but it didn't work): SELECT * FROM all_orders OUTER WHERE NOT EXISTS ( SELECT * FROM joes_orders INNER WHERE inner.order_ID = outer.order_ID ); I'll keep trying different things, but if anyone could tell me where I'm going wrong, I would...
  3. FlashMax

    Help with "anti" Join

    Well, this is not the actual layout or purpose of the tables, but it is a comparable example. For any possible future legal reason I'm not too comfortable giving the actual tables. However, for the purposes of my question, the example I gave is identical in theory to the actual situation...
  4. FlashMax

    Help with "anti" Join

    I'm having a bit of trouble with conceptualizing this problem. I'm pretty new to mysql and I'm working on my first large-scale project. Here's what I'm trying to understand. I have a table that keeps track of all orders. Then, each person can add one of those orders to their table. When...
  5. FlashMax

    Simple Table Organization

    This is a simple question for seasoned vets, but I am new to database programming. I have a table for cake orders and a table for cupcake orders. I had to split the two because the table columns are completely different (e.g., I have different requirements for the different orders). However...
  6. FlashMax

    VBA Access Table Passwords?

    I have been a programmer much longer than I have been a database developer. I see the error of my way. As I suspected--and your "harsh" words echo--I didn't even know how to approach the idea; however, that is mostly because I don't know much about Access. I thought that it might be a good...
  7. FlashMax

    VBA Access Table Passwords?

    TheAceMan1, I have uploaded the file to 4shared: http://www.4shared.com/document/BMtSEg5H/timesheetDB.html I have created a very simple version, but for the most part it is what I want a larger version to look like, except with more queries and reports. Basically, the structure that I want is...
  8. FlashMax

    VBA Access Table Passwords?

    Thank you very much TheAceMan1. That looks like the perfect solution. I just have one problem. I am very proficient with many different languages but VBA is not one of them. I really feel bad for asking--I don't want you to have to put forth more effort in correcting my ignorance than you...
  9. FlashMax

    VBA Access Table Passwords?

    Two parts to this question. 1) Can you create VBA for a table only? 2) Can you create a form in VBA on a table that will only make the table visible if the correct password is entered? Reason: I need to make certain tables viewable to only certain people. I've created tables that my employees...
  10. FlashMax

    Playback doesn't stop on 1st scene

    It sounds like you are only stopping the menu from continuing, not the entire scene. Put your stop() in the scene, not on a MC.
  11. FlashMax

    Two Scenes

    I was thinking that if you put a stop() on the first scene, and then on the end of the text exploding effect put a gotoAndPlay() with the scene name for scene two as the reference, that that will work. Then at the end of scene two you will need to also put a stop(). That way the text effect...
  12. FlashMax

    using one button to play two scenes??

    If you press buttonA and you always have the same sequence, like, scene 4 then scene 8, then on the last frame of scene 4 put a gotoAndPlay() function. Inside the gotoAndPlay() function use a scene name to refer to scene 8, instead of the number. This way if you ever add scenes or delete scenes...
  13. FlashMax

    Alias issue using "this"

    The first brackets do not require the leading dot syntax, as in _root[myInstance]. However, after that, especially when referring to functions of and properties of myInstance, you would use the dot notation. The same as in _root.myInstance._x. I think that in their example they are not referring...
  14. FlashMax

    Video in Flash

    Set the swf file _alpha to 0 on load. Then increment the _alpha until it is 100.
  15. FlashMax

    Alias issue using "this"

    The dot syntax replaces the [] syntax. They are synonymous. If you us the brackets to refer to an instance, then you don't use the dot, as in _root[myInstance]. However, if you refer to a property or function of myInstance, and still want to use the [], then you also use the dot, as in...
  16. FlashMax

    Can i do this with scenes???

    What I suggested is the easiest possible solution to what you are requesting. If you run a normal preloader to make sure that all of your frames are loaded, you can start the animation of the doors opening upon the conclusion of the preloader. If you made the doors sequence a movie clip with the...
  17. FlashMax

    Can i do this with scenes???

    I would advise not doing it with scenes. I would put the underlying website on a lower layer than the doors animation, but on the same scene. The doors opening won't affect your website that hides underneath. After the animation has run for the doors opening, I would have the rest of the frames...
  18. FlashMax

    Making my lines form a box with actionscript

    It really depends on how the lines move to form the box, and if the cross and box are 2D or 3D. If the cross and box are 2D and the horizontal line of the cross splits into two lines, then you could make each line a MC, and slowly progress the lines to their final destination. You would also do...
  19. FlashMax

    How do I get movie events to work at certain frames?

    The _root is the main timeline. Let's say that your movie clip is called box. On frame 1 of the main timeline, type in: box._visible = false; Now on frame 10 type: box._visible = true; Make sure that your movie clip is on the stage of the main timeline, and you have given it an instance name...
  20. FlashMax

    How do I get movie events to work at certain frames?

    You need to add the actions oldnewbie suggested in the frame that you want the movie clip to become visible.

Part and Inventory Search

Back
Top