How to use dynamic query in Access 2007 Form?

Dear Friends,
I have a table named "class_grades" and with the fields of "First Name",
"Last Name", "Age", "Math", "Physics", "Computer" and "State".
I would like to build an Access form with dynamic query...
1. For the age and state, it's "drop_down select"
2. For the Math, Physics and Computer, I can enter the number and click an
arrow button (to match the number with +/- 10%), then it will show all the
matched list. 
All these "keyin" and "results" should be shown in the form (form + sub-form?)

I am sincerely looking for your help to guide me how to implement it.
Thank you very much.

First Name   Last Name	Age	Math	Physics	Computer	State
		            drop_down 	keyin #	keyin #	keyin #	drop_down
		            select	<->	<->	<->           select
Wendy	    Alexander	20	76	76.5	77.3	NV
Charles	    Alsberry	20	78	78.5	79.3	MT
..............................................................................
.....................................


Below is my table :
First Name Last Name Age	Math	Physics	Computer	State
Wendy	Alexander	20	76	76.5	77.3	NV
Charles	Alsberry	20	78	78.5	79.3	MT
Rebecca	Alstrum	20	74	74.5	75.3	UT
Lindie	Alvey	21	78	78.5	79.3	CA
Jennifer	Armstrong	21	79	79.5	80.3	KS
Nancy	Ash	21	73	73.5	74.3	KS
Mysty	Atkins	21	87	87.5	88.3	NE
Lauritz	Austensen	22	78	78.5	79.3	MT
Tom	Baer	22	91	91.5	92.3	UT
Roger	Baird	22	77	77.5	78.3	NM
Dana	Baker	22	84	84.5	85.3	NE
Jennifer	Barnes	22	79	79.5	80.3	OK
Christine	Bayles	22	88	88.5	89.3	AZ
Justin	Benjamin	21	76	76.5	77.3	WA
John	Benson	21	89	89.5	90.3	NM
Amanda	Berg	19	81	81.5	82.3	NV
Steve	Bier	19	88	88.5	89.3	MT
Vicki	Blaine	19	88	88.5	89.3	TX
Janna	Borth	19	76	76.5	77.3	OR
Mark	Briggs	20	88	88.5	89.3	NE
Chris	Brown	20	88	88.5	89.3	NM
Kara Anne	Brown	21	81	81.5	82.3	CA
Michelle	Brown	20	86	86.5	87.3	AZ
Jennifer	Burgess	21	86	86.5	87.3	TX
Jody	Butts	21	89	89.5	90.3	AZ
Matthew	Cain	21	85	85.5	86.3	NV
Jonathan	Campbell	21	90	90.5	91.3	NE
Bethany	Carpenter	19	82	82.5	83.3	NE
Kara	Cheese	19	80	80.5	81.3	MT
Joseph	Chevalier	19	91	91.5	92.3	OK
Amy	Conald	19	81	81.5	82.3	CA
Kevin	Crowley	20	82	82.5	83.3	NE
Jeff	Curry	20	78	78.5	79.3	NM
Jennifer	Curtis	20	86	86.5	87.3	UT
Julia	Davis	20	92	92.5	93.3	UT
Rixie	Davis	21	76	76.5	77.3	NV
Brett	Dickson	21	93	93.5	94.3	UT
Bradley	Ditchen	21	82	82.5	83.3	OK
Chris	Dixon	20	88	88.5	89.3	ND
James	Elm	21	74	74.5	75.3	NV
Julie	Falk	22	88	88.5	89.3	NV
Kristopher	Fannin	22	93	93.5	94.3	NV
Kimberly	Farkas	22	82	82.5	83.3	TX
Joshua	Fecht	22	91	91.5	92.3	TX
John	Feely	22	90	90.5	91.3	ND
Richard	File	22	76	76.5	77.3	OR
Todd	Foldesi	21	91	91.5	92.3	TX
Gina	Garcia	21	87	87.5	88.3	NM
Ridonna	Gaston	21	76	76.5	77.3	MT
Sarah	Gill	21	79	79.5	80.3	KS
Eric	Graff	21	86	86.5	87.3	MT
Jeff	Graham	21	78	78.5	79.3	ND
Jennifer	Griffin	21	87	87.5	88.3	NV
Chris	Grotbo	19	88	88.5	89.3	SD
Kristen	Guilliams	19	83	83.5	84.3	UT
Steven	Halcomb	19	89	89.5	90.3	CA
Jennifer	Hall	19	87	87.5	88.3	WA
Virginia	Hardy	19	76	76.5	77.3	UT
Gregory	Harris	19	87	87.5	88.3	ND
Jennifer	Hemphill	19	88	88.5	89.3	OR
Bill	Herman	19	82	82.5	83.3	KS
Michael	Horn	19	85	85.5	86.3	OR
Rob	Hougas	20	76	76.5	77.3	CA
J Lane	Hunnicutt	20	74	74.5	75.3	UT
Lee	Isaacson	20	78	78.5	79.3	NV
Jennifer	Jeans	21	88	88.5	89.3	MT
Brooke	Johnson	21	93	93.5	94.3	WA
Kimberle	Jolliff	21	82	82.5	83.3	OK
Dawn	Kelley	21	84	84.5	85.3	OK
Heather	Kiel	22	73	73.5	74.3	NE
Jason	King	22	76	76.5	77.3	MT
Elizabeth	Klopfens	22	85	85.5	86.3	OR
Stephanie	Kneipp	22	87	87.5	88.3	OR
Michael	Lamonica	22	85	85.5	86.3	MT
Paul	Langellier	22	73	73.5	74.3	OK
Dung	Le	21	85	85.5	86.3	NV
Mark	Lipic	21	84	84.5	85.3	KS
David	Lorber	19	84	84.5	85.3	KS
Lisa	Mack	19	88	88.5	89.3	NM
John	Malito	19	90	90.5	91.3	SD
Erin	Malone	19	86	86.5	87.3	NV
Jason	Marshall	20	76	76.5	77.3	NV
Ryan	Maschhoff	20	78	78.5	79.3	SD
Lara	McClusk	20	93	93.5	94.3	OR
Jane	McCorma	21	76	76.5	77.3	WA
Bridgette	McDowall	21	83	83.5	84.3	NV
Sean	McPeak	21	86	86.5	87.3	NV
Molly	Meyer	21	87	87.5	88.3	ND
Marc	Mickiew	21	88	88.5	89.3	SD
Ted	Molis	19	90	90.5	91.3	NE
Dawn	Morgan	19	84	84.5	85.3	TX
Kevin	Naylor	19	82	82.5	83.3	KS
Scott	Nierstheim	19	86	86.5	87.3	UT
Jason	Nourie	20	77	77.5	78.3	CA
Amy	O'Connor	20	81	81.5	82.3	AZ
Son	Ong	20	87	87.5	88.3	WA
Erin	O'Rourke	20	86	86.5	87.3	CA
Jeffrey	Otto	21	78	78.5	79.3	SD
Meredith	Otto	21	85	85.5	86.3	WA
Sayuri	Ozeki	21	79	79.5	80.3	TX
Brenden	Penn	20	83	83.5	84.3	TX
Andrew	Peterson	21	82	82.5	83.3	SD
Rich	Peterson	22	74	74.5	75.3	WA
Sue	Phelan	22	89	89.5	90.3	NM
Rob	Pritts	22	77	77.5	78.3	AZ
Marty	Prochnow	22	84	84.5	85.3	TX
Tony	Ragusa	22	92	92.5	93.3	NV
Thomas	Reed III	22	91	91.5	92.3	OK
Kari	Robb	21	81	81.5	82.3	NM
Gretchen	Roetzer	21	87	87.5	88.3	SD
Sara	Romance	21	78	78.5	79.3	NE
Kara	Romine	21	80	80.5	81.3	NV
Aaron	Ruby	21	80	80.5	81.3	WA
Amy	Ryan	21	81	81.5	82.3	NM
Michael	Sams	21	86	86.5	87.3	NV
Susie	Scherb	19	90	90.5	91.3	SD
Jeffrey	Schryver	19	79	79.5	80.3	NE
Sarah	Scott	19	79	79.5	80.3	OK
Charles	Sieg	19	78	78.5	79.3	NV
Bryan	Simkins	19	78	78.5	79.3	OR
Lana	Smith	19	83	83.5	84.3	WA
Terence	Smith	19	90	90.5	91.3	KS
Adrien	Smith III	19	80	80.5	81.3	MT
Moria	Smoski	19	87	87.5	88.3	SD
Suresh	Soundar	20	89	89.5	90.3	ND
Felicia	Spakowski	20	87	87.5	88.3	AZ
Steve	Stabley	20	88	88.5	89.3	NV
Jason	Steele	21	77	77.5	78.3	AZ
Rebecca	Steiner	21	74	74.5	75.3	NV
Jennifer	Studeba	21	89	89.5	90.3	NV
Jerry	Sullivan	21	89	89.5	90.3	CA
Heather	Tatum	22	73	73.5	74.3	KS
Adam	Trudo	22	80	80.5	81.3	OR
Karen	Truttmann	22	81	81.5	82.3	AZ
Heather	Van Kirk	22	73	73.5	74.3	OK
Philip	Vancil	22	73	73.5	74.3	TX
Michael	Voelker	22	86	86.5	87.3	CA
Luke	Vybiral	21	88	88.5	89.3	ND
Linette	Wagner	21	88	88.5	89.3	AZ
Kari	Watkins	19	81	81.5	82.3	ND
Marshall	Watson	19	84	84.5	85.3	OK
Andrea	Weber	19	82	82.5	83.3	ND
Steven	Werby	19	89	89.5	90.3	AZ
Douglas	Wilken	20	85	85.5	86.3	UT
Katie	Wills	20	82	82.5	83.3	SD
Justin	Woith	20	80	80.5	81.3	OR
Jonathan	Woodruff	21	91	91.5	92.3	KS
Holly	Woodson	21	74	74.5	75.3	TX
Miriam	Wyman	21	87	87.5	88.3	NM
Ruth	Wyman	21	78	78.5	79.3	ND
Chris	Yeadon	21	88	88.5	89.3	CA
Eleanor	Yeh	19	85	85.5	86.3	WA
Matt	Young	19	84	84.5	85.3	UT

