Recent content by rahultiwari

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

No, the form always start with the first record. and then I naviagate to new record manually and even if I enter 10 records they are saved only in the table not in the form itself. I dont know how to make it go to a new record anyways, so please let me know how to do it. Regards

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

I have a form which is related to a table in the database. The table has all the data but the form is empty. How can I make the form updated with all the data in the table. Hope its clear this time.

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

I have data in the forms. All from the table which was created because I am only changing the database I already got. The forms were not allowed to change i.e I cannot change the data directly from the form. I need to do it from the table. I want to change the data, i.e including adding any new...

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