Automated test of Access application

[trimba]

Hi guys,

Have you created an application that provide Automated test for Access application. What I mean from the Automated test is The Access Form will be open, all text fields will be populated, automate button click event on the form that results to opening the second Access form, etc.

Any idea how to achieve this.

Thank you, any help will be very much appreciated.

[Rabbit]

Hi guys,

Have you created an application that provide Automated test for Access application. What I mean from the Automated test is The Access Form will be open, all text fields will be populated, automate button click event on the form that results to opening the second Access form, etc.

Any idea how to achieve this.

Thank you, any help will be very much appreciated.

I suppose you can use the On Load event. And then code whatever you want to automate. As for the button click, use a different sub and call it for the automation process and the button click.

[JConsulting]

Hi guys,

Have you created an application that provide Automated test for Access application. What I mean from the Automated test is The Access Form will be open, all text fields will be populated, automate button click event on the form that results to opening the second Access form, etc.

Any idea how to achieve this.

Thank you, any help will be very much appreciated.

Normally this kind of aumated testing is done using a large scale software package like WinRunner or TestDirector

These packages are geared to provide threshold testing and reporting.
J

[trimba]

Hi Rabbit,

Thanks for your input ...

This is one of the solution, but then I need to put the code on every onLoad event in the form. And To switch between test mode and live mode is very hard thing to do (when you have sequence of form to be tested.)

[trimba]

Normally this kind of aumated testing is done using a large scale software package like WinRunner or TestDirector

These packages are geared to provide threshold testing and reporting.
J

Hi JConsulting,

Ok, I'll look into it ... But if it cost alot then it wont be the solution :P

[Rabbit]

Hi Rabbit,

Thanks for your input ...

This is one of the solution, but then I need to put the code on every onLoad event in the form. And To switch between test mode and live mode is very hard thing to do (when you have sequence of form to be tested.)

Switching between modes isn't hard at all. Just code everything in a normal module and have a global variable to switch between test mode and live mode.

[NeoPa]

PW,
Probably the best way to switch between Debug & Live mode is to have a 'Conditional Compiler' definition. This way the code is only created for the version that matches your current needs. I've included some sample code (Excel VBA but same concept for Access)

'#Const conDebug = True     'Only when the project is still in development mode.
...
            Select Case strType
            Case "Refresh"
                If strMode = "Process" Then
                    Call .Calculate
#If conDebug Then
                    .ScreenUpdating = True
                    .ScreenUpdating = False
#Else
                    Set shtThis = ActiveSheet
                    Worksheets("Data").Visible = xlSheetVeryHidden
                    .ScreenUpdating = True
                    .ScreenUpdating = False
                    Worksheets("Data").Visible = xlSheetVisible
                    Call shtThis.Select
#End If
                End If
            Case "Process"
...

If the {#Const conDebug = True} line is commented out, then the {#If conDebug Then} evaluates to FALSE.