Access VBADiscuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
I actually have two questions I need to ask and I'll break it up so it's easier to answer.
Question #1: I have a table where I have two date fields. "First_Session_Used" and "Scheduled_Review_Date" are the two fields. I need to create a query which will take the date in the "First_Session_Used" and increase that date by one year, but also change it so that it is the first date in that month. So, if the date in "First_Session_Used" is 6/7/06, the date would need to be 6/1/07 in "Scheduled_Review_Date". So, I need an update query which will help me accomplish this. Incidentally, the table is "Tbl_Book_Holding".
Question #2: Once I get my dates updated in the table using the query above, I need to modify the form so that the "Scheduled_Review_Date" is done in the same way as Question #1. So, suggestions on how to modify the form so that it inputs the information that way.