Search results

i wrote this code in the switchboard got focus event... but its not working... Private Sub Form_GotFocus() Dim lbl As label For Each lbl In Controls("Label") If lbl.Caption = "Exit" Then lbl.ForeColor = 202 lbl.FontName = "Trebutchet MS" End If Next End Sub whats wrong ? i just want...

hey convert() function is not working in Access... is there any other way to convert an Integer to Varchar ?

hey btw, how to answer this ? i have 2 tables namely Books ( BooksID, BookName, Price) Magazine (MagID, MagName, Edition) also i have another table. Orders (OrderID, BooksName/MagName, NoOfBooks) now i have a form for the Orders Table. the form has 2 combo Boxes. one the first combo box says...

hey thank you very much. DKO i had used bound column as 1 in the first combo box and tried to equate the BankNAme. i altered the row source of the 2nd combo as follows ad its working properly. thank you again !! SELECT [Bank Branches].BranchName, [Bank Branches].BankID FROM Banks INNER JOIN...

i have 2 tables namely Books ( BooksID, BookName, Price) Magazine (MagID, MagName, Edition) also i have another table. Orders (OrderID, BooksName/MagName, NoOfBooks) now i have a form for the Orders Table. the form has 2 combo Boxes. one the first combo box says whether its a Book or Magazine...

This is what i want to do consider the following table Books (BookID, Title, Price, NoOfPages) the format of the BookID is "BXXX" (i.e "B" Followed by 3 Numbers) i want to get the latest BookID and get the Number part out of it. how can i do this ? BookID Title Price...

i tried SELECT [Bank Branches].BranchID, [Bank Branches].BranchName FROM Banks INNER JOIN [Bank Branches] ON Banks.BankID = [Bank Branches].BankID WHERE (((Banks.BankName)=[Forms]![CBO]![BanksComboBox])) ORDER BY [Bank Branches].BranchID; but the 2nd combobox doesnt show values then i tried...

i have 2 tables. Bank (bankid, bankName) Branch (BankID, BranchID, BranchName) (here BankID and BranchID are composite primary keys) in the form i'm hoping to have 2 combo boxes. the first combo box contains all the banks. the 2nd combo box should get filled according to the output of the 1st...

refer this code Private Sub comboType_Change() Me.Type.SetFocus Me.Type.Text = DLookup("CBOTypeID", "[CBO Type]", "[CBO Type].Description = comboType") End Sub comboType is a Combo Box. when the event is triggered, an error message prompts saying "Invalid Use of Null" so i used this method...

the DLookup thing returns an error runtime error 2001 "You Cancelled the previous operation"

can i use a combo box instead of the text box

well, this is what i want to do.. i have 2 tables Books (bookID, title, authorID, price) Authors (AuthorID, AuthorName) when i generate 2 forms using the form wizard, 2 forms will be generated.. but in the books form, there will be a text box to enter the authorID. what i need is to have a...

can i redirect the output to another textbox ? (if its just one value)

alright i am extremely sorry ok ??? i was frustrated at that time.. it wont happen again.. Mr.GalaxiomAtHome, ur answer is not clear.. i mean the previous one.. once again, sorry....

i have 2 tables here are the information about the 2 tables organization (OrgID, OrgName, OrgTypeID, PresidentsName, ContactNumber) OrgType (OrgTypeID, Description) i designed 2 forms seperately for the 2 tables. using form wizard. but in the Organization Form, the user is required to enter...

c'mon !! reply to this :(

i have a parameterized query.. it is "Select Description from Books where BookID=<a parameter>" i want to link this with a form and i'd like to pass the parameter from a text box in the form. i need to connect this query in to a button click event where the parameter will get the value from the...

i have a parameterized query.. it is "Select Description from Books where BookID=<a parameter>" i want to link this with a form and i'd like to pass the parameter from a text box in the form. i need to connect this query in to a button click event where the parameter will get the value from the...

i want to get that control over the form bro.. do u know a way of doing it ? (as in VB6)

a data control as in VB 6. to navigate regords and stuff like that :o