Recent content by Rockape

Thanks very much.... it worked a treat

Thanks I adapted it and it worked... :)

I wonder someone would help.. I have a form where I enter two dates i.e. a commence day and a final day and I also have a save button. I would either a. have a control on the save button which pops up a message if the final day is greater than the commence day and so preventing the save...

hi Pat, Done all that....also got a sample mdb. Woul dyou care to see and correct for me?

Hi, Grateful for advice. (Using MS Access 97 and 20003) I have a database with a number of clients. I have created a form that will query the database to find me the number of clients that contain a name, eg. Smith I get the following:- Mr J Smith, Mr and Mrs A Smith, A Smith and B Smith...

Thanks will retry and continue with this idea. May get back to you via this thread. :)

Hi all, I don't know whether I am in the correct forum but since I am looking at creating a form I thought I might ask here. The idea I have, simply put, is of creating an A-Z type of directory whereby by clicking on a particular letter a listing of all records commencing with the letter A...

Sorted it out ....damned pop up :)

Hi all, I'm having difficulty bringing to the front a form that I am calling from another form. i.e. I have a button on the main form. This button calls up another form but rather than popping up in front it remains behind the main form. Any idea why this is happening?

Hi all, I wonder whether it is possible for the following to be carried out: I would like a routine that would copy paste certain information that has been inputted into a particular field via a form (into a specific table) to be copied onto an email template. Presently I have a button on...

Hi, yes Certainly will...mind you the link provided by Spikepl was also quite useful.. Finally found sample database in http://support.microsoft.com/kb/175072 Your reasoning also helped quite a lot... Many thanks to all.

Hi, That's not working either. Please note I am using A97. Can anyone amend whet I uploaded to see if it works? Thanks

Hi, No I get an error in that field now when preview the report! By the way do you mean changing the Contol Source of the field Address 3 in the report?

yes I am now kicking myself..... to much screen time

Hi guys, I'm sure this is a simple question which I 'll probably kick myself when it finally works. I have an input form...simple enough with a couple of combos thrown in. Howver when I click the button for the next record (after having clicked the save button in order to save the record) my...