Search results

I hope this is a simple question. I have two fields - DueIn (Number) and Approved (Date). What I need is if the user enters an approved date the DueIn field returns the value of zero after the update. The DueIn field is initially derived from a target date after the update, which is the...

I am back. Just when I think I a figuring something out....Nope not a clue! I have a temp query I created to get my SQL statement. I want to total the lesson duration for each course to determine my course Hours. The sum of lessons (lesson total) is related to the catalog ID. Currently using...

I have written a function that counts my events using an SQL statement. I did this by watching various codes being written and putting it together. I would like advice on whether I have written the code to best practice. The code does work and gives the correct results. 'Used for Course Report...

I am looking to get the event count from my event report ininto the Module and report footer. I need the report to show how many events there are by Module and then overall (by report). I tried to write the following, but of course I did not do well. I do have an event Count Qry, but I could...

I have the following code written so that when a user does not want to save the data they entered they can opt not to save changes. I noticed that the autonumbering generates a number but does not save it. So if the user enters record # 4 and they decide not to save it the # 4 line item is...

Guys, when I nest my three sub reports in to the main report, I cannot scroll past the first record. It keeps bouncing back to the first record. Any help please.

I have a main form which has a field ModuleID. This is a selection field. I would like the dropdown list on my sub form to limit the options based on the Module ID selected on the main form. Is that possible? I tried to do it in the query but was not successful...

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...

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...

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 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"...

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

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...

So here I am with another table Question. I removed all the Look-up fields from my table. I had one field that was a multi-value field (roles). A client may be assigned multiple roles. I now understand that is bad, bad, bad. I am creating my form and need to assign the roles to the client. Is a...

I have taken three online courses, each instructor has done things differently, without any clear explanation. I was wondering if you guys might help provide clarity. When setting up the tables why do you not use the lookup wizard for a field so that it will populate with the value as opposed...

Guys, I have this code to display a message box if the field entry is a duplicate. I would like to add code to clear the field entry if OK is clicked. I don't know how to do that. Private Sub CatalogID_AfterUpdate() If DCount("[CatalogID]", "Course_tbl", "[CatalogID]= '" & Me![CatalogID] &...

Hi folks, I am trying to write a multiple-expression but do not know how to connect them properly. Help is appreciated. =IIf(not IsNull( [CompleteDate] , "Complete", " ", IIf(IsNull( [ReviewDate] , "Not Started)," ", IIF( [DueDate] > Day(), "Inprocess","OverDue")))

Hi guys I was not sure where this topic fit in the discussions. What I am trying to do is if the days late has data I want the due in field to clear Here is the expression I used so far. The piece I am missing is clearing (Hiding) the data in the due in field...

I am getting a better understanding of forms and sub-forms. I have found that I can hide sub-forms using a command button. My question is, is there a way to make the sub-form popup when the show hide button is selected? I have 7 sub-forms, I was hoping to make navigation a bit more friendly...