Debugging VBA code

[Lou_Reed]

The db program that works fails at a certain point. This failure point is outlined in the VBA when I ask for debug. However, when I want to print it out, the print command in the drop down file menu is greyed out. Thus I cannot print this stuff out.



How can I print it out? I usually open a form in design view and select a control on the form, go to properties, select event, and then look at the code. That will not work here. I am not sure what form (if any) the code is associated with, but I would sure like to try and find the source of the runtime error.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Homegrownandy]

To stop debug mode there is a little square stop sign at the top. However this will remove the highlighted line.

you can press print screen on your keyboard and then print that. a good tool for this is lightshot if you google that. you can select an area on screen and print directly or save. hope this helps.

[jwhite]

Not sure why you want to print it out. I use a screen capture utility (like Greenshot) to capture an error message so I can then look at the code and the message. Setting breakpoints above the location where you think the error occurs works well too. An invaluable help is to include a Resume line in the error handling section of each module:

cmdFilter_Click_Error:    Call ErrorHandler(MODULE_NAME, "cmdFilter_Click", Err, Err.Description)
    Resume cmdFilter_Click_Cleanup
    Resume

Before running the code, set a breakpoint on the first executable line of your error handling section (in my case, Call ErrorHandler...). Then when the error occurs, execution stops on that line. Move the cursor from the breakpoint line to the "Resume" line and press F8. It will take you to the line that caused the error. I presume you include error trapping in your modules? Here is a complete procedure:

Private Sub Form_Open(Cancel As Integer)

    On Error GoTo Form_Open_Error

    Call FormAutoExec(Me, True)
    
     ...

Form_Open_Cleanup:
    Exit Sub

Form_Open_Error:
    Call ErrorHandler(MODULE_NAME, "cmdCancel_Click", Err, Err.Description)
    Resume Form_Open_Cleanup
    Resume
End Sub

Also, this link may help you learn more about debugging techniques: http://www.fmsinc.com/tpapers/vbacode/debug.asp

[Lou_Reed]

I have SnagIt. This is code that I did not write and some seems to me to be from a library borrowed from who knows where. I just want a gestalt on how this works. Thus I want the whole print out of the code.

Respectfully,

Lou Reed

[alansidman]

If you have SnagIt, then make a picture and post it. Also, can you not do a copy and paste?

[Lou_Reed]

The db is attached in the file along with a screenshot of where the code fails.

Go to form frmAttendence, select a meeting date in combo box list. Once selected then click on add meeting and you will get
an error. This is code I did not write. It is there. I am not sure what is does, but it seems some type utlity function
that would be standard in any db.

I am curious why it fails.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[jwhite]

In addition to where the error occurs:

totalPersonnel = DCount("[MeetingID]", "qryAttendance", "[MeetingID] = " & MeetingID)

It helps to tell us what the error is:

Error 2471
The expression you entered as a query parameter produced this error: '[MeetingID]'

qryAttendance is not returning a field called MeetingID. Not only that, but MeetingID isn't in either table (tblAttendance or tblPersonnel) that is referenced in the query! Is it instead supposed to be "ysnMeetingID" which is in tblAttendance?

This sample database is causing you loads of pain. Most times it is better to design your own database from the beginning than try to change an existing database to suit your needs.

[Lou_Reed]

I will have to find out. As I said I did not write that section of code. I apologize for the failure to completely inform you. I thought that once you ran the code the error would
show up and be self-explanatory. Again, sorry for the omission. I have been a program consultant on many different languages and some times, I fuss at students and tell
them how can I help you if I do not know what the problem is. I should follow my own advice.

Again sorry. It is not easy debugging somebody else's code and I should be more succinct in my posts.

Now it seems like that code is library code. Is there a website where I can get more literature on it.

That would make my life easier.

I did check the obvious website in the code's header, but got little help there.

Respectfully,

Lou Reed

[jwhite]

All's good. As it was supplied as a sample database, I doubt the original author(s) would be willing to help you dissect the design and code. Do you have a working document on what processes this database is supposed to automate - including table structures and business requirements? If you do, I would be willing to help you get this working within a week.