0
klim1167
6/1/2010 1:13:51 AM
access.forms 6864 articles. 2 followers. Follow

3 Replies
2760 Views

Similar Articles

[PageSpeed] 46

The table you have is structured like a spreadsheet rather than a database. 
If you build it that way, you lose most of the power and reliability that a 
relational database can give you, and you make it difficult to query the 
results.

For a suggestion on how to build relational tables to handle school grades, 
see this example:
    Relationships between Tables
at:
    http://allenbrowne.com/casu-06.html

If you have never built or seen a relational design before this may sound 
strange, but it is the absolute core understanding to grasp of how 
relational databases like Access work.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"klim1167" <u60492@uwe> wrote in message news:a8da1e93430ae@uwe...
> Dear Friends,
> I have a table named "class_grades" and with the fields of "First Name",
> "Last Name", "Age", "Math", "Physics", "Computer" and "State".
> I would like to build an Access form with dynamic query...
> 1. For the age and state, it's "drop_down select"
> 2. For the Math, Physics and Computer, I can enter the number and click an
> arrow button (to match the number with +/- 10%), then it will show all the
> matched list.
> All these "keyin" and "results" should be shown in the form (form + 
> sub-form?)
>
> I am sincerely looking for your help to guide me how to implement it.
> Thank you very much.
>
> First Name   Last Name Age Math Physics Computer State
>             drop_down keyin # keyin # keyin # drop_down
>             select <-> <-> <->           select
> Wendy     Alexander 20 76 76.5 77.3 NV
> Charles     Alsberry 20 78 78.5 79.3 MT
> .............................................................................
> ....................................
>
>
> Below is my table :
> First Name Last Name Age Math Physics Computer State
> Wendy Alexander 20 76 76.5 77.3 NV
> Charles Alsberry 20 78 78.5 79.3 MT
> Rebecca Alstrum 20 74 74.5 75.3 UT
> Lindie Alvey 21 78 78.5 79.3 CA
> Jennifer Armstrong 21 79 79.5 80.3 KS
> Nancy Ash 21 73 73.5 74.3 KS
> Mysty Atkins 21 87 87.5 88.3 NE
> Lauritz Austensen 22 78 78.5 79.3 MT
> Tom Baer 22 91 91.5 92.3 UT
> Roger Baird 22 77 77.5 78.3 NM
> Dana Baker 22 84 84.5 85.3 NE
> Jennifer Barnes 22 79 79.5 80.3 OK
> Christine Bayles 22 88 88.5 89.3 AZ
> Justin Benjamin 21 76 76.5 77.3 WA
> John Benson 21 89 89.5 90.3 NM
> Amanda Berg 19 81 81.5 82.3 NV
> Steve Bier 19 88 88.5 89.3 MT
> Vicki Blaine 19 88 88.5 89.3 TX
> Janna Borth 19 76 76.5 77.3 OR
> Mark Briggs 20 88 88.5 89.3 NE
> Chris Brown 20 88 88.5 89.3 NM
> Kara Anne Brown 21 81 81.5 82.3 CA
> Michelle Brown 20 86 86.5 87.3 AZ
> Jennifer Burgess 21 86 86.5 87.3 TX
> Jody Butts 21 89 89.5 90.3 AZ
> Matthew Cain 21 85 85.5 86.3 NV
> Jonathan Campbell 21 90 90.5 91.3 NE
> Bethany Carpenter 19 82 82.5 83.3 NE
> Kara Cheese 19 80 80.5 81.3 MT
> Joseph Chevalier 19 91 91.5 92.3 OK
> Amy Conald 19 81 81.5 82.3 CA
> Kevin Crowley 20 82 82.5 83.3 NE
> Jeff Curry 20 78 78.5 79.3 NM
> Jennifer Curtis 20 86 86.5 87.3 UT
> Julia Davis 20 92 92.5 93.3 UT
> Rixie Davis 21 76 76.5 77.3 NV
> Brett Dickson 21 93 93.5 94.3 UT
> Bradley Ditchen 21 82 82.5 83.3 OK
> Chris Dixon 20 88 88.5 89.3 ND
> James Elm 21 74 74.5 75.3 NV
> Julie Falk 22 88 88.5 89.3 NV
> Kristopher Fannin 22 93 93.5 94.3 NV
> Kimberly Farkas 22 82 82.5 83.3 TX
> Joshua Fecht 22 91 91.5 92.3 TX
> John Feely 22 90 90.5 91.3 ND
> Richard File 22 76 76.5 77.3 OR
> Todd Foldesi 21 91 91.5 92.3 TX
> Gina Garcia 21 87 87.5 88.3 NM
> Ridonna Gaston 21 76 76.5 77.3 MT
> Sarah Gill 21 79 79.5 80.3 KS
> Eric Graff 21 86 86.5 87.3 MT
> Jeff Graham 21 78 78.5 79.3 ND
> Jennifer Griffin 21 87 87.5 88.3 NV
> Chris Grotbo 19 88 88.5 89.3 SD
> Kristen Guilliams 19 83 83.5 84.3 UT
> Steven Halcomb 19 89 89.5 90.3 CA
> Jennifer Hall 19 87 87.5 88.3 WA
> Virginia Hardy 19 76 76.5 77.3 UT
> Gregory Harris 19 87 87.5 88.3 ND
> Jennifer Hemphill 19 88 88.5 89.3 OR
> Bill Herman 19 82 82.5 83.3 KS
> Michael Horn 19 85 85.5 86.3 OR
> Rob Hougas 20 76 76.5 77.3 CA
> J Lane Hunnicutt 20 74 74.5 75.3 UT
> Lee Isaacson 20 78 78.5 79.3 NV
> Jennifer Jeans 21 88 88.5 89.3 MT
> Brooke Johnson 21 93 93.5 94.3 WA
> Kimberle Jolliff 21 82 82.5 83.3 OK
> Dawn Kelley 21 84 84.5 85.3 OK
> Heather Kiel 22 73 73.5 74.3 NE
> Jason King 22 76 76.5 77.3 MT
> Elizabeth Klopfens 22 85 85.5 86.3 OR
> Stephanie Kneipp 22 87 87.5 88.3 OR
> Michael Lamonica 22 85 85.5 86.3 MT
> Paul Langellier 22 73 73.5 74.3 OK
> Dung Le 21 85 85.5 86.3 NV
> Mark Lipic 21 84 84.5 85.3 KS
> David Lorber 19 84 84.5 85.3 KS
> Lisa Mack 19 88 88.5 89.3 NM
> John Malito 19 90 90.5 91.3 SD
> Erin Malone 19 86 86.5 87.3 NV
> Jason Marshall 20 76 76.5 77.3 NV
> Ryan Maschhoff 20 78 78.5 79.3 SD
> Lara McClusk 20 93 93.5 94.3 OR
> Jane McCorma 21 76 76.5 77.3 WA
> Bridgette McDowall 21 83 83.5 84.3 NV
> Sean McPeak 21 86 86.5 87.3 NV
> Molly Meyer 21 87 87.5 88.3 ND
> Marc Mickiew 21 88 88.5 89.3 SD
> Ted Molis 19 90 90.5 91.3 NE
> Dawn Morgan 19 84 84.5 85.3 TX
> Kevin Naylor 19 82 82.5 83.3 KS
> Scott Nierstheim 19 86 86.5 87.3 UT
> Jason Nourie 20 77 77.5 78.3 CA
> Amy O'Connor 20 81 81.5 82.3 AZ
> Son Ong 20 87 87.5 88.3 WA
> Erin O'Rourke 20 86 86.5 87.3 CA
> Jeffrey Otto 21 78 78.5 79.3 SD
> Meredith Otto 21 85 85.5 86.3 WA
> Sayuri Ozeki 21 79 79.5 80.3 TX
> Brenden Penn 20 83 83.5 84.3 TX
> Andrew Peterson 21 82 82.5 83.3 SD
> Rich Peterson 22 74 74.5 75.3 WA
> Sue Phelan 22 89 89.5 90.3 NM
> Rob Pritts 22 77 77.5 78.3 AZ
> Marty Prochnow 22 84 84.5 85.3 TX
> Tony Ragusa 22 92 92.5 93.3 NV
> Thomas Reed III 22 91 91.5 92.3 OK
> Kari Robb 21 81 81.5 82.3 NM
> Gretchen Roetzer 21 87 87.5 88.3 SD
> Sara Romance 21 78 78.5 79.3 NE
> Kara Romine 21 80 80.5 81.3 NV
> Aaron Ruby 21 80 80.5 81.3 WA
> Amy Ryan 21 81 81.5 82.3 NM
> Michael Sams 21 86 86.5 87.3 NV
> Susie Scherb 19 90 90.5 91.3 SD
> Jeffrey Schryver 19 79 79.5 80.3 NE
> Sarah Scott 19 79 79.5 80.3 OK
> Charles Sieg 19 78 78.5 79.3 NV
> Bryan Simkins 19 78 78.5 79.3 OR
> Lana Smith 19 83 83.5 84.3 WA
> Terence Smith 19 90 90.5 91.3 KS
> Adrien Smith III 19 80 80.5 81.3 MT
> Moria Smoski 19 87 87.5 88.3 SD
> Suresh Soundar 20 89 89.5 90.3 ND
> Felicia Spakowski 20 87 87.5 88.3 AZ
> Steve Stabley 20 88 88.5 89.3 NV
> Jason Steele 21 77 77.5 78.3 AZ
> Rebecca Steiner 21 74 74.5 75.3 NV
> Jennifer Studeba 21 89 89.5 90.3 NV
> Jerry Sullivan 21 89 89.5 90.3 CA
> Heather Tatum 22 73 73.5 74.3 KS
> Adam Trudo 22 80 80.5 81.3 OR
> Karen Truttmann 22 81 81.5 82.3 AZ
> Heather Van Kirk 22 73 73.5 74.3 OK
> Philip Vancil 22 73 73.5 74.3 TX
> Michael Voelker 22 86 86.5 87.3 CA
> Luke Vybiral 21 88 88.5 89.3 ND
> Linette Wagner 21 88 88.5 89.3 AZ
> Kari Watkins 19 81 81.5 82.3 ND
> Marshall Watson 19 84 84.5 85.3 OK
> Andrea Weber 19 82 82.5 83.3 ND
> Steven Werby 19 89 89.5 90.3 AZ
> Douglas Wilken 20 85 85.5 86.3 UT
> Katie Wills 20 82 82.5 83.3 SD
> Justin Woith 20 80 80.5 81.3 OR
> Jonathan Woodruff 21 91 91.5 92.3 KS
> Holly Woodson 21 74 74.5 75.3 TX
> Miriam Wyman 21 87 87.5 88.3 NM
> Ruth Wyman 21 78 78.5 79.3 ND
> Chris Yeadon 21 88 88.5 89.3 CA
> Eleanor Yeh 19 85 85.5 86.3 WA
> Matt Young 19 84 84.5 85.3 UT
> 
0
Allen
6/1/2010 3:02:19 AM
Thanks a lot, Allen.
Can you give me an example how to implement a parameter query in a form
without a pop up window?


