Search results

Group by team in the team group footer place a page break

I have created my own toolbar and disabled the default toolbar To only display your custom toolbar; Tools , startup then select your custom menu from the menu bar drop down list then deselect the four 'allow' check boxes

when you are in the vb Code of your database click on tools (on the menu bar) then on references. compare these from your Pc to those on the erroring PC's. You should spot the missing reference

You could do a dlookup using the query that your report is based on Out the dlookup prior to calling the report then check if the returned value is null if it is null output your no data message end exit the sub and you will automatically be returned to the report menu Dim answer as string...

I could be wrong but I don't think you can have a form in a report

a beautiful wig

If Me.cmb111 Is Null Then MsgBox(Select Increase or Decrease[, vbOKOnly] [, Selection Required] [, helpfile, context]) Try something like this if nz(me.cmb111,"") = "" then msgbox"Select Increase or Decrease",vbokonly,"Selection Required" me.cmb111.setfocus exit sub end if

If you place the following around the undo command it will ignore the error 'Undo not availble' On Error GoTo Err_Undo_Record_Click DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70 Exit_Undo_Record_Click: Exit Sub Err_Undo_Record_Click: '2046 means undo not...

if the query runs after the combo box has been updated then in the after update event check whic value has been selected andthen either run or not run the query

This may be of some help to you (see attachement)

I am assuming that the absent field contains a 1 for absence and null for no absence Sum(IIf([NewAttendance].[Absent],1,0)) Try this Sum(IIf(IsNull[NewAttendance].[Absent]),0,[NewAttendance].[Absent])

It depends on the circumstances but as a rule of thumb I believe it is best to base the form on a query. If you use a query you can manipulate the data in the query and then use the info on the form

Re query1 Try If Len(yourfield) = 9 And IsNumeric(yourfield) = True

In the on click of your button type docmd.setwarnings = false docmd.openquery "your1st query" docmd.openquery "your2nd query" docmd.openquery "your3rd query" docmd.setwarnings = true

Use tools start up and de select display database window

RE:RE:Newbie reports question 1) How can I pass parameters from a form to a query (ie the start and stop date) In your wuery in the criteria section of your date column type between forms![yourform]![yourstartdatefield] and forms![yourform]!yourenddatefield] 2) Once I have my results from...

You could create a form that has a start date end end date then pass these dates to your queries (form must stay open tho)

In your Query add a new column an type this in the field box inc vat: [amount]*17.5/100+[amount] (where [amount] is your amount field)

In your delete query in the building column type this in the criteria section Forms![yourform]![yourlistbox] When yo click the delete button call the delete query and it will take the value from the list box and delete the record

Your Office combo box should be based on a query that selects the info you require. In the institution column of the query (in the criteria section) type this forms![Yourformname]![yourinstitutioncomboboxname] In the On enter event of the Officecombobox type this Me!yourOfficecomboboxname.Requery