Recent content by JamesM

Hi, I think this is what you are after in form FrmProj_ProjectEntry_Sub1 on event AfterUpdate for field txtDueDt Private Sub txtDue_AfterUpdate() Me.txtDueDt.Value = Forms("Main_Form").txtDueDT.Value End Sub James

Hi, I think you may have to have 2 unbound combo boxes. make cboName row source = Select Name from Table make cboID = Select ID from Table Make both combo boxes restricted to list Below is the code you could use '----------------------------------------------------------------------...

Ok, the only other thing I could think of is a permission issue? Group policy or someting not allowing the database to access a required reference? But if you can open the form editor and save and that fixes the problem I am just as baffled as you? Have you done a compact and repair? Do you...

Hi, Are you all running the same version of access? I am suspicious that there may be a reference to a dll where an entry point may be different? Could you check in the VBA editor on the client machine and make sure you are both using the same libraries? Maybe when you changed something you...

This should help http://office.microsoft.com/en-au/access-help/i-see-name-displayed-in-a-control-HA001181447.aspx

Hi, All you need to do is set the datasource of your form to [YOUR_TABLE_NAME] on the properties data tab in design view and set each of the text boxes and combo boxes control source to the field name you want the text/combo box to represent. Cheers James

Hi, Here is an example of what I think you are tring to do. Main form with 2 subform controls sfc1 and sfc2 It gets a value from a subform sfc1 that has a datasheet list of records and updates sfc2 datasheet records with the field one value of sfc1 Private Sub btnCopyVal_Click() 'This...

Hi access2010, A little more information will help resolve this. Are you talking about a right click menu on a subform? What menu?

I want to thank everyone that assisted on this thread!!! I have found what is causing the null object Application.VBE.ActiveCodePane.CodeModule I was using this to get the current class that was running when the log was fired. The log variable was always initialized and was a red herring...

Hi lagbolt, I am still getting a the exact same error! I have created the dummy hidden form with get property of my logger class and also created the property of my hidden form so it ensured that it was accessible. Once again on first load all good, then as I click a button that calls the...

I'll give that at try Thanks so much :)

Thanks lagbolt, So do, I create a form called say "frmAppLogger" and I open as hidden when database starts Inside "frmAppLogger" I create a property that creates and instance of my AppLogger class 'frmAppLogger Private m_appLogger as AppLogger Public Property Get MyAppLogger as...

Hi If want to parse information form one form to another you could use the openargs property 'Long Term goal Form Private Sub btn_onclick() Dim iID as Integer iID = Val(me.ID_TEXTBOX.value) DoCmd.OpenForm "frmShortTermGoal", OpenArgs:= iID End Sub 'Short tem goal form...

Thanks, but my all is fine when I am using the vba editor? I add a watch on public variable and it stays set? As soon as I close the vba editor and reopen the database the variable is just empty after first initialize?

Ok, So I am running my access db from my c: I have a main form that loads. This form has subforms with subforms in them.. I have a module called "Globals" with a public variable declared Public log as AppLogger I have a Class Module called "AppLogger" This class has public functions that...