Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / September 2006

Tip: Looking for answers? Try searching our database.

Reading beginning and ending dates...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
stumped beginner - 28 Sep 2006 14:48 GMT
I am trying to create a form that will take Start Date and End Date from the
main form and give me a text box for each year between the two dates.

Example:
Start Date is 05/31/2000; End Date is 1/12/2006... when I go to the second
form, I want text boxes for 2000-2006 to appear.
Maver911 - 28 Sep 2006 16:59 GMT
hey stumped beginner,
  scenerio:
     2 comboboxes one with beginning date and the other with ending date.
     after you select the second date youd want 6 textboxes to be created
and in        
     them you want the dates formated?   well you could do something liek  
this where after the second combobox "AfterUpdate" sub use the following
format:    

for i=1 to Format(combobox2name - combobox1name, "yyyy")
  [add each date between that range in the 3rd combobox]
next i

This is untested. you might have to tweak it a bit. but this is the just of
what you need to do. Hope this helps alittle

> I am trying to create a form that will take Start Date and End Date from the
> main form and give me a text box for each year between the two dates.
>
> Example:
> Start Date is 05/31/2000; End Date is 1/12/2006... when I go to the second
> form, I want text boxes for 2000-2006 to appear.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.