Recent content by abidshahzad4u

Thanks for your reply. I have no experiece with Access as well as Application development. I have worked mostly for web. How can I use the above code in Access database? regards

Hi to all I need some favor. I have to develop a small database which will contain the information about sample of oil, rocks, water etc and their relative tests. In the main entry form I need some Windows XP start menu like control which will show the types of tests relative to the sample...

Hi I'm working on a tree view control. Tree view control is on a form and the related data is opened is a subform present at the same form. Problem is that when I try to add new record it warns me with: You can't assign a value to this object I don't understand why this warning is? I click on...

Thanks for the reply I have to re-populate the tree view control and don't know how to? Actually I'm web developer and never worked before in VBA. regards

Hi I have a tree view control on the main form. And the related data to the tree view control is displayed on subform from a table. When I add new record/node to the table from subform, it is not reflected on the tree view control. How can I refresh the main form contents specially tree view...

Thanks for the reply. Actual situation is as: When I want to delete the record from subform using delete button present on the subform. Before deleting I want to check that the record itself has some child record. If yes, then the record can't be deleted, until child records exist. I am using...

Hi I have a form and subform. Subform fields are populated by a tree view control on the main form. I want to access the subform field in VBA. How can I do that? regards

Thanks I have developed a recrusive function which includes all the sub level chiclds (up to n). Now the problem is that I want that root node must appear with + sing to its left for expansion. Now the root node open with sub nodes.

Hi I have added a tree view control to one form. And I want to populate it from the table. But the problem is that I don't know in advance that how much nesting will be there in the table. Mean a category have sub-categories, then sub-categories upto n level. I have done promgramming in C#...

Thanks for all I am getting the values from the same table at which I have insert record. As in my case the type 'parent' is not present in the table. I want to add it at top of the lookup populated from the same table.

Hi to all I am populating a combo box from a table in the Access Form. I have some values in the table which are displaying exactly in the combo box. I have to add a custome field at the top of the combo box, which is not coming from the table. How can I do this?

Hi to all beginner in access knowledge. I have two table. SampleTest and TestDetails. As one sample may have many tests. So the tables are in one to many relationship based on sample ID (Autonumber field in sample SampleTest table.). When I create a report and group it on the basis of...

Thanks all for helping

Hi I am using Access 2007 and created a database in Access 2003 format. I have to create a report based on form input, obviously based on some query. I have created a form for test and added some VBA code to open query. But it is not functioning. The criteria is provided in the Query Design...

Hi to all New to Access databases. The problems is that I have to validate the fields on submission. I have already put checks on the database level. But the messages displayed are confusing stating table name in the message. I want to validate them on form level especially for blank...