Hello Again,
I apologize for the late reply Wiklendt as I've been so busy with school, work and family I had to put this on hold. However, with this weekend coming up i'll be able to sink in and try to figure out some of what you have suggested here.
I have found that the best thing to do is...
Thanks again for taking the time to look into it for me wiklendt, if you have the ability and the time great... if not I understand.
I don't know what occurred to my first post, I bet I selected to preview post and because I always have so much going on, I just closed the browser assuming it...
I think maybe my post got eaten... or maybe posts submitted with an attachment require moderation... I wasn't paying so close attention. So I will try again. (I apologize if this winds up being a duplicate thread)
---
While trying to follow some of the advice here I messed something up I...
First let me say... Thank You wiklendt for taking the time to bother with me. It is hard to express via a forum post how much I greatly appreciate it.
I usually run into the problem where my ideas are greater than my capacity of understanding for the application. I am going to try out a few...
The Class Link is actually part of a convenience. Lets pretend I don't ever want to pull up the Class Table... I'll only pull up the Class Form if I have to Add or Delete data (in which case I have 2 forms... 1 specifically for adding classes and 1 fore editing / deleting classes).
The concept...
Ok, I think I understand... but I just want to clarify because I am still trying to figure out the need for certain field.
My Assignments Table looks like this:
tblAssignments
- PKASSIGNMENTSID (autonum)
- FKCLASSID (num)
- FKTEACHERID (num)
- FKASSIGNMENTTYPESID (num)
- Assignment Name (txt)...
So essentially I need to adjust my assignment table to reflect the id from the classes table.
- PKASSIGNMENTSID (autonum)
- Assignment Type (txt)
- FKCLASSID (autonum)
- Class Name (txt)
- Class Link (link)
The only question I have is... what is the purpose of Class ID? The ID number is of no...
I've read a few thigns online and looked over a few examples but I have to say I'm still vastly confused about relationships.
I'm creating a personal project manager of a sorts to keep track of my projects. (Work, School and Misc).
So I want to relate the table for classes to the form for...
I did... and by every standard of math i know it doesn't seem to calculate anything.
I looked in design view of the form... but since I couldn't tell what was supposed to be calculated and what wasn't I really couldn't decipher it.
Furthermore, I don't know if it was intentional but on my...
I'm slightly confused as to what field these codes would go in.
TOTAL: NZ([ONE])+NZ([TWO])+NZ([THREE])+NZ([FOUR])
Should it be like the following
TOTAL: NZ([FIELDVALUE01])+NZ([FIELDVALUE02])
Am I understanding this correctly.
---
Edit: Ok I tried this... don't know if this was right. It...
I don't understand?
---
I initially made the form as only a Customer Contract database. A Simple data entry type of document that would allow us to have a digital file of existing contracts.
However, my boss was so impressed with how clean the design was that he wanted me to explore the...
Hello again...
I got almost everything working on the form except for the Grand Total feature.
I tried the
=[field1]+[field2]+[field3]+[field4]+[field5]+[field6]+[field7]
and so on and so forth to the point it would add all the fields up into a grand total.
The only problem I run into is it...
So you want .5 on both sides...
SO make it not exceed 7.5 inches... alright man thanks a lot.
I'll test it out later today and see if I can make it stop prining those 2 blank pages.
SUCCESS!!!
Thanks a Million Mr. Hartman... I've had this form for 9 months now created... and couldn't do a damn thing with it.
My boss so frustrated about finding a solution for estimates (turned contract) to be legible say... pay whatever its going to take to get this working.
---
Thanks...
OK... i remember trying with expressions before and I couldn't quite get it to work.
So I'm going to try it now and see what I can come up with.
(In response to the Width)
I have tinkered with the width many times... compressing the information on the page to almost 7 inches (and in spite of...