I have a subform and I have checks I want to do when the user clicks anywhere off of the subform and I am using OnDeactivate.
The problem is the OnDeactivate won't trigger when I click on the parent form or another subform.
I even tried OnlostFocus and it doesn't work either.
Private Sub...
Hello,
The runtime error 3001 is being generated on the line ADOrs.lockType = adLockReadOnly I have tried several of the locktypes and they are produce the same error. I can't seem to figure out what I am doing wrong. I am using late binding so I can learn how to do this.
Public Sub ADOtest()...
theDBguy, thank you for pointing me in the right direction I appreciate your help.
I edited the code to the below and it worked.
InttxtMCID = Nz(txtMCID, 0)
strtxtMemberId = Nz(txtMemberId, Null)
Set db = CurrentDb
'Fetch and populate the Member information on the form
strSQLMember = "SELECT...
I tried the below but still get the same error.
The way the form is set up the user can enter either a MCID or Member_Id which means one field or the other can be null, does that matter?
strSQLMember = "SELECT * FROM dbo_vw_RAA_Member_Information WHERE [MCID]=" & txtMCID & " or [Member_Id]= '"...
Below is the query I have built and it runs fine if I just filter Where MCID= txtMCID but fails when I add the OR Member_Id = txtMemberId.
txtMCID is a integer and txtMemberId is a string.
strSQLMember = "SELECT * FROM dbo_vw_RAA_Member_Information WHERE [MCID]=" & txtMCID & " or [Member_Id]='"...
Hi All,
I have a form that contains two subforms.
I want the user to be able to double click a field in subform 1 and have it send textbox values to fields in subform 2.
I wrote the code below but it's not working correctly. It captures the global variables and sets the focus to subform2 but...
All,
We recently had some users upgrade to Windows 10 and it's causing the font on graphs displayed on a form to shrink and become illegible. Any idea how to resolve this? Any help is appreciated.
that was very helpful! thank you
I ended up using this:
strCS = "=(""https://collaborate.wellpoint.com/sites/cra/SitePages/Forms/RecentChanges.aspx"")"
Me.WebBrowser7.ControlSource = strCS
All,
I have a label on a form (Frm_Main) that when clicked I want to Requery a webBrowser control on a tab control (TabMain) on the Frm_Main.
Below is my code and when I execute I get error runtime error 451 "property let procedure not defined and property get procedure did not return object"...