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 / Forms / July 2008

Tip: Looking for answers? Try searching our database.

Default Value = Last day of the Current Month

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kay - 17 Jul 2008 19:59 GMT
Any Ideas?

Thanks in advance.
Kay - 17 Jul 2008 20:01 GMT
Sorry, I see that the subject cut off the last word.

Default Value = Last day of the  current month.

> Any Ideas?
>
> Thanks in advance.
boblarson - 17 Jul 2008 20:05 GMT
=DateSerial(Year(Date()), Month(Date())+1, 0)
Signature


Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP
Free Access Resources at http://www.btabdevelopment.com

> Any Ideas?
>
> Thanks in advance.
fredg - 17 Jul 2008 21:18 GMT
> Any Ideas?
>
> Thanks in advance.

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), crosspost by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Kay - 17 Jul 2008 21:53 GMT
Thank you for your help Bob.

Sorry for the inconvenience fredg.

> > Any Ideas?
> >
[quoted text clipped - 12 lines]
>
> It's a great site to visit anyway.
Kay - 17 Jul 2008 22:06 GMT
I went to the website you suggested.  I read Netiquette thoroughly.  I am not
a stranger to computers but I am to the world of newsgroups.  Several things
were unfamiliar to me.  Thank You:)  I would not want to offend anyone since
I could not have built my database without this site.

See Netiquette at http://www.mvps.org/access

> Thank you for your help Bob.
>
[quoted text clipped - 16 lines]
> >
> > It's a great site to visit anyway.
 
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.