Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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
Reply With Quote
  #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
Reply With Quote
  #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.

Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 10:20 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.