Recent content by kirstenlargent

I have a form with several tabs on it. I would like the form to Requery a specific query when I click on a certain tab. I tried putting the code in the "On Click" event of the tab, but it won't run. Where should I put the code? Thanks!

Once I set it under Query->Parameters, I then get a prompt for SchoolID. If I set it for General Number in the field properties, it still won't work. I've been fiddling with it for awhile, and I can get it to show up now if I multiply the number by 1. So my field now looks like this: SchoolID...

I need to refer to a subform field in a query. It pulls the info if my subform field is text, but if I try to refer to a number field on the subform, all I get is a character like this:
I get a blank field when I try to refer to a date. Yet all the text fields pull in fine. I'm...

I have four separate date fields in a record. I need to do an update query to compare all 4 date fields, and add the resulting lowest date to a new field in the record. What is the syntax I could use for that? I tried doing an if statement, but it got too big to try to compare all four dates...

I tried copying and pasting, but it didn't work. Someone here just figured it out - if you put a Border around the cell, it will then slant the fill of that cell. No border, no slant. Go figure! Thanks!

I just tried it, and all that did is draw diagonal lines in the cell, but the cell was still an upright rectangle, instead of having the fill slanted at 45 degrees to match the text. Any thoughts?!

I need to rotate a cell in Excel. I know I can rotate the TEXT part of the cell by going to Format, Cells, and Alignment, but I need to rotate the actual FILL color that is also in the cell. (45 degree angle) Someone sent me a worksheet where the fill was also rotated, but I can not figure out...

Now that is TOO EASY! I guess I haven't learned all of the new features in 2002! THANKS!

I'm trying to apply conditional formatting to a field in my form. I want the font color to be red if the value in the field is negative. This field is a calculated field, based on other fields in the form. I tried adding the code to the AfterUpdate, OnDirty, and OnChange events, but none of...

I just had this same problem, and I followed DonQuichote's suggestion above. I changed the printer quality settings from "Fast Normal" to "Normal", and the graphics printed fine! Easy solution!!! Thanks DonQuichote!!!

HALLELUJAH!!! That did it! Sorry it took me so long to get time to try it, but that extra table with the three codes did the trick. Once I added that into my final query, it returned the totals, even if they were zero! You are a LIFESAVER!!!!!!!!!

Your second scenario would be good. So far, my query to combine all those totals end up being blank since there are no LDG's. If I leave the LDG's off, all the other querys pull in ok and the class counts are all on one row. Any thoughts on how to get my blank query to show zeroes?

OK, thanks. Here it goes... Two main tables: 1. tEmployee - has employee data, primary key is EmployeeID. The field I need to use criteria on is "EmployeeType" which can be "LDG", "ZDG", or "EDG". 2. tCurriculum - has data about which classes taken...

JonFer - I need a bit more help now that I've had time to really dig in. I'm using your Option 1, but I'm still running into problems. I need to be able to select criteria from the table. Group field = ZDG, EDG, or LDG. Then the Yes/No field for a certain class taken, all in the same table...

Awesome! I tried Option 1 and it worked PERFECTLY! THANKS!!!