Search results

I would agree with this statement but seeing it is defaulted to use it this way i am trying to find a solution without having to rewrite the entire database.

Here is what i have so far. Private Sub cmdPushToPID_Click() Dim sqlStirng As String Dim tableName As String Dim pidIDNo As String tableName = Form_frmPIDInfo.txtTableName pidIDNo = txtPIDid sqlString = "UPDATE [" & tableName & "] SET dbcode_ = '" & txtItemNo & "',shortdesc_ = '" & txtSDesc...

I believe I will be using it in VB. We will be using two as an output. I have a table where TAG_ is a column and then I have a table where it has Function_ and TAG_. What i am looking to do is if i change one in one table the other needs to change. I have it figured out where the concatenating...

Hi all, New to this forum but i am looking at a way to uncombine strings. I have this [function_] & "-" & [TAG_] as [Tag] I would like a process where it takes [TAG] and turns it into [function_] [Tag_] The [Tag] will always be 2 digits for [function_]. Is there a way to write it where you...