Rename Table Using Parameter

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Hi. Using A02 on XP. Posted a request to Rename Table
Using Code and Ron Weiner was SO nice to give me a simple
solution. Now I have another question; can I replace the
autodating part with a parameter? Or should I use an
unbound field on my form to use for the data? How can I
tell it to rename the table using that date or have it ask
me what date?

Part of my form's button OnClick event has:
DoCmd.Rename "PayPeriod" & Format$(Date, "mmddyy"),
acTable, "CurrentPayPeriodData"

Any help or advice would be very much appreciated!!!
 
DoCmd.Rename "PayPeriod" & Format$(CDate(InputBox("Enter the date in
""mm/dd/yy"" format:")), "mmddyy"), acTable, "CurrentPayPeriodData"
 
Ken, Ken, Ken, you wonderful person. You have given me
JUST what I needed!!! I really appreciate the quick
response. It works GREAT!

I want to sincerely thank you for taking the time to lend
a hand and pass along your knowledge. Folks like you have
truly brought me from scraping my knuckles to feeling like
I can do this. I'm lovin' it!

May the fortune falcon swoop down and snatch any pending
problems from your path as you have cleared mine!
-----Original Message-----
DoCmd.Rename "PayPeriod" & Format$(CDate(InputBox("Enter the date in
""mm/dd/yy"" format:")), "mmddyy"),
Click to expand...
acTable, "CurrentPayPeriodData"
 
Bonnie said:
Ken, Ken, Ken, you wonderful person. You have given me
JUST what I needed!!! I really appreciate the quick
response. It works GREAT!

I want to sincerely thank you for taking the time to lend
a hand and pass along your knowledge. Folks like you have
truly brought me from scraping my knuckles to feeling like
I can do this. I'm lovin' it!

May the fortune falcon swoop down and snatch any pending
problems from your path as you have cleared mine!
Click to expand...


< G >

Makes my day! You're welcome.
 
Back
Top