When table is on a sql server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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()
Click to expand...
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
 
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/
 
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.
 
Back
Top