Access

Resolved · Low Priority · Version 2010

Mon 24 Sep 2012, 14:47 Delegate Kim said...

Kim has attended:
Excel VBA Intro Intermediate course

Access

Hi,

I have a text field I need to update with a new note on a few hundred clients; some of the records already have text that I don't want to be over-written.

Is there a way to add text to the begining of the field where it is not null.

Thanks

Tue 25 Sep 2012, 16:11 Trainer Mark said...

RE: Access

Hello Kim,

The method of achieving this can vary depending on the context in which and how the new text is applied, also what code you currently use to populate.

Maybe you could concatenate the additional text such as:
Forms!Form3!Text5 = Forms!Form3!Text5 & strResult

I hope this gives you an idea as to how to approach this.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Tue 2 Oct 2012: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.