Recent content by cooltom

i want to add a "empty line" to the start of the memo field so that when it is saved, it makes the first line of the table field empty and the text of the memo is displayed.

Hi, I have a memo field in a form. i want it to automatically add new line to the underlined table field and then the text in it. i am using access 2000. From, OP

Thanks but this code is for Access 97.. i am using access 2000. when i use this code in 2000, it gives a error on "Dim db As DAO.Database" can u help me with it !! From, OP

Thanks but that i have aleady done. how can i update muliple fields (of every record).Update query uses a where cluase with AND operator!! please try it on a sample database and you will know what i mean!!!!!

What is the correct code or sysntax for that??

How can i update all the null valued fields of a table to zero?? or is there any other method??? by the way i am using access 2000.

Hi, I want to have a table in which i can automatically save the current user name, login time and logoff time. Can anyone tell me method of doing this. Any code (or refrence website) will be be a great help... Apart from that does access mantains a event log for the errors or anything (like...