Search results

Correction/clarity- the screen update can be noticed because of the recordset update, not the calculation.

Works fantastic! I was hung up by not having quotes around every parameter. It is a bit slow- you can see the screen blink when its doing the computation... If I get user complaints, I'll put it in vba code to see if it helps. Thanks FoFa!! Remeber the Alamo! sorry, had to throw that in there...

Isn't the Dsum running a query against the data stored in the tables? I would need this to be dynamic. So that when a course is modified, i.e. change credits from null/blank/zero to 3 then the subform total changes to 12 and the main form total changes to 32 (or whatever the numbers will be)...

Also, by rule I found the "bible" books not so hot. Lots of pages with simple screen shots. So it may be thick, but only two chapters are useful. ex: The waste time showing where to find the switchboard manager, and how to create an entry. Unleashed wasn't bad, at least it covers the field...

I guess the key was better ADO examples in the SAMS books than the Jennings & Orielly book. You are right about ego. I generally am a HUGE O'Rielly fan. Their coding examples are typically fantastic, not just "hello world". But they always fell back to DAO. I did not pick up Mastering VBA vol...

I am going crazy trying to find a solution to this problem. I believe I will begin to create some monster code. There MUST be a better way! I have a form with recordset of colleges and subform with recordset of courses taken at each college. I need to total ALL the credits on my mainform...

Also good: Alison Bater Matering Microsoft Access 2000 Development http://www.amazon.com/exec/obidos/ASIN/0672314843/qid=1061912612/sr=2-1/ref=sr_2_1/002-4442711-7194428 AND F. Scott Barker Microsoft Access 2000 Power Programming...

ALSO--- I have an additional issue- If I clear the student grade, let's say "B" to null/space. I want to clear the autonumber fields Grade.GradeID and Grade.StudentID, in other words, get rid of all data for that row. I tried AfterUpdate: If IsNull(Me![Grade]) Then Me.ID.Undo...

Now I get a runtime error 2108 "You must save the field before you execute the GoToControl ation, GoToControl method or the setFocus method."

HELP! I'm getting the following error message: Cannot add or change record because a related record is required in table 'Adult' I have a form which was working great. I just added a validation rule on the table to ensure the user enter's the correct data. And now receive an error message...

I believe the only way to code this is with VBA doing a recordset clone Check out this one: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43990&highlight=recordset+clone Do a search on RecordsetClone or Clone across these forums for other links. And on MSDN...

I was at the Microsoft Developer net site and found the attached document describing how to address fields and controls in forms & subforms. Problem is, I found in my report these rules did not work well. Seems like reports don't like the "me" reference. I kept messing around, try just to...

Have you tried creating a subreport? OR: Do you want to have a sumation per week? On your report you have a company and week section, you can add a text box field in the detail of the week section which simply sums up the stock hours field returned by the query. Try this (properties of text...

I was searching this forum for 'almost' the same thing. Found this good post: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47027&highlight=subreport+and+nodata You can also try a search on "HasData" method.

I was at the Microsoft Developer net site and found the attached document describing how to address fields and controls in forms & subforms. Problem is, I found in my report these rules did not work well. Perhaps in forms they will work. What worked for me: On the main report I had a text box...

Okay. I reversed my logic and started with the most constrained query and then joined to the student table. Basically reversing the join sequence in the previous test queries. All works wonderful now. Thanks for your assistance Pat and Ancient One! :) I have to agree with Real Knotty on the...

okay, not getting very far with trying to debug my join syntax errors. I think I'm close, but no cigar. SELECT Student.* From Student Left JOIN (Select Course.*,Grade.* From Course Join Grade on Course.CourseID=Grade.CourseID Where (Course.Course="MGT100")) on Student.StudentID =...

Pat, Thanks for your assistance! If I want to introduce syllabus, then the many-to-many situation happens. Which, technically can be used to filter the course on a parameter form. So this is not big deal. I won't include this table in the sql query. This query works with three of the tables...

Pat- I agree it does not matter how many tables, but how they are joined/related. I tested a three table join and it worked fine for a simple join. However, you can not avoid the numerous one->many joins in an application. For example, For class=100, find all students and add/change their...

Thanks for your time Oh Ancient One! I hope you've crushed those infectious worms. The article on updates is great. Lots of rules. I tried to break down tables to smaller tables and linking them to fix the many-to-many issue. This did not work too good. So I have two other options: 2) Push more...