Search results

I'm not sure if a parameter query will do this (only type I know). I have a db with field plants: and field: reject number. I want to create a report that will count reject number seperated by plant. How would you accomplish this?

I have a report, which is based on a parameter query, which asks for the starting & ending date. Is there a way to put the the parameter (start/end date) on the report somewhere?

When using a parameter query, is there a way to hide the "Enter a Parameter Value" on top of the dialog box"?

I have a home made switchboard with command buttons that ask for a "enter beginning & ending dates", if the person hits cancel access displays some error message. I have some error code to eliminate the 2501 error. But it seems like i have to add the lines of code for each command button and...

I have a textbox called recordcount, control source =1, and running sum is set to overgroup. In the report footer I have a text box which is set to count the number. There is no query. The control Source is =([recordcount]). This works as long as there is data, but as soon as there is no data...

I no, you shouldn’t store calculated fields in a table, but rather on the fly, but I need the data. I have a table w/3 fields tot_audits, TOT_DISCREP & INFORMANCE (which is =1-([TOT_DISCREP]/[TOT_AUDITS]), but I can’t get it to store in the table, from a form. I tried using the afterupdate event...

I'm really stuck. I have a form which I have set up a cmdbutton. There are 3 different thing that can occured, an approval (check mark), a reject (check mark) or an interim (check mark). I would like the user to click the command button, and if the part check mark is approved, it would send a...

I have a form, that control source is a parameter query. The query asks for a report no. So if the user, hits return, or ok, the form opens to a blank record. How would I change this to say "No records found, please reenter the number". I've played with the OnError event, and the user can still...

I use paramter queries quite a bit, how do you change the title bar of the query the "ENTER A PARAMETER VALUE" to something else?