Search results

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

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

Thanks for the information Galaxiom.....

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

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

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

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

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

Hi all, I am trying to reference a control on a subform of a Navigation form Below is the Hierarchy NavigationForm NavigationSubform ReportingForm cmbState (This is the control) Below is the code I entered into the Query where clause for State...

Hi All, I have an Access database that I want to distribute to a couple of end users. I want to create a connection that doesn't require I setup a DSN on their machines. They have access to the DB2 database. Below is some code that connects using a Pass-Through query however it uses a DSN...

Hi All, I have an 2010 Access db linked to sharepoint lists. I have a form users use to update the lists and when they click Save (code below) some users are prompted with the windows security dialogue box prompting them to enter their credentials. When they enter their credentials the security...

All, I have a 2010 Access Database with a Navigation Pane. When I click a Navigation Button to view another form I lose the position and record I was on in the first form. It's almost like the first form refreshed when I click the navigation button to view the second form. Is there a way to...

I am attempting the refresh links in an access db using the code below but I am getting the message can't find installable ISAM. Any help is appreciated... Dim db As Database Set db = CurrentDb strPath =...