Comments by _Vitor Garcia_

_Vitor Garcia_ 9-Sep-16 10:34am View

Reason for my vote of 5 \n Thank you Zeev.

_Vitor Garcia_ 15-Sep-15 7:33am View

Reason for my vote of 5 \n Usefull information. Thanks

_Vitor Garcia_ 19-Feb-15 9:38am View

Reason for my vote of 5 \n Like

_Vitor Garcia_ 9-Feb-15 9:24am View

You could add objRec_Emp or Z_GETEMPLOYEEResponse to your Generic List and then for each it :

For each Emp as Z_GETEMPLOYEEResponse in _MyGenericList
'do whatever you want with each element Emp
msgbox.show(Emp.ENGLISH_NAME)
next

or maybe query your generic colection using Linq.

_Vitor Garcia_ 26-Jan-15 9:16am View

Reason for my vote of 5 \n Thanks

_Vitor Garcia_ 21-Nov-14 9:37am View

Reason for my vote of 5 \n '' YEEEEEEEE FOUND IT

_Vitor Garcia_ 6-Nov-14 7:31am View

Sorry. I can't help you if you don't want to.

When you write
line 149
however I have now changed the coding here is the coding

without even pointing changes what do you expect from me ? To figure it out? Im sorry, but i can't.

_Vitor Garcia_ 6-Nov-14 7:03am View

And in which line is it thrown ?

_Vitor Garcia_ 13-Oct-14 5:02am View

Reason for my vote of 2 \n This is only an introduction ?

_Vitor Garcia_ 15-Sep-14 12:08pm View

Can you show an example of what you are trying to do ?

_Vitor Garcia_ 12-Sep-14 9:41am View

Please understand that to help you, you should help me to understand whats your issue.

For the given info, I can't.

I could tell you to insert a textfield with your name in there and run the report. It will show your name for sure, but i guess that that is not what you want.

Please improve question. If possible, insert some screenshot of the report, whats the error the compiler is throwing in which line, etc.

_Vitor Garcia_ 12-Sep-14 4:13am View

Hi Bhatt,
Can you elaborate more on your issue ?
Please improve question.

_Vitor Garcia_ 22-Jul-14 10:38am View

You could have 2 controls overlayed. One with the original picture, the other with the processed.

_Vitor Garcia_ 26-May-14 11:04am View

With the given text I can't help you. Please improve the question (actually i cannot see a question here).

What do you mean with "it is not working" ?
Whats is the error ?
Whats the value of Path1 ?

_Vitor Garcia_ 13-May-14 9:35am View

Check which application is using your files with http://lockhunter.com/

_Vitor Garcia_ 8-May-14 9:37am View

You have to use a timer to control the one minute changes

_Vitor Garcia_ 7-Apr-14 5:36am View

This is really too hard to figure out. Please elaborate

_Vitor Garcia_ 1-Apr-14 6:36am View

Here it is :
This is after you right click the image, select Format Graphic and select Picture tab
http://s4.postimg.org/eoa31sf19/Graphics_Location.jpg

_Vitor Garcia_ 1-Apr-14 6:24am View

To change the image's graphic location follow these steps :

right click the image, select Format Graphic, select Picture tab, click the conditional-formula button that look like a x2 and set the formula’s text to the name of the formula or parameter field that will contain the image’s URL.
Save the formula and click the OK button. Save the report and test it.

_Vitor Garcia_ 6-Mar-14 10:06am View

What have you tried so far and why is it so urgent ?

_Vitor Garcia_ 2-Aug-13 7:12am View

What database ? you are extracting txt files !?

Read your question as if you were not you.
You are not helping us help you.

Please improve question.

_Vitor Garcia_ 29-Jul-13 10:35am View

Reason for my vote of 5 \n Nice article, cool cat :)

_Vitor Garcia_ 18-Jul-13 12:52pm View

Reason for my vote of 5 \n nice

_Vitor Garcia_ 17-Jul-13 12:35pm View

