Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  HOME    TRACKER    Visual Basic

Snapshot Viewer Format In Visual Basic (not VBA)

Is it possible to create .snp files within a VB project ???

We used an Access based program that is being "upgraded" to VB (in order to make a smaller and faster .exe file). Snaphot format was used to sendout reports. Clients had only to install the viewer.

I would love to continue using this .snp format.

Can anyone help me here ?

Jonas Roter
Rio de Janeiro - Brasil

View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Snapshot Viewer
I have a problem. A very confusing problem. I have searched this board and read every single post about the snapshot viewere. However, my situation has not been covered as of yet. I installed my program on some machines for beta testing this morning. Just to make sure they actually ran like I expected to, I started them up and did a few basic tasks. My problem began when i made my call to the snapshot viewer. I did this on four different machines and got a different result on each of them.

On the first machine - XP/Office XP - ran find, perfect execution

Next machine - XP/Office XP/Snapshot Viewer installed from Microsoft website - received error message "ActiveX component can't create object".On the first machine - XP/Office XP - ran find, perfect executionNext machine - XP/Office XP/Snapshot Viewer installed from Microsoft website - received error message "ActiveX component can't create object."Next - XP/Office XP/33gb free space on hard drive - received error message "Not enough temporary disk space to run requested operation", or something along those linesFinal machine - Windows 98/Office 97 Pro/Snapshot Viewer from Microsoft website - received error message "Can't open the database, it is either missing or exclusively open by another user"
Any information that could help me would be great. If it would help I will include the code that I use, in fact, here it is.

rptname = "rptWeeklySchedule"
OpenType = 2 'acPreview
Filter = ""
WhereCon = "tblClientData.PrimaryKey=" & cboSearchClientName.ItemData(cboSearchClientName.ListIndex) _
& " AND tblScheduleGroup.PrimaryKey = " & lstSchedule.selectedItem.SubItems(ScheduleKey)

Private Function OLEOpenReport(strDBName As String, _
strRptName As String, _
Optional ByVal intDisplay As Variant, _
Optional ByVal strFilter As Variant, _
Optional ByVal strWhere As Variant) As Boolean

On Error GoTo OLEOpenReport_Err
IncreasePGBar 10
' Create Automation object.
Dim objAccess As Object
Set objAccess = CreateObject("Access.Application")

' Open the supplied database.
' Optional parameter at the end of statement
' indicates exclusive mode if set to True...
objAccess.OpenCurrentDatabase strDBName, False
IncreasePGBar 25
' The OpenReport method uses the following arguments...
' Report Name - Name of the report object.
' View - Display in Print Preview or send to printer.
' 0 - acNormal - Print report
' 1 - acDesign - open report in design (n/a in runtime)
' 2 - acPreview - open in preview window
' Filter Name - Name of a saved filter query.
' Where Condition = valid SQL where condition.

If IsMissing(intDisplay) Then intDisplay = acNormal
If IsMissing(strFilter) Then strFilter = ""
If IsMissing(strWhere) Then strWhere = ""
IncreasePGBar 40
objAccess.DoCmd.OpenReport strRptName, intDisplay, strFilter, strWhere
IncreasePGBar 60
objAccess.DoCmd.OutputTo acOutputReport, strRptName, acFormatSNP, App.Path & " emp.snp", False
SnapshotViewer1.SnapshotPath = App.Path & " emp.snp"

IncreasePGBar 80

' Close Microsoft Access session instance without saving anything
objAccess.Quit 2
IncreasePGBar 90
Set objAccess = Nothing

OLEOpenReport = True
IncreasePGBar 100
frmReport.pgBar.Visible = False
Exit Function

MsgBox error$(), vbInformation, "Automation"
Resume OLEOpenReport_End
End Function
This code was copied from the Microsoft website and modified.

This code works on one beta machine, and it works fine on all the machines here at my office, however it does not work on those three machines (if not more) any help would be greatly appreciated.

Snapshot Viewer
I have a snapshot viewer that shows data and it works fine, but how come that it leaves the file on the desktop even after I closed the viewer (even the entire program)?

Its kind of annoying to have to erase all the files that are being made.
Eventually the whole desktop will be full

I have the program lying on the desktop.

Snapshot Viewer?
I have question about Snapshot viewer also? I have clients who will view MS access report but they don't have actually have MS access installed on their machines. My only concern is that will they be able to view access reports still if I use them to display in Snapshot viewer? Please let me know

SnapShot Viewer ??
anyone knows what is that for ?

Snapshot Viewer Control

Does anyone know what you can do with the snapshotviewer control ?
And how it works ?

I've tried to use it but it won't ....

it seems to be a nice control tool.. ?



Snapshot Viewer Not Display Numbers

I use Snapshot Viewer To view the MS Access 2000 Reports. But Unfortunately, the numbers in these reports are not displayed in the Snapshot Viewer.
I use MS Windows 2000 SP3

Waiting for you reply..


Access Reports And Snapshot Viewer
I am trying to save access reports as .snp files, it all goes well except when the report has 2 images on it, only one is shown in the snapshot viewer, but on print both are printed..... Has anyone else come up against this?


Snapshot Viewer Not Display Numbers
I use the Snapshot Viewer to display MS Access 2000 reports.
Unfortuanately, the numbers are not displayed in the Snapshot viewer.
I use Windows 2000, SP3.
Plz help me if you see this before


Visual Basic With Crystal Report Viewer
I have had a number of problems using Crystal Reports in a Visual Basic application, but finally, finally have the problems resolved - except for one. This is a new one, something that has popped up just recently, and I am hoping there is a simple explanation.

I am loading the Crystal Report into the Visual Basic Crystal Report Viewer - which works fine. I press the Print icon on the CR Viewer, and nothing prints. No error, nothing. I go to Settings, Printer, and test the printer, and it prints a test page fine. I signed off as my client ( I was testing under his login), log-in as myself (I have higher machine permissions) but have the same problem. I go back to my own cubicle, with my own machine, and run the executable, which points to a different printer. When I click the printer icon in the CR viewer, nothing happens. But the printer prints anything from any other application. I even tried the program directly from the Visual Basic Development Environment, the same problem.

Anyone had this before? I hope so, so that you can tell me how to fix it. Bringing this application up has been a long battle, and this appears to be the last item that is 'stuck'

thank you, laurie

How To Use Crystal Reports Viewer In Visual Basic?
how to use crystal reports viewer in Visual Basic and what is advantage of using crystal reports viewer? explain with example.

Previewing Access Reports With Snapshot Viewer Problem- Plz Help
My code:

Private Sub Command1_Click()
Dim Acc As Access.Application
Set Acc = New Access.Application
Acc.OpenCurrentDatabase "c:windowsdesktop
ewLazer Database.mdb"
Acc.DoCmd.OpenReport "Employee Job Pay", acViewPreview
Acc.DoCmd.OutputTo acOutputReport, "Employee Job Pay", acFormatSNP, "c:windowsdesktop
ew emp.snp", False

Set Acc = Nothing

Form1.SnapshotViewer1.SnapshotPath = "c:windowsdesktop
ew emp.snp"

End Sub

It works, except for one small issue. When the report is displayed in the snap shot viewer it is TINY, and as far as I can see it only displays certain characters. I can't zoom in either and when I try to print the report, all i get is garbeled info.

Any ideas?


Revolution3d Half-Life Model Viewer For Visual Basic.

As you know im asking a few questions so i can finalize my program I am making. I just need to know how to add this into my program. It is supposed to display Half-Life (which is a game) models (*.mdl) inside a Visual Basic Program. Its like a 3d engine. Its supposed to be easy and take like 3 minutes to implement. But i can figure it out. Is anyone familiar or could help me out with this?

Article Discussion: Visual Basic 6.0 Add-In Database Viewer/Code Gen.
Article Discussion: Visual Basic 6.0 Add-In Database Viewer/Code Gen. ...?

Visual Basic Data Format?
I have a COM interface which is either expecting UTF-16 or UTF-8 data to be passed in. I always understood that under the hood, VB is UTF-16, but this does not seem to be the case because if I pass it directly to the COM interface, the Encoding is not correct.

Is there something you need to do to get it into UTF-16.

Additionally, anyone know how to get it into UTF-8 as an alternative?


Visual Basic Data Format?
I have a COM interface which is either expecting UTF-16 or UTF-8 data to be passed in. I always understood that under the hood, VB is UTF-16, but this does not seem to be the case because if I pass it directly to the COM interface, the Encoding is not correct.

Is there something you need to do to get it into UTF-16.

Additionally, anyone know how to get it into UTF-8 as an alternative?


I Need Visual Basic Tutorial In PDF Format .............
I am doing Visual Basic course. I need tutorial in PDF format . If any is having that material please send me.............


Using ExCel Format In Visual Basic Form

How can PERSONALIS and ExCel sheet ???

Format Excel File From Visual Basic
How do I format the excel work book from Visual Basic. I export a file to Excel and then I want to format fields such as phone number and date, how do I do that?

