Search results

  1. S

    Access and Excel

    Greetings to everyone. I have the following scenario. I maintain a table of clients and their details in a database. I also have an excel workbook with some details. What I require is that when I key-in the unique Client_ID in a Column in Excel, the other details needs to be pulled from the...
  2. S

    Date Picker Control

    Hello Greetings to everyone, I am designing a form to collect the following: C_Name : Text (50) C_Add1 : Text (50) C_Add2 : Text (50) City: Text(50) ZipCode : Text(15) Join_Date : Date / Time for collecting the Join_Date information I would like to use the Date picker control. I tried setting...
  3. S

    Help needed "SQL Insert into..."

    Greetings to everyone, I have a table tblCountryState with the following structure pkID : Autonumber Country : Text State : Text Besides this I also have other tables tblStateCiry, pkID : Autonumber State : Text City : Text tblCountry. pkID : Autonumber Country : Text I have created a data...
  4. S

    Question Difference between Null

    Respected people, Can some one please advise me what is the difference between Null, vbNullString, "" The reason I ask is setting the property of text box at runtime ggave me some problems. when I set txtName.text = "" I get an error message whereas when I try txtName= Null works. Kindly...
  5. S

    Passing Parameters

    Hello Everyone, I have a Table tblCustomers, where I store the details about the Customers like, CustomerID, Name, Address, Contact Number (Office / Residence / Mobile 1 / Mobile 2). I have designed a form where the user can give any of the detail like CustomerID or Name or Contact Number. and...
  6. S

    Display query results in a dialogbox

    Hi, I have a form where I collect data which is used to find whether a record exists for the criteria. I use the dlookup to do this. Now I want to know whether I can display the results of a select query in a dialog box for the criteria. Example in a SalesOrder Table, there are many records...
  7. S

    Combo Box custom entry

    Hello Greetings to everyone, My name is Sakthivel. I have desinged a table to collect the customers details using a form. Details include field like Customer Name, Address1, Address2, Pincode, City, Contact No. fields. For collecting the City details, I am using a combo box to lookup values...
Back
Top Bottom