Search results

Thanks for the reply, I do understand creating the no of coloums is not a better idea, but the attendance needs to be captured on a daily basis, if i provide the dates in the row then it will not only increase the no of items, also create a double work for me to go on a daily basis and update...

Hi all, I am thinking to develop a tracker which will track the attendance on each day. My fields are : Emp Id, Name, Sup Name, date1, date2, date3 .... Where date1, date2, date3... are the current dates which will generate on a daily basis and modify the table. The row are constant...

Hi thanks for replying. I have no idea about it, not sure why this error pops up. Simple i have created a db which has tables, queries, forms. I have not given any index. It was working fine till yesterday, and now its showing the error.

Hi All, This is what the error my db showing, i tried repairing the database but it shows the same error, Also i tried importing, linking the tables to the other db, got the same result. Can you please help me out with this.

Hi James :Thanks for your quick reply. The reason i want to built this is because we are not suppose to use any IM clients. I have created a db where in it will capture the data of the process, in the same db i wanted to introduce this chat option, where in they can communicate each other...

Hi All, I am thinking to build an application in access where in we can chat with each other, without any internet connection, the access file will be saved in the shared drive. Something like we retrive username using ReturnuserName function, and send the pop up to the respective user. I know...

Thank you so much. Sometime a simple thing looks heavy on head....

HI vbaInet, Thanks for your quick reply, i understand that it would be difficult to handle, but everyone try to improve their knowledge, i have done no of databases with the codes, and many a times i struggle a lot due to one or the other issue, so i thought of unbound the form, then update the...

Hi All, I have the data in form and it is not connected to the table, i want the data to be saved in the table through code. Something like insert into table sql statement. For example i have the following database table Fields. Name EmpId secondname and i looking the data to be...

I need those settings to, only if i lock the system manually, because if i wont give the password to unlock system then anyone can access my files when i am away from the system.

Alright, i think i need to simplyfy my question. Basically what i am looking is system shouldnot get locked after a time interval i.e 5min.

I know, but i am thinking of writing a code in access form, where the time interval gets capture, and every 5min of time interval it should pass something like moving the curser up and down so that the system doesnt get locked.

Hi DCrake, Thanks for replying. We normally work on excel sheet, which has a huge data in it. We need to understand and investigate the line entry. For your information the entry which we find in excel sheet is accounts entry, for that to understand we need help from other colliques. What i...

Hi All, Please help me out on this. We have a file which needs attention morethan 5min continuesly without any movement. And badly system gets locked after 5min. Just thinking if i can build some VB script or an access file so that system doesnt get locked. Thanks in advance.

Hi, We use A97 in office, and offten i have inform the user to close the DB, if i have something like i open the form and the instruction to close the db it should automatically close the db after 'X' min which i entered. Also it should send a message to the user. Secondly : Can i track the...

Sorry to ask this silly question, What is 'lbarlnth = Me.Box20.Width - 30' 'l = 0' Because i am getting an error variable not defined, i tried defining as integer and string, however error.

That was interesting part. Thanks. However do you similar kind of sample database for A97. Reason we use A97 in office, and offten i have inform the user to close the DB, if i have something like i open the form and the instruction to close the db it should automatically close the db after X...

Thanks for the reply, I tried searching it, however i can't open because i'm using A97. If possible please convert the database into 97 and attached. Regards, asif

Hi Jon, I have done the needfull. It's my pleasure to do anything i can for this website. I have changed my default internet option to 'http://www.accessdatabaserepair.com/' is this what you wanted? Thanks

Hi, I have created a button, when you clicked a no of queries will run simultaneously, ex: merging of data from one table to other, copy of data etc. I am looking for a progress bar where in if one query is in progress the progress bar should show the status and the query name which is...