User Profile

Collapse

Profile Sidebar

Collapse
litpost
litpost
Last Activity: Sep 18 '15, 05:16 AM
Joined: Jun 18 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • litpost
    replied to Check if Report is fully formatted
    in Access
    I solved it at last.

    - switched on docmd.Hourglass before button which opens the Report (button is located on Order Form) and switched off docmd.Hourglass on exit sub.

    - in OnClick event of "Send" button at the top did the check for MousePointer

    Code:
    If Screen.MousePointer = 11 Then Exit Sub
    Now User is not able to start sending until all process of button on Order Form is finished....
    See more | Go to post

      Leave a comment:

    • litpost
      replied to Check if Report is fully formatted
      in Access
      Yes, I have. I can trap error and maybe someway retry sendObject row. Its one of solutions, however, not the best.

      Another solution maybe with timer help.
      Here I have question: when exactly Report ontimer event starts?
      See more | Go to post

        Leave a comment:

      • litpost
        replied to Check if Report is fully formatted
        in Access
        We have "Send" button on Confirmation Report. Report loads in acNormal view and sometimes it takes couple of seconds. To send report I use
        Code:
        docmd.sendObject
        If some non-patient user hits "Send" button before Report finishes to load it brings them error. I need to freeze "Send" button until report is fully loaded/formatted.

        Jim, I had similar idea first to save PDF file on disk and after send it. But I doubt...
        See more | Go to post

          Leave a comment:

        • litpost
          started a topic Check if Report is fully formatted
          in Access

          Check if Report is fully formatted

          We have Order DB in Access where we collect and send Order confirmation to Clients. In Order Form I click button to open Confirmation Report in Normal view. I have "Send Report" button on opened report to send it to Client in PDF format.

          All works grate with small reports. Problem arrise when report has 15-20 or more pages. After some investigation I found out that at time of report load user press Send button and report...
          See more | Go to post
          • litpost
            replied to Calculated value invisible until been clicked
            in Access
            Hi Jim, thanks for the suggestion.

            We have 10 users in office and 20 users in production (their do scan all the products at every prod. proccess point). Office works 8 hrs / 5 days but production do 24 hrs / 7 days and here is the problem. In fact we nether have situation when all FE are logged off.

            I have FE versioning done through vbscript. Every time user clicks the script file the FE (master) copy goes to separate folder,...
            See more | Go to post

              Leave a comment:

            • litpost
              replied to Calculated value invisible until been clicked
              in Access
              It helps for sure to resolve this problem but then I loose control on FrontEnds. We have BackEnd based on Access. To make maintance I need to close all FrontEnds (30 users). On Server it is not an issue but on individual PC's - how can I manage it?

              P.S.: I know that such many users must run on more serious DB, such as SQL SERVER. We plan to move there but it is different story...
              See more | Go to post

                Leave a comment:

              • litpost
                replied to Calculated value invisible until been clicked
                in Access
                As promissed I am back with test results. Unfortunately it did not help but now it is certain that our problem is directly related with thin client of remote desktop. So, nothing to do with Access. Still question is open and if somebody has resolved it would by great help for us.
                See more | Go to post

                  Leave a comment:

                • litpost
                  replied to Calculated value invisible until been clicked
                  in Access
                  Thanks for reply a lot.
                  I'll do it today for all front ends. We do not use neither Web nor SharePoint but who knows, maybe it helps. Be back with results after few weeks.
                  Still if anyone have other suggestions would be nice to hear.
                  See more | Go to post

                    Leave a comment:

                  • litpost
                    started a topic Calculated value invisible until been clicked
                    in Access

                    Calculated value invisible until been clicked

                    We are running Access 2010 runtime on Server 2008 R2 with both FE and BE on it. Each user has own FE copy on Server which is opened from own PC through remote desktop.

                    After fresh Server restart all goes well for 1-2 weeks. But then some strange behaviour starts:
                    - values of all calculated fields - whatever, on forms or on reports - disapears. When I click on a field it shows up again. And refresh does not help;
                    - all...
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...