Search results

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

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

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

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

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

I would like to create a report that has extra blank lines at the bottom. The existing report lists names/id's for students. The reports are passed out to teachers so they can hand enter scores and return them to the data entry person. I would like to have a few extra(blank) lines at the bottom...

I have created a chart that is generated from a make table query that has several parameters that a user must enter(year, grade, subject). My question is this: I would like a subtitle on the chart that describes the selected parameters instead of just a generic title. Is there any way to place...