Thanks, Lonnie. Lonnie Johnson <[EMAIL PROTECTED]> wrote: - How do I import MS Excel and text files using a UI (user interface)? You would need to create a form with text boxes that would populate the DoCmd.TransferSpreadsheet command's various parameters. - How do I ensure that the value entered by the user in the textfield does not exist in the table? There is a function called DLookup that can check a table for values. - How do I display values in a listbox that are updated? When the users enter new values and are saved in the table, the listbox is not updated. It is only updated when I load the form. When the form is updated you can use the ListBoxName.Requery method to refresh the listbox.
Hope this gets you pointed in the right directions. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: lrheeza <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, February 28, 2008 2:16:07 PM Subject: [ms_access] Help New MS Access User Hello Everyone, I am new MS Access user and I need help on a project that I am working on. - How do I import MS Excel and text files using a UI (user interface)? - How do I ensure that the value entered by the user in the textfield does not exist in the table? - How do I display values in a listbox that are updated? When the users enter new values and are saved in the table, the listbox is not updated. It is only updated when I load the form. Thanks, rhiz __________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping [Non-text portions of this message have been removed] L y a n n e R h e e z a C. O n g --------------------------------- Looking for last minute shopping deals? Find them fast with Yahoo! Search. [Non-text portions of this message have been removed]
