This is more of a structural question (me: newbie) as opposed to specific
coding. Please be patient...
I'm making a database for the small company I work for. It will be to add
and edit products listed on our e-commerce site.
I would like to have a customized form for each group of similar products
("drills, for instance, would be a similar group of products - although
there are further groups within the group of "drills"... ). Every product
will share standard fields like "product number" and "price" but there are
many product specifications that are specific to only some products (hence
the "similar groups"). These specs includes "volts," "amps," "horsepower ,"
etc.
So, I would like to be able to design these custom forms using an easy to
use form.
I was thinking of using a table listing all available specifications (volts,
amps, horsepower, etc.). I would then choose each specification (taken from
the "available specs" table) in a drop down menu. This would create a
*group* form. To clarify, some product groups would list "volts" and "amps,"
but not "horsepower " whereas others would have "horsepower " but not "volts"
or "amps."
The above example is an oversimplificat ion. The number of available specs
could be in the 150-200 range, the number of product groups could be in the
300-400 range and the number of products could go as high as about 30,000.
Is it possible to define the fields in a form using a table, query or
report?
If someone could list some key words that I could look up in my book, "How
to do everything with Access 2002" or on the internet, that would be
excellent. I don't mind fiddling around with something, but I need a place
to start.
Unfortunately, my boss is not really inclined to hire someone to do this.
Moreover, I'd like to learn how to do it myself.
Thanks for any suggestions.
Regards,
Robin 3 1691
Robin,
Sounds like you want a bit of subclassing... you should read this
article and play around with the sample database before going too far.
Should save you a few headaches, I hope. http://www.mvps.org/access/tables/tbl0013.htm
Your form may get a bit ugly, but I'm not sure how to get around that
part...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The way I'd do it would be to have a table of Product Attributes that
would be designed something like this:
ProductAttribut es
ProductID Long - foreign key to the Products table
Attribute Text - name of the attribute, Watt, Amp, KW, etc.
AttributeValue Text - the actual value of the attribute
Data would look like this:
ProductID Attribute AttributeValue
1 Watt 25
2 Horse Power 350
1 Amps 5
To find an engine that has a horse power rating between 200 and 500
you'd create a query like this:
SELECT ProductName
FROM Products As P INNER JOIN ProductAttribut es AS PA
ON P.ProductID = PA.ProductID
WHERE PA.Attribute = "Horse Power"
AND PA.AttributeVal ue Between "200" And "500"
You have to use quotes around the AttributeValue values 'cuz the
column data type is Text.
HTH,
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP9KnKIechKq OuFEgEQLhXgCg+4 lCpbRncHAzNPy54 O4RIEuUnQ4AoKTc
2TtWoJ9Hjpko7M7 CVzk2O1NV
=7R9Y
-----END PGP SIGNATURE-----
Robin S. wrote: This is more of a structural question (me: newbie) as opposed to specific coding. Please be patient...
I'm making a database for the small company I work for. It will be to add and edit products listed on our e-commerce site.
I would like to have a customized form for each group of similar products ("drills, for instance, would be a similar group of products - although there are further groups within the group of "drills"... ). Every product will share standard fields like "product number" and "price" but there are many product specifications that are specific to only some products (hence the "similar groups"). These specs includes "volts," "amps," "horsepower ," etc.
So, I would like to be able to design these custom forms using an easy to use form.
I was thinking of using a table listing all available specifications (volts, amps, horsepower, etc.). I would then choose each specification (taken from the "available specs" table) in a drop down menu. This would create a *group* form. To clarify, some product groups would list "volts" and "amps," but not "horsepower " whereas others would have "horsepower " but not "volts" or "amps."
The above example is an oversimplificat ion. The number of available specs could be in the 150-200 range, the number of product groups could be in the 300-400 range and the number of products could go as high as about 30,000.
Is it possible to define the fields in a form using a table, query or report?
If someone could list some key words that I could look up in my book, "How to do everything with Access 2002" or on the internet, that would be excellent. I don't mind fiddling around with something, but I need a place to start.
Unfortunately, my boss is not really inclined to hire someone to do this. Moreover, I'd like to learn how to do it myself.
Thanks for any suggestions.
Regards,
Robin
Pieter and MGFoster,
I don't think I made myself clear (my question probably got lost in a sea of
extraneousness. ..)
I need to define the fields of a form, using another form. This is the end
goal. The available fields need to be stored (I'd assume in a table) and be
available for selection.
The real issue is that I don't want to have to go into a form and manually
reconfigure it. Perhaps I could get a macro to copy a previously created
template form, rename it and define which fields were to be used, but that
seems like a lot of work....
Thanks for your answers though. Although they didn't answer my question,
they did provide further insight into the whole design problem.
Thanks again.
Regards,
Robin This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Matthew Clubb |
last post by:
Hi,
I need help developing an expanding form
I've decided that a use of PHP, Mysql and Javascript is the best platform
for creating a selection of database interfaces which I'm trying to build
for my company. I had been using Microsoft Access, but obviously this
requires licenses for every machine. BUT.....
I'm look for an easy way of recreating subforms. I'm trying to create a
Purchase Order system and in Access I did this by using a...
|
by: SammyBar |
last post by:
Hi,
I'm trying to bind a custom collection class to a data grid, following the
guidelines from the article
http://msdn.microsoft.com/msdnmag/issues/05/08/CollectionsandDataBinding/default.aspx.
The problem is the article is in VisualBasic. I already get the collection
to be recognized as a Data Source by the IDE. It populated the DataGrid
correctly from the fields on the items object of the collection, but I can't
get the DataGrid to...
|
by: Robert Neville |
last post by:
I am having some trouble with some old code revolving around custom
form navigation buttons. My main form has a sub-form with these custom
navigation buttons. In other words, the code should be modular and
work across forms and sub-forms. My previous code was taken from the
Access Expert Solutions 97 (Leszynski) many years ago. As my database
became more complex with multiple sub-forms and intricate combo boxes,
the code faltered.
Some...
|
by: Alvo von Cossel I |
last post by:
hi,
i have created many apps using the .net objects e.g. textbox, toolstrip. but
i have decided that i would like to go further with my c# studies and learn
how to write my own objects and create better apps but to start, i need to
know how to create my own objects.
can someone help me on my quest?
thanks in advance
|
by: AMDRIT |
last post by:
Hello everyone,
I have created a custom component and one of its properties is a class
object with it's own properties. During runtime, I can assign values to the
class object properties just fine. However, when attempting to assing
default values as designtime in the propertygrid, nothing is working on the
class object. I know that I am doing it wrong, any ideas what it is?
Thanks in advance
| |
by: Jake Forson |
last post by:
Hi there,
I'd like to re-create a form given only its resource file. I was going to
simply read the resource file and re-create the "Form" object and all its
controls as found in this file (applying all properties in the file and
relying on the default properties for those not found). After looking at
"InitializeComponent()" however (which is what I'm really trying to
re-produce here), can somone explain why this function does the...
|
by: rizwanahmed24 |
last post by:
Hello
i have made a custom control. i have placed a panel on it. I want this
panel to behave just like the normal panel. The problem i was having is
that the panel on my custom control doesnt accept other controls. The
control i drag drop on it becomes the child of my custom control's
parent form and not the child of my custom control. Then i added this
line
""
before my custom control class (i dont know what this line does). Now
|
by: Doc John |
last post by:
I need to create several Windows Forms and I'm thinking of creating a base
Form from which I can derive all Forms. Is it possible to include something
in that Base Form so that all Forms I create will use some specific controls
with some specific properties? For example, if I add to the Base Form a
button with a black background ans Arial Font, will all the Forms be
required to use this same Button?
Thanks.
|
by: hyperpau |
last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding.
I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com).
Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge.
I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
|
by: hyperpau |
last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding.
I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com).
Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge.
I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
|
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...
| |
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,...
|
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...
|
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,...
|
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...
|
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...
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |