Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 27th, 2006, 02:40 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default Single form for multi functions


 Hola ,

  I got a DB data as below,

Equipment Name

Personal COmputer

Printer

Scanner

Other Accessories

  * each having different type like different company & different model.

   and all the data are compiled as to be 500 records..
it ill be like
  Personal Computer - 200 Records
  Printer - 100 Records
  Scanner - 100 Records
  Others - 100 Records

  All the data is in one table called tblmain..


 Now my boss told me to get the data in Datatable view and in form view through front end..

  Like
        From1 (Combo Box - Equipments Name)
        From2 (Combo Box1 - Make ; Combo Box2 - Model)

 What i need is what i select the Equipment Name in CB1 and pass over to From2 then the CB1 & CB2 should show the particular make & model of the Equipment . Real task is the data field will contian all the make & model . Like filtering the data as Autofiltering ..

 If u not able to understand plzz reply me



bye
------------------------
pap...
 
Old July 28th, 2006, 09:44 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I don't understand what you want to do.


mmcdonal
 
Old July 29th, 2006, 12:24 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

I ill give an Example.. it may be too long.

Table1:
Equipment Name Make Model

Computer HP P-4
Computer Compaq P-4
Computer Siemens P-2
Printer Wipro LQ-5400
Printer Epson L1 – 2450
Printer Tvs 2400
Scanner Hp s4200
Scanner Acer sg45
UPS Agni 1KVA
UPS TVS 4KVA

These are the datas which i have (assume) then

 Iam going to creat an from called FROM-1 & FROM -2,
and In FROM-1, i want to place One Combo box & One Command Button. The Combo box as the data for name for the Equipments (i.e. ,Computer , Printer , Scanner , UPS ) & When i select any one of the Equipment and move to the FROM-2. In FROM-2 I placed two Combo Boxs (CB1 & CB2) & one Button , CB1 having the data for make & CB2 having the data of Model..

 Now what should i want is When i select Computer in the FROM-1 , then the FROM-2 should show only the Make & Model for Computer which i enter allready and when i select the make and model it should give the dataview for the computer only, i know it can be generated by an query...

 But for this pls give me an idea




Learn as you can..
------------------------
pap...




Similar Threads
Thread Thread Starter Forum Replies Last Post
By Default Servlet is Single or Multi-Thread Model bikash Servlets 6 September 3rd, 2009 02:35 PM
Multi-Tab form srotondo Classic ASP Professional 1 April 27th, 2006 06:38 PM
calling functions form another window geogomez Javascript How-To 2 November 29th, 2005 07:20 AM
ASP.Net Single Single-on with Oracle Application S guhanath Oracle 0 October 6th, 2004 05:05 AM
Multiple Form Instances in a single form? gman997 ASP.NET 1.0 and 1.1 Basics 1 March 30th, 2004 06:46 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.