Allen Browne wrote:
>The table you have is structured like a spreadsheet rather than a database. 
>If you build it that way, you lose most of the power and reliability that a 
>relational database can give you, and you make it difficult to query the 
>results.
>
>For a suggestion on how to build relational tables to handle school grades, 
>see this example:
>    Relationships between Tables
>at:
>    http://allenbrowne.com/casu-06.html
>
>If you have never built or seen a relational design before this may sound 
>strange, but it is the absolute core understanding to grasp of how 
>relational databases like Access work.
>
>> Dear Friends,
>> I have a table named "class_grades" and with the fields of "First Name",
>[quoted text clipped - 173 lines]
>> Eleanor Yeh 19 85 85.5 86.3 WA
>> Matt Young 19 84 84.5 85.3 UT

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201006/1

0
klim1167
6/2/2010 9:23:22 AM
Best to ask a new question as a separate thread.

If you don't want the parameter dialog popping up, then I presume you want 
it to pick up the parameter values from an open form. You can do that by 
specifying parameters like this:
    [Forms].[Form1].[Text0]

For information on a better way to do it, see:
    http://allenbrowne.com/ser-62.html
The last section of that article illustrates how to do it with a parameter 
query reading values from a form, if you really want to do it that way 
instead of building a filter string.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"klim1167 via AccessMonster.com" <u60492@uwe> wrote in message 
news:a8eaf7585359e@uwe...
> Thanks a lot, Allen.
> Can you give me an example how to implement a parameter query in a form
> without a pop up window? 

