473,842 Members | 1,598 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ACCESS: Continuous Form, List Products Show Multiple Categories for Each Products.

realayumi
1 New Member
ACCESS 2003
WIN XP

Hi, i'm new in access, just a view days, this is my first post.
Sorry for my bad English.


I have 3 tables.

tbl_product
product_id (primary) | product_name | product_price
1 | short | 100
2 | skirt | 120
3 | cap | 50

tbl_product_cat egory_xref (no primary)
category_id | product_id
1 | 1
2 | 2
1 | 3
2 | 3

tbl_category
category_id (primary) | category_name
1 | Men
2 | Ladies

Before, i want to list all product using continuous form, and using listbox to store multiple categories.
First, query the product, then in listbox source from query the categories taken from txtproduct_id (textbox).
The plan is like this image (i used PhotoShop to edit the image to make easy to explain), then i get error, and confused.



Then i read that many people say we cant do that in continuous form.
But i must use continuous form. It will take long time if i check the product 1 by 1 page.
Actually i dont need to edit the product's categories, i just want to know which categories the product is.
Any idea how can i show each product's categories?

Maybe create first query tbl_product_cat egory_xref and tbl_category to get category_name and automaticaly create temporary new

table (i dont know access programing) that combine category_name with "," separated each same id
SAMPLE NEW TEMPORARY TABLE (can be replace every time we open the form):
tbl_product_cat _temp
product_id | category_multi
1 | Men
2 | Ladies
3 | Men, Ladies

Then second qury for continuous form that displaying all products and connect to tbl_product_cat _temp,
and store this category_multi into textbox. Is this posible?
I really need this solution, and really hopeless...
I dont know where to get help. Nobody can use access in my area.
Thank you in advance.
Dec 16 '09 #1
1 3899
orangeCat
83 New Member
First, a suggestion.

Tell us what you are trying to do.
Help us understand your problem/situation. We do NOT know your application nor data.

Don't tell us how to do it, just tell us what you're trying to do.
Dec 18 '09 #2

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

Similar topics

1
2121
by: VbUser25 | last post by:
hi.. i have a drop-down menu with a list of products.when i select any one product i open a popup displaying hte product categories in it.i then enter the no. of items i want.and finally when i click to the submit button i want to display a summary of selected item in the parent form.to make it more elaborate: i have 3 items in a drop-down menu and each item has further 10 different types of products.
2
2172
by: Enjoy Life | last post by:
We have an ASP site that hits up an Access database of categories of products and products. (e.g. Categories = Napkins, Tablecloths; Products = 20x20 Napkins, 21x21 Napkins, 54x54 Tablecloths, 60x60 Tablecloths) We currently have select boxes that when you select a category, it populates the next select box with the proper list of products (i.e. I select Napkins as a category, I get a listing of the Napkins) We would like to put a...
9
3273
by: Frances | last post by:
Hi All, * PREMISE * I'm creating an Access form with 150 items subdivided into 20 categories. Multiple categories (and items) can be selected so my user wants checkboxes. All of the options need to be visible at the same time so no dropdowns (combo boxes) and no scrolling lists (list boxes). I will use tabbed sheets with logically grouped categories (and their respective items).
6
4770
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much appreciated. Thanks in advance
49
14373
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The application is relatively big: around 200 tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data (SQL Server 2000), 40 users. I'm wondering what are the disadvantages of using Access as front-end? Other that it's not...
4
3183
by: Kathy | last post by:
What is the standard technique for handling the fields in the following scenario on a continuous form? Multiple Divisions. Each Division has multiple Buildings. Each Building has a Supervisor. Tables: (abbreviated) TblDivision DivisionID
7
3329
by: Dave | last post by:
Hello All, These one may be a bit tricky, and what I'd like to do may not even be possible. I would love to hear any ideas you guys have for solving this. Here is the situation: I have a form that displays the high-level data for a set of records in continuous forms mode. I have a simple command button that will open another form with the details of the selected record.
2
1625
by: Kevin | last post by:
I want to use a set of check boxes to narrow down entries on a subform. I.e. a check box for black, red & green to describe the colors of a product. So a use clicks Black and only black products are shown, the click green and only black and green products are shown. There will be a large number of choices that a user can make so I'm wondering... can I right a bit of code or function and put in a seperate module to call from an after...
3
1416
by: jillinsky | last post by:
Wondering is this is possible - I have 2 tables. One is categories, and has catid, catname, hashighercat, and ...I can't think of the 4th one, but it isn't needed anyway. There are 40 categories, and about 1400 subcats. the categories are numbered 1-40, and the rest have their numbers - all of these are in the same field - catid. You can tell the categories from the subcategories by the field hashighercat - the 40 categories are null...
0
9872
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9715
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10612
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10672
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10314
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5696
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5885
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4499
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4089
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.