Search results
-
J
Access VBA Holding CreateObject in Memory
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...- jccrvb
- Thread
- Replies: 4
- Forum: Modules & VBA
-
J
Set SourceObject in VBA
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...- jccrvb
- Thread
- Replies: 3
- Forum: Modules & VBA
-
J
VBA SQL String from Controls on Form
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...- jccrvb
- Thread
- Replies: 10
- Forum: Visual Basic