Possible Duplicate: Convert Null to zero in access databaseI'm using Microsoft Visual Web Developer 2010 Express to create ASP/VB.NET page to connect with a Microsoft office Access 07. Here's my issue:
View 2 RepliesI used to write this:
Private Sub Example()
Static CachedPeople As List(Of MyApp.Person)
If CachedPeople Is Nothing Then
[code]....
But then wondered if I could reduce this to:
Private Sub Example()
Static CachedPeople As New List(Of MyApp.Person)
...rest of code...
End Sub
will the "New" bit only be executed once when the function is first executed but in the next call, it will already exist.
How can I programatically reveal the name of the current function or sub being executed? How can I programatically determine when a usercontrol is in focus. I've been using the .Paint peramiter and while this works, I think there has to be a better way.
View 2 RepliesI'm fiddling with sessions in asp.net in a http module.The problem:
session("whatever") = "something"
is set on page_load I need an event in the http-module which is executed after page_load, and in which I have access to the session in System.Web.HttpContext.Current.Session I was looking at this HTTPModule Event Execution Order? but I can only get the session in PostAcquireRequestState, which obviously comes before page_load...
Is it possible to reload a form of the running application from one computer when I executed a function from my other computer with the same application? co'z I want to see the changes of data on my datagrid view?
View 2 RepliesIn Access if a query were to compute the sum of different fields where there is a likelihood of one or more fields being NULL, you use something like NZ. Is there any equivalent Function for handling NULLs in VB .NET?
I'm use the code below to retrieve the SUM of the column "BudgetAmt" from my DB but get InvalidCast Exception was unhandled error because the BudgetAmt and/or AllocationPersonnel holds no data:
Dim strSbCode As String = cboSubSubOrg.SelectedValue.ToString
Dim budgetYr As Integer = CInt(cboBudgetYr.Text)
personBudget = CDec(transDetailsDT.Compute("SUM(BudgetAmt)", "FundSource = '02101' AND DataSource = 3" _
[Code].....
So, I am reorganizing a winform application I wrote to make it more readable and maintainable. The previous structure I used had:
1- a login form with some connection objects
2- an import process start form with some import objects
3- a log writer class that receives data from the import process and writes a log file at the end of the import process
The code quickly got too messy, so my goal now is:
1- a login form with only form events
2- an import form with only form events
3- a class with all the functions
Basically, my class with all the functions (3) looks like this:
Public Class MyProgramMainClass
Public Function test()
Dim testing As String = "test"
[Code].....
I need some further help regarding this thread [URL]..I use this Query
SELECT Kunder.anstnr, Kunder.FirstName, Kunder.LastName, GetJoinNames([Bestn.Anstnr]) AS Weeks, Bestn.Manad
FROM Kunder INNER JOIN Bestn ON Kunder.anstnr = Bestn.Anstnr GROUP BY Kunder.anstnr, Kunder.FirstName, Kunder.LastName, GetJoinNames([Bestn.Anstnr]) And this function in access and it works quite well
[Code]...
My problem is that some code I enter will not be executed. Here is an example of my Form Load event. If i debug the code then the first two lines are executed. The MsgBox won't be executed though. or anything else after it. My programm does run perfectly. But i cant make any changes anymore It's driving me nuts, I don't have the faintest Idea what could be wrong. I sent the code to a friend and he isn't having any problems at all. We both use win7 64bit (he has ultimate, i have home) [code]
View 2 RepliesI am developing a window application. I'm using Visual Studio 2005 and Mysql Database. The problem is, only one form is getting executed when I try to debug.I have changed the startup form to other forms(from a list of existing forms), but still that same old form is getting executed, even if I delete that form or exclude it from the project, it still keeps on executing.
Where this form is stored?(I deleted it from the folder where all other forms exist)
For intOuterCount = 1 to 5
For intInnerCount = 1 to 4
intTotalCount +=1
Next
Next
I'm trying to call a Dll function which looks like this (in the C/C++ Dll):declspec(dllexport) void execute(char** ReturnMsg, char* serverAddress, char* commandLine)
The VB 'wrapper' function looks like:
<DllImport("TPClient.dll", EntryPoint:="execute", CallingConvention:=CallingConvention.Cdecl, CharSet:=CharSet.Auto, ExactSpelling:=True)> _
Public Shared Sub tg_execute(<Out()> <MarshalAs(UnmanagedType.LPStr)> ByRef returnString As System.Text.StringBuilder, _
[Code]...
I downloaded VB Express 2010 and trying to access a variable array I created in the main form1 private section in another form / function. [code]...
View 3 RepliesI have a recursive function in this function i am adding some value to path variable here i want to acess this value outside of function for this what changes i will do in this function.
Private Sub GeValuePath(ByVal ParentID As Integer)
Try
dim path as string =""
[Code]......
I work with Access and VB6 for quite a while. I have read the thread of Phillip Maerz, but there was still the problem that the Function names had to be written in the delegate array. Thats why I started a new thread.Following Problem:How can I call a funktion dymacally, something like thisPublic Function Test1()Returns 1End Function Public Function Test2()Returns 2End Function Sub Main()dim i, r as integeri=2
View 5 RepliesThis is my function:
Public Function DBConnection(ByVal path As String)
' This function makes the database connection and returns the object
' to reference it.
[code]....
As you can see, I want to initialize a database connection and return it so I can use it in my forms. This function is in a module and my variables are as follows:
Public cn As OleDbConnection
Public cmd As OleDbCommand
Public dr As OleDbDataReader
But I'm not sure how I can use this in my forms, do I just call the function DBConnection and then proceed with my SQL statements? Also, I need some opinions. My application relies on a MS Access database. Is it better to initialize the connection on Form_Load and then close the connection when the user closes the program, or open and close the connections as the queries are run? I'm planning to use some database queries on multiple forms hence the reason I was putting it into a module, but I'm not 100% on how I should proceed with this.
how could i build a search function button which will access my database? as the search item match the database , there must be a window pop up to show the searched data from the database.
View 7 RepliesI want to open a website, change its javascript, then show the website + execute my changed js.
1) Is this possible?
2) How is this possible? ( VB.net, C#, FF + Addons )
EDIT: To your better understanding, I just want the js to be just changed for my browser output!
I have a hashtable of a class that contains a timer. When this timer elapses x amount of time, it calls a subroutine within the class. This subroutine calls several other functions and subroutines and then its done until the timer elapses again. Now one of the subroutines updates a label on the form and i can see that happening when its supposed to. There is another subroutine that should be updating another label but it is not. I believe this would be a simple correction but when i set a debug point on the routine it does not work. I'm not going to post the code for this as it is hundreds of lines of code and its probably just a configuration in the IDE that got changed somehow.
I run break points around the rest of the project just fine, even in other classes that use timers. Does anyone else have this problem of code being executed but not being able to debug it?
I have a project with 2 forms. I need the code to be executed on one form first, which is why it is run first, then I want to hide it and just display the user interface form. I have the following code, it makes both forms appear, but I only want the user display form to show: [code] I call both these subs in the frmLoad of the Processing form.
View 3 Repliesi = 5, j = 15
do while (i<j)
i=i+1
j=j-1
end while
how many times is the loop executed? is this 4?
final value of i? 9?
final value of j? 10?
when would you do a do while versus a for next loop?if the upperbound of a one dimensional array is 10, what is the size of the array? 11?CAN I GET HELP WITH THIS
dim x(20,2), y(20,2) as integer
dim i as integer
for i = 4 to 12 step 4
[code]....
how many times is the loop executed? 3?what is the value of i after the code is executed?if x and y are dimensioned as dim x(10),y(10,2) as integer, what would happen in the code?
Basically i know this sounds like its malicious but its not
Im trying to create a GUI for a console application but everytime a process is carried out the CMD window appears directly over then application.
Process.Start(fnvLocation.Text, "push " & recDir.Text & "Data.zip /data/local/rmo.zip")
I work in MS Visual Studio 2008, I have a VB.NET Solution which has three Projects, BusinessObjectLibrary (object properties), DataAccessLibrary (object functions such as selectAll, exportToExcel) and WindowUserInterface (UserForms c/w Controls)In my WindowUserInterface (project) I have a form called "rolFormGrid.vb", on this form, I have a DataGrid that gets filled with a function called "selectAll" when the form is loaded, I also have a button that calls the function "exportToExcel" and I have a Progress Bar called "rolProgressBar" ***.
In my DataAccessLibray (project) I have a class called "ROL_Adapter.vb", and in this class resides the function called "exportToExcel" which has all the code to create an Excel Workbook. When this function is being called, it can takes close to a minute to export to excel. We all know how users can be impatient if they do not see anything happening in the foreground when an application is working, that is the reason I want the progress bar.
[Code]...
I am trying to duplicate the Match function in excel for use in Access. Public Function Match(T() As Double, TTM As Double) As Double ReDim T(LBound(T) To UBound(T)) As Double
[Code]...
what is the equivalent of Access DMin and DMax function in VB.net?
View 1 RepliesI need to access a DLL function which has a void pointer argument (probably written in C/C++). In VB6 it could be accessed by declaring the argument as 'Any'. VB2008/VB2010 does not know this variable type 'Any'.
I tried instead: Object, IntPtr, UIntPtr, Int32(), Long e.t.c. but there always occurs a compile error or a runtime error.I did a lot of Internet investigation but could not find any answer.
Is there a solution to this?
How could I build a search function button which will access my database? As the search item match the database, there must be a window pop up to show the searched data from the database.
View 1 RepliesI created a access table with three fields, CustomerID, FirstName, LastNameI set the CustomerID field to the primary key and the type of AutonumberIn my VB app I dragged the three fields over to my form.I clicked on the plus sign at the top and it displayed -1 in the customer field, I entered a First Name and a Last Name and press the save button. I repeated the process 2 more times and the CustomerID field went from -2 to -3.I looked at my table in acces and all three records showed 1, 2 & 3 as it should. When I exited the form and then open the form again it shows record numbers 1, 2 & 3 as it should.How come it takes exiting the form and then back in to see the correct CustomerID's ?
View 4 RepliesAssume I have an If-ElseIf decision to make. Do all ElseIf's get executed after one has been found true? [Code] Obviously that is not a real subroutine but I wrote that just to clarify what I'm asking. When this is run, on the second ElseIf the value is equal to 5 so whatever is inside that ElseIf would execute. Once that happens do the following ElseIf's get checked or does the program immediately go to the End If?
View 5 RepliesI have the following code which is part of a PA Call system: The 'SetPTT' nd 'DisableZones' statements set controls on the form where the code is. The LAPG2Coms.SetZones command starts another project within the solution to control an external controller. What I can't understand is why it executes the LAPG2 statement before SetPTT or DisableZones. The LAPG2 statement for messages is in the PlayMessage Procedure
[Code]...