Recent content by FlashMax

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.

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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

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...