ColumnHistory syntax

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

Hi to all,

I am trying to use the ColumnHistory method but every time I alwasy get the
error 3075 syntax error ( missing operator ) in query .......

I have tried many different way to get the information but no luck;
ex1: me.text1.ControlSource = ColumnHistory("tblActionPlanned",
"OtherFutCancNotices", "IdBranch = 1")

ex2:me.text1.ControlSource = ColumnHistory([tblActionPlanned],
"OtherFutCancNotices", "IdBranch = 1")

ex3; me.text1.ControlSource =
me.Application.ColumnHistory([tblActionPlanned], "OtherFutCancNotices",
"IdBranch = 1")

I also tried the same syntax directly in the control source property of the
control and getting the same error.

Before I go insane ;), can anyone let me know what is the problem

Thanks
 
Forgot to mention that I want to build a popup report and assign the right
control source to only 1 textbox instead of building approx 20 different
report. It is working just fine now if I assign it directly to the control
source but I want to code it at the open report event.
 
Alain said:
I am trying to use the ColumnHistory method but every time I alwasy get the
error 3075 syntax error ( missing operator ) in query .......

I have tried many different way to get the information but no luck;
ex1: me.text1.ControlSource = ColumnHistory("tblActionPlanned",
"OtherFutCancNotices", "IdBranch = 1")

ex2:me.text1.ControlSource = ColumnHistory([tblActionPlanned],
"OtherFutCancNotices", "IdBranch = 1")

ex3; me.text1.ControlSource =
me.Application.ColumnHistory([tblActionPlanned], "OtherFutCancNotices",
"IdBranch = 1")

I also tried the same syntax directly in the control source property of the
control and getting the same error.
Click to expand...


Your control source expression needs an = sign and must be a
string:

me.text1.ControlSource =
"=ColumnHistory(""tblActionPlanned"",
""OtherFutCancNotices"", ""IdBranch = 1"")"
 
Thanks for the info

Marshall Barton said:
Alain said:
I am trying to use the ColumnHistory method but every time I alwasy get the
error 3075 syntax error ( missing operator ) in query .......

I have tried many different way to get the information but no luck;
ex1: me.text1.ControlSource = ColumnHistory("tblActionPlanned",
"OtherFutCancNotices", "IdBranch = 1")

ex2:me.text1.ControlSource = ColumnHistory([tblActionPlanned],
"OtherFutCancNotices", "IdBranch = 1")

ex3; me.text1.ControlSource =
me.Application.ColumnHistory([tblActionPlanned], "OtherFutCancNotices",
"IdBranch = 1")

I also tried the same syntax directly in the control source property of the
control and getting the same error.
Click to expand...


Your control source expression needs an = sign and must be a
string:

me.text1.ControlSource =
"=ColumnHistory(""tblActionPlanned"",
""OtherFutCancNotices"", ""IdBranch = 1"")"
Click to expand...
 
Back
Top