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 ToolkitsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / November 2008

Tip: Looking for answers? Try searching our database.

Open up a form with today's date

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ChuckW - 21 Nov 2008 19:40 GMT
Hi,

I have a form called frmSalesAW with a subform contained in it called
frmCallLogAW.  It is based on a query called qryCallLogAW which is based on a
table called tblCallLogAW.  There are fields such as BusinessDate,
PhoneDials, AppointmentsMade etc and about 300 records in the table.  There
is actually a record for each business day from November 2008 to December
2009.  The BusinessDate field is field in with these date values while all of
the other fields are blank.  I have created the frmCallLogAW form so that a
sales rep can open the main form and then fill out numeric information into
this form.  It is in single form format where the user uses the navigation
buttons to toggle to yesterday or tomorrow.  I want to write some vba code
which will always open the form to todays business day with the cursor being
on the field PhoneDials.  Can someone help me with that?

Thanks,
Signature

Chuck W

Adam Milligan - 22 Nov 2008 01:04 GMT
air code, but maybe...

docmd.openform "YourForm",,, "[YourDateField] = #" & date() & "#"

Adam

> Hi,
>
[quoted text clipped - 12 lines]
>
> Thanks,
 
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



©2010 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.