I say if you like to watch sports or movies, then go with a plasma. If you're going to do more gaming, go with an LCD. They both have a great picture though and if it comes down to price, then for the same size tv, the plasma will be a little cheaper but the prices are equalizing. If you want great bang for your buck, go with the Panasonic THPZ50... (somthing like that). A 50", 1080p can be had for a little over a $1000. Pioneer's are great also, but you'll probably have to shell out twice as much. For LCD's, I like the Sharp's they seem to be pretty good, but I don't know anyone who has it. The picture on the Samsung LCD's look great, but again the price is a yowza.

Thanks Dave that was exactly what I needed. I think every google search I tried had 'view' in it and that must have been my big problem. I've posted the new code below: Dim db As Database Set db = CurrentDb Dim curSQL As String Dim qrynam As String For Each qrydef In db.QueryDefs qrynam = qrydef.Name curSQL = qrydef.SQL MsgBox "sql name: " & qrynam & Chr$(13) & "sql view: " & curSQL Next

I need help figuring out how to display the sql view of a query using VBA. I have an Access 2003 database that contains a little over 300 queries. Yikes! I know in Access you can open a query in Design view and then change the view to SQL view so that you can actually see the Select statement. Instead of doing that more than 300 times to cut and paste the query statement, I would like to write a quick macro to display the information. I was able to figure out how to loop through all my query objects and display the name, but I can't find a way to actually get at the sql view of the query. Below is the code I have: Dim obj As AccessObject Dim dbs As Object Set dbs = Application.CurrentData For Each obj In dbs.AllQueries MsgBox "sql view: " & obj.FullName Next obj When I watch the obj data, there isn't any properties for the sql view. I thought this information would be in there. Am I misunderstanding what this object contains? It seems like I'm pretty close because I'm able to see the name of all the queries I have in my DB. What crucial piece of information am I missing? Thanks, FMPol