SetValue macro trouble...please help

B

bdehn

I am brand new to Access and armed only with a For Dummies book. I'd really
appreciate some help.

I have a list of employees and their Layoff Date, the date they Returned to
Work and the date they move to the Bottom of the List (22 days after they
return to work)
I need to have this list in order with oldest date at the top, to know who
gets called first.
I made a query that calculates 22 days from the Returned Date, no problem,
but...

What would be the best way to move the person to the bottom of the list?

I've tried making a query that shows me all the Bottom of the List dates
that match today's date. Then making a SetValue macro that would change the
Layoff Date to the current date, thereby moving them to the bottom. Seems so
simple, but I can't get it to work. I run into a wall when I fill in the Item
and Expression lines in the SetValue macro. It tells me my Query doesn't
exist.
Any suggestions?
(Thank you thank you thank you!)
 
S

Steve Schapel

Bdehn,

You would need to give details of the macro you tried before anyone
could assist with why it is causing problems.

However, it appears that an Update Query (and a OpenQuery action if you
need to use a macro to activate it) may be more applicable to the task
than a SetValue action.
 
B

bdehn

What I want to do is open a query and if the "Bottom List Date" field matches
todays date, then the "Layoff Date" field would update to today's date.

Is that enough information to help me?
:)
 
B

bdehn

Yesssssssss!
Thanks Steve!
I studied the Update Query in my Access for Dummies book and figured it out.
It was so simple, of course.
I have so much respect for those of you with the smarts to have figured out
so much of this program who then take the time to explain it here. It has to
be just as frustrating explaining it sometimes as it is to those of us who
can't figure it out.

I'd bake you cookies if I knew where to send them.
 
S

Steve Schapel

Bdehn,

Congratulations on pushing through with this to get the answer yourself.

As for the cookies, I live so far away that we don't even call them
cookies here :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Help with Date Modified Macro and putting into data-entry form 1
'SetValue macro action' problem 1
SetValue to all Records 1
Macro: VBA code to move/forward email based on subjects and attachments 0
Access Help file 1
Automated Weekly Output Table to Excel 3
Insert Date() in table field using a macro 2

Top