Visual Basic

Re: How to send mail using local machine when proxy is Set at Remote(server) side

9-Oct-08 11:45

rohitkpurohit wrote:
This Question is related to our upcoming project in which we need to send mail using local machine.

OK. Your "local machine" will need to be running an SMTP server to send mail out. Oh! And that box is going to need access to the internet through your firewall too. On top of that, any upstream mail servers you end up going through are going to demand your SMTP server be authorize to use them.

rohitkpurohit wrote:
"Failure Sending Mail message".

This is probably because your machine cannot connect to the target server. Again, your proxy/firewall is getting the way. No amount of code you write will get around this problem. You simply have to get acces from your network administrators.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

rohitkpurohit11-Oct-08 17:44

rohitkpurohit

11-Oct-08 17:44

thanks for reply,

i will try as u told me.

How set the install directory after publishing

DCAUB8-Oct-08 22:46

DCAUB

8-Oct-08 22:46

Hello,

I have the following question.

I publish my application to a folder, after that i copy the folder to for example a usb stick with that stick i go to the PC where the programm needs to be installed.

When i run the setup the programm is auto installing and is working without any problems.

What i dont find is how i can set the directory where the programm needs to be installed . for the moment is is installing someware Locallow\...\...
So the directory is not in program files.

Can anyone tell me how i can change that ?

I have a second question, i need to copy also a DLL for my star ticketprinter to the installation destination folder is there a way that i can include it in the setup ?

Thanks

Best regards

DCA

Dave Kreskowiak9-Oct-08 3:39

9-Oct-08 3:39

Is it published using ClickOnce?? If so, you have no control over the install location.

If you created an .MSI installer (non-Express versions of VS,) then you've got control over where it installs. Or, you can even use third party installer creation apps, like InnoSetup, Wise Package Studio, InstallShield, ...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

DCAUB9-Oct-08 10:25

DCAUB

9-Oct-08 10:25

Hello,

Thanks for responding.

When i check the properties of the project i see in security settings Enable Clickone Security settings. When i uncheck that one and do a publish i can still not select the destination directory.

Can you please give one more time advise please.

thanks

DCA

Dave Kreskowiak9-Oct-08 11:41

9-Oct-08 11:41

I already said if you're using ClickOnce to deploy your application, and you are from what I can tell, you have zero control over the installation directory. Once again - are you using an Express Edition of Visual Studio??

It's that simple. I already told you want your options are.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

DCAUB9-Oct-08 16:47

DCAUB

9-Oct-08 16:47

Hello,

Sorry, i was forgotten to set in my mail wich version i use :

Visual Studio 2008 professional Service Pack 1

Can you please write me very short the steps i have to check ?

Thanks

Best regards

DCA

Dave Kreskowiak10-Oct-08 0:59

10-Oct-08 0:59

Add a Setup project to you solution. There's a wizard available to walk you through the basics.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

shell

Shazz Rock8-Oct-08 20:50

Shazz Rock

8-Oct-08 20:50

Dear All

I had used following code in VB6.0 to open test document through shell and I got following error....

Code: Shell "C:\shashi\test.doc"
Error: Invalid procedure call or argument

Code: Shell "C:\Program Files\Microsoft Office\OFFICE11\winword.exe" & "C:\shashi\test.doc"
Error: File Not Found

Please help......

Ashfield8-Oct-08 21:14

8-Oct-08 21:14

I think you are missing a space before the file name, so what you have is

winword.exeC:\shashi\test.doc

so try

Shell "C:\Program Files\Microsoft Office\OFFICE11\winword.exe" & " C:\shashi\test.doc"

Bob
Ashfield Consultants Ltd

Shazz Rock9-Oct-08 2:03

Shazz Rock

9-Oct-08 2:03

thanx for reply...
same error again actually there is no sapce present...

jzonthemtn8-Oct-08 23:36

jzonthemtn

8-Oct-08 23:36

Shazz Rock wrote:
Code: Shell "C:\shashi\test.doc"

You'll have to use ShellExecuteEx to do that.

Shazz Rock9-Oct-08 2:02

Shazz Rock

9-Oct-08 2:02

thanx...
do i hav to add preference or component....
if not then sorrrry to say it didn't work...
please give another solution....

jzonthemtn9-Oct-08 9:20

jzonthemtn

9-Oct-08 9:20

The ShellExecuteEx is an API. Google it next time before you 1-vote replies, or next time you won't get any replies.

Dave Kreskowiak9-Oct-08 3:31

Re: Passing variables in VB

9-Oct-08 3:31

Shazz Rock wrote:
Shell "C:\shashi\test.doc"
Error: Invalid procedure call or argument

There's only a couple of reasons this would have failed. The first is if the file path doesn't exist. The second is if there is a problem with the extension association (.doc) with an application. But, in this case, you would not have gotten the error you did.

Shazz Rock wrote:
Shell "C:\Program Files\Microsoft Office\OFFICE11\winword.exe" & "C:\shashi\test.doc"
Error: File Not Found

It didn't work because you tried to execute something called Program, with the command line parameters of Files\Microsoft and Office\OFFICE11\winword.exe and C:\shashi\test.doc. Spaces, anywhere in the command line, are treated as delimiters.

You need to wrap full path specifications in double quotes so they are treated as a single component of the command line.

Your code should be closer to:

Shell """C:\Program Files\Microsoft Office\OFFICE11\winword.exe"" & _
    " " & """C:\shashi\test.doc"""

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Passing variables in VB

piejun8-Oct-08 19:49

piejun

8-Oct-08 19:49

"hello

I have following problem, I want to pass a variable in VBA code (MS Access)

M_Variable = "Text"

with Mrst

![M_Variable]= "AnotherTextString"

end with

The problem is I don't know how to pass this variable on.

Do I have to put hyphens? ("'"M_Variable"'" or [ & "'" & M_Variable & & "'" & ]) I tried some more combinations but they didn't work.

Many thanks for your help

Pierre

Ashfield8-Oct-08 20:22

Re: Passing variables in VB

8-Oct-08 20:22

Try this

dim x as string
x = Mrst![M_Variable]

Bob
Ashfield Consultants Ltd

piejun8-Oct-08 20:59

piejun

8-Oct-08 20:59

Hello Bob

Thank you for your reply.
It gave me a hint. following solution worked.

With MyRst
.AddNew
.Fields(MyString) = mychaine(M_Number)
.Update
End With

Thanks again

Pierre

Re: Passing variables in VB

Ashfield8-Oct-08 21:15

8-Oct-08 21:15

No problem.

Bob
Ashfield Consultants Ltd

No i dont know much

WEB2BABA8-Oct-08 16:20

WEB2BABA

8-Oct-08 16:20

i thought it is not very difficult to create such a fn

Re: No i dont know much

Ashfield8-Oct-08 20:24