Search results

Yes I sure can

I have a report for Courses. This report has several sub reports, one of which is roles to course. In my case, the user assigns many roles to one course. This information is posted to my "role to course" table. I am trying to bring that list into my report. For example, OTC101 has 2 roles...

This is the road I started down since the post. Thank you for the confirmation. You are all a huge resource.

I have a question on how to best construct assigning roles to courses. I currently have a db with tables courses, lessons, topics, events, and roles. What I need to do is assign roles to the courses. There can be many roles assigned to one course. In the course form, I need to list all the...

Thank you, I get it now. Happy Dance!

I am not sure I fully understand the cascade updates. If I make a change to a record from a form it updates the records. Do you have an example of the cascade update you can share?

I think I get the basic idea, but I could use some guidance on these two features. I am not sure when it is a good idea or a bad idea. I need the user to be able to delete a record in the form view so I set my relationship to cascade delete. I hope this means all follow-on data is deleted as...

Hi, I was wondering if I have a field that is auto-populated based on another field entry, can I do an after-update function on the auto-populated field? I have a review date field and when I select the date, the due date auto-populates adding 4 days to the due date. I was trying to get a...

I also tried ... DoCmd.OpenForm "Event-change_Sfrm", , , "CatalogID = " & Me.CatalogID & " AND EventID = " & Me.EventID

I could use some help My db has four forms Course>Lesson>Topic>Event. Course and lesson are linked by Course ID .... 1 to many Lesson and Topic are linked by Lesson ID .... 1 to many Topic and event are linked by topic ID .... 1 to many I have a change form "Course-Change_Sfrm"...

yes, I am trying. I map in my mind what I want it to do, then I try and get it to work with macro, so I can get a basic visual, and then I try VBA. Sorry for any trouble.

My form is based on a query. I need to build code that requires two conditions to be met in order to open another form. I need the catalogID and The event ID in my open form command. i do not know how to do more than one condition. I have this

Okay do I was indeed making the call in the wrong field. Thank you so much. I feel like I ask a lot of stupid questions but I will say I am so thankful you guys are here. I am learning so much.

'Used to calculate the review cycle Due Date Public Function AddWorkingDays(ByVal dtmDate As Variant, Optional NumberWorkDays = 3) As Date 'the #3 is the number of days for the review cycle Dim i As Integer If IsDate(dtmDate) Then Do dtmDate = Int(dtmDate) + 1 If WeekDay(dtmDate)...

I did try this and nothing happens Private Sub txt_DueDate_AfterUpdate() Me.txt_DueDate = AddWorkingDays([ReviewDate]) End Sub

I want the due date left blank if there is no review date Private Sub txt_DueDate_AfterUpdate() If Nz([ReviewDate], 0) = 0 Then Me.txt_DueDate = 0 { I do not know what to say here} Else Me.txt_DueDate = AddWorkingDays([ReviewDate]) End If End Sub

I removed the removed the relationships and removed the CourseID from the events table. Thank you for checking.

Private Sub txt_DueDate_AfterUpdate() =AddWorkingDays([ReviewDate]) End Sub that does not work. I thought I would need and if statement

Hi, I am trying to turn an expression into VBA code, I placed the following into the duedate expression builder .... =AddWorkingDays(ReviewDate) and it works. addworkingdays is a public function in myDb. i would like to know how to write the VBA for this Basically, I would like to say if the...