Access Database

[hamadahmad]

I need some help in building an Access Database for my office work.

If you could help me I’ll be really grateful to you.

I’m an Engineer having good knowledge of computer and knowledge of databases. Developed short programs and complicated spreadsheets but cannot write Codes in VB.

I can understand if some guidance is provided to me.

I’ve tried many things but could not get the desired results.

Let me give you an example:

• There are few houses (Suppose 3).
• Each house has some rooms.
• Each room has some items in it.

Now I want that:

• There should be the list of houses on the form
• When I click on any house, a list next to it show the rooms ONLY in the selected house
• And when I click the room I could see the items in that particular room only.

In fact probably I could not properly link the value that I select in List Box with the Criteria box in the Query.

Depending on your cooperation I will get further guidance from you.

Thanking and waiting for your reply


Engineer Hamad Ahmad

[DonnaLamberosa]

I have built a small version of what you have requested, and can send it to you if I had your email address. I don't see how to attach a file to this response.

I need some help in building an Access Database for my office work.

If you could help me I’ll be really grateful to you.

I’m an Engineer having good knowledge of computer and knowledge of databases. Developed short programs and complicated spreadsheets but cannot write Codes in VB.

I can understand if some guidance is provided to me.

I’ve tried many things but could not get the desired results.

Let me give you an example:

• There are few houses (Suppose 3).
• Each house has some rooms.
• Each room has some items in it.

Now I want that:

• There should be the list of houses on the form
• When I click on any house, a list next to it show the rooms ONLY in the selected house
• And when I click the room I could see the items in that particular room only.

In fact probably I could not properly link the value that I select in List Box with the Criteria box in the Query.

Depending on your cooperation I will get further guidance from you.

Thanking and waiting for your reply


Engineer Hamad Ahmad

[ADezii]

I need some help in building an Access Database for my office work.

If you could help me I’ll be really grateful to you.

I’m an Engineer having good knowledge of computer and knowledge of databases. Developed short programs and complicated spreadsheets but cannot write Codes in VB.

I can understand if some guidance is provided to me.

I’ve tried many things but could not get the desired results.

Let me give you an example:

• There are few houses (Suppose 3).
• Each house has some rooms.
• Each room has some items in it.

Now I want that:

• There should be the list of houses on the form
• When I click on any house, a list next to it show the rooms ONLY in the selected house
• And when I click the room I could see the items in that particular room only.

In fact probably I could not properly link the value that I select in List Box with the Criteria box in the Query.

Depending on your cooperation I will get further guidance from you.

Thanking and waiting for your reply


Engineer Hamad Ahmad

To fully understand how to accomplish what you are requesting, there are 3 steps which you should follow:

1. Read the material in the following Link:
   http://www.thescripts.com/forum/thread605958.html
2. Download the sample Database that I have attached and select House 1, Rooms 1 or 2.
3. View the Relationships Window for the sample Database.
4. View the code in the AfterUpdate() Events of cboHouses and cboRooms.
5. If you have any questions, let me know.