Go Back   Access World Forums > Search Forums

 
Showing results 1 to 4 of 4
Search took 0.00 seconds.
Search: Posts Made By: KAsad
Forum: Forms 11-09-2012, 06:59 AM
Replies: 8
Views: 894
Posted By KAsad
Re: Dlookup

It is only one form which shows all timesheets. In each line, I have timesheet ID, date and I need to show a delivery month which is based on a calendar. If the timesheet date is 01/05/2012, then the...
Forum: Forms 11-09-2012, 06:49 AM
Replies: 8
Views: 894
Posted By KAsad
Re: Dlookup

Yes, I have checked the link but I have missed the point that I have to put # for date field.

Now I have changed it to
=DLookUp(" [CALENDAR]![FIN_MONTH] ","[CALENDAR]","[CALENDAR]![FIN_YEAR] =...
Forum: Forms 11-09-2012, 06:24 AM
Replies: 8
Views: 894
Posted By KAsad
Re: Dlookup

Thank you , I have changed it to this
=DLookUp(" [CALENDAR]![FIN_MONTH] ","[CALENDAR]","[CALENDAR]![FIN_START] <= " & [Forms]![frmFinanceCheckTimesheet]![TIME_DATE] & " AND [CALENDAR]![FIN_YEAR] = "...
Forum: Forms 11-09-2012, 05:52 AM
Replies: 8
Views: 894
Posted By KAsad
Dlookup

Hi

I have this Dlookup in my form in the source control o f a field but it does not work
=DLookUp([CALENDAR.FIN_MONTH],[CALENDAR],[TIME_DATE]>[CALENDAR.FIN_START] And...
Showing results 1 to 4 of 4

 
Forum Jump



All times are GMT -8. The time now is 05:01 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World