Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access Date functions

Posted on 2008-10-05
1
Medium Priority
?
478 Views
Last Modified: 2013-11-29
I think there's like 3 ways of accomplishing this but...    I have a Text box on one of the forms that the user enters their Starting date of class.    I also have a combobox that keeps track of the status of the reservation.  (all be it manual)  Is there a way to tie the combo box and the text box together.    i want it to automatically change a "future" (combo choice)  reservation to "inhouse" (combo choice).  

SO.  I can get the combo box to change if the day is today but how do I write the  less than or equal to todays date?


If Text40 is < or = today then 
cboStatus ="Inhouse"

Open in new window

0
Comment
Question by:Rfinsl
1 Comment
 
LVL 66

Accepted Solution

by:
Jim Horn earned 2000 total points
ID: 22647025
If IsDate(Me.Text40) then
   If Me.Text40 >= Date then
      Me.cboStatus = "Inhouse"
   end if
else
   'Me.Text40 is not a valid date.  Handle it here.
end if
 
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question