Search results

  1. G

    SQL: Replace Null values with Blank ""

    Hi everyone, I have a a table called [Email Database] with many fields I need to create a query that replaces all Null values with blanks or "" I'm not that familiar with SQL so any help would be appreciated!
  2. G

    Half of the properties for list box dont show..

    Hi Everyone, For some strange reason in VB6 it doesn't give you all the properties of a list box. I cannot use the following, perhaps others also that I am unaware of. ListBox1.Text ListBox1.List(i) ' i is the index number ListBox1.Clear Are there any references I am supposed to add to...
  3. G

    Remove duplicates from four different fields/columns

    Hi everyone, I am working on a database to manage newsletter subscriptions. Each subscriber record has the option of having up to four email addresses registered to his/her name. Is there a way to check for duplicate email addresses in the entire database? It would have to compare all values...
  4. G

    Export Selections From List Boxes to MS Excel

    Hi everyone, I needed your assistance with a small problem I am having with list boxes in MS Access. I have a list box that displays the results of a query. The query actually searches a Customer table for individuals or groups of customers. I wanted to know if its possible to export the...
  5. G

    Access Critereia Query - with blank fields and search parameters

    Hi everyone... I'm a high school student working on an Access project for a summer internship. I needed your assistance in writing a criteria for a select query. Table1 has the following fields: ID, First_Name, Last_Name, Org, Email, Status Only "Email" is mandatory, ID is autonumber, the...
Back
Top Bottom