By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Registration Renewal VB Code

P: 1
I'm new to VBA/MSAcces. I have academic project on membership registration DB.

I have Tables for Members and Items

I want when a member's name is searched, if the registration date is a year or more, I should have an Alert "renew registration"

How do I do this on the Registration Form

Attached Images
File Type: png Reg Form.PNG (5.9 KB, 125 views)
2 Weeks Ago #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 3,158

Welcome to Bytes!

When you find the member's name, use their current registration date and compare that date against your criteria using the DateAdd() function.

This will get you moving in the right direction--our forum does not usually provide complete solutions, but is designed to assist in trouble-shooting and advice/guidance.

Hope this hepps!
2 Weeks Ago #2

Expert Mod 5K+
P: 5,331
just a thought...
+ Conditional formatting for the control to highlight it
+ Personally I try to use message boxes for only really important issues and Calculated control on the form for simple flags... in this case it looks like you can shorten the height on the label for registration date and then add a textbox control that is normally blank, not in the tab order, transparent boarders, transparent background, locked and set the control source to IIF() to check the state of the date (based on TwinnyFo - combine this with conditional formatting and you have a fairly obvious flag to the user.

Or better yet, replace that label entirely with a textbox, using the IIF() to switch between messages, and conditional formatting on both the new "textbox acting like a label" and the data field

You can get fancier...
1 Week Ago #3

Post your reply

Sign in to post your reply or Sign up for a free account.