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

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

Subscribe Reply

3888

orangeCat

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

Similar topics

2120

urgent-how to pass values into the parent form

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.

ASP / Active Server Pages

2169

Populate a popup window with clickable records from an Access DB and upon clicking, populate a selectbox on the original webpage with the clicked record

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

ASP / Active Server Pages

3268

best control/method for item selection on Access form

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

Microsoft Access / VBA

4753

Error Trapping In Access 2000

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

Microsoft Access / VBA

14356

Disadvantage of Access as front-end

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

Microsoft Access / VBA

3174

Using Combobx In Continuous Form

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

Microsoft Access / VBA

3323

Need ability to have data dependent icons on continuous forms...

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.

Microsoft Access / VBA

1622

Continuous filtering with a module?

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

Microsoft Access / VBA

1414

Access 2000 lookups

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

Microsoft Access / VBA

9621

What is ONU?

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

General

9454

Changing the language in Windows 10

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

Windows Server

10264

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9914

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

General

8937

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7463

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6717

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5484

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4012

transfer the data from one system to another through ip address

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

C# / C Sharp