Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Short cut to updating multiple field properties

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Short cut to updating multiple field properties

Resolved · Urgent Priority · Version 2003

Reply Wed 10 Sep 2008, 13:57Delegate Gillian said...

Gillian has attended:
Access VBA course
Excel Advanced course

Short cut to updating multiple field properties

Hi,

I am updating fields in a table recorset. Is there a quicker way to update multiple fields in a recordset in the same way e.g. Trim them all rather than code it individually for each field?
Conversely is there a quicker way to do lots of things to one (or many) field rather than code it individually e.g. for a field I want to trim it, do a few find and replaces, set to lower case etc?
Thanks.

For upcoming training course dates see: Pricing & availability

Reply Wed 10 Sep 2008, 20:06Trainer Laura said...

RE: short cut to updating multiple field properties

Hi Gillian

If you need to tidy up every field in a similar way you could shorten your code and write a function to use on each field.

For Example

Function TidyUp(stOrigValue)
TidyUp = Trim(stOrigValue)
TidyUp = LCase(TidyUp)
End Function

and then when processing your fields

With rsMyTable
.fields("UserName")=TidyUp(.fields("UserName")
...

.Update
End With

Hope that helps

Laura

Access articles

· Growing A Customer Base For A New Business - With The Help Of Access
· What Are The Benefits Of Publishing Your Microsoft Access Database?
· Convert a Paper Trail to a DBMS
· Mining For Data With Access
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps

Please browse our web site to find out more about
ms+access+courses and other Microsoft training courses.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips