I am trying to return to a module from a userform and I cannot figure out how to do it. My program is set up so that the module will call userforms at various times to collect/display information but then I want to return to the module after each userform has done its job, and I want to return to the next line of code in the module.[code]
View 2 RepliesBelow is my code for an employee class and employeetest module. Im not sure why i cant get the test module to return Salary cannot be negative with i put in a number less than zero and not sure how to get monthly salary to convert to yearly and then giving a 10% raise.[code]
View 4 RepliesI am trying to end all running macros, but also keep my userform up and it will not work. If you know anything that will work or if there is another way to reactivate a userform
'mycode
End
Userform1.show
end sub
I am trying to create a userform in MS Word. I have a text box, a set of 3 option buttons and a command button in it. I want that on clicking the command button, the text in the text box and the option button selected by the user should automatically get displayed on header or footer of the word document (active document).
View 1 RepliesI have the following form:I want to join the boxes so that it looks like this: would rather create the lines on the userform manually but I do not think there is a way to do it. I've tried the following code but I cannot see the line:
Private Sub DrawLine(ByVal X_From As Integer, ByVal Y_From As Integer, ByVal X_To As Integer, ByVal Y_To As Integer, _
ByVal Line_Width As Integer, ByVal Line_Colour As System.Drawing.Color)
[code]....
I don't know where this fits so moderators go easy. I've been trying to enter a text box on this site using a form made with Visual Studio 2010. See here for the site. I have the following
[Code]...
I have a Macro that prints Sales Vouchers, is it possible to attach the userform to an Email or write it to a file for later attaching to an email or even send the UserForm to Word again the aim is to transmit the voucher electronically rather than paper. My code at the moment is very simple: UserForm2.PrintForm which prints the form. I tried printing to a file but couldn't get it to work. I am guessing that printing to a file is for Text only and not bit by bit.
View 5 RepliesI've been using VBA quite a bit in the past to build userforms in Access, that used user-supplied data to custom-build sql statements on the fly, query data from a linked table, read that data into variables, perform calculations and spit out results onto the userform. Now I'm wanting to do some similar things in vb.net 2008.
I would use some code like this:
Set MyRecordset = New adodb.Recordset
MyRecordset.Open "SELECT * FROM Table1", CurrentProject.Connection, adOpenDynamic, adLockOptimistic
MyRecordset.Filter = "ID = '" & Me.cmbAgentName.Value & "'"
With MyRecordset
[Code] .....
Whenever I try this, I get an error message along the lines of "Conversion from type 'Field' to type 'String' is not valid."
so yesterday this code was working for my userforms and today its not. Its a simple clear command for textboxes and comboboxes. what is from here?
Dim ctl As Control
ForEach ctl In Controls
IfTypeOf ctl Is TextBox Then ctl.Text = ""
IfTypeOf ctl Is ComboBox Then ctl.Text = ""
Next ctl
How to use a vba userform to input a number to the excel file and get another number from that excel file back to the userform?!! (such as input value to A1 and collect C1 back to userform). Beside is that possible to open another excel file via ComboBox and input the number (C1) to that particular excel file...
View 4 Replieshow we can declare a connectionstring in a module and call that module
View 1 RepliesI have a VB.Net interface that communicates with an Access 2k3 Database using this module:
Module MOD_ENGINE
'Declare Database connections controls
Dim con As New OleDb.OleDbConnection
Dim dbProvider, dbSource As String
[code]....
I want to call EngineConnect procedure from MOD_ENGINE module into popCboBox module so I can ignate the engine!
Question:Is it possible to make a userform transparent but have non-transparent controls?I notice changing the opacity of the userform will change the opacity of controls embedded on it.
View 9 RepliesI use this code to return records in a DataGridView:
[Code]....
I'm working up a system where I plan on using RealProxy objects to enable intercepting method calls against a set of objects, handling the call, and then returning appropriate results. This works just find for simple return types like strings or ints, but I can't seem to return objects from the RealProxy.Invoke method. Everything works. I get no errors, but the returned value is always NOTHING, instead of an object.
I've worked up the smallest sample code I could, and have included it below. Essentially, just call RPtest and single step through. The code creates a simple object, RPTestA, with a string field and an object valued field It then retrieves the string
[Code]...
I'm making a Visual Basic GUI application to display whether a number of my ports are open for people to know whether things like my website and my Minecraft server are open.My problem is I have absolutely no idea how to do this in Visual Basic.Basically, I'm asking for something which sends a signal to an IP with a specific port, if it is open then return true, if it's closed, return false. Similar to: http:[url]....
View 1 RepliesI would like the following function to return Nothing if the element with the specified key is not in the collection. Instead, it returns an error - something to the effect of "no element found"
Public Class MyCollection
Inherits System.Collections.ObjectModel.Collection(Of MyType)
Public Function FindByActivityKey(ByVal searchValue As Integer) As MyType
[code]....
I would like to know how to use module, why we need to use module and when to use module. I've tried to use module but some of my textboxes, labels and other controls didn't recognize by the module i've created.
View 5 RepliesHow do I use a module?
View 3 RepliesIn order to return a value from a VB.NET function one can assign a value to the "Functions Name" or use "return value." I sometimes see these inter-mixed in the same function. Personally, I prefer the return. My question is, what is the internal difference, if any, between the two?
View 5 RepliesI need to use some feature of VB.net that is Module for my Asp.net MVC project. But I found that C# can't handle Module like VB.net does. VB.Net - Globalization Project
[Code]...
Some of my co-workers make extensive use of the VB.net concept of Modules. Unfortunately, I just don't 'get it'. I see no benefit in using modules over shared classes. When would it be preferable to use a module?
View 2 RepliesI have a connection module in which I have written the open and close database connection.... if database connection is an error it will return false else if success it will return true the function of the modules will be called from the form code....
what I need is if the connection is an error the module should also get the form name which returned the error...is it possible???
check my below code....
DBConnection.module
Imports System.Data.SqlClient
Module DBConnection
[Code].....
now what I need is if the functions Open_DB_Connection() or Close_DB_Connection() returns error it should prompt the form name....
I want the current module name for Verbose Logging. Tried using DeclaringType.Name and it returned the Class name, not the Subroutine name. Ideally, I would like the class/module and subroutine/function name.
View 11 RepliesHow do i create a new module like the one i was told to create in [URL]? If you don't know, how do i create a Global Variable?
View 4 RepliesMy applicaiton has several forms with textboxes. I need to make Save settings button and Load settings button. I have module that stores a lot of variables. Saving these variables was easy. Now i want to load these settings. In each form_load event is written code, which fill textboxes with variables from module file, also some forms create databases which are defined in module file..
View 2 RepliesThe module containts of a bunch of string properties like: [code]how do you acces this module in your view ? If Page.User.IsInRole("Beheer diensten") Then..The goal is to prevent typo's all around the application and if someone for some unknown reason wants to change the description of a role we don't have to check every if.
View 1 RepliesI am using the under given code in a module and I am getting an error ['Me' is not valid within a Module]
[code]...
What is the meaning of having constructors (sub New) in a module, and why must they have no arguments?
View 4 RepliesI have a "Main" module that is sort of the "brain" or "top level" of my project. Basically, I think there are routines that it only should be allowed to call. Some of these routines are in other modules, so I don't know how to make them hidden to everything except the Main module. If the routine is ublic, anything can call it; if it is private then the Main module can't see it. Also the other modules are big enough that I don't feel it would be a good idea to stuff them completely inside my main module. How can I achieve this "private except in one place" functionality?
View 2 Replies