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 / March 2005

Tip: Looking for answers? Try searching our database.

How to get access to generate a deadline date

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chris - 22 Mar 2005 05:07 GMT
I'm using Access 2003.  The database I'm trying to create tracks quality
complaints from my customers.  I've created a form that generates an ID with
auto number, allows the user to input the complaint, who the customer was
that complained, the date the complain was made.  I want to get access to
generate a deadline date automatically.  The date will be atleast 30 days
from the date the complaint was received.  I have 2 tables: 1)list of
customers and 2)problem table.  The problem table includes a field for the
deadline date.  I've tried using an expression to generate the deadline date,
but with no success.  I'm new to access and I'm trying to learn this program
as quickly as possible.  Any help would be appreciated.
Jeff - 22 Mar 2005 05:57 GMT
chris,
 several ways to do that.  easiest way maybe to set the default value of
the deadline day in the table.
  set the default value to =date()+30

> I'm using Access 2003.  The database I'm trying to create tracks quality
> complaints from my customers.  I've created a form that generates an ID with
[quoted text clipped - 6 lines]
> but with no success.  I'm new to access and I'm trying to learn this program
> as quickly as possible.  Any help would be appreciated.
Chris - 25 Mar 2005 02:41 GMT
Jeff,
Thanks for the help.  I tried it but it didn't work.  Do you have any other
suggestions?

> chris,
>   several ways to do that.  easiest way maybe to set the default value of
[quoted text clipped - 11 lines]
> > but with no success.  I'm new to access and I'm trying to learn this program
> > as quickly as possible.  Any help would be appreciated.
 
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.