Reason for my vote of 5 \n Really nice ! Thank you.

_Vitor Garcia_ 17-Jul-13 10:09am View

Reason for my vote of 5 \n nice

_Vitor Garcia_ 17-Jul-13 9:47am View

Why not create a user for your own with the right privileges and forget about sa ?
SQL Server don't change sa on its own.

_Vitor Garcia_ 15-Jul-13 9:13am View

Reason for my vote of 3 \n nothing new

_Vitor Garcia_ 5-Jul-13 12:38pm View

Please read http://mattgemmell.com/2008/12/08/what-have-you-tried/

You should use Begin Transaction, Commit transaction and if you catch an error you should rollback.

_Vitor Garcia_ 25-Jun-13 12:31pm View

You could yourvar.Replace(Chr(34), "") or yourvar.Replace("""", "")

_Vitor Garcia_ 19-Jun-13 5:37am View

Hi dp24,

Are you aware that your resulting sqlq is something like :
SELECT * FROM Sócios WHERE Número Sócio Maior 1

This comply with standard sql. Do you have a table whose name is Sócios ?
If you have this table then, if there is a Número Sócio column then you should [Número Sócio]. Maior is not recognized by sql. Use > instead.

I think you should understand first your sql query string...

_Vitor Garcia_ 18-Jun-13 12:19pm View

Reason for my vote of 5 \n nice to know the difference. ty

_Vitor Garcia_ 14-Jun-13 7:16am View

Gert,

did you tested my solution ?

Just asking bcause your code :

For Each cntrl In Me.Controls
If TypeOf cntrl Is TextBox Or TypeOf cntrl Is ComboBox Then
FileString &= cntrl.selectedvalue.ToString & ","
End If
Next
is only partial for my solution.
please confirm u tested this for as this :

For Each cntrl In Me.Controls
If TypeOf cntrl Is TextBox Then
FileString &= cntrl.Text & ","
End If
If TypeOf cntrl Is ComboBox Then
FileString &= cntrl.SelectedValue.ToString & ","
End If
Next

_Vitor Garcia_ 12-Jun-13 12:19pm View

Reason for my vote of 3 \n Nice effort

_Vitor Garcia_ 11-Jun-13 9:26am View

Its a simple VB.Net project with only one form.

_Vitor Garcia_ 21-May-13 6:20am View

im sorry. I was. My mistake.

_Vitor Garcia_ 21-May-13 5:44am View

I did a search for you and came up with this :

foreach (var e in Directory.EnumerateFiles("C:\\windows", "*.dll", SearchOption.AllDirectories))
{
Console.WriteLine(e);
}
which is in http://stackoverflow.com/questions/8676516/searching-by-file-extensions-vb-net
try it.

_Vitor Garcia_ 21-May-13 5:31am View

What have you done so far ?

_Vitor Garcia_ 17-May-13 6:40am View

You must find an external server like imageshack or postimage or Tinypic and host the image there.
After that you can post a link to that image in your question with the link provided.

_Vitor Garcia_ 17-May-13 5:15am View

Hi Haresh, Please provide the screenshot.
Aren't you sending a Enter char or any other special char before the text ?

_Vitor Garcia_ 16-May-13 12:32pm View

Reason for my vote of 5 \n Nice article !

_Vitor Garcia_ 14-May-13 6:44am View

Deleted

Whats your DB type ?

_Vitor Garcia_ 13-May-13 4:26am View

Reason for my vote of 5 \n Understood ! TY

_Vitor Garcia_ 6-May-13 9:54am View

Reason for my vote of 5 \n nice tip

_Vitor Garcia_ 8-Apr-13 11:43am View

Reason for my vote of 5 \n Thank you

_Vitor Garcia_ 8-Apr-13 4:34am View

Reason for my vote of 5 \n you rule

_Vitor Garcia_ 12-Mar-13 5:25am View

I don't have Segoe font installed so i'm using similar Segoe UI.
You were trying with Arial and now changed to Segoe.
Why didn't you change the 3rd parameter of Font construct from 0 to FontStyle.Regular ?
Please try the following code instead of yours and give feedback :
label.font = New Font(New FontFamily("Segoe UI"), 8.5, FontStyle.Regular)
instead of Label.font=New Font(Segoe, 8, 0)

BR,
VG

_Vitor Garcia_ 11-Mar-13 13:14pm View

Reason for my vote of 5 \n nice

_Vitor Garcia_ 11-Mar-13 10:16am View

Dear Junoli,
I don't use MySql. Yet, when i look at your code and see things like MySqlConnection i think immediatly in MySql.
Maybe you should use ADODB Connection instead.
http://msdn.microsoft.com/en-us/library/ms807027.aspx
Here you can search for details on this type of connection and in http://www.connectionstrings.com/ you can look after a connection string suitable to your case.

Here is an example on how to connect to SQL server database Pubs :

Dim cnn As ADODB.Connection = New ADODB.Connection
cnn.ConnectionString = "driver={SQL Server};" & _
"server=MySqlServer;uid=MyUserName;pwd=MyPassword;database=pubs"
cnn.Open

Best regards,
VG

_Vitor Garcia_ 11-Mar-13 8:59am View

same question here. It is always usefull this site : http://www.connectionstrings.com/

_Vitor Garcia_ 11-Mar-13 8:57am View

please provide me the messagebox code.

_Vitor Garcia_ 11-Mar-13 7:17am View

you said 8.5
If you want it to be 8 then do this :
lbltext.Font = New Font(New FontFamily("Arial"), 8, FontStyle.Regular)

Best regards,
VG

_Vitor Garcia_ 8-Mar-13 4:05am View

Hi niahant.
Could you please provide details regarding the error you refer ?

_Vitor Garcia_ 26-Feb-13 10:56am View

Reason for my vote of 5 \n Ty for your effort. It really helped me.

_Vitor Garcia_ 26-Feb-13 10:53am View

Reason for my vote of 5 \n Nice approach. Ty

_Vitor Garcia_ 20-Feb-13 4:15am View

what do you mean by "connect"?
Please elaborate more your question as we can't figure out what you are trying to achieve.

_Vitor Garcia_ 7-Feb-13 7:10am View

You can create a PDF file from scratch. Take a look here http://www.codeproject.com/Questions/160004/how-to-create-pdf-file-in-vb-net

_Vitor Garcia_ 7-Feb-13 6:36am View

Instead of working with MS Word, could you produce a PDF file ?

_Vitor Garcia_ 5-Feb-13 12:25pm View

Reason for my vote of 5 \n Nice !

_Vitor Garcia_ 5-Feb-13 5:05am View

you shouldn't post your email here, unless you love spam.
This is a public website and the solutions should be available to the community, not exchanged via email as you proposed.

You also posted a question as a solution, which isn't the right thing to do.

Take care,VG

_Vitor Garcia_ 4-Feb-13 4:31am View

Whats the question ?

_Vitor Garcia_ 31-Jan-13 4:22am View

the first thing that come to me mind is LINQ

_Vitor Garcia_ 21-Jan-13 4:34am View

Hi Ahmed,

Take a look at this : http://robindotnet.wordpress.com/2011/02/06/how-about-a-bootstrapper-package-for-sqlserver-express-2008-r2/

_Vitor Garcia_ 15-Jan-13 10:33am View

Do what Shanu2rick pointed, just be careful with SaveFileDialog as far as it browses in local HD, not in the SQL server HD

_Vitor Garcia_ 15-Jan-13 5:35am View

Can you elaborate a question ?
Please provide a full description of your issue telling what is the issue and what should happen.
I would like to help you if you let me...

_Vitor Garcia_ 14-Jan-13 7:43am View

Please clarify what you are trying to achive as far as this isn't a question. Please elaborate and post here some code snipet of what you already done.

_Vitor Garcia_ 14-Jan-13 4:23am View

I guess you should set :
.Filter = "*.*" 'for all file types
.IncludeSubdirectories = true ' or false depending on what you want to achive
.EnableRaisingEvents = true
for each of your fs objects.

_Vitor Garcia_ 9-Jan-13 7:43am View

either you bind it as joe_j said or you get the value from db and test
if recordset.field.item.value = "Yes" then
checkbox1.checked = true
else
checkbox1.checked = false

_Vitor Garcia_ 8-Jan-13 9:49am View

do you want to freeze panels like you do in excel ?

_Vitor Garcia_ 27-Dec-12 4:54am View

No Alan as for the solution provided, it only changes the file extension... Dont install it.

_Vitor Garcia_ 26-Dec-12 10:45am View

Im guessing you dont have focus on the application you need to do crtl+p. Can you confirm it ?

_Vitor Garcia_ 21-Dec-12 9:52am View

No i didn't.Please mouse over the this word.

_Vitor Garcia_ 21-Dec-12 9:40am View

I'm curious : Is your app running thru a remote desktop session ?
I had many issues like yours and solved it detecting if the com port exists with System.IO.Ports.SerialPort.GetPortNames() and testing if the port is open with COM_PORT.IsOpen before writing to it.

_Vitor Garcia_ 21-Dec-12 7:52am View

Can you elaborate better ? Please show some code for your issue.
Improve question please.

_Vitor Garcia_ 21-Dec-12 7:47am View

Im glad you could figure it out. After your first comment i thought you must be in need of sleeping :) don't get me wrong :)
Here its 12:46 am.

_Vitor Garcia_ 21-Dec-12 4:23am View

Dude...
Mouse over the word This at solution please. Its a link.
What time is it there ?

_Vitor Garcia_ 20-Dec-12 7:56am View

No question asked.
Do you think we can figure out what you want with what you state ? I can't.
So please improve question...

_Vitor Garcia_ 18-Dec-12 4:58am View

clever friend of mine :)
ty

_Vitor Garcia_ 18-Dec-12 4:55am View

Can i copy your comment to notepad so i can use it on future commentS ? :)
BR

_Vitor Garcia_ 18-Dec-12 4:31am View

And your question is ?

_Vitor Garcia_ 18-Dec-12 4:29am View

How can we help without knowing anything about your issue ?
Can you post some snipet and tell in which line does it breaks and whats the exact error the compiler is throwing ?
Do you think we are such a clairvoyants we could figure it out without some kind of detailed description / code when you have it and can't ?

_Vitor Garcia_ 14-Dec-12 6:36am View

this is not a solution as far the question isn't , as is, solvable.

_Vitor Garcia_ 12-Dec-12 5:34am View

Why don't you use add methos from items like this :
Dim fname As String = "empfname"
Dim lname As String = "emplname"
Dim full As String
full = String.Concat(fname & "," & lname)

LnameComboBox.Items.Add(full)

_Vitor Garcia_ 11-Dec-12 4:16am View

Break a leg

_Vitor Garcia_ 10-Dec-12 12:21pm View

Now you managed to get DesignID in ds.tables(0).rows object.
You could select the records you want to show from that other table by DesignID.

_Vitor Garcia_ 10-Dec-12 12:20pm View

This is a second question of yours, isn't it ? I provided a solution for the first one.

_Vitor Garcia_ 5-Dec-12 4:12am View

See this pls :
http://www.codeproject.com/Lounge.aspx?fid=1159&df=90&mpp=25&sort=Position&spc=Relaxed&select=4443483&tid=4443134

I did a search and easily got what you are looking for, so why won't you ?

_Vitor Garcia_ 5-Dec-12 4:06am View

What do you mean ? Did you try the solution provided ? Did it solve your problem ?
Please be more clear.

_Vitor Garcia_ 4-Dec-12 11:04am View

give credits to who helped you, please.

_Vitor Garcia_ 4-Dec-12 4:09am View

Its just frustrating to see an increasingly number of people asking for "give me a source code" ... looks like a trend or something like "Im a developer so give me the code to compile".
I quit replying to human compilers from now on.

_Vitor Garcia_ 3-Dec-12 4:29am View

What is happening and what do you expected to ?
What is the datatype of Rate Field ?
Does this throw any exception ?

_Vitor Garcia_ 30-Nov-12 4:33am View

Whats the result of the execution of this snipet and what do you expect it to be ?

_Vitor Garcia_ 30-Nov-12 4:25am View

I guess you could just change https://someSecureTransferSite.com/directory to https://102.52.52.58:443/directory being 102.52.52.58 changed for your public ip. 443 is the standard port for https.

Just give it a try and report here the result please.

PS - What do you mean by "na" ?

_Vitor Garcia_ 28-Nov-12 11:02am View

check if the righttoleft property of the textbox is set to yes

_Vitor Garcia_ 28-Nov-12 7:53am View

Can you clarify what you really want to do ?
Are you talking about SAP B1 ?

_Vitor Garcia_ 28-Nov-12 5:03am View

Which version of ms access are you using ?

_Vitor Garcia_ 28-Nov-12 5:02am View

My best guest is that QRoom is a query with parameters.
Find the query and see which parameter it is waiting for and act accordingly.

_Vitor Garcia_ 26-Nov-12 9:44am View

Seams like a visualization problem. Are the visualization settings equal on both computers ?

_Vitor Garcia_ 22-Nov-12 9:47am View

One other thing that comes to me mind is that inthe navigate sub you have a parameter which you are not using

Inside the navigate, isn't this what u want ?

Sqll = "SELECT * FROM Person WHERE Id ='"& int.tostring &"'"

_Vitor Garcia_ 21-Nov-12 4:29am View

could you use english ?

_Vitor Garcia_ 21-Nov-12 4:27am View

and i don't understand what you mean by "i want it to be the opposite..."

_Vitor Garcia_ 21-Nov-12 4:25am View

What's the type of UserInput ? String ?

You are searching for every row in which the sentence fields has something with one space.
Shouldn't you search for something like this ?
.CommandText = "SELECT field1, field2, sentence FROM fear WHERE sentence LIKE '%"& UserInput &"%'"

_Vitor Garcia_ 20-Nov-12 4:37am View

Can you clarify your question ?
You could use Sql Server Import and Export Wizard or DTS (in sql 2000).

_Vitor Garcia_ 20-Nov-12 4:35am View

Nice SA. You nailed it, as usual :)
As for the button doubt, it was clear to me and i still dont get what is all the fuzz about. The truth is that given the question I tried to help Dillep and apparently I did.

_Vitor Garcia_ 19-Nov-12 12:34pm View

?

_Vitor Garcia_ 19-Nov-12 10:01am View

I'm glad :)

_Vitor Garcia_ 19-Nov-12 9:43am View

You could check which control has focus and if its not = "" inside eventhandler and act accordingly

_Vitor Garcia_ 19-Nov-12 4:23am View

you are very welcome. all i did was search for articles at the top right of this page :)

_Vitor Garcia_ 19-Nov-12 4:22am View

and your question is... ?

_Vitor Garcia_ 19-Nov-12 4:10am View

As a nice starter i think u should take a look at this http://www.codeproject.com/Questions/288591/How-WE-can-Create-mdb-file-with-VB-NET

_Vitor Garcia_ 15-Nov-12 12:32pm View

whats your record selection formula ?

_Vitor Garcia_ 15-Nov-12 12:26pm View

youre welcome

_Vitor Garcia_ 7-Nov-12 5:26am View

right ! It was not clear to me on the initial question.
There are 2 thing i guess you should have in mind :
1. You should make sure that SQL Server service account has read and write priviledgeon the UNC path.
2. Backup up to UNC via Management studio UI is not supported. (this doesn't apply here, just as reminder)

Comments by _Vitor Garcia_ (Top 112 by date)