Results 1 to 2 of 2
  1. #1
    Lkrsfan2282 is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    2

    Report Wizard creates Now() control

    Using Access 2013 Windows 7 64-bit
    When using Report Wizard Access generates a control box in the footer for =Now(). When the report displays is generates a popup that asks me to Enter Parameter Value for Now. In design view (2nd image) the field is in the footer but when I look at the properties the Control Source is blank. When I try to edit the control source and select Now from the Expression Builder function list I get "The expression you entered has a function name that Microsoft Access can't find." This problem first occurred yesterday and I have been using this version of Access since it came out and on this PC since then also.
    Thanks in Advance for your help.



    Click image for larger version. 

Name:	Access Parameter 1.PNG 
Views:	7 
Size:	6.6 KB 
ID:	20133

    Click image for larger version. 

Name:	Access Parameter.png 
Views:	7 
Size:	20.2 KB 
ID:	20132

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    I never use the form and report design wizards. Does this issue occur with a manually created report and textbox? Does it occur with Date() function?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Control Wizard Not working
    By mngisguy in forum Access
    Replies: 2
    Last Post: 01-21-2014, 03:18 PM
  2. Treeview control wizard
    By masoud_sedighy in forum Programming
    Replies: 10
    Last Post: 06-20-2013, 11:17 AM
  3. Control Wizard not functioning in reports
    By Harley Guy in forum Reports
    Replies: 2
    Last Post: 02-26-2013, 11:28 AM
  4. Replies: 1
    Last Post: 02-04-2013, 12:06 PM
  5. report (using the wizard) with 8 queries
    By fabiobarreto10 in forum Reports
    Replies: 12
    Last Post: 04-23-2012, 11:12 AM

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