Results 1 to 2 of 2
  1. #1
    neil45156 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Mar 2011
    Posts
    4

    DLookup

    Hi Everyone,



    Just wondering if anyone can help me with this one.

    I am trying to get 2 text boxes to autofill off a DLookup event procedure. As the date changes (driven by system date) I want the 'day' text box to update to the correct day and the 'week' text box to update to the reflect the correct week number.

    I understand at the moment that part of my problem is in use of the term 'day' as part of my DLookupas it is undefined?

    Any help would be appreciated

    Thanks Neil45156

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    I am trying to get 2 text boxes to autofill off a DLookup event procedure. As the date changes (driven by system date) I want the 'day' text box to update to the correct day and the 'week' text box to update to the reflect the correct week number.
    I'm not sure what you mean by Dlookup event procedure, are you using the Dlookup() function directly or are you using it in a procedure off some event and if so what event?

    Couldn't you just set the default value for the date control to date() to populate it with today's date? For the week number, you can just use the datepart() function to display the weeknumber based on the date. There would be no need to store the weeknumber.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. DLookup example
    By pkstormy in forum Code Repository
    Replies: 1
    Last Post: 07-16-2012, 09:52 AM
  2. DLookup Help
    By Alex Motilal in forum Queries
    Replies: 3
    Last Post: 01-17-2011, 02:01 PM
  3. dlookup help
    By gsantacruz in forum Programming
    Replies: 9
    Last Post: 10-11-2010, 11:46 AM
  4. DLookup()
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 09-15-2010, 07:20 AM
  5. Need help with dlookup.
    By Keith in forum Database Design
    Replies: 8
    Last Post: 05-24-2010, 06:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums