OK So no one that visits this site is up on MSChart.
So be it.
Here's a little trouble syntax problem I have with data access. Any help on this will be appreciated.
This ado call procedure is supposed to return records from the Holdings table if the accounts fields match the LIKE expressions, if the account has a current value and the returned records should be based on the Investor_Number.
The call works fine with the current value and the LIKE expression but for some reason it ignors the Investor_Number filter. I have verified that the frmStartPage.txtInvestorNumber is loaded with the correct Investor number. The textbox and data field are Integers.
adoAddCash.RecordSource = "SELECT * FROM Holdings WHERE (Description) LIKE '%MONEY%' OR (Description) LIKE '%Treasury%' OR (Description) LIKE '%Cash%' AND Current_Value > 0 AND (Investor_Number) = " & frmStartPage.txtInvestorNumber
adoAddCash.Refresh
Thanks in advance,
Dwight
PS Igot a new computer and even though I reinstalled my old xp pro, for some reason I can now issue Helpful Stars
DK
So be it.
Here's a little trouble syntax problem I have with data access. Any help on this will be appreciated.
This ado call procedure is supposed to return records from the Holdings table if the accounts fields match the LIKE expressions, if the account has a current value and the returned records should be based on the Investor_Number.
The call works fine with the current value and the LIKE expression but for some reason it ignors the Investor_Number filter. I have verified that the frmStartPage.txtInvestorNumber is loaded with the correct Investor number. The textbox and data field are Integers.
adoAddCash.RecordSource = "SELECT * FROM Holdings WHERE (Description) LIKE '%MONEY%' OR (Description) LIKE '%Treasury%' OR (Description) LIKE '%Cash%' AND Current_Value > 0 AND (Investor_Number) = " & frmStartPage.txtInvestorNumber
adoAddCash.Refresh
Thanks in advance,
Dwight
PS Igot a new computer and even though I reinstalled my old xp pro, for some reason I can now issue Helpful Stars
DK