Recent content by damdoumaa

Hello, I'm exporting a table to html format, but the html file does not have any titles. How can I add the titles so that the user knows which field is which? Thanks, -DIMA

Doc Man, Thank you for this response. However I have some questions about this method. 1- I can "let the update happen" by doing nothing. Is that correct? 2- How do I do this? THIS is the code that i got so far in the BeforeUpdate event of the form: Private Sub Form_BeforeUpdate(Cancel As...

Thank you veryyy much... that was very helpful :)

Hello everybody, I guess that this is kind of a basic question, I hope someone has the answer. This is about a contact database. I have a search form that allows the user to search by either first name or last name. The user gets the list of contacts that meet the criteria in a listbox, then...

Never Mind!! I got this solved by using "NOT In" operator instead of MINUS. Thanks anyway!

Hello, I was wondering if I can use the MINUS operator in MS ACCESS 2000!!! I have a contacts database that also contains multiple mailing lists. I have the following tables: Contacts (ContactID, Fname, Lname .......etc) MailingLists (MailingListNb, MailingListName) MailingListMembers...

Thank you for the quick response. I tried DoCmd.RunSQL "strSQL" and now i have a different error message that says: Invalid SQL statement; expected 'DELETE', ' INSERT','PROCEDURE','SELECT', or 'UPDATE' I tried the same sql statment inside a query and it worked!! do you know what the problem...

I have a contact database and I'm trying to create a regular add form so that the user can add new contacts. On the form, I have unbound text boxes for all the fields of the "contacts" table. I also have a buttom that the user has to push after he/she enters data so that the data could be added...

How do you send emails using email addresses saved in Access DB? I have a contacts database on Access. I want users to be able to select multiple contacts from a listbox ( I know how to do this part), write the email subject and text then send an email using outlook? Is that doable? Thank you

Thank you Wayne, that was very helpful.

This is not the answer I was looking for. I think my question was much more basic. I have a listbox that contains values based on a search. I have another button that should open a report that contains only the records inside the listbox. I created a report that displays all the records in the...

Hello, Does anybody know how I can use the LIKE operator in a query in Access 2000. I'm trying to put it in the where clause of my sql: where Contacts.FirstName Like [forms]![search].[txtFname] This query is not working. Does anybody know why? Can I use "LIKE" operator in Access 2000? If not...

I have a search form that allows the user to search a contact database and obtains contactId, FirstName, LastName and CompanyName the obtained records are placed into a listbox (lstResult) I want to add a button that would open a report that cotains only the records that are in the listbox...

Hello, I have a contact database. On the search form, I have 2 text boxes to allow the user to search by firstname &/or last name. After enterting the search criteria, the user should press a button so that all the records that meet the search criteria appear in a list box. I did that by doing...

No, I only have this text box and the command button. You're right a combo box would be better. I might change it into combo box later on. Either way, the command button, OR the combo box would have the same code on "OnChange" or "OnClick" events, that changes whatever is in the subform when...