0
Allen
6/2/2010 1:10:13 PM
Reply:

Similar Artilces:

Custom Forms #3
I have created custom form for a Public calendar. Which I have some checkbox yes/no fields. For Example (Need Tables check for yes.) When I print that appointment the fields shows a 0 or -1. Is there away to have it print yes or no. I have tried yes/no and Icon format ...

Using Brackets in Excel
I would like to know how to show negative numbers in an Excel worksheet in brackets rather than a minus sign in front of the number. Thanks and regards On Mon, 18 Aug 2003 02:50:05 -0700, "Robert" <Robert@kellyassociates.biz> wrote: >I would like to know how to show negative numbers in an >Excel worksheet in brackets rather than a minus sign in >front of the number. > >Thanks and regards Format/Cells/Number/Custom/Type: 0.00_];\[0.00\] --ron Hi Robert Select the Cells that you whish to apply formula to then, from the Format Menu select Cells, then s...

Unable to resize Navigation pane in access 2007
This ability to resize the navigation pane has become disabled. Is there anyway to reset it to default settings? Can you not just drag it? -- Build a little, test a little. "SJ" wrote: > This ability to resize the navigation pane has become disabled. Is there > anyway to reset it to default settings? > > > . > ...

DVD Burning using C++
I am writing an application to burn DVDs using C++. Is there any way to burn a DVD using Visual C++. i know about IMAPI but its gives only support CD burning. what about the DVD Burning. how i can do that. Can anyone help me? Thanks a Lot... I haven't tried this, but it's shareware so you could try it out and see if it does what you want. The $250 per copy for royalty free license seems reasonable to me if it does all it claims: http://www.freedownloadscenter.com/Programming/C_and_C++_Tools_and_Components/Magic_CD_DVD_Burner__C_C___Library_.html Tom "jain" <parul...

