Simple Question Probably

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi. I have started a new job, and I have a huge database backlog of 45,000
entries I need to clean up.

What I have to do, is search the database for a certain subject, and change
one of the fields for each case from 'open' to 'paid'.

The way I do this is to click on the field, and select 'paid' from the
drop-down box. Or, the quickest way I have found is to select a field,
press 'p' (which auto completes paid), and then press down to go to the next
field. so basically I just keep pressing 'p' and 'down', over and over
again.

My question is, is there a way to automate this process with a macro or
something? Or by using a keystroke recorder by coping the pressing 'p', and
'down' process, and play it back x amount of times?

I know it may sound complex, but it is a very simple process. It just takes
a while to get through 45,000 entries.

Cheers.
 
Adam said:
Hi. I have started a new job, and I have a huge database backlog of 45,000
entries I need to clean up.

What I have to do, is search the database for a certain subject, and change
one of the fields for each case from 'open' to 'paid'.

The way I do this is to click on the field, and select 'paid' from the
drop-down box. Or, the quickest way I have found is to select a field,
press 'p' (which auto completes paid), and then press down to go to the next
field. so basically I just keep pressing 'p' and 'down', over and over
again.

My question is, is there a way to automate this process with a macro or
something? Or by using a keystroke recorder by coping the pressing 'p', and
'down' process, and play it back x amount of times?

I know it may sound complex, but it is a very simple process. It just takes
a while to get through 45,000 entries.
Click to expand...

An Update query would do all of this in one shot.

UPDATE TableName
SET FieldName = "Whatever"
WHERE (your criteria)
 
An Update query would do all of this in one shot.

UPDATE TableName
SET FieldName = "Whatever"
WHERE (your criteria)
Click to expand...

And, don't be intimidated by the SQL -- you can easily and simply create
this query in the Query Builder window (without being an SQL expert).

Larry Linson
Microsoft Access MVP
 
Back
Top