Here is part of the code for Excel file.

Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object
Dim numRows As Integer = ds.Tables
'Start a new workbook in Excel.
oExcel = CreateObject("Excel.Application")
oBook = oExcel.Workbooks.Add

Visual Basic Internal Object Format
Does anyone have any info on the internal structure and linking methods of VB's .obj files. Specifically, are they compatible with the new Platform SDK linker? I want to link some C++ code into a VB App.

Checking Word Format From Visual Basic
Is anybody aware of how to check the format of a document before you open it in Visual Basic? I am opening Microsoft Word documents from a Visual Basic application but want to know the version of the document I am opening. I am trying to avoid the case where somebody has inadvertently named an executable or excel document with a .doc extension and then attempting to open it and have it error out. I am assuming there is a Visual Basic or WordBasic call that will tell you if the document in question has a valid Word format or not. Thanks in advance.

How To Import Crystal Report Into Pdf Format Using Visual Basic.
fellow experts,

i would like to import my crystal report into .pdf format using vb. Any ideas in that ? would like to hear from you.

Opening And Saving An Excel Workbook In Another Format From A Visual Basic Executable
I would like to Open an Excel Workbook with the .xls extension and save that same Workbook as a xlCSV (.csv) type document.

Using an Excel Macro works

ActiveWorkbook.SaveAs "book1" , xlCSV

but when I attempt to use the SaveAs method from outside Excel I get the following error

run-time error 1004
SaveAs method of Workbook class failed

This is the code that I compiled and ran

Private Sub
     Dim Excel As Object
     Dim Workbook As Object
     Set Excel = CreateObject("Excel.Application","")
     Excel.Visible = False
     Set Workbook = Excel.Workbooks.Open("book1.xls")
     Workbook.SaveAs "book1" , xlCSV
End Sub

I have written a C++ program that processes a .csv document format, and I would like to convert .xls documents to .csv with this function for my C++ program.

Is there something wrong with my vb code, or is there something wrong with the SaveAs method?


Word And Visual Basic [ How Can I Get The Save As Window Through Visual Basic? ]
Hi, I made a small program in visual basic that with the use of

Dim oWord as new word.application
Dim oDoc as new word.document

fills a document with some data from the visual basic.
I want when those data are loaded in word the save or save as window to appear.
The command oDoc.saveAs saves the document without even asking for a filename.

What Can I do?

How Do I Run A Program I Made In Visual Basic On A Computer Without Visual Basic?
I created a program in Visual Basic and I was curious at what I needed to do to be able to install or use this program on a computer without Visual Basic. Any help would be great! Thanks in advance.

Extracting Visual Basic Source Code From Visual Basic EXE
hi everyone,

Well actually the problem in my case is that i had mad an EXE in VB6 around a week ago and had stored the EXE and th source code in two diferent folders. By mistake somebody ha deleted the source code folder. I wanted to make some changes i the EXE code and Now i have only the EXE folder to deal with.

Is there any method by which i can extract the Visual Basic cod from the VB EXE. Is there any application or software which ca help me in this? Do give me the hyperlink for downloading th EXE for the extraction if possible.

Please let me know at the earliest.

Thanks in advance.


*Challenge* Rich Text Format In Crystal Report Viewer
I am actually writing my text data in the Rich Text Box of VB6. I have given buttons to do some formatting like 'Bold', 'Tab' etc. for the Rich Text Box data like MS WORD. The data is then saved in the Access Data Base in RTF format. When I retrieve the data from the Access data base to VB6, it is OK. But when I retrieve the same data in Crystal Reports 8.5, then CR is not able to interpret the data correctly. The text is OK but the formatting is disturbed.

Is Visual Basic Script As Ubset Of Visual Basic

Is visual basic script a subset of Visual Basic code?

