Search results

I can now control access to a subform with a simple OnActivate command: Secure(Me.Name) which executes: Function Secure(AForm As String) 'This routine runs a procedure to set the Access Level for any form Dim Var1 'Security Access Level Dim SubForm As String...

This is the code I needed! I send the variable to the function as: MyFunction(Form.Name) The function then creates the subform name: SubFormName = Form.Name & "_SubForm" then use: Forms(FormName).Controls(SubFormControlName).Visible = False to control whatever feature I want to control. I...

That worked! But how The reason for this is to create a function which can be used in many different forms to control access to a given form.subform; if I can use a variable to call out the form.subform then a cleaver naming convention can make this possible.

In the OnActivate function of my form I have the following statement: Forms!IP_Log.IP_Log_SubForm.Visible = False how do I replace IP_Log.IP_LogSubForm with a variable? IP_Log is the Main Form IP_LogSubForm is the SubForm Name

I have formatted the date using CDATE, but the graph continues to put my dates at 1/1/00; It clearly recognizes my dates as a value of 1. What else can I try?

I think you are correct about needing a restart. Just trying to be fancy.

To secure my database, I disable "Allow Full Menus" from the "Access Options". As I develop the database I want to press a button from the secure database which will turn the menu back ON and allow me into "Access Options". I've already used: DoCmd.ShowToolbar "ribbon", acToolbarYes...

A few years ago? You use a geologic calendar?

New Here but long time developer. Working with SQL Server now so new learning curve.