Recent content by mhartman

Hello You would loop through the controls collection to do this: Put the following under a command button click event and run: Dim ctl As Control For Each ctl In Me.Controls MsgBox ctl.Name With ctl Select Case .ControlType Case acLabel...

Hello: You might try also, the IsError function to test for an error. Division by 0 does generate this error. Regards Mark

Hello: You would use the "ALL Forms" collection to do this: Sub AllForms() Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentProject ' Search for open AccessObject objects in AllForms collection. For Each obj In dbs.AllForms If obj.IsLoaded = True Then...

View, Design View, File Save As

In Access, saved your SQL statement as a query. It should then work. Regards Mark

Hello Sarah I have enclosed an example of one way to do this: The database is of the relational type. IE: One job may have many managers. This is what Wayne was referring to above. Take a look at the report and see if this is what your after. This was made in Access 2003 Regards Mark

Hello: SELECT Sum(YourTableName.YourField2SumName) AS SumOfYourField2SumName FROM YourTableName; Regards

Sarah, what you do then is base a query on your table that returns only the records that are managers. Then group on the individual names. Also, if this does not work, if your post a sample of your database, I will attempt to fix it. Regards Mark

Sarah, run the report wizard to build your report. When the wizard asks if you to have any grouping, this where you would select your managers. Regards Mark

Hello: You need to disable the "SetWarnings" setting to dispense with the Access standard warning messages. Regards Mark

A basic search found this.......... http://office.microsoft.com/en-us/templates/CT101426031033.aspx?av=ZAC000

So, what's your question?

Hello: Look at "Input Masks". The following mask, ###.## will do what you ask. Set Format field to currency and construct the required mask for the "Input Mask" property. Regards Mark

Also: see attachment

Hello: Here is a example of what MStCyr was referring to: Run the report. In design mode notice the Format property setting. Regards Mark