Access Data Project

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

Mark A. Sam

Hello,

I am making an ADP app to distribute to companies so that they can enter
data directly into my web database (SQL Server). I need to be able to
filter the users data, but there are no facilities to store local data into
the data base and I can't link to a local table, so I thought I would hard
code the data into Global Constants and use functions to filter the table
data. However the views in SQL Server don't seem to accept the Functions
from by ADP database. Any ideas on how to accomplish the filtering?
Thanks and God Bless,

Mark A. Sam
 
For anyone with the same issue, I constructed and assigned the RowSource
query in the Open Event of the form.

Me.RecordSource = "SELECT TrucksLocal.*, CompanyID AS Expr1 FROM TrucksLocal
WHERE (CompanyID =" & getCompanyID() & ") ORDER BY UnitNumber"
 
Back
Top