marlon ng

Hello. The code below is for a program that uses the classis Access sample database called Biblio.mdb . The controls on the form are: 1 commmand button, 1 Datagrid control, 1 textbox, and 1 ADO Data Control. [code] Option Explicit Private Sub Form_Load() txtUserQuery.Text = Adodc1.RecordSource Adodc1.Caption = Adodc1.RecordSource End …

Hello. In the classic database example, Biblio.mdb, the relationship between 'TITLES' AND 'TITLE AUTHOR' tables does NOT enforce referential integrity. Please explain to me why. I'm kind of a beginner so please make your explanation as simple and clear as possible. Thanks a lot guys!!!

Hi. Im a beginner and I've recently studied ASSIGNING ARRAYS and have drawn the following conclusions. Please tell me if they're correct or not. If their wrong, pls explain to me why they're wrong and pls give me a sample code. Thanks a lot guys!!! Assign fixed array to dynamic …

Hi. Pls copy paste this to your form module. [code] Option Base 1 Private Sub Command1_Click() Dim mArray(15) As Integer For x = LBound(mArray) To UBound(mArray) Print Format(x, "!@@@@@@"); Next x Print For x = LBound(mArray) To UBound(mArray) Print Format(x * 2, "!@@@@@@"); Next x End Sub [/code] There's a …

I got this from a book.: Forty students were asked to rate the quality of the food in the student cafeteria on a scale of 1 to 10 (1 means awful and 10 means excellent). Place the 40 responses in an Integer array and summarize the results of the poll. …

If I uncheck the AllowZeroLength, wouldn't that have the same effect as checking Required? Please correct me if I'm wrong. I'm having a hard time differentiating the two. If a Customer table contains a Phone No. field, and I'm about to add a new customer who doesn't have a phone …

Hi! Beginner here. I'm using VB 6.0 . I created a new Access database (.mdb) using Visual Data Manager (from Add-Ins). If I right-click on a blank space in the Database Window, and click New Table in the context menu, a Table Structure window would appear. In it, I'm supposed …

I'm a beginner so pls bear with me. Try to make your explanations as simple as possible. The program i'm going to make will be like this: the user enters the customer name, the items ordered by the customer, the quantity of those items, and their prices. Here are my …