Recent content by bconner

  1. B

    On Deactivate

    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...
  2. B

    ADO Connection producing run time Error 3001 arguments are of wrong type

    That makes sense and I like the idea of creating a module and declaring all enumerations.
  3. B

    ADO Connection producing run time Error 3001 arguments are of wrong type

    Thanks for the information Galaxiom.....
  4. B

    ADO Connection producing run time Error 3001 arguments are of wrong type

    Thank you Isaac that worked! I appreciate your help...
  5. B

    ADO Connection producing run time Error 3001 arguments are of wrong type

    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()...
  6. B

    Solved Missing Operator error in VBA Query

    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...
  7. B

    Solved Missing Operator error in VBA Query

    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]= '"...
  8. B

    Solved Missing Operator error in VBA Query

    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]='"...
  9. B

    Send Text box value from one sub form to another sub form

    YES! That worked.. Thank you sir.. I am grateful for your help.
  10. B

    Send Text box value from one sub form to another sub form

  11. B

    Send Text box value from one sub form to another sub form

    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...
  12. B

    Upgrade to Windows 10 causing issues with Graphs

    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.
  13. B

    Accessing webcontrol on tab control

    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
  14. B

    Accessing webcontrol on tab control

    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"...
  15. B

    Reference Subform of Navigation form

    arnelgp, thanks for the quick reply your solution worked! marlan, thanks for the reference link this is helpful.
See more
Top Bottom