Results 1 to 9 of 9
  1. 10-15-2017, 02:30 PM #1
    Silvera
    Silvera is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    May 2013
    Location
    California
    Posts
    65

    DBs for projects each project has a # stored in a form need to get # on 1st pg of report, in textbox

    I have several databases (DBs) that have unique numbers. The project information form has the basic proj. info. I have several possible reports for the users. Currently I am putting the proj. numb. manually in each report header. I want to have the reports capture the proj. numb. from the project information form. I'm using 2010 Office with Windows 10
    Reply With Quote Reply With Quote
  2. 10-15-2017, 03:52 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,898
    What do you mean by "several databases" - several tables or several db files?

    Isn't the project number in the report dataset?

    How are you manually putting in report header?
    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.
    Reply With Quote Reply With Quote
  3. 10-15-2017, 04:00 PM #3
    Silvera
    Silvera is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    May 2013
    Location
    California
    Posts
    65
    each DB is for just one project and there are several databases.
    Turns out it was a computer problem. I thought that my old code was no longer but "Me![lbltitle].Caption = DLookup("Proj_Ttl_ful_CAPS", "Proj_info")" and "Me![lblprojnum].Caption = DLookup("Proj_numb", "Proj_info")" are working fine now.
    Reply With Quote Reply With Quote
  4. 10-15-2017, 04:05 PM #4
    Silvera
    Silvera is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    May 2013
    Location
    California
    Posts
    65
    Each DB is for just one project and there are several databases.
    Turns out it was a computer problem. I thought that my old code was no longer but "Me![lbltitle].Caption = DLookup("Proj_Ttl_ful_CAPS", "Proj_info")" and "Me![lblprojnum].Caption = DLookup("Proj_numb", "Proj_info")" are working fine now.
    I do not know how to get threat tools
    Reply With Quote Reply With Quote
  5. 10-15-2017, 04:08 PM #5
    Silvera
    Silvera is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    May 2013
    Location
    California
    Posts
    65
    Each DB is for just one project and there are several databases.
    Turns out it was a computer problem. I thought that my old code was no longer good but "Me![lbltitle].Caption = DLookup("Proj_Ttl_ful_CAPS", "Proj_info")" and "Me![lblprojnum].Caption = DLookup("Proj_numb", "Proj_info")" are working fine now.
    I do not know how to get threat tools to mark this as Solved.
    Reply With Quote Reply With Quote
  6. 10-15-2017, 05:41 PM #6
    orange's Avatar
    orange
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    Click image for larger version.  Name: MarkAThreadSolved.jpg  Views: 10  Size: 99.4 KB  ID: 30822

    Click the button at top of page.
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
  7. 10-15-2017, 08:07 PM #7
    Silvera
    Silvera is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    May 2013
    Location
    California
    Posts
    65

    I did that but have notseen those options

    Quote Originally Posted by orange View Post
    Click image for larger version.  Name: MarkAThreadSolved.jpg  Views: 10  Size: 99.4 KB  ID: 30822

    Click the button at top of page.
    I have not seen the "Thread Tools" or the other options in the gray bar. How do I get them to appear?
    Click image for larger version.  Name: How to mark a thread as solved - SeaMonkey-001805.jpg  Views: 7  Size: 43.0 KB  ID: 30824
    Reply With Quote Reply With Quote
  8. 10-15-2017, 08:09 PM #8
    Silvera
    Silvera is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    May 2013
    Location
    California
    Posts
    65
    Actually it is the gray bar I have not seen it, only blue-gray bar
    Reply With Quote Reply With Quote
  9. 10-15-2017, 08:15 PM #9
    Silvera
    Silvera is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    May 2013
    Location
    California
    Posts
    65
    I just noticed that it is in the top. I hope I will now remember how. I am having memory issues, it is no fun getting old...
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Report textbox taking value from form textbox.
    By tazzzz in forum Reports
    Replies: 3
    Last Post: 08-21-2015, 12:06 PM
  2. Populate textbox with result of stored query object
    By FinChase in forum Forms
    Replies: 3
    Last Post: 01-14-2014, 03:56 PM
  3. Need help with designing table/query/form/report for project!
    By mfearer94 in forum Access
    Replies: 2
    Last Post: 07-29-2013, 03:23 PM
  4. Can Data be Stored in a Report
    By jgross in forum Reports
    Replies: 1
    Last Post: 02-02-2011, 10:31 PM
  5. report to compare projects' targets
    By Arest in forum Reports
    Replies: 0
    Last Post: 07-29-2009, 09:04 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums