Results 1 to 4 of 4
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    528

    Get User Name for Page Footer Section in Report


    Hello my friends
    I have a database with users privileges. There is also a report that all of these users can print this report.
    What I want is for the username that printed this report to appear in the report's footer
    Thanks in advance

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,543
    Try:
    =Environ("username")

    as the Control Source property of a text box.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    528
    Click image for larger version. 

Name:	ee.JPG 
Views:	5 
Size:	43.6 KB 
ID:	41614Thanks Bob Fitzpatrick
    But this shows me the name of the computer (Windows)
    I mean here that I have a table inside the database of users working on the same computer.

  4. #4
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    528
    Bob Fitz I use this code below
    But the problem is that the database works on only one computer
    Code:
    Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
    Me.User = Environ("UserName")
    Me.Last_Modified = Now()
    End Sub

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

Similar Threads

  1. Force Report Footer to before Page Footer
    By Charles CL in forum Reports
    Replies: 15
    Last Post: 01-21-2016, 12:06 PM
  2. Replies: 12
    Last Post: 01-12-2016, 08:53 PM
  3. Replies: 2
    Last Post: 12-21-2013, 02:09 PM
  4. Replies: 2
    Last Post: 10-15-2013, 09:30 AM
  5. Replies: 26
    Last Post: 11-06-2009, 10:16 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