Visual Basic Discussion Boards

megadith1-Sep-04 5:08

1-Sep-04 5:08

Me again!
I was wondering if anyone knew how to send a command to print a PDF file without necessarily opening it. What I want to do is print a list of PDFs when i use a button event. So my list of PDF files will be in an array, and i can just print them off one by one to my printer. It would be nice to do this in a command line or something but i cant figure out how. any ideas??? thanks for all your help with my questions lately!

megadith

Re: Print PDF file

Dave Kreskowiak1-Sep-04 6:17

Dave Kreskowiak

1-Sep-04 6:17

The command line for launching Acrobat Reader and telling it to print a .PDF file is:

AcroRd32.exe  /p /h "%1"

Where %1 should be replaced by the full path to the file you want to print.
All you need to do is Shell launch that command line and you'll get your PDF's printed.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Detecting a remote user

dataman91-Sep-04 2:20

dataman9

1-Sep-04 2:20

I'm looking for a method to determine from a VB6 application if the current user is connected using Terminal Services.

Thanks for any pointers.

Re: Detecting a remote user

Dave Kreskowiak1-Sep-04 8:16

Dave Kreskowiak

1-Sep-04 8:16

You'll have to call the GetSystemMetrics Win32 API function to get this information.

Private Declare Function GetSystemMetrics Lib "user32" (ByVal nIndex As Long) As Long
Private Const SM_REMOTESESSION As Long = &H1000
 
Dim rc As Long
 
rc = GetSystemMetrics( SM_REMOTESESSION )
If rc <> 0 Then
    ' This session is running on Terminal Services.
Else
    ' This session is NOT running on Terminal Services.
End If

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

ISS... Help :(

Ranoush1-Sep-04 2:08

Ranoush

1-Sep-04 2:08

How can I create an ISS file to be used for silent installation when distributing an application?

Re: ISS... Help :(

Dave Kreskowiak1-Sep-04 6:19

Dave Kreskowiak

1-Sep-04 6:19

I though ISS file were for automating the installation of SQL Server and various services, not the creation of a database. I've just always used a SQL script to create the database on whatever server the user specifies.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: ISS... Help :(

Ranoush1-Sep-04 11:26

Ranoush

1-Sep-04 11:26

Well, I am lost here and I need help!
I need to create a file for silent installation for an application-created using VB.Net- that is going to be distributed via a network.
This can be done by an ISS file..But I have no idea how

Any suggestions?

Re: ISS... Help :(

Dave Kreskowiak2-Sep-04 4:28

Dave Kreskowiak

2-Sep-04 4:28

I don't know how an ISS file is going to come into play, because I've never used one for any installation, even a quite one.

If your app installation was built with the Visual Studio Installer and you created an .MSI file that contains your installation, you can launch it without any user interface, otherwise known as quiet mode, just by including the /quiet (or /q) command line switch. The command line to launch your install would look something like this:

msiexec /package myApp.msi /quiet

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

get project objects name

udiyochi1-Sep-04 1:17

udiyochi

1-Sep-04 1:17

i need to retrieve all object from a project
the project is an acces database adp or mdb or ade
iwant to show all objects name with out opening the project
i need help about opening a mdb acces file

shay dayan
shay@amitec-g.com
shayperi@012.net.il

Data validation in windows forms datagrid

Alexyeboah31-Aug-04 21:33

Alexyeboah

31-Aug-04 21:33

I have a dataview bound to a windows form datagrid. I wish to ensure that data is entered in a column (say 0) before other columns can be modified. When no text is entered in the column, the columnchanging event is not fired. How do you get this event to fire as long as that column has received focus and is now losing it?

I also tried putting the datagrid in the edit mode but it didn't work. Any ideas?

Thanks

How to perform Mail Merge to Printer (Office Automation)

jawadh9031-Aug-04 21:13

jawadh90

31-Aug-04 21:13

If I want to print only 5 - 10 records, Can I perform Mail Merge to Printer.
What would be easy way to do so.

Thanks

Re: How to perform Mail Merge to Printer (Office Automation)

Dave Kreskowiak1-Sep-04 6:01

Dave Kreskowiak

1-Sep-04 6:01

What do you mean by "to Printer"?

Are you trying to do this in code or in Word?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: How to perform Mail Merge to Printer (Office Automation)

jawadh901-Sep-04 6:13

jawadh90

1-Sep-04 6:13

I have Templates setup in Word. My program updates the SQL database and then it should print the templates. There is a Mail Merge in word document to the Database. Now If i want to print only 5 records instead of printing all records, It should perform Merge to Printer (same as in word). I want to create a program with From, To, Current, All which will allow me print records in the templates.

In the word there are features as "Merge to New Document", "Merge to Printer", "Merge to Email"

Thanks for replying.

Re: How to perform Mail Merge to Printer (Office Automation)

Dave Kreskowiak2-Sep-04 4:07

Dave Kreskowiak

2-Sep-04 4:07

You might want to look at How To Automate Microsoft Word to Perform a Mail Merge from Visual Basic .NET[^] on MSDN. Get the MailMerge to work how you want first, then worry about hiding Word.

When you get down to the bottom of the code, change the line

wrdMailMerge.Destination = Word.WdMailMergeDestination.wdSendToNewDocument

to read

wrdMailMerge.Destination = Word.WdMailMergeDestination.wdSendToPrinter

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: How to perform Mail Merge to Printer (Office Automation)

jawadh902-Sep-04 5:03

jawadh90

2-Sep-04 5:03

Thanks Dave

Database Synchronization

Rashid Ali Khan31-Aug-04 20:05

Rashid Ali Khan

31-Aug-04 20:05

i want to Synchronize my local database with remote database but i have to face problem in login

i m writing my connection string here, it opens the database but when i want to retrieve database, it gives me error login failed computername/guest
while my login name is not guest.....i have no account with the name guest.

/*************************************************************************/
Private Sub btnButton2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnButton2.Click
'Dim flag As Boolean = Me.ChkValidIP(Me.txtTextBox2.Text)
'If flag = True Then

Dim CS As String = "Network Library=DBMSSOCN;" & _
"Data Source=10.0.0.15,1433;" & _
"Initial Catalog=REIMSCDB;" & _
"User ID=sa;" & _
"Password= ;" & _
"Trusted_Connection=yes;"

Dim con As SqlConnection = New SqlConnection(CS)

Try
If con.State.Open Then
Dim sqlDA As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM LoginAccount", con)
Dim ds As DataSet = New DataSet
sqlDA.Fill(ds)
If Not ds Is Nothing Then
Dim dr As DataRow = ds.Tables(0).Rows(0)
MessageBox.Show(Convert.ToString(dr("LoginID")))
End If
MessageBox.Show("Done")
con.Close()
Else
MessageBox.Show("false")
End If
Catch oexp As System.Data.SqlClient.SqlException
MessageBox.Show(oexp.Message)
Finally
con.Close()
End Try
'End If

/*************************************************************************/
please try this code and send me solution if you know about this.

RAK

Re: Database Synchronization

Steven Campbell1-Sep-04 7:46

Steven Campbell

1-Sep-04 7:46

Try switching the Trusted_Connection=yes to Trusted_Connection=no. And please, please use a login id other than sa.

my blog

Re: Database Synchronization

Anonymous8-Sep-04 21:21

Anonymous

8-Sep-04 21:21

i tried all posibilities of login but it don't work send me another solution of it

Combo Box

Rashid Ali Khan31-Aug-04 19:59

Rashid Ali Khan

31-Aug-04 19:59

i need a combo box just like use in
OutLook express--->
Contacts--->
New Contact ---->
Email : Combo box Diaplay

Please open the outlook express and see the new contacts if you know help me

RAK

Re: Combo Box

Anonymous31-Aug-04 22:17

Anonymous

31-Aug-04 22:17

I think it's a menu, not a combobox

Re: Combo Box

Dave Kreskowiak1-Sep-04 1:50

Dave Kreskowiak

1-Sep-04 1:50

That's a menu, not a ComboBox...

All it is is a menuitem with a little down arrow icon next to it.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Create XML document

Pokemon_G31-Aug-04 19:50

Pokemon_G

31-Aug-04 19:50

How can I create an XML document as a result of Visual Basic code compilation?

Re: Create XML document

Dave Kreskowiak1-Sep-04 1:49

Dave Kreskowiak

1-Sep-04 1:49

What do you mean? The VB.NET Compiler doesn't output any XML documentation if that's what your talking about. At least not until VB.NET 2005 or Visual Studio .NET 2005...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Create XML document

Pokemon_G1-Sep-04 3:05

Pokemon_G

1-Sep-04 3:05

Thank you

Re: Create XML document

Purple Monk1-Sep-04 1:56

Purple Monk

1-Sep-04 1:56

what do you mean?

"cheese"

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.