• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

VBA Loop Problem

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    VBA Loop Problem

    Guys,
    Can anyone help me with the atatched code. Been working on it for to long. The problem is every time a run the code , the reports export fine and when the loop finshes my PC freezes.
    Would really apprecaite any advice. I have tried if exit statments to no avail.

    Private Sub Command91_Click()

    Dim db As Object
    Dim rs As Object
    Dim StrPractice As String
    Dim Practice As String
    Set db = CurrentDb()
    Set rs = db.OpenRecordset("SelectPractice")


    Do Until rs.EOF = True


    StrPractice = ("Practice")

    DoCmd.Echo False, ""

    Me.Practice = StrPractice

    DoCmd.OpenReport "Master Practice Report", acViewPreview, acNormal


    DoCmd.OutputTo acOutputReport, , _
    acFormatSNP, "C:\test\" & StrPractice & ".snp", False
    DoCmd.Close acReport, "Master Practice Report"

    rs.MoveNext

    Loop


    Set rs = Nothing

    Set db = Nothing


    Exit Sub

    End Sub

    #2
    My first move would be to put in an error trap and check if there is one being raised and put in some Debug.Prints so you can see exactly where the execution has got to.
    Never has a man been heard to say on his death bed that he wishes he'd spent more time in the office.

    Comment

    Working...
    X