Page 9 of 12 FirstFirst 123456789101112 LastLast
Results 121 to 135 of 167
  1. #121
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,285

    If the users have to scroll to the date, I probably would set up cascading combos. I have combos with a couple of thousand items, but users always type in the value they want as they have it on a paper form in front of them. I use a combo to get other columns of data.

    I've done it (make filtering selections) both on a form before the actual work form and on the actual work form. I'd say it depends on your desired workflow.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  2. #122
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    179
    Quote Originally Posted by pbaldy View Post
    If you type

    \\one.mda.mil\Public\TSC\Test Events\DSR Library\

    into a Windows Explorer window, can you navigate to that folder? Can you manually add a file there?
    Sorry, I was on vacation last week. That path did not work, but I got my network guy at work to help me sort it out. Thanks.

  3. #123
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    179
    One thing I'm noticing now that the PDF saves in the correct places is that inside the PDF, the Run Results are not displaying in sequential order. Sometimes it will display Run 3 as the first one, sometimes Run 1 or Run 2.

    Any thoughts on what is going on or how to make it always put them in order?

  4. #124
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    179
    Also, the BLUF text box I have on the DSRfrm ​is set to Yes for Can Grow, but it does not change size on the form or on the PDF.

  5. #125
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,473
    Add a sort order to the report to sort by the run number. As for the blue box check the CanGrow property in the report design view.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  6. #126
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    179
    Quote Originally Posted by Gicu View Post
    Add a sort order to the report to sort by the run number. As for the blue box check the CanGrow property in the report design view.

    Cheers,
    Thanks Vlad, that fixed the BLUF box size issue.

    Edit, I got the sort order figured out as well. Thanks!

  7. #127
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,473
    You're welcome!
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  8. #128
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    179
    Quote Originally Posted by Etoimos View Post
    Edit, I got the sort order figured out as well. Thanks!
    Well, I guess I spoke to soon. It appears that the sub form data is not being sorted correctly, they are just being displayed in a random order. On my DSR_rpt I added ORDER BY RunResultData.RunNumber; to the Record Source. My full Record Source looks like this:

    Code:
    SELECT DSRtbl.BLUF, DSRtbl.DSRExecutionDate, RunResultData.* FROM DSRtbl LEFT JOIN RunResultData ON DSRtbl.DSRExecutionDate = RunResultData.ExecutionDate WHERE (((DSRtbl.DSRExecutionDate)=[Forms]![DSR_frm]![DSRExecutionDate])) ORDER BY RunResultData.RunNumber;

  9. #129
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,285
    In a report, the sorting has to be specified in Group & Sort. The sorting in the record source is generally ignored.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  10. #130
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    179
    Quote Originally Posted by pbaldy View Post
    In a report, the sorting has to be specified in Group & Sort. The sorting in the record source is generally ignored.
    Thanks, that seems to have solved my issues.

  11. #131
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,473
    Great, (that is what I meant by "Add a Sort").
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  12. #132
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    179
    Quote Originally Posted by Gicu View Post
    Great, (that is what I meant by "Add a Sort").
    Cheers,
    I figured as much, I just did not know what I was doing.... as usual

  13. #133
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    179
    I'm tring to setup another form that will allow the user to select the Event and Date and then click a button to open different form in read only mode. Very similar to my Search Run Sheet form. I've got the cascading combo boxes working, but the code below does not open the form correctly (it prompts me to enter the Event and Date manually even though they were selected in the combo boxes):

    Code:
    DoCmd.OpenForm "DSR_frm", , , "Event = '" & Me.SearchDSREventCombo & "' AND Date = #" & Me.SearchDSRDateCombo & "# ", acFormReadOnly
    I think I might have an issue in the area that I put in bold.

  14. #134
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,285
    Those are both fields in the form's record source? The form's record source isn't by chance a query that has parameters on those 2 fields, is it?

    Date is a reserved word, and shouldn't be used as a field name. Sooner or later Access will confuse it with the Date() function. If it's too late to change, you'll need to bracket it most of the time: [Date]
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  15. #135
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    179
    This is my Form's Record Source:

    Code:
    SELECT RunResultData.ExecutionDate, RunResultData.Event FROM RunResultData;
    RunResultData is a table.

    Date was just the caption for the combo box label. That should have been ExecutionDate and I have updated the On Click to this:

    Code:
    DoCmd.OpenForm "DSR_frm", , , "Event = '" & Me.SearchDSREventCombo & "' AND ExecutionDate = #" & Me.SearchDSRDateCombo & "# ", acFormReadOnly
    After this update I still have the same issue.

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

Similar Threads

  1. Replies: 4
    Last Post: 10-13-2014, 09:20 AM
  2. Replies: 6
    Last Post: 02-19-2014, 11:11 AM
  3. Replies: 3
    Last Post: 07-03-2013, 10:38 AM
  4. Replies: 1
    Last Post: 10-30-2012, 10:29 AM
  5. Replies: 1
    Last Post: 07-11-2012, 08:36 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 - Senior Forums