Importing status dialog

[EKelly]

I have an image control on a report. The same image is displayed in the control on every page of the report. The images are stored in an external directory and I use the detail_format procedure in the vb editor to load the image control's '.Picture' property. The report is being called from a seperate visual basic application. The problem I have is that each time the report is loaded Access pops up the 'please wait... importing' status dialog. Not only that but this message box flickers on the screen and it looks terrible. Also the Access logo appears in the task bar but the word access dosn't appear beside the logo and (this sounds strange!) the logo travels along the task bar!Is there a way to suppress this dialog from popping up and will that sort the other problems?

Any help would be much appriciated.
Erin

 

[gol4]

If only want to hide what is going on during repaint use

Application.Echo False

then
Application.Echo true after code completes

 

[EKelly]

I tried that but it has no effect. Is there anyother way to 'turn off' or bypass the screen messages from access?

 

[PHV]

Have you tried this ?
DoCmd.SetWarnings = False

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[gol4]

you can also look at the syscmd function to see if that does you any good

 

[EKelly]

Set appAccess = CreateObject("Access.Application")
        
With appAccess

   .OpenCurrentDatabase (gblProjectPath & gblProjectDBName)
   .DoCmd.SetWarnings False
   .DoCmd.OutputTo 3, ReportName, acFormatSNP, 
gblProjectPath & ReportName & ".snp", False
   
   .CloseCurrentDatabase
   .Quit

End With

Set appAccess = Nothing

This is the code that im using in visual basic to manipulate the access database. The docmd.setwarnings gives me an error message of "Object doesn't support this property or method".
I appriciate the help so far. Has anyone anymore suggestions?

Thx
Erin

 

[PHV]

Perhaps you can't change SetWarnings when .Visible is false ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[gol4]

did you set references to the access object library in your vb project