Search results

Hi all, Can I call a specific switchboard page from VBA? I can open the default switchboard form itself using code docmd.openform "switchboard" The switchboard page I am trying to open has a switchboardid = 2 and I have trIed to use this condition in the code DoCmd.OpenForm...

Thanks MR B. I have not created customized shortcut menu's in 2007 or later and it looks like I'll need to use code. Do you know off hand the edit hyperlink control ID?

Good morning all, I have developed an application using Access 2010, with numerous forms which I have locked down so users cannot get access to the design section of the app, using the toolbars However, one part I overlooked is if a user right clicks anywhere on the form, they can access the...

Apologies JZ, I've made a very amatuerish mistake :( Your debug code printed exactly what I have coded for the listbox rowsource, so it was right but the variable name for MMDBID was incorrect and I have just remembered that I changed this from MMDBID in an earlier version of the app. I...

I'm not sure if my table relationship has any bearing on this but I though I should let you know I have 4 tables - 3 in a one-to-one relationship - realted by primary ID's MMDBID (tblFundAddEdit, tblContactAddEdit, tblWiresAddEdit) The 4th table is tblcodes and is in a one-to-many...

Many thanks for your reply JZ Unfortunately the code amendments is forcing an input box "input parameter value" when the form opens and I have to enter in the ID. Once entered the listbox populates. I removed the code from the form current code section and placed it behind a command...

Good afternoon all, I have added a listbox to one of my "edit" forms and I have set the rowsource in the form_current code section to retrieve data from a table based on the value in a form field List174.RowSource = "SELECT tblCodesAddEdit.Auto, tblCodesAddEdit.[IOE Code]...

Good afternoon all This one may be for the forms section so please feel free to move to teh correct forum. I developed an access db application for an end user in work, which consists of 6 tables and two forms. The form I have a problem with consists of 3 of the tables, in a one-to-one...

Hey Gemma, thanks for the input! After stepping through the code from what I could see it wasn't recognizing the first checkbox of the AND statement as True After amending the code to If me.Editing = true And me.Closed_Fund = True Then Status.Caption = "Pending Approval - Fund Closue"...

Hi Bob, Many thanks for your reply. The code itself is already in the On Current section of the forms code and the default view is Single Form and not continuos I changed the Datasheet view to No, bit unfortunately the code still does not work. I have just tried referring to the...

Hi all, As simple as this seems, this is giving me the run around!:banghead: I have 3 check boxes in a table and form associated. Based on the values of these checkboxes, and different combinations, other controls become active or inactive. This is working fine for me in the form on...

Thank You New code Dim ctrl as control For Each ctrl In Forms!frmlfund!SubFormWires.Form If ctrl.ControlType = acTextBox Then Forms!frmlfund!SubFormWires.Form.Controls(ctrl.Name).ControlTipText = Nz(Forms!frmlfund!SubFormWires.Form.Controls(ctrl.Name).Value, "") End If...

Apologies for the repost - My previous thread was bombed and I was directed to this location by a mod http://access.mvps.org/access/forms/frm0031.htm After reviewing the above thread I have got this far with referring to the subform. But I am getting a property let and get failure message...

:banghead: Thanks Moishy!! no need for the setfocus line and .text stSubject = "MM Investment Application Approval Required Change:- " & [Forms]![frmaddedit]!tblFundAddEdit_Uptix_Code & " / " & [Forms]![frmaddedit]!tblFundAddEdit_Investment_Name Thanks for the other inputs also

Hi Paul, without the setfocus access gives out as soon as the code is stepped through Error Run-time error '2185': You can't reference a property or method unless the control has the focus Here's my public email function I am calling. The two lines I am interested in are in red, not too...

Hi all, I'm looking to reference to fields on a form when sending an email using code. One field works fine once it has the focus but then trying to reference the second field I run into problems. I could create another text box on the form and allow it's value to equal the two values of...

Unfortunately not. Adding a new text box to the form no options were available. After looking at this with a fresh pair of eyes this morning I found the problem Part of my macros, modules, and switchboard startup, I have code in place to hide the entire MS Access window. I want to avoid...

Hi all, Im about to release a small app and after some testing I have found that my hyperlink options are not available, when the field is right clicked - see attached screenshot I have removed all security features (Tools Startup), code from the form_load and form_current - but this issue...

Thanks again JR. That code works as far as the open mail. strEmailAddress is being given the correct data, ie the email address based on combo box selection as I can ouput the strEmailAddress data to a text box As soon as the email is opened there is nothing in the "To" box. I've used...

In addition to the send email function I am trying to use a value of a combo box to look up an email address based on the email table. I have added the following code to the code in my first post Dim strUser As String struser = Me.cboEmailSelect.column(1) Set rst =...