Search results

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...

Thank you one and all and especially dbDamo for all the inputs. I am now also keeping in mind the Normalization concepts which at no cost should be avoided while designing a database. I hope i have got the solution by creating a subform to enter all records which would go into another table and...

were you able to have a look at my problem. I think i have no issue with my table structure My db already contains 14tables). it perfectly is fine. after my rethinking & studying a bit and re looking at my entire database i felt the structure is fine. Yes there can be one bit that can be done is...

yeah you are right. i should not be worried about forms but about the basic table design. so now i create a table for all the queues with sno being the autonumber and the primary key. but my single doubt is there might be fields left without being used when they fill information for other...

right now i understand abt the table part and th design(though designing the table was never a issue- always tried to follow 3NF) but what still worries me how do i create space in the form for the user to enter the multiple entries? how can i create more boxes on the form if required? i think i...

hi all, i am trying to get normalization concepts right in my desing of database so as to avoid wastage of space and corruption of data. i have 12 queue (people work on this data which they get from different sources) an they will require to enter informatin related to the queue in the...