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

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

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.

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

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

Hello Everyone, I am trying to get the Top 10 NPI's by State and By County based on the Current_Year_Members_Outreached. Below is the query I created but I haven't been able to verify if the results are correct because when I execute it runs and some results show but in the lower right corner of...

Hi All, I am getting error 2342 a RunSQL statement requires and argument Consisting of a SQL stmt when I try to run the below code. Basicall I am prompting the user using an InPutBox for a value then trying to run the query. Any idea why this won't work? strInPutBox = InputBox("Enter...

Hello All, I have searched all over the internet for a solution and now I am breaking down and posting my problem. I am trying to grab the username using the below code. This code works fine on my machine however when I send the db to another person it fails and produces the Compile Error...

Hi All, I am trying to get a Case Statement to evaluate multiple conditions. Example: below when I get diagnosis code 20400 and the age_at_diagnosis is 40 the code is basically ignoring the second condition of the Case "And rs![Age_At_Diag] < 18". How do I get the code to recognize both...

Hello, When I run the below code I am getting the error "End Select without Select Case" I figured it might be because I have the "End Select" before the "End With" however when I move the "End Select" after the "End With" I get the error "Loop Without Do". I am stuck! Any help is greatly...

Hi All, I am trying to run the below code but I am getting the MS Access can't find object on this line DoCmd.OpenQuery "SELECT * FROM PROV_CL WHERE [Address 1] LIKE '*" & strInputBox & "*'", acViewNormal from the code below. I just can't seem to figure out what I am doing wrong. Any help is...

Hi All, I am trying to import data from Excel 2010 into Access 2010. I am having a problem with one column not importing when there is a space in the value like A245609 345. I have the field set as datatype TEXT in access because there are both alpha and numeric and spaces. Access won't import...

I have an Access form with a Subform when the User clicks Save on the Main form I need to check and make sure a required field has been populated on the subform. Below is the code I am using it runs but doesn't work (ignores test). Basically if a User selects "Pending" in the cmb_ActionCode I...

I am trying to reference the fields on the active record in a subform. What I would like to do is have the user select a row on a subform (Datasheet View) and have a drill thru query generated. How can I pass fields from the active record in a subform to a query using VBA? Any help is appreciated...