My Assistant
|
|
Feb 23 2012, 02:43 PM
Post
#1
|
|
|
UtterAccess VIP Posts: 6,898 From: Earth... |
Hi My 'Utter Friend's, I'm sure some one has done this. When creating new forms for an app, its a pain to select like: Close=no Min/Max=no Etc, When creating new forms, I need a 'quick' way to select a form and change all the settings I need. Someone must have an idea.... (IMG:style_emoticons/default/iconfused.gif) |
|
|
|
![]() |
Feb 24 2012, 03:21 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 7,590 From: South coast, England |
Aqua - glad you got it sorted, and Doug, thanks for following through on my post (IMG:style_emoticons/default/thumbup.gif) (I'd taken an early night here!)
Looking through the code it may have been more robust to reference the instantiated form with it's own form variable, i.e. CODE Public Function UpdateAllFormsProp() On Error GoTo err_proc Dim srcFrm As Object Dim strFrm As String Dim frmOpen As Form For Each srcFrm In Application.CurrentProject.AllForms strFrm = srcFrm.Name Debug.Print strFrm DoCmd.OpenForm strFrm, acDesign Set frmOpen = Forms(strFrm) With frmOpen .AllowFormView = True .AllowDatasheetView = False .AllowPivotTableView = False .AllowPivotChartView = False .AllowLayoutView = False End With DoCmd.Close acForm, strFrm, acSaveYes Next srcFrm exit_proc: Set frmOpen = Nothing Set srcForm = Nothing Exit Function err_proc: MsgBox "Error in Function: 'UpdateAllFormsProp'" & Chr(13) & Err.Description Resume exit_proc End Function ' ' but as this is a bit of code that I only use occasionally and it works, I've never 'fixed' it! Cheers |
|
|
|
Aquadevel Setting New Form Properties When Designing New Forms Feb 23 2012, 02:43 PM
rbianco While I don't have any sample to shoot you at ... Feb 23 2012, 02:56 PM
Aquadevel Hi RB,
The template would work dor new forms, But... Feb 23 2012, 03:26 PM
Doug Steele Write a module to open each form in design view, c... Feb 23 2012, 03:30 PM
pere_de_chipstick Hi Aqua
I go with Doug's suggestion, and have... Feb 23 2012, 03:59 PM
Aquadevel Hi Pere & Doug,
I agree I need to loop thru t... Feb 23 2012, 04:55 PM
Doug Steele Look closer at Bernie's example. It's not ... Feb 23 2012, 05:08 PM
Aquadevel Doug,
Welp,
I've tried Pere's code again... Feb 23 2012, 06:57 PM
Doug Steele So what's the exact code you're using? And... Feb 23 2012, 07:15 PM
Aquadevel Doug,
CODE[/code]
Public Function Update... Feb 23 2012, 07:39 PM
Doug Steele Your syntax is incorrect.
CODE With srcFrm
.... Feb 23 2012, 08:15 PM
Aquadevel Doug,
I've been up to long!!!... Feb 23 2012, 08:19 PM![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 22nd May 2013 - 03:09 PM |