benu302000
Programmer
I am trying to implement a form that will allow a user to search for records that are about to expire (VIA a date field marked "expiration date") through a form that allows them to enter the number of days from the current date to check for records about to expire. For instance, if the user enters the number 30 into the text box, the form should ideally return all records that are due to expire in the next 30 days.
This means I need access to the current system date through access, as well as any useful, quick-and-painless objects or methods that might exist code-wise for working with, and calculating dates. If there are any such objects or methods for the use of making dates easier to work with, I'd be much apppriciative of what they are, or how they work, or a reference to a resource that will tell me. Thanks in advance, you wonderful guys and gals are the only reason this project has advanced so far already.
This means I need access to the current system date through access, as well as any useful, quick-and-painless objects or methods that might exist code-wise for working with, and calculating dates. If there are any such objects or methods for the use of making dates easier to work with, I'd be much apppriciative of what they are, or how they work, or a reference to a resource that will tell me. Thanks in advance, you wonderful guys and gals are the only reason this project has advanced so far already.