Search results

I have this Filter: ([qryRequested Course_View].[Completion time] =Between #10/1/2022# And #9/30/2023#) Filter On Load: Yes I am getting a syntax error.

How to I do the filter on load to be a date range?

I just came across insert query while trying to find out how to copy a filed in table Applications to a specific record/field in Requested Course. Here is what I am trying to do. I have a form with table/query Requested Course If the Student ID# is blank I have a pop up form people can search...

What I would really like is 5 toggle buttons. Year 1 Year 2 Year 3 Year 4 Year 5. I can select 1 or all. The dates would be based on a federal fiscal year. Default would be the current fiscal year. 10/1/22-9/30/23 I know the table has a between, but I need guidance on setting up the onload...

I have a form with a query that I want to filter on load between 10/1/22 and 9/30/23. I then want a check box that I can click to view all records. When checked- show all records Unchecked- between 10/1/22 and 9/30/23 I saw this on a demo access but can not figure it out. Need some guidance...

How do I setup the set focus?

I have a check box that when I click on, I want to add a record in my notes subform that says emailed then also populate the date. So on the main form I have check box [email_approval] Subform- Contact Notes subform1 2 fields Notes NoteDate Thanks

I have a combo box that looks up value on my form. It results in a list of names I have a sub datasheet set to single form. I have two fields check in and date. I want when I select the drop down, and the names appear, I can go to a new record in the subform. This is my set up Main form...

I think I need to use the NZ option. I am not sure how to do it. In one of my subreports, I have the field [Award Amount] and then in another field =Sum([Award Amount]) When I have a value in there it shows up on the report. When it is null, the subreport is blank.

I have a report that I want to email as a pdf. The report looks great, however when I go to email it via pdf or print the 3 subreports are not being included. I have had reports work prior, and I added 1 more subreport to it and now it does not work.

I do have it group. Then when I select the group at the bottom and totals still gives me the total students who attend each course.

I have a query with 2 tables. Requested Course and the Status of the course When I run the report it shows perfectly, Only list the Provider and the Courses they offer are listed perfectly When I go to do the count. I only want the count of each course. Right now it includes the count for...

I have a form with a combo box where a person can select a business.-This works Next I want to have a drop down that they can select the grant year. How would I sent up my query and drop down to display the following? Year 1 (Date Range 10/1/20-9/30/21) Year 2 (Date Range 10/1/21-9/30/22) Year...

I have a field with the current time I want to have another field that says either good morning or good afternoon based on the time. [txtTimeAMPM] is a unbound field set to short time. =IFF([txtTimeAMPM]<=TimeValue("12:00"),"Good morning","Good afternoon") I am getting a #Name Please help...

I currently have a subform in datasheet with a check boxes per record. I want to check the box Click command button Open report Only display records that were checked. Main Form: RecurringPayment Subform: frmRecurringPayment_Subform Query: QryRequeste Course Report: rptRequestedCourseComplete...

I have a check box. If/when I click it I want my subform to be visible. So check box is true If/when I click again, I want my subform to be not visible. so check box false. My checkbox name is: Reoccuring Payment My subform name is: RC Breakdown subform I can rename them if easier. Thanks

I am not familiar with error handlers. Can some point me in the right direction? My error is that I canceled the send object command.

Thank you. I figured it out. I just needed to put yes to allow edits. It was simpler than I thought.

Okay. one more question. I need 1 more line of code at the end. If I cancel my email, I get the debugger message. How to I omit that?

This is what I have: Private Sub Command205_Click() Dim sExistingReportName As String Dim sAttachmentName As String sExistingReportName = "rptApprovalEmailRC" sAttachmentName = [Student Name] & " " & "Approval" DoCmd.OpenReport sExistingReportName, acViewPreview, , , acHidden...