+ Reply to Thread
Page 4 of 4 FirstFirst ... 2 3 4
Results 31 to 36 of 36

Thread: Chooser Form

  1. #31
    rivergum23
    rivergum23 is offline
    Barn Newbie rivergum23 is an unknown quantity at this point rivergum23's Avatar
    Join Date
    Feb 2009
    Posts
    31
    Rep Power
    3

    RE: Chooser Form

    Oh Ok...

    So I'll explain what I'm trying to do then. In the report that you created for me (see attached) I want to display both the "SkillID & "SkillDescription" on the report. So with this example in the report;

    SkillID SkillDescrition

    a1 Roofing
    b2 Carpentry

    etc,

    If you can show me how to modify the report query to do this that would be excellent.

    Thanks for you help again.
    Attached Files
    rivergum23, September 6th, 2009 06:17 PM
    Reply With Quote Reply With Quote
  2. #32
    AOG123
    AOG123 is offline
    Lightning Master AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123's Avatar
    Join Date
    Mar 2008
    Location
    Fortress Of Solitude
    Posts
    394
    Rep Power
    7

    i have simply added the skill id to the report query, Report_Current_Emp_Query

    Code:
    SELECT tblEmployees.EmployeeName, tblEmployees.EmployeeID, SkillsPossessedQuery.SkillDescription, SkillsPossessedQuery.SkillID
FROM tblEmployees LEFT JOIN SkillsPossessedQuery ON tblEmployees.EmployeeID=SkillsPossessedQuery.EmployeeIDFK
WHERE (((tblEmployees.EmployeeID)=forms!formmain.employeeid));
    See attached,
    Attached Files
    AOG123, September 6th, 2009 07:04 PM
    If i helped you, make me famous by clicking the
    Reply With Quote Reply With Quote
  3. #33
    rivergum23
    rivergum23 is offline
    Barn Newbie rivergum23 is an unknown quantity at this point rivergum23's Avatar
    Join Date
    Feb 2009
    Posts
    31
    Rep Power
    3

    RE: Chooser Form

    Thanks heaps for you help!!

    When I open up the query it comes up in SQL format, is it possible to change it out of SQL format??

    Cheers,
    Brett
    rivergum23, September 6th, 2009 08:11 PM
    Reply With Quote Reply With Quote
  4. #34
    rivergum23
    rivergum23 is offline
    Barn Newbie rivergum23 is an unknown quantity at this point rivergum23's Avatar
    Join Date
    Feb 2009
    Posts
    31
    Rep Power
    3

    RE: Chooser Form

    Ok,
    So I worked out how what your SQL statement did and applied it to the sample program I uploaded and got it working. However my program is now quite a little bit different and cannot get it working.

    I've attached my modified version of the program to show what I'm trying to do. If you run the "Report Query" and say enter a value of 4300 (which is the crane serial number) it runs the current query with all the information I need apart from the "Part Description" I have tried to incorporate the "Part Description" into the "Report Query With Part Desc " however the query now ceases to display any information.

    I have been bumming around for hours trying different configurations and cannot work out how to get it working. Probably easy for someone that knows how I figured.

    Anyway, if you can help me out again it would be much appreciated.

    Thanks Again!!
    Attached Files
    rivergum23, September 7th, 2009 07:52 AM
    Reply With Quote Reply With Quote
  5. #35
    AOG123
    AOG123 is offline
    Lightning Master AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123's Avatar
    Join Date
    Mar 2008
    Location
    Fortress Of Solitude
    Posts
    394
    Rep Power
    7

    See attached,

    Regards,
    Attached Files
    AOG123, September 7th, 2009 10:41 AM
    If i helped you, make me famous by clicking the
    Reply With Quote Reply With Quote
  6. #36
    rivergum23
    rivergum23 is offline
    Barn Newbie rivergum23 is an unknown quantity at this point rivergum23's Avatar
    Join Date
    Feb 2009
    Posts
    31
    Rep Power
    3

    RE: Chooser Form

    Works like a dream!

    Cheers Again,
    Brett
    rivergum23, September 8th, 2009 07:07 AM
    Reply With Quote Reply With Quote
+ Reply to Thread
Page 4 of 4 FirstFirst ... 2 3 4
« Previous Thread | Next Thread »

Similar Threads

  1. Time Entry Form
    By sbenj69 in forum Access Database Samples
    Replies: 5
    Last Post: May 1st, 2009, 06:48 AM
  2. Simple way to email form
    By Rebelle in forum ASP Development
    Replies: 17
    Last Post: August 14th, 2008, 05:03 PM
  3. Generic Form Handler
    By richyrich in forum .NET Development
    Replies: 3
    Last Post: July 28th, 2008, 02:34 PM
  4. filters on a form
    By javier_83 in forum Microsoft Access
    Replies: 4
    Last Post: July 28th, 2008, 02:03 PM

Bookmarks

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


SEO by vBSEO