Ask Experts Questions for FREE Help !
Ask
    JoeMicro's Avatar
    JoeMicro Posts: 21, Reputation: 1
    New Member
    		  
    #1

    Nov 29, 2008, 06:37 PM
    Represh Report with vba in access
    Hi Guy's,

    How do I refresh a report with vba in access

    Code:
     me.refresh
    does not work.

    My problem is I'm opening a report in acViewNormal and the report is longer than the page but I don't get a scroll bar unless I manually press refresh all (access2007).

    Thanks
    Joe
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Nov 29, 2008, 07:49 PM

    Why not use preview mode?
    JoeMicro's Avatar
    JoeMicro Posts: 21, Reputation: 1
    New Member
    		  
    #3

    Nov 30, 2008, 07:09 PM

    Because I need a lot of the benefits that come with the Report View

    Like dblclck, Select all, Bottuns, etc
    JoeMicro's Avatar
    JoeMicro Posts: 21, Reputation: 1
    New Member
    		  
    #4

    Dec 2, 2008, 05:11 PM
    Any ideas?

    (btw how do I change the tread title? From "Represh" to "Refresh"?)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Opening and Closing balance in access report. [ 3 Answers ]

I want access 2003 to generate the goods sold account report showing the opening and closing Balance. I have the issued qty. and sold qty. and the closing balance is an calculated value (issued qty. - sold qty.). Now, I want the report show the result as per my given starting date and show the...

Should I report or not? [ 3 Answers ]

Hi experts, I am a new employer, and I have one simple question about reporting 1099misc for one of my independent contractor. Since the condition of Box 7 of 1099misc shows: "At lease $600 or more to report", so what if the amout of a fee paid is less than $600?? Does that mean I don't need...

Can't access pop3, Pop3 access not working from my computer [ 1 Answers ]

I have XP SP 2 - Its been about a week since any of my pop3 accounts have worked (Gawab, Gmail, Spymac, Toughguy). The error messages I am receiving on all of my pop3 accounts are similar to : The host 'pop.gawab.com' could not be found. Please verify that you have entered the server name...

View more questions Search