Visual Basic Items Removed From Visual Basic.NET
A while ago (maybe up to a year) I had found a web page (probably a Microsoft MVP's home age) that had a list of about 100 things that were removed from Visual Basic in the transition to Visual Basic.NET. As it is, I would like to look at that again, but I can't seem to find it on my computer. Does anyone remember this page and/or have a copy of the link or the file that was on it. It has particular things like Debug.Print is no longer valid and MsgBox function is not supported. I've look on Microsoft's website and found a great deal of information about implementation difference, but I can't seem to locate this particular piece. If anyone could help I would appreciate it very much.

Thanks in Advnance

Nick August

Fwd: How To Disable Basic Functionality Of Back Space & Delete Key In Visual Basic
<html><div style='background-color:'><DIV>
<P><A href="" target=_top><IMG alt="Image by" src=" flamingtext_com_1057144048_20660.gif" border=0></A> <BR><BR>
<DIV>Try to use API's i am sure u will get ur problem</DIV></P>>Hi all
<DIV></DIV>> can any one tell how to disable back space & delete keys in perticular
<DIV></DIV>>text box.
<DIV></DIV>>thanks & regards,
<DIV></DIV>>Sridhar cs
<DIV></DIV>>*Manage Subscriptions:
<DIV></DIV>>*Leave Group:
<DIV></DIV>>*Questions: mailto: email@removed
<DIV></DIV>>*Terms of Use:
<DIV></DIV>>*Copyright (c) ITtoolbox and message author. No redistribution.
<DIV></DIV></div><br clear=all><hr>Add photos to your messages with <a href="">MSN 8. </a> Get 2 months FREE*.</html>

How To Disable Basic Functionality Of Back Space & Delete Key In Visual Basic
Hi all

can any one tell how to disable back space & delete keys in perticular
text box.

thanks & regards,
Sridhar cs

Code Change From Visual - Visual Studio 2005
I am working on a tuturial that i have for Visual ( for now )

I am working with Visual Studio 2005.

I have been working on a code to change the text color by the name put into
the text box.

Visual Basic .Net code.
Label2.ForeColor = Color.FromName(TextBox1.Text)

i get the error
Name 'Color' is not declared.

I was wondering if someone can show me how things would be in Visual Studio.

thank you

Difference Between Visual Basic And Visual
visual basic and visual
i am very new to programming, and i was wondering if someone could explain the difference between visual basic and visual i Know this may be a silly question to ask, but if i dont i will never find out.
i am designing a system for a chinese restaurant, hopefully i hope create it in Visual basic.
if anyone can help, i would be grateful.

What Are Advantages Of Visual Basic .net Over Visual Basic 6.0?
I am thinking of installing Visual (standard version) in place of Visual Basic 6.0. I dont know what are the disadvantages of it and I am hesitating to do that. I thought that I should ask the forum before making this decisions.

Would someone help me to know the followings.
1. If I install, and if I do programming in, will I be able to run it in Visual Basic 6.0?

2. Can I do everything that I do in Visual Basic 6 in Visual Basic .net?

3. Are there things that I can do in Visual Basic . net which can not be done in Visual Basic 6.0?

4. Would you recommend Visual in place of Visual Basic 6.0?

Thanks in advance.

[Solved]Visual Basic && Visual
Wat is the difference between Visual Basic & Visual

I just dont understand.....are they 2 different programming languages? Are they related to each other?
Do they both need the Ms Visual Basic software to develop?.....
Which is more powerful & which is better for beginners?
What is there in thats not there in VB....?
pls help me out with this...

Upgrading From Visual Basic 3 To Visual Basic 6
Has anyone upgrade a project from VB3 to VB6?

What Is The Different Between Visual Basic And Visual Basic Access?

actually i'm going to do a database to track student attendance, where the student need to scan their student ID card.

which software is suitable for me? Visual basic or Visual basic access?

actually what is the different between these two?

can anyone explain to me?

Upgrading From Visual Basic 3 To Visual Basic 6
<html><div style='background-color:'><DIV>
<P>Is it possible to upgrade a project from VB 3 to VB 6?</P></DIV>
<P>Avi Manor<BR><BR></P><BR><BR><BR></DIV>
<DIV> </DIV>
<DIV></DIV></div><br clear=all><hr>Get your FREE download of MSN Explorer at <a href=''>http: //</a><br></html>

Visual Basic 6 To Visual Basic 5 Conversion
What has to be done to the files in a VB6 project to get it to run on VB5CCE?

DLL Visual Basic 6 On EMbedded Visual Basic 3.0
Hello Friends, as I can create a DLL for embedded. or as I can have something similar to FileListBox of VB6, I want to recover the archives that are in a directory in individual.

Hola Amigos, como puedo crear una DLL para embedded.

o bien como puedo tener algo parecido a FileListBox de VB6, quiero recuperar los archivos que se encuentran en un directorio en particular.

Basic Question On Visual Basic (counting Rows)
Hi friends,
i'm a novice of VBA. I'm trying to write a sub that needs to count the rows of my sheet.
I't seeems there's no way to understand automatically how many rows/columns are used in a sheet.

Can you help me, plzs?

URGENT Help Required Basic Visual Basic Code
How do I bring up records from a list box??? this is what I have so far of my programming...

Option Explicit
Dim FileName As String

Private Sub cmdAddFileWrite_Click()
Dim Name As String
Dim Age As String
Dim DOB As String

Name = txtName.Text
DOB = txtDOB.Text
Age = txtAge.Text

Open FileName For Append As #1
Write #1, Name, DOB, Age
Close #1
txtName.Text = ""
txtDOB.Text = ""
txtAge.Text = ""
End Sub

Private Sub cmdDisplay_Click()
Dim DataToDisplay As String
Dim Name As String
Dim Age As String
Dim DOB As String

Open FileName For Input As #1
Do While Not EOF(1)
Input #1, Name, DOB, Age
lstdisplay.AddItem Name

Close #1
End Sub

Private Sub Form_Load()
FileName = App.Path & "AddPlayer.txt"
End Sub

That is wha I have so far I mean I have a list box there where it displays the data that has been inputted, now how do I get that to link up wit a record something to do with a module?

Basic Question About Excel Macros And Visual Basic
I have a macro in Excel that takes some input on data ranges and produces charts based on the input. I want to place those charts (a number of them are generated) at a certain point in my excel worksheet. I know I can nudge it over by a certain amount but I can never tell where Excel will place them so I would like to just say "hey chart, sit here". Being able to do that in relation to cells would be great. Also, I would like to know if there is any way to resize the chart without using the percent. Once again, in realtion to cells would be great. Thanks for your help.

Apply Windows Visual Themes From Visual Basic?
I am moderately new a visual basic - i know quit a bit - but not as much as some people - was just wondering - is it possible to make a visual basic program that applies a windows visual style - if so - how?

Data Type Conversion From Visual C++ To Visual Basic
I'm trying to convert some code from Visual C++ to Visual Basic. There are some types, however, that I cannot seem to figure out what they should be. The C++ types are dpecifically WORD and DWORD. What should they be in Visual Basic? I thought DWORD is a Long, but I have no idea what a WORD would be. Specifically, I'm determining the types from the BITMAPINFOHEADER structure.

Microsoft Visual Studio 6/Visual Basic 6 Sp6 RELEASED!!!!
Microsoft released Service Pack 6 for Visual Studio 6, download the latest(and final) service pack if you have VS6/VB6 installed.

Official Page
Official Page of sp6

List of Fixes
See the fixes from sp4 and sp5

Direct Download
Click here to download it (About 62mb)

Download it, it has many fixes included!

As BrianS told me: VB6 SP6, its only 26mb and VB Runtimes sp6 its only 1.02mb

Enjoy the new service pack! It is the LAST!!!!!

Linking To DLL's Created In Visual Studio From Visual Basic
Can anyone give me some usefull tips or links on how to link to routines writen in C++ from Visual Basic

I am aware of the

Declare Function CloseHandle Lib "testdll.dll" (ByVal hObject As Long) As Long

type notation, but I am curious on what I have to do with my DLL to allow this notation to work.

Any suggestions or links would be a great help, thanks!!!

Visual Basic Development && The Visual C++ Shared Objects
I having a really irritating problem. I'm developing an Add-in in Visual Basic... however, to do the development I'm doing, I require the "Visual C++ shared Objects" reference to be added to the project.

Here in lies the problem. I also need the VB command left [as in left string copy - ie. left("aaaaa", 2)] The only problem is that by adding the "Visual C++ shared Objects" reference, the LEFT command is overridden with the C++ version which returns a long (or something like that).

In the References window, I've already set "Visual C++ shared Objects" to the lowest possible priority... is there anyway to get around this arrangement?

Thanks in advance,

How To Access Visual FoxPro Data In Visual Basic
I have a problem :(

I would like do delete a record in FoxPro data base with Visual Basic 6

I use ODBC kuhinja:

Const povezava = "Provider=MSDASQL.1; Persist Security Info=False; Data Source=kuhinja"

adott1.ConnectionString = povezava
adott2.ConnectionString = povezava

adott2.RecordSource = "SELECT sifra,grupa,naziv,nabavna,vpc " _
& "FROM izdelki "

to view data in datagrid

I delete a record :

adott1.RecordSource = "SELECT * " _
& " FROM izdelki " _
& " WHERE sifra='" & adott2.Recordset!sifra & "'"

Record is marked in FoxPro as deleted ( not yet PACK ) but in Visual Basic datagrid (adott2.refersh ) record is still in it.

How can i execute PACK in Visual Basic????


sorry for bad english :)

Copyright 2005-08, All rights reserved