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

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

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.

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

 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