Search results

I am using a linked table into an Oracle database. I run a report which is based on a query on this table. If the user does not enter a valid username and password to access the Oracle database or cancels the ODBC password prompt, the event code continues anyway. How can I capture the cancel...

Is there a way I can save a report to file (pref using the OutPutTo method), prompting the user for a filename and directory location but displaying the file save dialog box with a default location. The users will mostly be saving files to the same location and it would be nice to avoid them...

I have a main form with a button which performs an action. The actio should only be performed if there are records in the subform (i.e. that there is at least one record relating to the record in the main form). Can anyone help me write the VB to do this check? I've tried all sorts of things...

I have some code which will set this property to false to prevent users from accessing the underlying database structures and menus using the SHIFT key. However, I need to specify some kind of key combination which will allow an administrator full access (as the SHIFT key would if it was...

I have a report comprising of several sub-reports. Each subreport has field labels as well as the data which are displayed when previewed separately. However, when placed as subreports within another report, the field labels disappear. I've looked everywhere for options that determine whether...