Search results for query: *

Hi, I don't know if there is a role for stored procedures, what I do is give the person execute permission one procedure at a time. grant execute on PROCEDURE_NAME to USER_NAME I think there is a way to create a role with the permissions you need, but I haven't done it. Hope hits helps. David

Hi, Could you post the code you're using? Maybe the problem is in the connection when opening the excel file or it's not in the same location in the client computer. David

Thank you!!! With your example I was able to find the problem. I was missing: Me.Controls.Add(dgv) Thank you again.

Hi, Getting back from the weekend. I tried your suggestion, still not working. But I have another clue, not only I can't access the columns, but neither the rows. It's like the datagridview hasn't been initialize. I will with this theory and search for solutions. Any help will be...

Hi, let me try your suggestion and I'll get back to you on Monday. Thanks

Hi, Thanks for the replay. But I have done that and it didn't work. Also, according to the help if the datagridview is populate trough a datasource the AutoGenerateColumns property is set to true by default. I did tried it anyway just to be sure :) Any other idea will be appreciated. David

Hi, I'm going to guess that the stored procedure returns a recordset in the query analyzer. If that's true you can use insert into [YOURTABLE] EXEC spQueryAD @LDAP_Query, @Verbose Hope this helps. David

Hi, Here I am, wondering what I'm missing in my code. Maybe I should just ask if there is a problem or a must-do-code that have to be present when one tries to create a datagridview in runtime and then tries to access the columns. I always gets zero for the columns count even thought I can...

Hi, The way I see your problem, there are different approach depending in the data platform of your new software. 1-If the new software use or doesn't use the data from a MSSQL database: 1.1- For the historical information, create a one-use DTS package, copy the information in your new...

Hi, Sorry for the delay... jebenson Thanks for the links, those are very useful. I don't know how I miss them, guess I didn't use the right search keywords :) RiverGuy Thanks for your advice. I'll take them in consideration

Thank you for answering me jebenson But as I understand, that will only work with if the commands are in vbscript, I'm looking for a way to execute VB.NET code lines. I was using the message box as an example, but I would like to interact with the .net program, changing variables values or...

Hi, I was wondering if there is a way to execute code in VB.NET from a string. I'm using VB.NET 2008 Express. For example, read a file or database and put it in a string then execute the command in runtime. Dim StrCommand as String strCommand = "Msgbox(""Hello World"")" Execute(strCommand)...

PHV, JohnYingling and trollacious thanks for the reply. I was already thinking in read the entiry file, but I was hoping not to do this. Thanks all.

Hi, In a existing text file, I need to replace one line with something else. Is there a way to do this in VBScript. For example, the file is first line second line third line ... What I want to do is modify the file so it will look like this was the first line second line third line ...

laperouse For what I see the insert statement UserRec = "Insert INTO [UsersTemp] ([UserID], [Location], [FullName], [Dept]) Values ('" & NxtUserID & " , " & Location & ", " & E - Mail & ", " & Department & "')" should be UserRec = "Insert INTO [UsersTemp] ([UserID], [Location]...

HVehari I agree with johnwm The Printer.EndDoc tells windows your done with the job and that it should send it to the printer. If you want to keep working with the document just don't send the EndDoc until you have finish working with the document. Hope this helps, David

I know you have your reasons for using the help inside the vb application. But wouldn't it be easier to use a standard .chm help file, it uses html files and it handles the index for you. If you go this way, let me know if you need more help. Hope this helps David.

What exactly do you want? How are you printing the transaction? If you're using the Printer object then don't use the EndDoc method before you finish whatever your doing. Hope this helps. David.

I don't think you're gone to have problems, unless you use a SP6 only feature, or a new property. But if you don't upgrade the client's machine SP you won't get the bug's fix that comes in SP6 Hope this helps, David.

You can try to do it in the query, if you're working directly with the database (no recordset manipulation) you can look for the database's engine implementation of that, or if you're manipulating the recordset you can use a column and update with an incremental value (not sure if this will...