Search results for query: *

Control Arrays (Solved) For i = 1 To 104 Me("TextBox" & i).SetFocus If Me("TextBox" & i).Text = "" Then Msgbox "Please enter a value in " & "TextBox" & i & " field", vbOKOnly Exit Sub ElseIf Not IsNumeric(Me("TextBox" & i).Text) Then Msgbox "Please enter a numeric...

Control Arrays Revisited I had attempted to use the code you provided without success. I'm using VBA not VB.NET. I'm not sure if there is any other reason why this subroutine is not working.

I have searched the VB.NET Forums for references towards control arrays in Access 2003 using VBA code. I haven't found what I was looking for. I will try to explain. I am trying to find a way to programmatically loop through a collection of controls on a form. Here is an example of code that I...

It is possible to use parameters in Access or just Micro$oft SQL Server.

I am planning to write a small reservation application. One of the features I would like it to have is to save a local copy of a database that I have created as an XML file. I have done some research and I believe what I would need is multiple files. The XML Schema and an XML for each table in...

I have looked up the help and do not understand it that's why I'm hear. I finally understand what you are talking about after reading the help files over and over and you are correct. What I'm going to is hide the three forms.

I'm trying to load all table relationships programmatically through the GetOleDbSchema method under the connection object. Currently I load can load all tables into a dataset using a loop shown below. Public Function getDataset(ByVal Connection As String) As DataSet Dim cn As New...

Can you show a code example of this jmcihinney. It would be greatly appreciated.

I might be misunderstanding what you are saying but I want to respond to the click event from within the module not the form. My goal is to start a thread based on the click event raised by the form. Also thank you for tip.

Global Variables I think what TPM means in simple terms is simply declare the counter in the top of the form instead of in the click event. Public Class frmLogin Inherits System.Windows.Forms.Form Dim dt As DataTable ' Global variables Dim login As MediaCenter.Users 'Global variables Private...

In my module I would like to respond to a click event raised by another object (my form). There seems to be little documentation on how to do this. The code I have so far is listed below. I am a very programmer, in fact have only been doing it for about year as a hobby so if I don't understand...