can not open excel files using associations
Hi, I am having problems to open an excel spread sheet by double clicking on the file itself. Please, any ideas? Thank you Marcela Try Tools>Options>General and un-check 'Ignore other applications' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "Marcela Pruk" <marcelapruk@lubtec.sk> wrote in message news:%23Fv9hCjIFHA.720@TK2MSFTNGP10.phx.gbl... > Hi, > I am having problems to open an excel spread sheet by double clicking on > the file itself. Please, any ideas? > Thank you > And ...

in office 2007 we cannto logon exchange mail box
i installed office 2007 then arrnage mail account , when i configure exchange box officce said that message.0x80040011d when i see in network connection gatway not avaliable because dhcp automaticly share when i configure manullay no problem. how can solve thanx Twety <ak@yahoo.com> wrote: > i installed office 2007 then arrnage mail account , when i > configure exchange box officce said that message.0x80040011d Is your mailbox store mounted? Can you open this mailbox in OWA? > > when i see in network connection gatway not avaliable because dhcp > aut...

2007 duplicate email messages
Erratically I see duplicate email messages. Why and what can i do to avoid it? iuse Outlook Office 2007. Thanks!! Typically remove the e-mail scanning add-in of the Anti-virus software you are using. It doesn't provide any additional benefits. VP wrote: > Erratically I see duplicate email messages. Why and what can i do to avoid > it? iuse Outlook Office 2007. Thanks!! "VP" <VP@discussions.microsoft.com> wrote in message news:155FBFD6-5E89-4DA9-8DDC-FE08C4CF5A28@microsoft.com... > Erratically I see duplicate email messages. Why and what ...

