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 23 2012, 03:59 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 7,591 From: South coast, England |
Hi Aqua
I go with Doug's suggestion, and have used this in the past to do the same: CODE Public Function UpdateAllFormsProp() On Error GoTo err_proc Dim srcFrm As Object Dim strFrm As String For Each srcFrm In Application.CurrentProject.AllForms strFrm = srcFrm.Name DoCmd.OpenForm strFrm, acDesign Set srcFrm = Forms(strFrm) With srcFrm .SomeProperty1 = SomeValue1 .SomeProperty2 = SomeValue2 End With DoCmd.Close acForm, strFrm, acSaveYes Next srcFrm exit_proc: Exit Function err_proc: MsgBox "Error in Function: 'UpdateAllFormProps'" & Chr(13) & Err.Description Resume exit_proc End Function Obviously changing .SomeProperty1 = SomeValue1 .SomeProperty2 = SomeValue2 as appropriate hth This post has been edited by pere_de_chipstick: Feb 23 2012, 04:01 PM |
|
|
|
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
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
pere_de_chipstick Aqua - glad you got it sorted, and Doug, thanks fo... Feb 24 2012, 03:21 AM![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 25th May 2013 - 12:13 PM |