Search results

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...

Ok... Well I'm not very advanced with MS Access, in fact I'm not advanced at all. I only know how to design a databse to hold information and create a form so that information can be generated. I am sure there are 100 other ways of doing it that are easier... but I just don't know them. I...

Hello... I have a form I created use MS Access... and near every aspect of the form is just the way the company wants it. However, my boss would like it to calculate certain values... which in spite of my greatest efforts to decipher the more in-depth aspects of MS Access I am unable to do it...

I appreciate the offer but I will just go get a book. I find it cofusing that you cannot understand that I simply want to do a mathematical problem. 1 x 2 = 2 Where 1 is the amount of squares entered and 2 is the defined price per sq. But if it requires me to take apart the db file and such...

I can't attach it... it's a 13mb file. But I will upload a screenshot clip to show you what I mean. Ok so I Check the Box Tear Off (this does or doesn't have to really effect anything.) What really is important is to have Price Per SQ be the default value (for that field which I can do). The...

Hello MS Access Experts, I designed a form for my place of business. We do estimates for roofing and construction and the form is really basic in terms of MS Access and it's potential. But I'd like to modify it to have it make certain calculations. The way I have it setup is... on the left of...