Search results

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

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

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

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

Hi, I searched and thought a lot about securing the modules and the code behind the form, but once who know to open the form in design they can manipulate the code easily, can some one help me with locking the form and the modules so that no one go inside the code to change. or probably i can...

Hi, I was wondering is there any way to protect the code or not to show the code in the database? Also is there a way to protect the tables, because many of us here know how to link the table from different database, i was looking an option where we can't link the table? Thanks in...

Hi, Please help me with the code below. UPDATE tblquerylog SET tblquerylog.Programworkstream = DLookUp("[Programme Workstream]","tbllookuptables","[Account]"="tblquerylog.SAP_Company_Code_Account"); where-> tblquerylog is a table Programworkstream is a field in the table tblquerylog...

Hi, I have the form where if i click on a check box(Accept) it should automatically append the query with out asking the confirmation. Please help me out with this. cheers! Asif

I am trying to attached the charts (Report) in the body of the e-mail. I can attach as an attachment, but my boss wants it in the body. Please can some body reply. Its possible or not.

Hi, Please help me out with this. I am trying to watermark in the form, and unable to do it.

Hi i have a small problem in sending the e-mail, what i am looking is when i update the record in the form and click on saved button, the code should send a mail from the outlook to the recepient available in one of the textbox. Please help me with this, as my boss is hitting on my head.

hi, I usually receive the data from my colleques in excel format, and i want to move the same data in to a access file with the help of macro or similar option. For ex : i have fields : ID,Name,process,Address,DOB,Sub process etc. This data will be sent by lot of people, so i am thinking to...

Hi, I am looking for the field to find the data depending on the value i entered in text box. For example : I have table containing - ID,Name,DOB,FatherName,MotherName etc. And i want to place a combobox in the form containing the field contains in table(ID,Name,DOB etc). If i select a ID from...

Hi, My boss gave me a project to do, the project is creating forms in VB with the help of excel, however i have done, but i want to create a connection between the feilds in form with the access fields. For example : the table in the access contains System no, ID, and DOB. which should be...

Hi, Please convert this database to Access97 format. I am not able to do it.

Hi, I have access97, however i am not able to open the database which is created in 2000 or later. please suggest me how can i open the database in 97.

I have designed a database, in which i have inserted a bypass key code (which is disabled now) and created a AutoExec macro, however instead of giving a form as a startup, by error i have given a msgbox in AutoExec. And the database is password protected. From three days i am streching like...