Recent content by JohnJ

I don't know if this is any help. I have a form in which I wish to carry over 3 fields into the next one. For each field in the After Update event I have the following [Event Procedure]. ('Campus' is the name of the field.) Private Sub Campus_AfterUpdate() If Not IsNull(Me.Campus) Then...

I can get a graph to show O.K. from a query but if I use a parameter in the query to reduce the number of records the graph returns an error message saying it can't find any field named after the parameter input message. Should I create a new table from the query and graph from that? Is there...

Pat, Thanks for your reply - I will take note of what you say. Ironically after having fixed a couple of minor points elsewhere all seems to work O.K. now. Thanks John James Melbourne, AUSTRALIA

I have a problem with a user using Access 2000 under Win98. When she goes to save a form after entering the data she gets a 'The Save action was cancelled' error message. She then has to exit the form. But the record is saved. The funny part is that it seems that it is only this one...

In the end I didn't use Pat's uggestion but rather the simple, and to me elegant, solution proposed by 'raskew' in his reply of the 9th June 2001 to a similar problem. This solution results in a control, after updating, making its contents the default contents for the next form. Thanks raskew.

Thanks for your reply Pat. I will try the form/subform idea. John

I have a small database in which staff complete a form to make budget submissions. Often staff have to use more than one form (i.e. make more than one submission). How can I get the staffname, campus and faculty details from the first form automatically show on the next one and so on. Its...

I have a report which can be viewed or printed. If users view the report on their monitors then to exit the form they have to click on the small X box in the top right-hand corner to shut the window - not very graceful. How can I design a button which they can click on to close the view. I...

Thanks Pat - indirectly you solved my problem. I downloaded the MS document as you suggested and, while it didn't directly answer my problem, when I looked at some of its examples I realised I was using an incorrect keyword in my SQL procedure. It now works exactly as required. Thank you.

I have created a form based off a query which uses an SQL procedure to use input values from 2 combo boxes on a form. The resulting records are shown in a sub-form. When trying to use the sub-form to amend record details I get the message "Record set is not updateable." In...