When table is on a sql server

[alvin Kuiper]

Hi
My table is on a sql server ,
all works fine, but in a form i have to make a newrecord
i want to say that my date field in my table shall be

date()

if i work just in access i can make this in my table
but how can i do this when my table is on a sql server.
Reagrds
alvin

 

[Jeff Boyce]

Alvin

I can't be sure, but it sounds like you are using a query to check if the
value in your table is greater than today's date. You can do that in an
Access query just the same way you would with an Access/JET table (with ">
Date()" in the Criteria under the field).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Duane Hookom]

It sounds like you want to create a validation rule in a table linked from
SQL Server. You can do this through the SQL Enterprise Manager or just do
all data entry through forms and set validation on the control.