Search results

You are correct. I sometimes wonder why I thought I needed to Learn Access. LOL Thank you for your help. I will not give up, I will keep at it.

I will give this a try. I was just stumped as to why it worked for Lessons and topics but not events.

Yes I entered one event to validate and I cannot get the Topic ID to populate Table Record: And here if the form entry

Thank you for this. I will try. What I had before I ran into the issue was a CourseT form with a course selection list. The user selects the course and the form opens to that form. Then I created a button and applied Private Sub btnLesson_Click() DoCmd.OpenForm...

Yes, I am able to create the form and sub-form. I think I may be using the wrong approach. I have been watching some videos but I am getting confused. I have five tables. Each table is related to its predecessor. I have; Course, Lesson, Topic, Event, and Review cycle. If I use the sub-form...

Yes, I just am not able to get the Event ID to populate into table 2

Guys I need to create two tables Each table will have an event ID. When I create a form for Table 1 Event ID how do I get that event ID to populate into Table 2 event ID? I might be trying to apply the wrong logic. I have events the user must complete stored in Table 1 based on the event ID...

I was able to get it to work even though I got this error when I first ran the event. It seems to be working and recording my entries.

I am sorry, here is my tab control, if I am understanding correctly Here is the page and subform my button is on, it is a yes/no button Here is the page I would like to open when the check box is selected

Did not work. I might not have explained myself well. I have a button, when I click the button, I would like the tab that the issue log is on to open.

Did not work. I might not have explained myself well. I have a button, when I click the button, I would like the tab that the issue log is on to open.

I have one main form "Courses" and within that form I have two sub-forms on tab controls (Pages) "Event" and "Issue Log". Currently, the users can click the tab and move between the two tabs (subforms). In the Events tab subform there is a check box for Issue (yes/no), I would like to have the...

I am not sure how to put this as resolved. I needed to put the expression in the default field not the control field. My bad

I have two tables one is tblCourse and the other is tblissuelog. Each has a field CourseID field and they are related in relationships. I then have two forms one for each - frmcoursedetails and frmissuelog In the frmcoursedetails if the issue checkbox is selected the frmissuelog opens to a new...

Oh my thank you, that is way over my head. I will keep at it and eventually I hope to understand.

Does not matter where I put it. Here is my DB if you want to check it out. You can use course FIN-AA300 to run the report, it has a parameter set.

I did not know I could add a DB file, wow. So if you go to frmcontactdetails select a contact go to the assignments tab click the course Id it opens the form to a new record not the specific record

No because if I do that I loose my search function. I don't think I can do what I want with the main form being set to on load new record. If I take the on load off it works fine. That's a bummer because it leaves my first record up and if folks are not paying attention they could accidently...

Hi, I have yet another question. I have a sub form that list courses by developer. So this form shows a list of courses assigned to the developer. What I want to do is open the main course form to the specific course when the user clicks the course ID in the sub form. So what I am attempting is...

I am using =Sum([LessonDuration]) From what I can tell it is totaling from the query, which is probably right. I just don't know how to get what I want.