Search results for query: *

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

Thanks for the speedy reply. My base queries only have two fields - one is a Yes/No field to indicate if a user has taken a class. I have select criteria of "Yes" to count only users that have taken the class. The other field is the Username, and has a count. This works fine for...

I currently have multiple queries that use the Count function. I have them all combined into one main query. My problem is that some of the Count queries do not find any records (and that is correct, there are currently no records meeting the criteria). But when the queries find no records...

I need help setting up an Access database to be able to input and analyze survey results. I want the user to be able to enter the survey results into a form that will list the 10 questions, each with 4 possible responses. I want to have a report that will list each question and the percent for...

The TransferText looks like it will only work for a table or query, and I need to export a report. I need to export a report because I need certain data only in the first row (class name, number, date) and then I need different data in the rest of the rows (class participants). The only way I...

I need to export an Access Report to a Text file with the fields each being a fixed width. What is the easiest way to format the report so I can tell what space a field will start at? Would any certain font in the design view help? I have been doing it field by field by trial and error, but...