If I had a mother/daughter relationship... .
Would I make the following records?
A. Mom's student ID - B. Child's student ID - C. Mother
AND
A. Child's student ID - B. Mom's student ID - C. Daughter
RockKandee
Last Activity: Mar 4 '14, 05:15 PM
Joined: Dec 8 '13
Location:
-
Connecting Family and Friends relationships in Access
I am using Access 2013 in Windows 8
I have a Student table that holds all students with their contact and personal information. Each student has a primary key auto number.
I have students that have relationships with other students that I want to track.
I do not care about tracking non student relationships (ie; I don't care who a 14 year old student's mother is unless she also takes a class.)
... -
That is a good idea. Thank youLeave a comment:
-
Hmmmm....In English??????? LOL
My attempts failed today, but I will keep trying.
I didn't like having the message box display as an on open form event. So I made it a button. I now have 4 buttons.
1 - chooses display of start time or not (provided by ADezii)
2 - changes pop up to no
3 - prints
4 - changes pop up to yes
2-4 are my original Print button broken...Leave a comment:
-
The message box being a pop up is fine. I need the calendar form to not be pop up when printing.
I need to get the calendar to:
1. Change pop up to No
2. Change Start Time to not display
3. Print selected month
4. Change start time to show
5. Change pop up to Yes
I think I have it, or it may be wishful thinking - lol
Hopefully I can test it today.Leave a comment:
-
Your code isn't my trouble, I think I understand it. However, I reserve the right to change my mind ;)
I think I need to figure out how to add - pop up yes/no - to your on open prompt.Leave a comment:
-
I think I will work on that last one.
I am having some issues right now. Prior to this post, I thought I had the printing all set. I use this calendar as a pop up. So my print command would switch to design view, change pop up to no, go to normal view, print, then change back to pop up. In testing - without actually printing - all seemed great - as in not errors - code working. I over looked the fact that when the form changes to not...Leave a comment:
-
ADezii - Update - the original code prints without the start time when I print from the version you posted. I need to play with the order of my print commands to make it work on my calendar.
I didn't get a chance to add the new code you posted yet. So I will work on that tonight and test tomorrow. Will let you know how it all works out.Leave a comment:
-
Now that code actually makes some sense to me :D
The other code - I was like - huh - I have no idea what this says - I only know if I click the button - it works!
I will get back to you later today after I have a chance to print.Leave a comment:
-
ADezii is a Rock Star.
It looks perfect. I am at home and out of ink - lol. I will test the printing on Tuesday and let you know. Thank you so much.
NeoPa
That isn't the whole module it is only part of it. I copied from the first mention of [Start Time] through to the last mention. I do not know which parts print the start time. I think it prints simply because it is displayed on the form. I am not sure which...Leave a comment:
-
Ok - Keeping my separate printable version is what I will do.
Thank you!Leave a comment:
-
I didn't actually try the code you provided, I just changed the code manually. I can't print for a couple of days, so I could only test by viewing. However, those changes only made the time in the form's caption go away.
Maybe it only works for printing and not viewing?
I need the [Start Time] that displays with the [Title] in each day block to not show.
...Code:'Private Function InsertEvent(strExistingText As String,
Leave a comment:
-
This shows what all I changed to get the start time to not show. The original code is still there.
...Code:'Private Function InsertEvent(strExistingText As String, strTitle As String, strStartTime As String) Private Function InsertEvent(strExistingText As String, strTitle As String) '>>>> Kandee - Changed for printing without times On Error GoTo Err_InsertEvent 'CFB added 2-18-10Leave a comment:
-
My solution to the second part of this topic was to create a new subform with a shared record source of the main form where the record source could only equal 1 record and made this not visible. I included the same controls and code in the new subform to get the correct number of rows to print. I then duplicated the lines and labels from the original sub form.
I placed the new sub form under the original subform.
I changed...Leave a comment:
-
Thank you!
Great info links and all in one handy location for me to find again :)Leave a comment:
-
Oops!
I meant [start time] not the actual time.
When I print the calendar, I need the start time to NOT be included due to space limitations.
My apologies for not being clear.
Thank you for your help (no kisses for you - the wife gets too jealous - lol)Leave a comment:
-
MS Access Calendar Stop displaying time
Hi!
I am using Access 2013 with Windows 8
I am working with this calendar
http://http://bytes.com/topic/access...ccess-calendar
I would like to know if there is a quick way to stop the display of the time with this calendar.
I already took the long route to accomplish this so there is no need to spend time explaining unless there is a quick and easy route.... -
Converting Macros to VBA Do command or execute
Hi All,
I am using Access 2013 with Windows 8.
I am in the process of converting all of my macros into VBA. I read somewhere that it is better to use ? rather than do com. I cannot find it now to read it again.
I think it was execute....
I would love to get some input before I have too much code to fix - lol
So opinions on what code is best to use rather than, for example... -
Like this??
Category (1 to Many) >> Name
Name (1 to Many) >> Info
Info (1 to Many) >> Number & Date
Number (1 to 1) >> Date
Number & Date (1 to Many) >> Schedule
Staff (1 to Many) >> Schedule
Staff (1 to 1) >> Student
Facility Schedule (1 to Many) >> Schedule
Facility (1 to Many) >> Facility Schedule
Schedule (not sure)...Last edited by RockKandee; Jan 16 '14, 06:07 PM. Reason: Category (1 to Many) >> Info - changed Info to Name (oops)Leave a comment:
-
History/Archive Tables - Normalization - Table Levels
I am using Access 2013 on Windows 8
After receiving info on the below linked thread, I have found myself with a new dilemma.
http://bytes.com/topic/access/answer...n-table-levels
I was advised it might be best to merge the history table in with the progress table.
I am running into issues with merging and I am hoping there may be some other options that I don't know about....
No activity results to display
Leave a comment: