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

That didn't work but adding an event to the report, NO data did. Private Sub Report_NoData(Cancel As Integer) MsgBox "There aren't any records to display, try another date!" DoCmd.Close acForm, "Dock Audit Discrepancy Report" Cancel = True End Sub

I tried this, on a report that is not running off a query, and I still get 1.

It looks like it would work, but it doesn't; it can't find recordcount

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

Point! I've scrapped that idea.

This is how I did mine, I created a popup form and put it in the startup. There are two fields txtUserName & txtPassword and 2 command buttons, cmdOk and cmdcancel Sub NoEntry() MsgBox "User name or password is incorrect", vbInformation, "Cannot Open!" DoCmd.Close Private Sub...

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

Thanks a MILLION, it works like a charm. I'm thinking of naming my first born Stoner!

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?