Outlook 2007 and symbian 9.1 (3rd edition)
Hi - I have noticed (and I have seen others replicate the behaviour) that Outlook 2007 does not synch notes with symbian 9.1 devices (such as the nokia e61). Anyone aware of a fix? contact the maker of the sync software you use for a fix. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http:/...

Surprisingly fidly query?
Hello All I'm sure this should be simple - but can't seem to get it! I need a query that takes various integer values (say 'monthnumber'), and returns an integer (say 'period') between 1 and 12, according to the following pattern: 'monthnumber' 1 returns 'period' 1 'monthnumber' 2 returns 'period' 2 'monthnumber' 3 returns 'period' 3 etc etc until 'monthnumber' 13 returns 'period' 1 'monthnumber' 14 returns 'period' 2 etc etc until 'monthnumber' 25 returns 'pe...

change a date query fra a single to a several
I’m coming from Denmark, so excuse me for the bad English. I’ve got a table in an Access , I Have made by a Query, from a Employee “Clock in / out system”. They are also using the “Clock in / out system” to planed free (holliday), in this example At first , they put in the Employee number , next the start date ( 26-11-2007 ) and next the end date ( 30-11-2007 ) and at last the letter for Holliday “ H “ . and now the problems begin. Because all these information’s is taken into one records ( line ) Employee id Start date End date Letter for free H, ……. 1234 ...

