Recent content by jccrvb

THANK YOU SO MUCH!!!!!!!!!! Creating the extra instance of Excel was the problem!!!!!!!!!!!!! You rock!!!:)

Although ultimately I would need the file to remain open, I did add the “Close/Quit” lines to see if it released the file and still the same result..."EXCEL.EXE" still listed in Task Manager...I end process, reopen Excel and it is "recovered". What I am trying to do is let Access VBA create an...

The following code is the OnClick even on a form in my Access database. (I also show my public functions that are in Module1.) It works well the first time only. After the first time it runs, the excel file genereated by CreateObject is still in memory and either the KillFile function fails or...

I appreciate your reply, but it's a little vague? "me" usually refers to the current form, right? And is "sfrm" a variable? I want to set the source from another form not itself on open. In code behind a command button on another form that will open frm_main containing sub form frm_sub, I...

Hi, I have two forms: "frm_main" and "frm_sub". "frm_sub" in an unbound sub form on "frm_main". I would like to set the SourceObject of "frm_sub" dynamically in VBA behind a command button on another form. The SourceObject will be one of many forms in the database. Also on "frm_main", I would...

Hi Bob, Working great! I also added a "strFROM" that includes JOINS and a "strGROUP"! I can't thank you enough for your help...and I like this board too...I thank you for that too...

Hi Bob, Thank you so much. I just now got to looking at it. I thank you for the date code...I was just going to append that as part of the "WHERE"...but your way is much more clean and efficient. I do intend to remove the "*ALL*" UNION from the row sources, to be sure. I am going to read through...

Hi Bob, Here you go...I stripped as much as I could simply to make db smaller... Thanks, me

Oops...I am trying to put together the form and table now in a temp db...I am linked to a SQL server, have pw protection...etc...yikes!

Hi Bob... Set mydb = CurrentDb() On Error Resume Next DoCmd.DeleteObject acQuery, "test" strSQL = "SELECT * FROM tblScrubbedData " strWhere = "WHERE " If Not IsNull(Me.cbo_codeshare) Then strWhere = "[CodeShare] In (" For Each varItem In Me.cbo_codeshare.ItemsSelected...