you will have to get the software for the camera and see if they supply a
programming interface that will let you control it from vba or some other
language that you could interface to vba.  if you are lucky they will supply
a dll with an interface that lets you call it from vb, if you are REALLY
lucky they may even give you an example of how to do it.  if not, try their
tech support site to see if they have a group that handles things like that.

I'm doing something similar with a scanner. The way I'm doing it is to run
the application software that came with the scanner from a button on the
screen. The code I used is listed below and came from the button wizard.

Private Sub ScanPicture_Click()
On Error GoTo Err_ScanPicture_Click

   Dim stAppName As String

   stAppName = "C:\Program Files\ScanSoft\PaperPort\PaprPort.exe"
   ' stAppName = "C:\Program Files\Canon\CanoScan Toolbox
Ver4.1\CSTBox.exe"  This was the first one
   Call Shell(stAppName, 1)

Exit_ScanPicture_Click:
   Exit Sub

Err_ScanPicture_Click:
   MsgBox Err.Description
   Resume Exit_ScanPicture_Click

End Sub