Search results

I have 2 tables that I wish to get information out of, but I am unsure how to set up my query. I hope one of you can assist me. Intake Intake ID Date Of Intake(Date/Time) Caseworker(Text) Risk Assessments Intake ID Substantiation Risk Level(Text) Substantiation Risk Complete(Yes/No) 3 Month...

Hello everyone! I have created a form named "DuplicateName", which I would like to use instead of a messageBox. This form will be ran from the results of a BeforeUpdate event of a form called "ParticipantInfo". I would like the buttons of the DuplicateName form to perform the following actions...

Hi everyone - I have a form right now which has a First name and Last Name fields (PFirstName and PLastName). I just want to be able to determine if a name possibly exists in one of my tables. The following code that I have is not working yet. Not sure what I am missing. I have 3880...

Good morning everyone - I have written a procedure in VBA that grabs information that a user selects in a combobox and then generates a PDF file. You can either view this file or at the click of a button it will automatically send to the correct users folder located on a local shared drive...

Hello everyone - I have a query with 4 Fields (Category, Time, CategoryCount, and Date). I want this query to group by category, Sum the time for the category, display a count of each category. If I remove the Date field from my query, this will result in pulling all the information in my...

Hello everyone, I have a form with let's say, 10 numerical fields on it. The user may or may not fill all of these fields with data. I need to come up with a query that will count those records with data in them and not the null fields. Currently the values of each of these fields is 0. This...

I have a database that keeps track of training sessions here at work. This database has 2 tables (Associate and Training). The training table has multiple records for the associate. Every once in a while we have meetings where it involves the entire staff. I want to be able to have a way where...

Good morning, Let me start with this .... :banghead: I am trying to do a simple query that pulls data from a date range using the BETWEEN operator. Simple right? Apparently not as simple as I thought. So I have 4 fields I am pulling info from. RSID, PCounty, Type, and RDate. For the date...

Good morning everyone. I have a question reguarding a pre-selected field. Currently on my form I have a Start Date and also a End Date. After you enter the 2 dates then you can print the report that the form is set up for. The textfield is set up to either allow you to type in the date or...

I have a Form that allows the user to select a date range for an Associate's total Training Hours. After they select the date range the user can select a button on the form that says something like "Get Report". Everything is working as intended. The total training hours is displayed by the...

I have a combobox that has a query in it based on a Participant ID. I wrote this little search tool to find the Social, but if the record is not found and I backspace it generates an error. Actually let me be more clear on what I want to be done. First I want the user to be able to type in...

I currently have a field on a form thats indexed (no duplicate values). What I want, is if the user types a existing social in the field, that it lets them know the social is in use and that the record will not save. I believe this will have to use the before update event for my...

I have a form that has 4 checkbox controls on it. I want these to be an On/Off switch for subforms in a report named "rptMainReferralForm". I'm pretty sure I have the basics down. Do i need to add a subform control on the report and set the visibility to False? Then when the checkboxes are...

I currently have a form with 2 combo boxes on it. One combo box has a list of participants that is pulled from a participant table. The other combo box are referrals, which a participant can have many of. When you have both combo boxes selected there is a "Report" button that displays the...

Hello, I am trying to generate a report to save as a PDF and concatenate different fields into the file name. This file will be saved in a individuals folder depending on a field called CareCoord. On a form a user can click a combo box for a person who they want a report generated upon. There...