Search results

Guys I am going to give it my best shot explaining what I am doing and what my issue is. My database has a form for Lessons, and that form has a sub form for events. The lesson has a duration say .25 (15 minutes) I created a query to show me my lessons and associated events so I could make a...

Good Idea. I have been adding subform to the end but using the "s" would shorten things up and make sorted. Thanks.

So it reads each line separately I do not need if then statements. You are a huge help thank you. This is a great forum! Worked perfectly!

I had eariler changed the name of the form and thought I had updated it everywhere. But I did not know about the other tab check. I am sure that is why I was getting the code errors. When I deleted the sub form and added it back (New Name) it worked. These are my rookie mistakes.

As you can surly tell I am new to coding. I have already entered an on load code and am not sure how to add this to it properly Here is what I currently have: Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub

Geezs ole Peety! I did not know I could do THAT! What a big help that is going to be!!! THANK YOU!

Guys, with help from this form I was able to get my show/hide sub form button working. Now I am wondering if it is possible to have the sub form in the closed state when the main form loads? So the user does not see it unless they want to.

Humm. I do not see that on the other tab.

I Finally got it. I deleted the sub form and reinserted it and now works fine. Very odd. Thank you so much for the help.

Yes I checked that.

Tried that and get the same error

I want to show/Hide my sub form. when the user clicks the button the subform displays and when they click again it hides I cannot get any of these to work 'Hide It Forms!frmCourseDetails!frmCourseReviewCycleSubform.Visible = False 'Show it...

I want to hide my subform until the user clicks the button I cannot get any of these to work 'Hide It Forms!frmCourseDetails!frmCourseReviewCycleSubform.Visible = False 'Show it Forms!frmCourseDetails!frmCourseReviewCycleSubform.Visible = True This does not work either Private Sub...

I am thinking you may be right. I need to track if the task is removed from scope or if the task was added to scope. This tracking scope changes. I need to put some thought into this. I am not sure I may need two tables. One table to establish the Scope change ID Add to or remove from then a...

Team, I have a query where I count the number of records in my task table (Count: TaskID) which returns 15 records this is correct. I have one record that is set to remove. I need to leave this record in my task table for tracking purposes but I do not want it in my over all count. I add the...

Okay, that was it. Boy what an idiot I am. Sorry for the trouble. =IIf([statusID]&""="10",0,DateDiff("d",Date(),[TargetDate]))

I made that a combo box store the ID but select from the value list. So the user sees the value not the ID.

I made that a combo box store the ID but select from the value list. So the user sees the value not the ID.

I am working to create a due in date. I have a field that is the target date and I have a status ID field. I want the due in date to tell me how many days until the task is due or subsequently how may days overdue. So I am building off the idea that if the status is complete return 0 if the...

I have a cantact form. This form is used to enter new contacts as well as edit existing contacts. I have also added a go to button which allows the user to select a contact to go to from a list. Currently my form opens to my first contact. I would like to have the form open to a new record.