What files need to be shipped with Visual Studio 2008 Application that uses MFC Feature Pack
What all files (MFC dlls etc) need to be shipped with such an application (as in the subject line)? I understand most of the users won't be having the latest system dlls. So i wanted them to reside besides the application exe. I am using many Feature Pack utilities like Ribbon Interface etc. I found that wiki (http://en.wikipedia.org/wiki/ Microsoft_Foundation_Class_Library) mentions MFC 9.0.30411 (mfc90.dll). How do I identify this? warm regards, Divya Rathore When I build my applications, I prefer to statically link with MFC. Although this makes my EXE image larger, it simplifies di...

I need open or gain access to an external file
Here is my problem and I hope someone can help me out. I am trying to open or retrieve data from a file that is only accessable from a different user. Example: If you are logged in under user and need to access a file that is only available under admin. The files are unavailable under user because they do not need to be tampered with. These files cannot be made public. Is there a way to do this? Doesn't that sound like it would defeat the purpose of having the file placed where you can't/shouldn't be able to get to it? -- Best Regards, Luke M "P.Griesh...

Change the name of the file attachment using sendobject
I would like to change the name of the excel spreadsheet that is attached to an email using the sendobject method. DoCmd.SendObject acSendQuery, "Q Email Export", acFormatXLS, "thechad@thechad.com", , , " Email List Export" any help is appreciated very much. Chad ...

Office 2007
I am using Office 2007 and windows XO. TYhe screen resolution is 1280 x 1024. Why are the icons still solarge? Is there a way of reducing the size so they appear like my other computer using Office 2007 and vista? Which icons?, the default installation of 2007 doesnt place any icons on the desktop "Phippsy" <Phippsy@discussions.microsoft.com> wrote in message news:23691D04-C4CF-4FB5-9863-153D3D234FDA@microsoft.com... >I am using Office 2007 and windows XO. TYhe screen resolution is 1280 x >1024. > Why are the icons still solarge? Is there a way of redu...

Phone Activity Form
My question is regarding viewing phone call activities from the activities entity created from a quick campaign for Leads. I am only able to view the regarding (which is the campaign name) and recipient (which is the full name of the Lead) field, on leads we often only know the company name and not a first or last name. So viewing the resulting phone activities created from the quick campaign have to be opened up then click again to open up the Lead form to view the company name if there is no first or last name, very time consuming. When I do an advanced find and chose edit columns/...

How do I set up a Startup Form with Access 2007 ?
Hi When I open a database, I want a certain form to start. This form is going to be used for a menu. Please let me know. Thanks Mark Create a macro named Autoexec. Have action open your form. -- KARL DEWEY Build a little - Test a little "mthornblad@gmail.com" wrote: > Hi > > When I open a database, I want a certain form to start. This form is > going to be used for a menu. > > Please let me know. > > Thanks > Mark > > On Aug 13, 5:24 pm, kasab <ka...@discussions.microsoft.com> wrote: > Alternatively, click the Office button ...

