Hi, I hope someone have some insight into this. I have a check box on page 1 and when it's clicked, it will launch a macro & insert a value to a text box on page 10. Simple The problem is, the script in the macro is looking for the value of another text box on page 5 to do some calculation. Whenever i do text5value = Val(oFFld("Text5...
Hello, i try to convert this kind of sql query into linq in visual basic, but i get stuck on how to make a percent.. I also don't know how to use linqpad for creating this linq Please help. SELECT CASE RIGHT(PICName, 3) WHEN '(P)' THEN 'Problem' WHEN '(R)' THEN 'Request' ELSE 'Other' END AS [Reque...
How can I make a control array? Or the equivalent. I am used to Visual Basic 6 which presents the option of whether to create a control array when I copy and paste and control. ...
i am using vb6 dll in c#.net. It is working properly but when i host it on iis then it shows an error S*ystem.Runtime.InteropServices.COMException: Unable to show modal form within this context* i am using vb6 dll in following way first register it, then add reference in my project and use it so tell me how can i solve that problem ...
Someone asked me today if it was possible to port a visual basic application to Linux or similar platform, I assumed it was .NET so I suggested to use Mono, but noticed that on their vb support page they only talk about vb 8 (.NET) Does mono support non-.NET vb? In fact I'm not sure what he is using, I think vb6, I'm not sure of the ver...
I created a dropdown by dragging the combo box onto my sheet from the UserForm toolbar. I assigned some values to it from some cells in the book. Now I want some vba code to access the selected dropdown item's value in form of a string. My dropdown contains only text. Also how do I find the name of this newly created dropdown...it's n...
First of all I'm a total newby in visual basic, I needed to hack an application that kept clicking (don't ask). Everything is nice and dandy on my pc, then I compile, move it to its final destination and I doesn't work! At first I thought it was a OS problem, but both machines has win7, I then thought it was a compilation problem, inst...
How do I convert the following? I'm porting a vb 6 app to vb .net. Public Property Get Width() As Long Width = m_lWidth End Property Public Property Let Width(ByVal value As Long) m_lWidth = value End Property Public Property Get Height() As Long Height = m_lHeight End Property Public Property Let Height(ByVal value As Long) ...
I everyone. I currently have a problem with my focus when using a splash screen. I am using VS2008, with .NET framework 2.0. Also, I have linked my project with the VisualBasic.dll since I use the ApplicationServices to manage my single instance app and splash screen. Here is a code snippet simplified of what I tried debugging. namespa...
Is there any difference between using the Microsoft.VisualBasic.DateAndTime.Now compared to the System.DateTime.Now? I seem to remember reading something that said the MS.VB namespace was for legacy use only, and was much slower than using the native .net classes. ...
I have a list of buttons in VB2010. What is the best way to assign a function to their click event. So every button has the same function, e.g.: On Button Click FireFunction(1) End On Button Click Without having to add a click event for every button. The goal is to produce something similar to what is done with the Control ...
I need to copy table in Outlook body to the clipboard and paste in Excel using VBA. I need to preserve the data in the cells, but I do not know how to do that. The data looks likes this, but when copied and pasted into excel it would be in four cells. -339 -339 5 5 Thanks ...