Search results

Hi..I have three tables A ,B and C, which have fields A,B and C respectively. I want to do that following default calulation A.a=B.b+C.c meaning adding two columns of different tables and storing it in a third column. It works for me in the forms but I want to do that in the table. Is there any...

Hi.. I have a table in which there are fileds sample_ID,sorter and another table with field split and bigrare. One sample has a sorter and a person can sort more than one sample. I want to create a report such that the report shows how many samples a person has sortered and how much is the...

Hi I am trying to autonumber a field in a form so that it should have a value of 1 more than the highest value in the field. I am trying to use the following formula. DMax("[SAMPLE]","BUGSAMPLE")+1 where sample is the name of the field and bugsample is the name of the table. but everytime I...

Hi.. I cannot save the data in the forms I have made. once I close the form, all the saved infomation is lost when I reopen the form. But somehow they reman stored in the table. Any suggesstion on how to retain the records in the form too. Regards Rahul

Hi I have two tables. bug and drift. They are linked by a field called sample. When I try to create a form using these two tables and include the sample filed of the bug table, the form will allow the data to be changed only on those field which are in the bug table and I cannot do anything...

Hi.. I am trying to add data to the table. Is there any way that if i add data to the table the forms associated with it get updated automatically. It seems that when I update the form it works fine with table ,but if its the other way around it doesnt work. Any solutions.. Regards Rahul

I have created Several Forms but I am not able to save any new records in them. When I click the add new button the records are added alright. but when I exit the form and reopen it all the new data added to the form is lost. I even tried the save button but that doesnt help. anyone has ideas...

I want to put a button on my form which closes access i.e when i click it the access application closes and I go to desktop directly. Is there anyway I can do that. Regards Rahul

Hi, how can I update the form with all the data of the table after modifying the form if it doesnot contain any data.

Hi .. I have a lot of forms in my database. This database is already half way complete. I was not able to edit the data in the so I unlocked all the forms and allowed it to be edited, deleted and all those data related stuffs. but I realised that making these changes makes all the data in the...

Hi.. I want to put two buttons on my form. 1. save the form as a word file. 2. Print the form. Is there any way to do it with the form, not with the report. Regards Rahul

I created a form with an "exit" button and a "return to main menu" button on the form. but when I am on the last data and press tab the form closes automatically. what could be the reason. Do I have to put some condition on the macro I have created for the two buttons listed above. I have just...

Hi.. I created a database using access database wizard. When I click on the mdb file the form directly opens, while when i click on the mdb file the I have made without using wizard, a list of tables appears and when i need to open a form i have to double click on the form. Is there any way I...

I am using a database prepared by someone. But it seems that when i try to add data to a form I am not able to do that. Neither can I edit it. For both these purposes I need to use the table . i.e for adding records and for editing too. Is it possible anyway that I can change the record in form...

Hi...I am new to access...not sure if we can do that... is there any way we can enter the date in access this way.. if we enter 01012004..the slash is added automatically..i.e the date becomes 01/01/2004. It would be great if anyone could help me out.. Regards Rahul