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
  #1 (permalink)  
Old November 1st, 2007, 01:28 AM
Registered User
 
Join Date: Oct 2007
Location: chennai, tamil nadu, India.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default drop down box.Help needed badly

i am doing automation using macro, forms, query.

I have an excel sheet with 60,000 rows and 20 columns.
I linked this with access. I queried for particular manager="RANJIT", particular date in table. Then i sorted the SR (its one field in table). Output looks like this

SR MANAGER EMPLOYEE DATE HOURS
12 RANJIT VIDHYA 10/12/07 10
12 RANJIT LAkSME 10/12/07 5
12 RANJIT ARUN 10/12/07 6
12 RANJIT PAD 10/12/07 7


14 RANJIT MANO 10/12/07 4
14 RANJIT SRI 10/12/07 3
14 RANJIT SUR 10/12/07 8


SO ON.........................


I created a macro which will refresh the excel sheet (linked table manager) then it will query, finally transfer it into excel sheet (output to).


Now what i want is? i want a drop down box (displaying 1. management
2. Analysis
3. FP)
in form, so that after querying, for each record it should ask the user to select from the drop down box.

example:

SR MANAGER EMPLOYEE DATE TYPE HOURS
12 RANJIT VIDHYA 10/12/07 management 10
12 RANJIT LAkSME 10/12/07 FP 18
12 RANJIT ARUN 10/12/07 Fp 18
12 RANJIT PAD 10/12/07 FP 18

14 RANJIT MANO 10/12/07 FP 7
14 RANJIT SRI 10/12/07 FP 7
14 RANJIT SUR 10/12/07 ANALYSIS 8



after i selected one type for each record it should add the hours corresponding to type. I want the output excel sheet after querying, should be like the above table. Now i have the output as that of first table.


I have written the query in SQL view in ms access.

Help needed badly. Thanks for your time. Your help is highly appreciated.

vidhya
  #2 (permalink)  
Old November 2nd, 2007, 06:26 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 am not sure what you are trying to do here.

Are you trying to do something in Excel or Access? Do you need help creating combo boxes, or creating cascading combo boxes, or running reports from combo box selections?

What is
"2. Analysis
3. FP)"

These don't seem to be fields in your data.

mmcdonal

Look it up at: http://wrox.books24x7.com
  #3 (permalink)  
Old November 5th, 2007, 07:43 AM
Registered User
 
Join Date: Nov 2007
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

I just want to know that u said you linked the excel sheet with access...actually i am doing the same thing i have the filename of excel sheet (abc.xls) but i donot have the code to link that excel sheet with my access database.

  #4 (permalink)  
Old November 12th, 2007, 02:46 AM
Registered User
 
Join Date: Oct 2007
Location: chennai, tamil nadu, India.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I want a drop down box which should display three option(FP,Analysis,Development).... User should be able to select any one of the three option.....This process should get repeated for all records.


What i want is "I want to create a drop down box which has three option... At run time user should select any one of these.... These changes should get implemented in access...."

vidhya
  #5 (permalink)  
Old November 12th, 2007, 02:49 AM
Registered User
 
Join Date: Oct 2007
Location: chennai, tamil nadu, India.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

 am not sure what you are trying to do here.

Are you trying to do something in Excel or Access? Do you need help creating combo boxes, or creating cascading combo boxes, or running reports from combo box selections?

What is
"2. Analysis
3. FP)"

These don't seem to be fields in your data.

mmcdonal



Yes these fields "2. Analysis
3. FP)" are not there in input excel... I want to create a combo box displaying these options.... User should be able to select those option at run time... I am new to access help me

vidhya


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box Won't Drop Down sjf905 C# 0 January 13th, 2007 12:09 AM
drop down box selected value crmpicco HTML Code Clinic 1 March 31st, 2005 09:56 AM
Drop down Box NomAnor Classic ASP Basics 2 March 29th, 2004 12:21 PM
Drop down box format julitin Classic ASP Basics 1 November 6th, 2003 12:02 PM
Search using drop down list box and a text box tcasp Classic ASP Basics 1 July 31st, 2003 02:58 PM





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