Search results

What keeps causing this to occur? The solution seems to be just opening the backend file and it auto-repairs itself. But, how do I prevent this in the first place? I'm not sure what background info to provide, please ask away.

I'm trying to develop a query that provides a count of the number of records where a certain criteria is true for each field, individually. I.e., How many records where Field 1 = Yes How many records where Field 2 = Yes How many records where Field 3 = No etc... But, I don't want it to be...

Hi everyone, I'm looking for a tutorial on how to build a search function/form. I have a main form that users input data into, but I'd like to build an easier way for them to search other than the embedded Access search field in the nav bar at the bottom. Essentially, I'd like the user to be...

I have a main user input form ("CALS v2" in the attached copy). Within that form is a command button that opens up the current record in a secondary form ("HelplineReferralTracking"). Once the user inputs what they need in Helplinereferraltracking, they click the save and close button and it...

I have a command button that closes the user input form and returns back to the navigation form. My current code is as follows: If IsNewRecord = "Yes" Then AssessmentEndTime.Value = Time IsNewRecord = "No" DoCmd.RunCommand acCmdSaveRecord Else End If If MsgBox("Would you like to save and close...

If I change the name of 1) field name or 2) table/form/query name will the change be made in all downstream locations including VBA and SQL coding?

I have a query that I'm displaying (in datasheet view) in a form. I want to set the criteria of the query based on input from the user. Basically, the user will select their program and the form will open to the query filtered to only entries for that program. I found the below article, but...

I'm having trouble firing the requery command and returning to the current record instead of reverting back to record 1. I picked this up from someone else: Dim Curr_Rec Curr_Rec = Me.CurrentRecord DoCmd.Echo False Me.Requery DoCmd.GoToRecord , , acGoTo, Curr_Rec DoCmd.Echo True...

Hello, I'm trying to accomplish the following in VBA: If condition1 = X AND (condition2 = Y OR condition3 = Y) THEN .......... Ex: If [Eligible_PROSPollock] = "Eligible" And [Interested_PROSPollock] <> "Yes" Or "No" Then However, I keep getting a type mismatch error

I'm building an assessment tool and would like the end-user to search for the client before proceeding with the assessment to see if the client has already been assessed. The client should be searched by last name and DOB or last, DOB, and first. If the client exists, the form navigates to the...

I have a query that is calculating a client's eligibility for services. This field's output is either Yes or No depending on data from a series of other fields (automatically calculated). On my form, I would like the "Interested" field to be active only when Eligibility is Yes. Something around...

Hello, I have two spreadsheets, and I need to pull patients' visit dates from the second sheet based on the visit number in the first sheet. I've attached an example file and a screenshot below since it's hard to explain. Essentially, in Sheet 1, I have the variables ID, Visit#, and...

Hello, I have a form that displays records from a query. I've utilized the following code to allow users to navigate forward and back in records by using the left and right arrow keys on their keyboard: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) On Error GoTo ErrHandler...

I have a command button set to navigate to the next record (Docmd.gotorecord etc..) but then I want to focus on a textbox that's in a subform so the user can begin typing after clicking the command button without having to then click on the textbox. I have...

Background: I'm creating a clinical decision support tool in which a Query will provide doctors with a suggested decision for a patient's prescribed drug based on whether the patient's medical condition falls under the domain of the drug. I.e., if a patient is taking an anti-depressant and any...

I'm creating a clinical decision support tool for our clinic with access. Without getting into too much detail, our clinic is required to review all medications that we prescribe to patients to make sure the patient has the correct certification to receive that med. Each certification allows for...

Hello, I have a form with several subforms within (tabbed subforms). I've used the code: In the Current event of the parent form - Code: Me.AllowEdits = False Me.AllowDeletions = False Me.AllowAdditions = False In the Current event of each of the subforms - Code: (THIS NEVER WORKS FOR ME -...