OWA and Full Mailbox Access .... weird Send As
Hello i use Exchange 2003 SP2 I have 2 users : user1 and user2 user1 has got fullmailbox access on user2 (nothing more) If I use outlook : I connect with user1 and I send an email from user2 then it appears has : sent on behalf.... wich is ok If I use owa : I connect with user1 and then I add user2 just like this http://exchange/exchange/user2 I send an email .... and then it appears has : from user2 wich is a "bug" ... it should be the same behaviour. How can i solve this problem? In news:45337094$0$8606$426a74cc@news.free.fr, Stephane <steph@nospamamamamamam.net> ty...

Launching a Form
Hi I inserted "MS Excel 5.0 Dialoge" and put some check boxes on it that run some macros. Question: How do I make this "Dialoge" form? show up. I used another "Command Button" with the code Unload DialogFrame1 But this gave me an error. Thanks hi, attatch this code to a button or icon Sub ShowForm() UserForm1.Show 0 ' rename userform1 to your form name AppActivate Application.Caption End Sub Regards Frank >-----Original Message----- >Hi > >I inserted "MS Excel 5.0 Dialoge" and put some check boxes on it that run >...

OneNote 2007 Attachments from Outlook
Is there any way to have the attachements of an email sent from Outlook to actually be attached to the notebook you file the note in once received? I have THOUSANDS of attachments to emails filed, and all the actual files are in the "Temp" subdirectory, and don't move when the page is moved from the "Unfiled Notes" section. Certainly makes synchronizing notebooks a problem. ...

How do I keep other users from accessing my Word documents and mus
I want to keep my documents private and my music from being deleted by others on this computer. How do I do that? You can password protect your Word documents against opening, which will keep out all but the most determined snoop, but it won't stop anyone you allow access from deleting them. You need to introduce security measures to keep other users out of your profile (not perfect but it's a start) and you need to move important files to an external drive which you should keep locked away when you are not using the PC. The best security measure is to prevent any acces...

Outlook 2007, Flickers and Hangs
HI I have been using OL2007 for about 6 months, but from last week I have experienced some issues: 1: When sending a new email with an attachment, when I click on the paperclip icon the search box which appears to select the file to attach flickers, nothing is displayed in the box and outlook hangs. Interestingly I can drag the file from the location into the email and send ok. 2: When replaying to certain emails when I hit send Outlook again hangs and the screen flickers. In both instances I have to Ctrl Alt Delete to force quit. Any ideas? Thanks Mark Do y...

help
I'm using Excel 2003. I've got two worksheets of data in my workbook, one copied from a text file, the other downloaded from the Bureau of the Census, originally in .csv format and saved as an .xls file. I'm using vlookup to use the state name in one sheet to lookup the data value I want from the other worksheet. Vlookup returns the value of the last cell in the table rather than the value that should be returned. I've done some simple testing on the lookup value relative to that in the table array. Both entries are the same length. Both are text (istext). Mat...

Room booking system using a Gantt chart
Hi, I am trying to set up a room booking system using a Gantt chart approach. I am working on a working example that I downloaded from John Lacher's site (http://lacher.com/examples/lacher24.htm), which almost meets my needs. His example display a room booking system over a 24 hour period. What I need it to do it to show a room booking system over a weekly/monthly period, etc. I have tinkered around with it endlessly but cannot get anywhere. Everytime I format the y axis to date format the chart goes ski-wift - after 6 hours it's starting to drive me bananas! Could someon...

SUM of a colum where IF function is used
Hi, I would like to have the sum of cloumn 'C' in the attached file. An IF function is used to derive column C. =SUM ( C1:C21) is not giving the result. Please help me. Jeevan See responses to your duplicate posting with the attachment. In the future, do not start another thread. Simply post a follow-up in your original thread. ----- original message ----- "Vinay Vasu" <vinayvasu@hotmail.com> wrote in message news:%23dk6OOj3KHA.5820@TK2MSFTNGP06.phx.gbl... > Hi, > > I would like to have the sum of cloumn 'C' in the at...

Using DDL to Create Constraint
I am running into a problem with the following code that I am testing. I get a syntax error on the third DDL SQL statement. I can't see what I am doing wrong. Perhaps what I am attempting is not possible using DDL and I will have to use DAO to build the relationship? -- Access 2003 msb (Access 2000 format); -- Split FE-BE where I need to update the application at a remote location The one-table is tblSessions The many-table is tblSessionCurriculum Modules Private Function fDUmmy() Dim strTargetDb As String Dim dbsTemp As DAO.Database Dim strSQL As String On Error GoTo ERROR_fDU...