Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Validate one field based on two other fields?
txtField3_LostFocus() If nz(txtField3,"")="" AND _ txtField1 <> txtField2 then 'nz tests for Null and "" msgbox strMsg txtField3.SetFocus endif- dugbel
- Post #3
- Forum: Microsoft: Access Other topics
-
Validate one field based on two other fields?
txtField3_LostFocus() If nz(txtField3,"")="" AND _ txtField2 <> txtField2 then 'nz tests for Null and "" msgbox strMsg txtField3.SetFocus endif- dugbel
- Post #2
- Forum: Microsoft: Access Other topics
-
Access to AS400
I have solved part of the problem. AS400 didn't want a semicolon at the end of the SQL. Anyone know what I can do about the File DSN? -
How do I import .cvs data to access.
You can set up the csv as a linked Table or you can create a Schema.ini and link to it on the fly and pull the data in. There are quite a few articles in the MS Knowledge Base on Schema.ini files.- dugbel
- Post #2
- Forum: Microsoft: Access Other topics
-
Access to AS400
I am trying to connect to an As400 from Access to retrieve a recordset. I am using: Set ws=dbEngine.CreateWorkspace("ODBCWorkspace","","",dbUseODBC) stDNS="Name of DNS" 'Set up using ODBC Admin aplet Set db=ws.OpenDatabase("tempDB", , ...
