I have a form to display inventoried items using Access2003. On this
form I have a subform that displays a list of all my inventoried items
in the form of a DATASHEET. What I would like to do is when I
double-click on an item on the subform I would like another subform to
display that lists more details about that item. Both subforms would be
getting data from the same table but the top subform would be just:
InventoryID, Manufacturer, SerialNumber and the bottom subform would
contain more data like ModelNumber, PurchaseDate, ReplacementValu e...
maybe 15 fields at most, probably displayed as formview instead of
dataview.
My first idea was to emulate the example in Northwind called form:
"Customer Orders" which contains "Customer Orders Subform1" and
"Customer Orders Subform2" however in that example Subform2 shows
order details of orders found in Subform1, thus both not coming from
the same table. Any clues as to how to accomplish this? Thanks in
advance!
1  1445 
well, being based on the same table, the recordsets of the two subforms will
have the same primary key field(s). try using the Northwind-type setup, but
in the 2nd subform control, the LinkChildFields and LinkMasterField s
properties will refer to the same fieldname - the primary key field.
hth
"Parasyke" <kr************ @yahoo.comwrote in message
news:11******** **************@ e3g2000cwe.goog legroups.com...
I have a form to display inventoried items using Access2003. On this
form I have a subform that displays a list of all my inventoried items
in the form of a DATASHEET. What I would like to do is when I
double-click on an item on the subform I would like another subform to
display that lists more details about that item. Both subforms would be
getting data from the same table but the top subform would be just:
InventoryID, Manufacturer, SerialNumber and the bottom subform would
contain more data like ModelNumber, PurchaseDate, ReplacementValu e...
maybe 15 fields at most, probably displayed as formview instead of
dataview.
My first idea was to emulate the example in Northwind called form:
"Customer Orders" which contains "Customer Orders Subform1" and
"Customer Orders Subform2" however in that example Subform2 shows
order details of orders found in Subform1, thus both not coming from
the same table. Any clues as to how to accomplish this? Thanks in
advance!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Evil |
last post by:
Hi,
i have a problem with a treeview and some subforms in MS Access97.
I have a form with a treeview on the left side which lets me navigate
thru some projects. Then on the right side, i have several Tabs, each
with a subform.
Now, my tree view nodclick code goes like:
sProjNum = me.tvwX.SelectedItem.Key
|
by: M Wells |
last post by:
Hi All,
I am developing an Access 2003 project application with the back end
in SQL Server 2003.
I have a master form that tracks projects, and several subforms on it
that track various aspects of the project. On the masterform I have
two unbound listboxes that I populate with information regarding the
current record in one of the subforms.
|
by: Jack |
last post by:
Hi all,
I searched the archives and found everyone happy with Stephen's
MouseWheel On/Off code except for those with subforms. Stephen's page
indicates that he has added code to handle subforms ("Bug Fix for
SubForms with ScrollBars. Bug fix for SubForms without visible
ScrollBars.") - BUT I still can't get it to work on my app with my
subforms.
I'm using Access 2000, It works fine on the main forms but not on the
|
by: Jack |
last post by:
Gday everyone,
I'm dearly hoping Stephen Lebans is going to update his masterpeice to
stop the mouse wheel scrolling to work on subforms *he has indicated
this to me but of course beggers can't be choosers here so I have no
idea when this would be done*. I'm just wondering if anyone has gotten
around the problem some other way?
--Original Thread---
|
by: xavier vazquez |
last post by:
I have a problem with a program that does not working properly...when the program run is suppose to generate a cross word puzzle , when the outcome show the letter of the words overlap one intop of the other....how i can fix this
the program look like this
import java.util.ArrayList;
import java.util.Random;
| | |
by: xavier vazquez |
last post by:
have a problem with a program that does not working properly...when the program run is suppose to generate a cross word puzzle , when the outcome show the letter of the words overlap one intop of the other....how i can fix this this run the random words for the program
import javax.swing.JOptionPane;
import java.util.ArrayList;
import java.util.Random;
public class CrossWordPuzzleTester {
|
by: ashish0799 |
last post by:
HI I M ASHISH I WANT ALGORYTHMUS OF THIS PROBLEM
Jigsaw puzzles. You would have solved many in your childhood and many people still
like it in their old ages also. Now what you have got to do is to solve jigsaw puzzles
using the computer. The jigsaw puzzle here is a square of dimension d (a puzzle with
d^2 pieces) and the jigsaw pieces (all same dimensions) are of dimensions H x W
(Which means the pieces have ‘H’ rows of ‘W’...
|
by: oncue01 |
last post by:
Word Puzzle
Task
You are going to search M words in an N × N puzzle. The words may have
been placed in one of the four directions as from (i) left to right (E), (ii) right
to left (W), (iii) up to bottom (S), or (iv) bottom to up (N). The program
will print the starting place and the direction of each word.
Limitations
The number of words to be searched can be at most 100, the size of the
puzzle N can be minimum 5 maximum 20....
|
by: honey777 |
last post by:
Problem: 15 Puzzle
This is a common puzzle with a 4x4 playing space with 15 tiles, numbered 1 through 15. One "spot" is always left blank. Here is an example of the puzzle:
The goal is to get the tiles in order, 1 through 15, from left to right, top to bottom, by just sliding tiles into the empty square. In this configuration, the goal would be to get the 14 and 15 to switch places, without affecting any of the other squares.
Your...
|
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: 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...
|
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...
|
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();...
|
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...
| |
