Populate temp table with Calendar form closed
ADezii
My Training Events Details form can be opened from my Main Events form or the Calendar. I've added a list box on the form that show all the records that occure on the date selected in the [Start Date] field. The data for the list box is drawn from the temp table. I chose the temp table because I like how your temp table splits up a record that contains start...
scootaman
Last Activity: Mar 18 '10, 07:11 PM
Joined: Feb 1 '10
Location: Kansas
-
scootaman replied to How do I change the record on a main form when I click on a record in the subformin AccessUpdate. I got the list box working the way I need to. I added
In the On Current event right after the code that automatically inserts the date for the day on the calender I click. My list box now shows all the events for the current day just like I wanted it to. This works much easier than trying to work backwards by using the subform.Code:Forms![training events details]![List34].Requery
I have a long...Leave a comment:
-
scootaman replied to How do I change the record on a main form when I click on a record in the subformin AccessOpps, I spoke to soon, the List box doesn't do what I want. I am using the Calendar made by ADezii. When I click on a day in the calendar my form Training Events Details opens to a new record and automatically inserts the Start Date for the day that is Dbl Clicked on the calendar. The subform I had will show all the events for that day event when it is a new record. The list box will not work the same. If I open the form to a new record...Leave a comment:
-
scootaman replied to How do I change the record on a main form when I click on a record in the subformin AccessWell I found an easyer solution for now. I used a list box with and a macro.Leave a comment:
-
scootaman started a topic How do I change the record on a main form when I click on a record in the subformin AccessHow do I change the record on a main form when I click on a record in the subform
I have a main form for adding or changing events called Trianing Events Details. On that form there is a subform that is tied to the Start Date field of the main form. I have the form setup this way to mimic a day view in a calendar. I would like to be able to click on a start time of a record in the subform and have it show in the main form. I expect a day may come when I intering an event I may need to change the start time of one of the other... -
That works great Thanks!Leave a comment:
-
Adezii,
I've kinda fixed the bug for now by adding an On Error GoTo statement so now a user will get a message to double click on the record instead of the runtime error.
...Code:Private Sub lstEvents_DblClick(Cancel As Integer) On Error GoTo Error_lstEvents_dblclick DoCmd.OpenForm "Training Events Details", acNormal, , "[ID] = " & Me![lstEvents].Column(0), acFormEdit, acDialog Exit_lstEvents_dblclick:
Leave a comment:
-
Small bug
ADezii,
I found a small bug in the Double click event for the lstEvents box. If only one record shows in the box and I accidentally click on the open space below the record, but within the box, I get a run time error that says there is a Syntax error or missing operator in the query expression ID =
If I Choose End instead of Debug on the error message, the calendar stops functioning and I have...Leave a comment:
-
ADezii,
Never mind, I figured it out. I was putting AcDialog in the wrong place. This code worked:
Thanks for such a cool calendar!!Code:DoCmd.OpenForm "Training Events Details", acNormal, , "[ID] = " & Me![lstEvents].Column(0), acFormEdit, acDialog
Leave a comment:
-
ADezii,
How do I get the form to open in dialog mode? The form is opening in the tab behind the Calendar where I can't get to it without closing the Calendar. It is, however, finding the right record.
When I tried:
I recieved the error messae that says , "Wrong number...Code:Cmd.OpenForm "Training Events Details", acNormal, , , , acDialog, "[ID] = " & Me![lstEvents].Column(0), acFormEdit
Leave a comment:
-
Thanks
I'll add this on Monday when I get back to work! Thanks for the prompt reply. Your Calendar is really cool!!Leave a comment:
-
Double clicking on the bottom box
ADezii
Is it possible to make a double click on a record that shows in the bottom LstEvent box to open my Training Events Detail to open to the record shown? I tried a typical macro to open the record by the ID but I get a function error.
I thought it would be nice to open a record that way if there was a date or other change that needed to be made.
...Leave a comment:
-
Perfect! Perfect! You made my day! Thanks so much for all your help!...Leave a comment:
-
ADezii
Thanks for all your help, I think I have everything going well with the calendar. I have just one question left, (hopefully my last dumb question). Is there a way to generate the Sync Up comand for the calendar when I close the Training Events Detail form?
After I double click a calendar date to add an event, enter the info and then close the form, I notice the calendar does not show the new date unless I...Leave a comment:
-
I found the following code on the web that seems to work on close. It gives the user the choice to go back to the form or cancel the record. I went back and set my Title field to required and this code worked fine for closing the form without saving the record.
...Code:If IsNull(Me![Title]) Then If MsgBox("'Title' must contain a value." & Chr(13) & Chr(10) & _ "Press 'OK' to return and enterLeave a comment:
-
What is the code that would go in the BeforeUpdate() Event?
My Title field was origninally required but I found that it created a error message on close that made it very difficult to close the form. The error just kept looping back. Will step two prevent all the warning messages?
I turn the warnings off then back on with the delete query so that no messeges show.
Thanks...Leave a comment:
-
That worked! The only thing I need to do is figure out a good way to prevent numerous records with just a start date from building up if someone double clicks on a few different dates on the calendar and decided not to enter an event. I fixed that problem for now by running a deleted query on close that will delete all records without a title. I'm sure there is a better way but that was the only way I could figure to keep numerous unwanted records...Leave a comment:
-
ADezii
I looked at the multiple date span and how it shows is fine with me since the end date stays the same. It doesn't cause me any confusion since the dates all show in the calendar. So you don't need to worry about fixing that for me.
I do have the calendar in my database and it is working fine and I really like it.
I do have one question that I am not sure if it can be done. I set the double click property...Leave a comment:
-
ADezii,
Wow Great Form!! Thanks for help on this! I think I have it working, I had to delete the attachemnt field from both tables in my 2007 database. the calendar form would not work or populate with the attachment field for some reason when the property was set to the new 2007 attachment property. I made sure both fields were set to the attachment property, but that didn't make a difference. Once I deleted that field, the...Leave a comment:
-
Saved as 2002-2003
Here it is. I had to change the attachment feild to text type in order to get it to convert, but I don't think that should effect anything.
Thanks....Leave a comment:
No activity results to display
Leave a comment: