Search results for query: *

Sorry everyone -> a quick interlude in this discussion. I was just wondering what the central difference was between BeforeUpdate and AfterUpdate. Ive always used AfterUpdate myself, but the more I think about it, the only thing I can think of is berfore you update similar to setting focus...

Hi there, thanks for responding. In regards to your issues - I originally had what you were talking about firstly - percentages are entered, and the grades are calculated based on minimum and maximum cutoff grades from another table, exactly what you were talking about. Problem was that there...

Hi Everyone and Anyone! My problem: I need to make an update query to place scores from Course Reports, to Individual Student Tables. These are my tables... tblStudent Stores all of the Student details. strStudentID strSurname ...etc tblStudentAcademic...

Righto - some more information! tblEmployees ysnSupervisor - select if supervisor or not. frmMenu - main menu toolbar. Search - lookup field which looks at all employees. cmdSupMenu - when pressed, should look at status to see if supervisor - MY PROBLEM! This is my code when cmd button is...

Hey, I have a main form, which is used as a sort-of menu. At present, employees access a drop down select box - where their ID numbers are selected with their names etc. This information is accessed via tblEmployees. In this also, there is a yes/no box, where employees have selected if they...

I find that this kinda error happens to me alot - and yea, as dhookom was saying, it has something to do with the name of the textbook sharing the same name, or something like that. Try inserting a new text box in your report, and copying the same equation into that. Hey, this worked for me for...

Hi All Righto, this is a fundamental problem that keeps repeating itself, and I dont know where I am going wrong! Basically, I have a string, which in the record, shows up OK, say strCO. Yet, when I add =[strCO], it comes up with #Error. I think this has something to do with my record source...

Hey Yep, worked great. Cheers for that.

Hey All I was just wondering if it were possible to do a numbered list showing each record. Before you jump the gun, and tell me I should use "autonumber" with each record, some records will be deleted etc., so wont count exactly 1, 2, 3, ... etc. Basically, its a table showing...

Hey. Firstly, yes I admit the name is a bit misleading - the value intARI is not really an integer, but more of a float variable. Just my definition of an integer is a number at the moment! Hence, it is possible to have intARI = 89.9, as you said. With Select case, you cannot have Case 80 <=...

Hi, thanks for that redapples, dont know why I didnt think of that! In response to the integer division, that was a result of another question I posted, concerning roundings of percentages. For example, if the percentage was 89.9% (as would be displayed in intARI), but Select Case only...

Hey All I have been having some trouble with this grading program again. Here it is thus far: 'Functions corresponding to each grade Private Sub UpdateARIGrade() Select Case ([intARI] \ 1) '<-- integer division Case Is >= 90 Me![ARIgrade] = &quot;D&quot; Case 80 To 89...

Beautiful! Your a legend. Works great. Ta.

And so hence last thing! How do I link this code up to my form? So far, Ive got it in a &quot;current&quot; form function - but it obviously doesnt automatically update once you change it - just only when you enter the form? How would I go about doing this? So far; Private Sub...

Thanks for that Just one quick thing - the cases have been changed from say, for a credit, 65 - 79. What happens if the user puts in 79.3 ? Would this work as a case? Round down? Thanks again.

Hi, I am a bit of a beginner in VBA, so... I am writing a database based on students grade. The user inputs their percentage, and the grade is automatically calculated. It prints the grade in an &quot;unbound textbox&quot;. How would I go about setting this up? I have the following thus far...