Search results

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...

Hi , Just done that but the problem remains!!

Hi, I would like to know whether the following routine is possible. (I am using A97)! I have a table of addresses:- A1 A2 A3 Country There are occasions when the address is so short that Address 3 (A3) is not required even though the country field is filled in. I also have a report which...

Thanks much appreciated... I will try this out. Regards

Hi all, I would be grateful for assitance: My problem is as follows:- I have two fields A and B formatted (as y/n)which need to be populated per record. I have inserted two option buttons to cater for these two fields, i.e. by ticking either box the value is saved in the record. The...

My apologies... I meant that it was not functioning the way I wanted it to. I agree I should have been more specific. I tend to commit these stupid errors :confused:. I will try to be more specific next time.