macro challenged

  • Thread starter Thread starter Bernie R.
  • Start date Start date
B

Bernie R.

Looking for some help on how to write a macro.

I have a form where the first column (a) contains names, the second column
(b) is the collective task being done, the following columns (c-z) are the
supporting tasks being credited for doing the collective task.

When I enter a date in column B, I want to enter the same date for all the
columns in that row that don't already have a date in it. And this repeats
till there are no longer any names for data to be entered.

I hope the above made sense. Most of our errors are coming from inputting
this data and I thought a macro that does this would eliminate this type of
error.

Appreciate anyone's help.

Bernie R.
 
Bernie,

The basic concept behind this task would be to make an Update Query to put
the dates where you want them, and then use an OpenQuery action in your
macro to run the update.

Having said that, I also have to say that what you have described would be
regarded as an invalid database design. I don't know enough details to be
able to advise specifically. But I do know enough to be able to say that
all these supporting tasks and dates should absolutely not be in separate
columns in the same record. They should be separate records in a related
table.
 
Steve,

After reading your reply I realized I didn't give you enough information.
The query that I have is pulling info from several tables. The first two
columns are the Names and Collective task, and whatever is to the left of B
are the supporting tasks which already have dates in them. Is there a way to
write a macro for when we insert a date in the collective task and then
populate every column to the right that doesn't have a date in it?

My partner and I are two Army Joes with just enough Access training to be
dangerous, but not enough to really be efficient.

I hope this helps you alittle more. We appreciate you taking the time
trying to help us.
 
Bernie

Are you able please to give details of the tables that comprise this query?
If so, this is a useful format...

NameOfTable
- NameOfField
- AnotherField
- etc.

Then, can you also go to the design view of the query, select SQL from the
View menu, and then copy/paste the SQL view of the query into your reply.

Thanks.
 
Back
Top