Recent content by adz2013

freakazeud, I just tried it and it worked great, so thanks agian.

Thank you very much for your help. I will try this code.

I am sorry about that, yes I am useing SendObject, I changed it to False and it still does not send. I am using Lotus Notes as my email. Is that a problem? Thanks

All, I have a question on sending emails from a database. Is it possible to force it to send the email? I have the code that sets up the email but it does not acctually send it. I don't want to click send. Any help would be appreciated. Thanks

I am trying to reference a sub form on the main form. This is what I am useing: Me.ahRating(control on the main form) = Forms![MainFormName]![SubFormName].Control On SubForm I have used it before but now I am getting a message that says "Object doesn't support this property or method". Does...

RichO, Thanks!

On the onclick event of the new record button you can put in the code the following: Me.Detail(or any other part of the form).BackColor = 255 '255 is red Then do the same to change it again onclick of the save button.

I have been trying this for a while now and I am still having problems. I have done this before but for some reason it is not working. I have a form that if the user clicks on view it will show previous data. If the user clicks new then they enter a new record. The problem I am having is I...

I have been getting this error on a machine when I try to link through an openlink ODBC driver. It works on ther machines but this machine it does not work. Has anyone seen this before? [OpenLink][ODBC][Driver]Connection rejected by data source (#0) [Microsoft][ODBC Driver Manger] Driver's...

Thank you I got it. And thank you for the other code.

Autoeng, Do you know where on the site I might find the tool. I looked but could not find it. I will keep looking but if you know that would be great.

I have yet to see Access crash because of the number of records. I have some databses that are not being used anymore that had 1 million rows. Yes there are some performance issues but that is it. Don't listen to anything Microsoft tells you about size or users. I have called them to ask...

Thank you Autoeng, I will look into the website. Also I do not have it split out, but I just need to compact and repair the database because there is a problem with another user. I am not changing anything in this database. I would be interested in your example of having each user have there...

I currently have databases with 100,000 records and are 200 mb. So your 20 mb database is not anywhere near being to big. I have the users compact the database on a daily basis to keep the size down. You should compact it as much as possible and your network connection will make a difference.

Is anyone aware of a tool that will kick someone out of a database? There is one person in a database that I need to do something to and no one can get access to the computer. The person is away and there door is locked. They have the database opened and I want to close it out. Any help...