Are you sugjesting that i format my code like this?
If Forms!FRS_Packa ge_Maintenance! Packages.Form!O KToDeliver = True Then
Edward Polite
Last Activity: Apr 23 '13, 04:34 PM
Joined: Oct 26 '11
Location: Potomac, MD, USA
-
How to determine If checkbox is checked on subform.
I have a form with two sub forms. When I select a customer on form1, form2 displays details for that customer in ‘continuou s’ form view.
In form2 I have a checkbox, with the code listed below in the “Before Update” event, which works perfectly when it is actually checked by the user.
I would now like to run the code from a Button on my main form. One button would auto check the check boxes. Then...Last edited by zmbd; Oct 2 '12, 05:24 PM. Reason: Please format posted code using the <CODE/> button. -
NeoPa, I followed your lead, and it took some time to figure it all out, but I modified lines 3 & 5 below by inserting the following code(Format(rstEven ts![Start Time], "h:mm AMPM"))to get the results I was looking for in the "txtDayBloc k" areas. Thank you for pointing me in the right direction!
...Code:Select Case lngEachDateInRange Case lngFirstDateInRange '1st Date in Range, no existing Text
Leave a comment:
-
Format time to display hh:mm AM/PM in the calendar block area
I have another question re: Access Calendar, Wide Calendar w/Switchboard.
Currently the time format in the calendar block, display like 03:00:00 PM, Hour:Minutes:Se conds AM/PM.
Even though the code below appears to be formated Not to display seconds, time is still displayed as noted above.
I looked at another code, below... Modified it,...Code:strEventTime = Format(strStartTime, "h:mm AM/PM")
-
I agree. Kudos to the original author and NeoPa as well!Leave a comment:
-
Good Morning ADezii,
I am finished!! The code worked perfectly! Maybe the code can be condensed, but right now the coding is fine.
Hats off to all MS Access Experts, what a wonderful group of people you all are!!
Thank you!!!Leave a comment:
-
Good Morning ADezii,
Wow! Off the top of your head, your a blessing man! I will get to work on this and let you know how things turn out. Pointing out the calendar population section of the code has been insightful and has made understanding the db and its functions a lot easier.
Thank you!Leave a comment:
-
Thank you for your reply. I modified the code as you suggested and it works really well. No problems at all!! I really appreciate all the time and effort you put into answering these questions.
If you don't mind, I have another related question. Is it possible to insert the [Title] & [Start Time]into let's say October 16, 2011 calendar block, And then insert the [Title] and [END Time] fields into the October 20, 2011 calendar block,...Leave a comment:
-
Wide Calendar w/Switchboard
This question references MS Access Calendar.
I recently downloaded the "Wide Calendar w/Switchboard" database that I found on this forum and it is exactly what I have been searching online for. I have read through most the thread looking for an answer to my question, but have not found one.
I plan on using the 'Training_Event s' form to input data into the calendar. Currently the data that is displayed in the calendar...
No activity results to display
Leave a comment: