Recent content by gautam89

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!

Well I thought that VBA would be similar to VB6. And the list boxes would have the same properties. This is what I was referring to: http://www.magictree.com/vbcourse/06listboxes/listinfo.htm

Just tried it on another computer... It's weird it still doesn't work. When you type list0. you get the intellisense window. that doesn't show "clear" But if you continue typing list0.clear it will automatically capitalize and change it to list0.Clear Then when you run through the...

Just tried what you said. Was a good idea, but still the same problem - both in the existing database and in a new database I just created...

Very sorry for the typo. I am using VBA. I don't have VB6 installed on my computer... I'm typing VB code behind Access forms.

both... :(

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...

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...

I tried the TejPal's sample database, but it gives an error when I try to export. I googled the error and found that it could be an incompatibility with MDAC version. I checked mine, but it was the latest one available. Any other suggestions? Pls help... I really need to finish this access...

doesnt work... Well actually I need to be able to select certain records from the list box and export only those. That won't work with Files > Export > Excel Any other ideas out there??

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...

Hi everyone, I'm having the exact same problem as racer25. I tried the code above by luddite_lad, but it didn't quite work. Maybe I set it up incorrectly? On the double click property, I linked it to a macro. In the macro, I added a row - RunCode. I set the RunCode to run a function. I...

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...