Search results

I figured it out. On the properties tab, I changed allow edit to yes. I have been working on this for months.

Is there a way when I open my form to go to a specific field [StudentID] and activate my onclick macro? I have a on open macro Goto Control -This work. Now I just want the onclick macro to run.

Great questions. I want my user to select an age group to send an email message to. I am just starting the process so open to suggestion. As of now, I have a query and can filter on a form. That's as far as I have been able to get. In the past we just copy and paste into excel and let that...

I have a query that I can use in forms that filters by student grade. I have some families with students in same grade so I end up with duplicate emails. Is there a way for the user to filter by grade, then remove duplicates all on thr form and not access the query? Or what are some options I...

On my form I want to duplicate a record but be able to update the ID number. Is this possible?

It is still now working the way I hope for My drop-down shows Name Student ID Which I want. I want to type in the name, but returns the student id. Currently when I type in Mrs Ann, it show Ms Ann. Thanks everyone for the quick response and help.

I have created a combo box on my form Under row Source I have my desired fields Name Student ID On the combo box, I want to select/type a name, but input the student id into the field. Currently, I have in row source query Name First (Ascending) Student ID I want to search by name and return...

Thanks! Now I since i am using two tables that are not connected in any way, I just want the Approval Table to be set in place, and my Applications table will have all the participants. How do I keep the approval table from clearing even though the info is there?

I hope I can ask this easily :) I am trying to draft a template for an approval letter. I started in forms and would like users to be able to make edits if need be that will display on each record. I also have fields that are mixed in from a table. I am able to combine all my fields but when I...

No. I am not familiar with that. Are you able to assist with helping me navigate that? Also what is a template file? I am searching for that as well.

I have a command button and onclick I want to email a report and add a message text. In a macro I can only do 1 line of text. I would like to add a message. This is part of what I have played with. But only the first line shows up. =[Parent Name] & “,” “Congratulations! Knik Tribe is...

I have many open reports from forms, but for some reason, this one is not being friendly. I have a form frmProviderStatus Default View: Continuous Query: qryRequested Course_Crosstab On field [Requested Provider] I have an on double click to open a report Report Name Provider Details When I...

I am trying to email "statements" (reports) to parents based on a query. I have the query and I have the report, but right now it emails the first person in the query the selected people and the statement is all in 1. Example: I have 3 people in my query that I want to email their individual...

Hello I have a main form frmStudentCheckIn and a subform frmSubCheckin and a field [Select Course] Currently, I have a combo box in the form header where students can select their name and then on the subform can select the course they are taking. I need help with- After they select their...