Access97: How to set form defaults based on SQL Server defaults 
Author Message
 Access97: How to set form defaults based on SQL Server defaults
I'm writing a form in an app which has Acces97 as the front-end and SQL
Server v6.5 as the backend. When the user clicks on the Add button to
add a new record, I'd like the form to populate the controls based on
whatever the SQL Server table definition has defined for column
defaults.

Any pointers or sample code regarding how to do this would be greatly
appreciated.

Thanks,
Betsy

Sent via Deja.com http://www.***.com/
Share what you know. Learn what you don't.



Sun, 03 Mar 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. VFP: Setting default form/form element properties

2. Set default based on another fields of the table

3. Set Defaults for Many fields, Using Form/Code

4. Set/ Read Field Default Value of Access/ Sql Server

5. Setting defaults on a new record in a form

6. Need help to set the default date format in SQL Server

7. Set the SQL Server default date format

8. Basic question setting default dates in SQL Server Table

9. Setting Default Client Ptotocol on SQL Server 7.0

10. How can I set default views of forms?

11. SQL server smalldatetime default hour setting

12. Set Default Database in SQL Server 7.0 Query Analizer


 
Powered by phpBB® Forum Software