I agree with kbuc6. I display some visual indicator on the form showing that the field is mandatory (ie asterik, bold label, symbol, etc...) I also validate all information when the user attempts to save the information. If any fields are blank, or the information is invalid, I take the user...
First of all, create a parameter field in your sub-report for the date. Then in you main report, right click on the sub report and select Change Subreport Links menu item. Mapp the date field in the main report to the parameter field you just created. A report selection formula will be built for...
Call this subroutine on startup. Pass the userid, password and database server name. You could also use Microsoft's OleDB for Oracle driver. If connection is not successful, application ends. Be sure to close your connection when the application ends. (gCnn.Close)
Public Sub sExecuteLogon()
Dim...
Try .LogOnServer "pdsodbc.dll", "server", , "userid", "password"
I use this when accessing an Oracle database.
Also, are the users mapped to the same drive as you are for the report location?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.