Search results

I have a report which is grouped by Committee. What i want to be able to do, is to exclude printing the Committee detail, if the Committee total is NIL. I'm sure I will need to write some code, and any advice would be appreciated. Thanks.

I have the following code attached to a button BudHdr = InputBox("You may also send a complete set of these reports. To do so, please type the name of the recipient(s) in the box below. Please use an ; to identify different recipients.", "E-mail ALL ?") DoCmd.SendObject acSendReport, ...

Isn't thisd something to do with the Tab Order. Try creating another field on Page 2, but hide it. Then set the tab order so that this field is at the top. This should work.

For subforms to work, you must have fields in both tables which are the same. E-mail me direct, and i may be able to help you. I not saying I can defo. but i'll have a go. Lee.

You can use SnapShot Viewer. This can be downloade from www.microsoft.com/accessdev

I have managed to create the command to e-mail the reports. I now need to be able to e-mail them to the right people. I have the -email address in the query which the report is bound to, but i don't know what to type in the event as the To : My query is called Q_Code List for Cost Centre's and...

I am writing a procedure, but am having difficulty in turning the SystemWarnings to Off. Can anyone tell me what I need to type ???

Presumably your form is based on a query. In the query you need to sort by LastName, and then FirstName. If your form isn't based on a query, in the form design you can use the OrderBy facaility. Type in there LastName;FirstName. This should work. Let me know.

I have managed to do this previously. I created a form with all the summary data on (i.e. Name of User, and also created a Command button on the form. Also, create a form with all the other data on it which you would wish to edit. Then create a macro with the OpenForm action. Open the form with...

I have created a sub-form which is wider than the screen view, so I therefore have to scroll across. Does anyone know if I can lock the first 3 columms in my form, so that the other data will in effect scroll behind these columns.