Hi everyBody,
I Want to know how can I change, or accede (from VBA) to the :
form -> Propriety -> Data -> Sourrce -> SQLCODE
In fact, I want to make dynamic my SQLCODE Query. So I want change :
SOURCE -> SQLCODE = SELECT [Forms name].[fields name] FROM [Forms name];"
To
'at each time I insert the name of the table
strSQL1 = InputBox$(TitreInputBox, "Acquisition of data"
SQLCODE= "SELECT [" & StrSQL1 & "].NumSugg FROM [" & StrSQL1 & "];"
So I want to know the syntax must I use to excute the SQLCODE
cordially
nadjib
I Want to know how can I change, or accede (from VBA) to the :
form -> Propriety -> Data -> Sourrce -> SQLCODE
In fact, I want to make dynamic my SQLCODE Query. So I want change :
SOURCE -> SQLCODE = SELECT [Forms name].[fields name] FROM [Forms name];"
To
'at each time I insert the name of the table
strSQL1 = InputBox$(TitreInputBox, "Acquisition of data"
SQLCODE= "SELECT [" & StrSQL1 & "].NumSugg FROM [" & StrSQL1 & "];"
So I want to know the syntax must I use to excute the SQLCODE
cordially
nadjib