Search results

I face a challenge of activating a hyperlink in a protected form. The link will only work in the unprotected mode. I set up this form with Text fields and Dropdown fields as well, so I need to protect the form. I tried to add the hyperlink in text fields and other fields but none of this work...

In form design, go to View/Tab Order and make sure the first field of your form is moved to the top of the Custom Order list. Mike

Can you not split up the report to 3 separate reports with different subreport format? You may run the query first to determine the Type and run the appropriate report depending on its value. If Type.value = 1 then docmd.open report "Report 1" elseif Type.value = 2 then docmd.open report...

Please put these codes in your form: Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo Error_Form_BeforeUpdate If IsNull(Me.Home_Tel) And IsNull(Me.Mobile) And IsNull(Me.Other_Tel) Then MsgBox "You must enter data in one of the contact information fields." Cancel = True...

I would put the codes in the Before Update event of the form. As soon as user moves to the next record, codes will run, poping up a warning message box advising user to enter data in one of the fields. Mike

odin1701, thanks for your help. That is a good simple alternative. I keep forms in a password-protected backend to allow an administrator to perform similar form functions plus other features not included in the frontend. Mike

I have splitted a database into forntend and backend. They share similar codes in their forms. However, I want to hide some fields when a form is loaded in the frontend. Instead on changing the code in the frontend, I want to use Conditional Compilation Constant as follows: 'Conditional...

pbaldy, It works. Thanks for enlightening me. Mike

I have a frontend and backend database put in a network drive where users can access to the frontend version which has tables linked to the backend. When I set up the link tables from the frontend to the backend, Access points to a local drive letter in my computer. For example, if I map the...

You may put these codes under the After Update Event of the lstNames list box. XYZID being the id in your name list. Private Sub lstNames _AfterUpdate() On Error GoTo Error_lstNames_AfterUpdate If IsNull(Me.lstNames) Then GoTo Exit_lstNames_AfterUpdate Me.RecordsetClone.FindFirst...

I agree with odin1701. However, if you really need to enter multiple lines in a text box, hold down Crtl and press Enter. Mike

For new contractor, you can trigger off opening of a form based on the table to allow user to enter phone, fax etc. Mike

Why don't you add a record "All Branches" in the source table of the combo box so that when this option is selected, it shows all branch locations. Mike

Thanks for the suggestion. I finally figured it out. if Crtl.ControlType = acTextbox then do something end if

I am trying to loop through all controls in a form and do something when a specific type of control is found. However, the control type is not a supported property. I did try to search the forum but without avail. I wrote the following codes which do not work. Hope someone can give me a hint...

Thanks Paul. It works like a charm. You are the best!

I received a "invalid qualifier" error on this code. Mike

Hi gemma-the-husky 1,2,3,4 are the number in the combo box control in the report. I tried your codes but got an "invalid qualifier" error. I enclose a test file for you to check. Thanks Mike

Hi guys, I have another issue. Since there are numerous controls on the report which require the same conditional formatting attribute, I want to create a Sub Routine for each control to call it. However, it does not seem to work for me. I got "type mismatch" error on ForeColor. Option Compare...

Thank you guys. I got it running. There is no default selection on the control properties for ".ForeColor", but I just hard coded it Me!ControlName.Forecolor and it works.