Recent content by ezpc

Doh!!! Omigod I am so sorry. Here is the file with the tables

I'm trying to run a report based on this query(qryCSAP_Crosstab). This particular field in the query (Not Tested) may not have any data and I'd like to display zeroes in the column. I'm struggling with the Nz function and just can't seem to get the syntax right. I'm not sure if it's because...

I'm trying to package an Access application. I've done it many times before with the odd glitch or two that I can usually figure out. This one is a problem though. The wizard runs fine and the packaging starts and runs. When it gets to the end the error message appears.."An unknown error...

Checkbox to disable form Thank you so much! I've got it working fine now.

Checkbox form in Northwin Rich, Yes, I have looked at the one in Northwind. I got a little confused though because that one is on the startup form and I do want my existing startup form to stay the same(it has a verification of backend location routine).

I want a user to be able to turn off an informational form with a checkbox. I added this code to the On Open event of the form. If Me.HideIntro = True Then DoCmd.Close End If It didn't work though. The check box doesn't stay checked and the form continues to open after it has been...

Yesss! Thanks so much Harry. That's just what I wanted.

I have a graph that shows about five grouped fields displayed as percentages. I would like to have the y scale go from 1 to 100%. Even if I try to manually adjust the scale maximum to 100%, it won't stick. Say, the numbers vary from 5% to 18%, it will only display the maximum as 18%. Scratching...

Thanks for your response Carol. Been busy putting out other fires but now have had some time to work on this problem. I'm not having much success. One problem is that it's a subform and when I try to run this code(after update) - Forms!frmSLPSubform![CurrentCRT] = True I get an error message...

Thanks in advance for any help. This forum is the best on the web! I have a subform that contains records of student assessments. There is a checkbox that indicates the current teacher giving the assessment. The data entry person invariably forgets to check the box which affects some reports...

Yes, Pat, I forgot to mention that I changed it to this: stLinkCriteria = "[cboTestID] & [cboTeacher]=" & Me![cboTestID] & Me![cboTeacher] It seems to be working correctly. Thanks.

Carol, thank you so much for your help. It is working correctly now. I think I was trying to make it too complicated!

I hope I can describe this correctly. I want a user to be able to select criteria from drop down boxes on a form. (TestID and Teacher). I can get the required results but not without generating an error message "Object Required", which is referring to the Reports object. Here is the piece of...

Thanks for your reply jatfill. I had tried requery too but I had so many events happening that they were conflicting with each other. I finally decided just to have the main form close(instead of hide) and then it is reopened when the add form is closed. Probably not the best way but the easiest...

I have a form with subforms for entering test scores. The main form contains student info and subforms contain scores. There is a command button that opens another form to add students if they aren't in the database. I've tried refresh code command button on the add form after new students are...