Recent content by stevethefiend

hi moonshine, what you said is basically the same as what i was attempting in the first place (and didnt work). Sub DBConnectionExecute(CommandText As String) 'Main Use: Delete Or Update Statements, SQL String Set conn = Nothing <-------why do you need a connection Set cmd = Nothing...

very sorry guys but i have solved my own problem! rather than saying : Dim cmd1 As ADODB.Command Set cmd1 = New ADODB.Command cmd1.ActiveConnection = CurrentProject.Connection cmd1.CommandText = StrSQL cmd1.Execute i just say: docmd.runsql (strsql) i shouldnt need to do it this way and would...

Hello, i am having some issues with an sql statement not running that has been built upo dynamically in code: Private Sub cmdSave_Click() Text8.SetFocus StrDescription = Text8.Text Text10.SetFocus StrParent = Text10.Text Text12.SetFocus StrPIN = Text12.Text Text14.SetFocus StrDWG = Text14.Text...