Search results for query: *

MS Access 2000. I have this Query: SELECT [StudentDataTest].[FOLIO], [Receipts].[ Code], SUM([Receipts.Amount]) AS Total FROM StudentDataTest INNER JOIN Receipts ON [StudentDataTest].[FOLIO]=[Receipts].[Folio] GROUP BY [StudentDataTest].[FOLIO], [Receipts].[Code]; Folio: is a Student's Unique...

vb 6.0 - MSAccess 2000. I'm using two recordsets as follows: rst1 - to Get all the [unique] IDs from a Master Table - using an SQL statement as the DataSource. Then I'm Looping through the IDs one at a time & for each ID I'm opening a 2nd Recordset with a different SQL statement as its...

Hi! VB 6.0 - MS Access 2000. I'm trying to use two recordsets simultaneously as follows: Set rstFolio = New ADODB.Recordset Set rstCode = New ADODB.Recordset strSQLText = "Select [Folio] from [StudentDataTest] order by [Folio]" Set rstFolio.DataSource = ExecuteSQL(strSQLText...

Here's [in my opinion] the pertinent code: 1. Clicked event that Calls the Function which is in a bas module. Private Sub cmdDefaulters_Click() Dim strSQLText, strMsgText, strFolio, StrCode As String Dim curAmount, curAmountOwed As Currency strCnn = ConnectString 'ConnectString is a function...

In VB 6.0 - how do I set up Global Variables? For instance - if I need a UserID to be stored throughout the session - after a user has logged in - where can I declare the Variable so that once the User has logged in I can check who the user is at any given point in the Application & decide if...

I want to write a 'Clear All' function that can be called from anywhere in my application that will Loop through all the controls on the Form from which the function is called, identify which ones are [for instance] TextBoxes, ListBoxes & ComboBoxes and then clear their contents - setting them...

I'm looking for a function that will look at each character in a string and verify whether it is alpha [a-z or A-Z] or numeric [0 - 9]. Is the best way to do this in VB to test the ASCII value of each character / number that is being validated? I'd like to know the most efficient way. I would...

How do I populate a List Box with the contents of the values in a field in a Code Table so that users can choose from the list? Is a ListBox the best option for this? The list is in a Code Table which has 'Code'& 'Description' as its two fields. I want the Users to be able to select from a...

I usually work with PowerBuilder. I am used to using in line SQL like the following to get values from my Databases & process them: Select SomeFieldValue Into :SomeVariable From SomeTable Where Some[Other?]FieldValue = Some[Other?]Variable; Then I can go back to PowerBuilder Code and...

I'm trying to insert a value into an Access table. The field is defined as Date/Time in the Access table. I have not had a problem Inserting String/Text or numeric values - just the Date/Time value. Here's what I have tried: INSERT INTO Receipt (Folio, Amount, Code, DateTime) VALUES...

I need help writing a query that will insert a date into a Date/Time field in MS Accesss. I have tried: 1. INSERT INTO receipts (Folio, Amount,Code,DatePaid) VALUES ('44444',555.55,'TUI4',#03/27/03#) 2. INSERT INTO receipts (Folio, Amount,Code,DatePaid) VALUES...

I am getting a compile error: 'User defined type not defined' on the following line in General Declarations: Dim dbMyDB As Database I'm trying to connect to an Access DB with VB 6.0 I'm using what looks like pretty standard DB connection code but I can't get past Dim dbMyDB As Database . . . I...