By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,949 Members | 2,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,949 IT Pros & Developers. It's quick & easy.

Access Database

P: 1
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
Jan 31 '08 #1
Share this Question
Share on Google+
2 Replies


P: 1
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
Feb 1 '08 #2

ADezii
Expert 5K+
P: 8,638
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.
Feb 2 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.