Search results

AncientOne- No, the real DB does have relationships, the sample DB does not because I did not think it mattered for creating a quick testdb. The query is performing the outer left join, which is basically what a relationship is doing. I would think the behavior is the same if you define a...

I was messing around with the tables, and I need to make this a union in order to pick up students which have no grades entered yet in the table. Which makes it even more ugly with number of queries running around out there. Does it make sense to have vba code doing some processing to keep it...

Thanks knotty. I ran through several of my forms and noted the ones which work great are only 2 tables. Or work great as subforms. And of course the one which failed is four tables. I'll break it up as you suggested. I was hoping to avoid creating even more queries. My application is filled...

Thanks Wayne! You pushed me in the correct direction. I did not like the before insert because you don't see the value on the screen. So I kept hacking away. default value=NZ(DMax("[College number]","COLLEGE","[StudentID] = " & [StudentID]),0)+1 The formula did not like the Me. in front of...

Thanks for your assistance Wayne- I did try the code on the beforeinsert property of the subform. I don't think I want it on the main form since I am inserting a row within the subform not the main form. The main form has basic "header" info which does not change. The subform contains the...

In the design view the criteria section is your "where" clause in sql. So you would be looking for records where field3=field2, hence NO records. What you want: In design view in FIELD you want the following Field: Number 1ST HALF TOTAL field3: 1ST HALF TOTAL Table: team...

No go. Because this is a subform, do I need to reference this differently in the VBA code? I wonder if the Me.[College number] is getting confused on the main form vs. subform. Also- I noticed the before insert event is located on the form properties, not the properties of the field I wish to...

I have a subform which looks like: MAIN FORM----------------- Student-> Mike ------------------------------- SubForm------------------------------------------------------------ Previous Colleges--> START END ASSESSMENT 1 Univ of Florida 1/4/1993 5/15/1993 N...

I had this working before but now can not. How can I change the queries in the attached sample database to update vs. readonly. I want to be able to view a the courses a student 'can' take, plus the grades he/she already has received. Then naturally update the students record. I do NOT want to...

You will have to do some coding modifications. You need to look at every token in the string, if it starts with numbers, leave it alone. If it is letters, propcase it. That would be the easiest and add some rules about apartments. I'm not sure why you have 4 letter rule. "12 South MAIN Street"...

When there are null values in a field, the Sum function produces null also. I had a report, where some fields added, and others didn't. It only sum'd when each field was populated with a value. As soon as there is a null, bingo, I had a blank field in my report. I searched the forums and found a...

Thanks! Thought so. Two related questions-> Is there any way to push zero inch borders in a subreport? I set pagelayout to 0, but access pushes .16 into the right/left borders. and then when I drag the subreport to the right it increases my main report and creates an extra blank page. Yes, I...

Yes, I did recreate the links, actually numerous times. I noticed when I wanted to check the links, as soon as I clicked on the down arrow, I received a warning message (more like a hand slap vs. yellow triangle) informing me about ensuring the links are defined. Which they were. So I simply...

okay I was getting confused with some of your statements about what is in the footer section & detail section. How 'bout in the detail section: Other [text box??] Record Source=Nz([Vac],0)+Nz([Sic],0)+Nz([hol],0)+Nz([brv],0) Sum Records=no What does that give you?

You can try this, It fixed a problem on my report: =nz(Sum([sic]))+nz(Sum([vac]))+nz(Sum([hol]))

I have a report with two subreports which were a bitch to format in order to align with the main report. Should I have done this with dlookup instead? or VBA?? What's the consensus out there?? Looks something like: Report Subtotal: 88 3 3 6 7 3 12 22 44 45 Sub-report...

I'm scratchin' my head. Why access can get so PICKY! I've built a report and it runs good. I created a sub report and it runs perfect stand-alone. I add the sub-report to the report, and now I'm prompted for a parameter which I never defined. The prompt is for a parameter named "Student" The...

Also-- If you search this forum you would have found this one to handle the Mc's and Mac's: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46405 You can also do a quick & dirty convert if you don't have spaces or multiple words in the database field (i.e. "JOE SMITH"...

You can write a VBA procedure to call the StrConv function: In your report set the field's record source to =myPropCase([strNAME]) VBA procedure in module: Private Function myPropCase(sText as String) As String myPropCase= StrConv(sText, VbStrConv.ProperCase) End Funciton Extracted from...

I need some help calculating a Total from all subforms In the main form if I set the record source =[fsubCourse].Form!ENGsubtotal), I naturally pick up the subform value of ENGsubtotal. And if there are three recordsets, I can easily move forward & backward or enter values in the subform, and...