Recent content by sunilvedula

wow!!! that is a lot of stuff for me and thank you all for your advices. As for split database i completely agree with you in this regard and my 100% support for it. I have this MDE file which is located in a folder on the network drive. Every user opens access from their computer and open this...

First of all i am sorry to say but each user does not have his own copy. It is one executable file which is placed on a network drive and all other users access the same copy. It recognizes each users who logged in through a code and submits the data into the tables with each user id. what i did...

Hi All, What i am trying to accomplish here is this:I have 2 forms one is prod form and the other is report form. When user updates something on the report form i need a msgbox to be popped up in the prod form for all other users who are working on it. I can use a timer control to check if...

Thank you for your replies. The outlook article looks good let me see if i can tweak it to lotus. But if you can find an article for lotus it would be great

Hi All, I wanted to know if there is a way to check emails that have been receivced in lotus notes. It needs to check if an email is received particularly with the subject that is already available in a table in database. if it can check it needs to inform the user working on the database that...

hi all, I have written a small html coding with javascript. I have used radio button to say yes or no. The problem is the selection of the radio button is not being passed to the variable in the java script. fine the code below. pls help me out . it works fine in chrome browser but not in ie8...

what is wrong. what am i doing is this. just dividing the amt by 100.

Yes got it. sorry my mind did not work enough. thanks a lot Cdbl([myfield]/100) worked

no i am not converting just dumping the data. so u tell me that CDbland dividing it by 100 should help. am i right?

Hi All, I am importing excel sheet data into a table. It has a field for amt and it imports into temp table as text and then sends it to main table where it converts it into currency. Now the problem is the data from the excel sheet looks like 00002145 and when it comes to the main table it...

thanq a lot. i was worried it may lead to problems but it worked fine

hi all, i have divided my access file into 2 components. one is the front end and the other is the backend which contains tables only. Now the problem i have is i run a macro which loads the data from an excel sheet into the tables. I cant run the macro on the front end since they are all...

You have clarified me in many things. Thanks to it. just a few more.If that is the case would i not end up having 12 tables because each queu can end up in have atleast one distinct field. Too many tables is tht not an issue? having so many tables how will it help the performance of the database?

Hi All, My Apologies for not uploading the client api.dll. I am uploading it now. As for the table employees you need to add the way you login into your system if by chance it is not allowing yu. In the HCSID fields add the name throught which you login. now coming to the point of the queue...

hi i am uploading my db deleting all other 11 forms and other tables. this db contains main table which is used for all the 12 forms. i did not feel the need to create multiple table to store data. pls have a look at the design and let me know your thoughts and where can i improve or if this...