Search results

Wayne Many, many thanks for your helpful explanation. Will have a go at your suggested codes. Much appreciated. Rollo

Hi Wayne Thanks for your help. Yes, I do mean changing the data after the initial input (eg a week or so later) - when some of the info will need amending. Unfortunately, I am an absolute novice at coding. Would appreciate some guidance ...... bearing in mind that I'm pretty hopeless! Thanks...

I've looked on the various threads but cannot find any directly relevant info. Is it possible to set up the fields on a form so that, when the data in the field has been edited/changed, either the font or background colour of that particular 'cell' automatically changes. I am using Access 97...

Macro for message My apologies, ghudson ...... think that it's me that's dazed and confused! Thanks for forwarding. ghudson ...... many thanks for your response, will do as you suggest. Rollo

Macro for pop up message ... Wonder if anyone can help. I have a macro which imports a spreadsheet as a new table. Unfortunately, if a user unknowingly clicks twice on the macro button, the data from the spreadsheet is imported twice, into the same table – causing duplicate entries. Can anyone...

Many thanks for your post, Harry. Your solution works a treat! Rollo

I would like my report to appear in the centre of a sheet of paper (equidistant from each side margin) when I print it. Is there any easy way of doing this, apart from manually adjusting the side margins? I am using Access 97.

Many thanks for your help .... David R. Have now resolved the sort. Cheers.

Liv - many thanks for your response which is helpful if I need to find and alternative way of working round the problem. My apologies, it is probably my poor explanation. Looking at the data: Base....Check....AC....Ref....Location A................PA....N628...HTV/SPO...

I have a table which includes the following fields: Base.....Check.....AC.....Ref....Location A......................PA.....N628...HTV/SPO A...........x..........PA.....N525...LMN/PCY B...........x..........PA.....N526...PCY/LMN F......................BM.....G304...MPE/YUR...