This particular problem has been a long time coming for an answer. The goal is simple–Populate a PopUp menu with values from a SQL table, then select the value in that PopUp with a result from an SQL query. Here’s my solution:
You’ll notice that the solution is not clean. Is there a way to select a value in a popup based on the value of the item’s RowTag? NO! (If there is please let me know). What I wound up doing was store the value of ListIndex in the table and select based on the queried ListIndex.
I just got done with seven interviews with filmmakers at the Los Angeles Asian Pacific Film Festival. I had a blast. This is what I like to do. I love talking to people about what their passions are. I love to have real conversations about how people get things done. I love learning something new from anybody. Check back. I will be posting these interviews on my YouTube channel and playing them on the Geek Lab show.
I really hate breaking up synergy, but in this case, I thought it was the prudent decision to make. I’m pulling all of my personal interviews with filmmakers and centralizing it into one location. Primarily, because I need to create a more professional setting for these interviews and to let the art of independent filmmaking stand on its own.
I created the Independent Film Talk channel on YouTube. I’m pretty sure I’ll have to change the name down the road, but here is a one-stop shop for my discussions about independent films and independent filmmaking. Enjoy.
Adobe has added a fantastic new application for easily creating animation. I’ve been a long fan of animation and this tool helps create fast talking-heads animated shorts. Here is an example me interviewing the cast of Star Wars. I went through the process of creating a caricature of myself, draw it in Illustrator and adding the necessary mouth positions.
As you know, I’m currently producing a sketch comedy show for local television called The Real Rejects of Orange County. Here’s a valuable lesson I learned about the editing process. If you want to have your video edited cheap, do it yourself. If you want to have it done fast, pay someone to do it.
I’m currently in the process of learning Premiere Pro. I’ve dabbled with it for a few year, but this is the first time I am learning it with the intent of producing something professional. Editing requires patience, endurance and the ability to fight the urge to end a project before it is done, only because you’ve seen the same thing a hundred time.
Well folks, being a writer and comedian does not pay all the bills. A new opportunity has been placed before me. It utilizes the skills that I learned long ago at the credit union. It requires me to learn two data applications: XOJO and Filemaker Pro.
I tried the demo to both and my thoughts are XOJO is Visual Basic and Filemaker Pro is Access. So the learning curve for both programs is good. I’m documenting my journey learning both software packages.
I am learning XOJO first. Why? Because it is harder to learn and less expensive to implement. This is my first taste of XOJO.
If my life is not busy enough, I just gave birth to a new podcast called “FIVE Things That Changed Your Life.” I serve as the podcast’s producer and occasional voice in the background. My friend, Loren Kling, serves as the host and he talks to people about the FIVE Things That Changed Their Lives. It is currently available on iTunes and Google Play. We should be on Stitcher any day now.
The first episode is available now and features Film Expert and TV Host, Chris Gore.