Recent content by Scott Oh

I would like to unlock my subform via my VBA code but I am getting an error message: Application Defined or Object Defined Error. My code: Forms!frmMain.Form.sbfrmCVOption3.Form.Locked = False I would appreciate any suggestions on how to unlock my subform. Thank you.

I have a field in my query titled "Exposure" with a criteria of "HFA". No problem running the query. However, I needed to get more out of my output and changed "Exposure" to "Exposure: DLookUp("exposure","tblReviewDetail","[tblReviewDetail].[ReviewName]='" & Replace(tblCusip!ReviewName," ' ","...

Bob, Your suggestion was right on the money. I appreciate your time and patience for all of my questions in this thread. Code works great now.

Bob, Sorry for the delay in responding but my work laptop simply crashed on Friday and I had to get a temporary laptop Monday morning to access this database. To further respond, I am very appreciative of your advise and starting to feel guilty to keep coming back for more. However... (you...

I appreciate your patience with this Bob. I have altered the code (minus the quote) and reinserted into my code but with this, the whole strSQL is now red. I understand the Char(34) equating to double quotes so the count of quotes would be 5. Would this be correct? strSQL = "SELECT TOP 10...

Bob, Thank you again for your patience in this. I feel that I'm following the directions but still coming up short on making this work. I've taken out the parems but getting errored out at the .RecordSource = strSQL line. My attempts at altering the code has not been successful. Can you...

Bob, gbnz, Thank you for your assistance with this code. Altering the code as you both suggested did in fact allow me to refresh my graph successfully. As with some threads, the answer brings up a few follow up questions that I hope you are able to comment on. What is the purpose of the...

Bob, I had a nice reply but got timed out. So much for creative writing skills. Here is the code that you requested. To elaborate, I am having a syntax issue on the HAVING line of my strSQL line. I'm hoping that the solution is something obvious but so far it is eluding me. Thank you...

I am scratching my head on this syntax. I am declaring strType to be one of three options. Then the variable strType will factor into the embedded query: strSQL. I would appreciate any assistance in this syntax issue. TY. Dim strType As String If strType = "Single Family" Then strType...

Chris, You are the man! The chart flows amazingly well. How you approached this is certainly above my VBA grasp and I look forward to using this chart project to increase my Access skills. To reply to your comments, most of what I was attempting to do was within my skill set.... obviously I...

Chris, You've been very generous with your time in helping me in this problem. I reviewed your reply db and feel that I am making this chart way more difficult than it needs to be. Since this approach is not working the way I had hoped I'm wondering if a different (and easier) approach would be...

Chris, Thank you for taking the time to review my chart issue and fixing the problem. Delaying the code was an option I would not have figured out. I am seeing that, for example, when I click the "bankruptcy" checkbox this shows a bar instead of a line (per the code). Would this be a function...

Chris, Here is a demo version of the database in question. I appreciate you taking time to review. I look forward to hearing your suggestions. TY

Chris, Yes the list for threads on SeriesCollection is certainly well represented here. In fact, I have managed to put together the lion's share of this code based on the suggestions of some very talented people here on this site. The problem is that I cannot seem to find any examples that fit...

Gizmo, Can you elaborate on what you mean by setting a reference? Perhaps give me an example so I can integrate into my code. Thank you.