Access Newsgroup Flash: 12/3/2002

[Rita Nikas [MS]]

Hi all.

Here's the newsgroup flash for 12/03/2002 (these will be coming out twice a
month).

New content on MSDN of interest to Microsoft Access users and developers:

Database Design for Mere Mortals (Chapter 12: Views)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacbk02/ht
ml/odc_DBs4Mortals.asp

Access Cookbook (Chapter 1 Excerpt: Using a Query to Show the Relationship
Between
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacbk02/ht
ml/odc_CookbookChapter1.asp

Access Cookbook (Chapter 8 Excerpt: Make Slow Forms Run Faster)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacbk02/ht
ml/odc_cookbookchapter8.asp

Access Cookbook (Chapter 9 Excerpt: Create a Generic, Reusable Status Meter)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacbk02/ht
ml/odc_CookbookChapter9.asp

Choosing and Using MSDE 2000 as the Database Engine for Your Application
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html
/msderoadmap.asp

Urgent/Time-Critical Issues
~~~~~~~~~~~~~~~~~~
If you're working on a time-critical issue or something that's *urgent* to
resolve quickly, please contact Product Support Services and open a support
incident. This is the fastest way for you to get assistance on technical
issues. Newsgroups do have a time-lag.

Do keep in mind that Microsoft Partners in the United States and Canada can
ensure success in escalated customer situations with free Microsoft
technical phone support 24x7 during critical LAN outages or "business down"
situations.

Technical Chats
~~~~~~~~~~~~~~~
Upcoming technical chats can be found at http://msdn.microsoft.com/chats/

Upcoming Support WebCasts
~~~~~~~~~~~~~~~~~~~~~~~~~
Please visit Support WebCasts for more information, located at:

http://support.microsoft.com/default.aspx?scid=/default.aspx%3Fid=fh;en-us;w
ebcst%26style=flat

Microsoft Newsletters
~~~~~~~~~~~~~~~~~~~~~
If you go to http://www.microsoft.com/misc/ and enter your .Net Passport
username and password, you can select *all* sorts of Microsoft Newsletters
to receive by e-mail.

Top Issues
~~~~~~~~~~
The Top 10 Microsoft Access 2000 Support Issues are located at:

http://support.microsoft.com/default.aspx?scid=/support/access/content/acc20
00top.asp

Microsoft Product Support Lifecycle
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Microsoft's Support Lifecycle policy provides consistent and predictable
guidelines for product support availability at the time of product release.
The Support Lifecycle policy takes effect October 15, 2002 and applies to
most products currently available through retail purchase or volume
licensing and most future release products.

Located at http://support.microsoft.com/default.aspx?scid=fh;[LN];lifecycle

Security
~~~~~~~~
For the most recent security-related information, see
http://microsoft.com/security/.

Tips
~~~~
Microsoft Access Support Center, located at
http://support.microsoft.com/default.aspx?scid=fh%3Ben-us%3Bacc&x=16&y=16

Office Development Support Center
http://support.microsoft.com/default.aspx?scid=fh;en-us;ofd

Posting Tips
~~~~~~~~~~~~
To get the best response to your post, review the following posting
suggestions:

* Apply the most recent versions of the operating system and Internet
Explorer updates; the most recent service
release/service pack for your version of Microsoft Office; and apply the
most up-to-date version of the Jet database
engine.

* Attempt to reproduce your issue with the Northwind sample database.

* Provide your specific operating system name, including service packs;
specific Microsoft Access and Office versions;
and specific Jet version.

Newsgroup Support Boundaries
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
298645
ACC2002: Microsoft Product Support Guidelines for MS Access
http://support.microsoft.com/default.aspx?scid=KB;EN-US;298645
For Microsoft Access 2002

298641
ACC2000: Microsoft Product Support Guidelines for MS Access
http://support.microsoft.com/default.aspx?scid=KB;EN-US;298641
For Microsoft Access 2000

166776
ACC: Microsoft Product Support Guidelines for MS Access
http://support.microsoft.com/default.aspx?scid=KB;EN-US;166776
For Microsoft Access 97

Partner Information
~~~~~~~~~~~~~
www.microsoft.com/partner

Sincerely,

Rita Nikas, MCSE MCDBA
Microsoft Access MVP Lead
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

[Tom D]

Please verify your links before you post.

"Rita Nikas [MS]" <ritan[MS]@online.microsoft.com> wrote in message
news:#f#eAJwmCHA.2352@TK2MSFTNGP11...

[Randy Harris]

Thank you! I thought it must have been my problem. I can't get to any of
her links either.
--
Randy Harris

"Tom D" <tdonnelly%%%@%%%underwood-engineering.com> wrote in message
news:eIKGYQwmCHA.2252@TK2MSFTNGP11...

[Dirk Goldgar]

Which one(s) did you find broken?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"Tom D" <tdonnelly%%%@%%%underwood-engineering.com> wrote in message
news:eIKGYQwmCHA.2252@TK2MSFTNGP11...

[Dirk Goldgar]

Not any? They're line-wrapped, of course, but I had no trouble
following at least the first once, once I joined the broken lines.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"Randy Harris" <randy....@nospam.net> wrote in message
news:#eJO4YwmCHA.2360@TK2MSFTNGP09...

[Sandra Daigle]

All the links that I've tried work for me - which ones are not working for
you?

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

[Rob Oldfield]

I've only tried one, but it didn't work. The 2000top.asp one.

--
For real reply address, lose the cash.
www.realuk.co.uk

Dirk Goldgar wrote in message <#I5RlbwmCHA.2204@TK2MSFTNGP09>...

[Dirk Goldgar]

Interesting. It worked fine for me just now.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"Rob Oldfield" <r$o$b@oldf$ield10$0.free$ser$ve.c$o.uk> wrote in
message news:elZRDjwmCHA.2208@TK2MSFTNGP09...

[Stephen Lebans]

The links are fine Tom, they just got line wrapped in your NewsReader.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"Tom D" <tdonnelly%%%@%%%underwood-engineering.com> wrote in message
news:eIKGYQwmCHA.2252@TK2MSFTNGP11...

[Tom D]

I caught it after my post...
Sorry.

Thanks for the links Rita!

tom d.

"Stephen Lebans" <Stephe...@mvps.org> wrote in message
news:#Ic$UtwmCHA.2260@TK2MSFTNGP11...

[Rob Oldfield]

Think Microsoft's site is having a funny five minutes. I just went there,
did a search, and tried to follow a link. Page unavailable.

--
For real reply address, lose the cash.
www.realuk.co.uk

Stephen Lebans wrote in message <#Ic$UtwmCHA.2260@TK2MSFTNGP11>...

[Rob Oldfield]

For reference, go to www.microsoft.com, search for 'switchboard access' (no
speech marks obviously), second hit is Q262847.

Though I've just done a search directly for Q262847 and that fails to find
anything.

Weird.

--
For real reply address, lose the cash.
www.realuk.co.uk

Rob Oldfield wrote in message <#tGHbxwmCHA.2360@TK2MSFTNGP09>...

[Dirk Goldgar]

I believe the KB articles are being renumbered and revamped in groups,
so some may not be available at any given time.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"Rob Oldfield" <r$o$b@oldf$ield10$0.free$ser$ve.c$o.uk> wrote in

message news:OFkuA3wmCHA.456@TK2MSFTNGP08...

[Rob Oldfield]

Where did you hear that? And why don't they have big signs up and klaxons
going off with massive red warnings saying "You're wasting your time here
bud."

Still can't get to the 2000top.asp either. Suspect I may be able to blame
my browser as it's ancient.

--
For real reply address, lose the cash.
www.realuk.co.uk

Dirk Goldgar wrote in message ...

[Randy Harris]

Sorry, it was the line wraps that caused the problems (kept getting page not
available).
--
Randy Harris

"Dirk Goldgar" <d...@NOdataSPAMgnostics.com> wrote in message
news:uFQ2KdwmCHA.672@TK2MSFTNGP08...

[Sandra Daigle]

How about this:
http://support.microsoft.com/default.aspx?scid=fh;[ln];kbnumb

If you use the Knowledgebase and your search fails with no matches, you get
a link to the above article.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Rob Oldfield wrote:
> Where did you hear that? And why don't they have big signs up and klaxons
> going off with massive red warnings saying "You're wasting your time here
> bud."
>
> Still can't get to the 2000top.asp either. Suspect I may be able to blame
> my browser as it's ancient.
>
>

[Dirk Goldgar]

"Rob Oldfield" <r$o$b@oldf$ield10$0.free$ser$ve.c$o.uk> wrote in

message news:O#wawExmCHA.2276@TK2MSFTNGP12...

> Where did you hear that?

I can't recall.

> And why don't they have big signs up and klaxons
> going off with massive red warnings saying "You're wasting your time
here
> bud."

So far, I haven't encountered any unavailable pages personally, though
I've heard of a few such. But I don't think it's as bad as that. I'm
not at all happy about the change in article numbers from "Qnnnnnn"
(for English-language pages) to just "nnnnnn", though.

> Still can't get to the 2000top.asp either. Suspect I may be able to
blame
> my browser as it's ancient.

I do suspect your browser, or maybe your security settings?

[Rob Oldfield]

Thank you.

--
For real reply address, lose the cash.
www.realuk.co.uk

Sandra Daigle wrote in message ...

[Arvin Meyer]

Folks the problems you are having with the url's is due to line wrapping.
You can use the little utility to fix them. It sits in your quickstart bar
and all you need to is copy the entire url (wrapped and all) then click on
the icon and it will automagically fix the url and open the page:

http://www.sellsbrothers.com/tools/urlrun.zip

Neatest thing since sliced bread!
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"Tom D" <tdonnelly%%%@%%%underwood-engineering.com> wrote in message
news:eIKGYQwmCHA.2252@TK2MSFTNGP11...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.423 / Virus Database: 238 - Release Date: 11/25/2002

[Chris Mills]

You need a mercy-shot to the back of the head, if you don't understand
word-wrap by now.

:-) :-)

"Tom D" <tdonnelly%%%@%%%underwood-engineering.com> wrote in message

news:e1HbOvwmCHA.2000@TK2MSFTNGP12...

[Chris Mills]

You also need a mercy-shot, if you think it's somehow difficult to combine a
wrapped-line.
1) Copy/paste the first part to explorer
2) Switch Windows. Requires a keystroke
3) Copy/paste the rest to explorer

For goodness sake, Marvin, there's no need for a whole 'nother url.

"Arvin Meyer" <a...@m.com> wrote in message news:OAyjmv0mCHA.952@TK2MSFTNGP12...

[Arvin Meyer]

That would be Arvin. There was no mention of difficulty at all. Nor was
there any mention of another url (like the tinyurl program which is nice,
but too much work for more than one url).

The urlrun process is easy and takes far less time. You simply select all
the text in the url, now matter how many lines it is. Right-click and choose
copy. Click on the urlrun button on the Quick Launch toolbar. Thats it!

The browser opens to the url. Everything that you've done in line 1 of your
directions (and more) is done and you are looking at the page. It's not a
question of difficulty. I can add a hundred lines of numbers in my head from
a spreadsheet, but why do it when I can click on a column and then the Sigma
button? Computers exist to do the stupid and/or repetitive things we do, not
to do the things which require intellect.

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"Chris Mills" <phad_...@xtradotco.nz> wrote in message
news:uqo6n52mCHA.2260@TK2MSFTNGP11...

> You also need a mercy-shot, if you think it's somehow difficult to combine
a
> wrapped-line.
> 1) Copy/paste the first part to explorer
> 2) Switch Windows. Requires a keystroke
> 3) Copy/paste the rest to explorer
>
> For goodness sake, Marvin, there's no need for a whole 'nother url.
>
> "Arvin Meyer" <a...@m.com> wrote in message
news:OAyjmv0mCHA.952@TK2MSFTNGP12...
> > Folks the problems you are having with the url's is due to line
wrapping.
> > You can use the little utility to fix them. It sits in your quickstart
bar
> > and all you need to is copy the entire url (wrapped and all) then click
on
> > the icon and it will automagically fix the url and open the page:
> >
> > http://www.sellsbrothers.com/tools/urlrun.zip

---

[Tom D]

Sorry Chris Mills,
If we all could only compare to you're word-wrapping-url genius.
We all make bone-head mistakes sometimes. Thanks, for the tip,
I'm well aware of cut and paste, and how a long URL gets wrapped.
I just replied to the post too quick, and without a better look. (As I
stated...bone-head mistake) Maybe the mercy-shot candidate should
be reconsidered. ---Arvin, thanks for the link, I liked
it. Being URL challenged, I found it useful.

--Chris, you don't impress anyone with that kind of attitude.

HTH,

Tom Donnelly, PE, mcse, ccnp
Senior Systems Engineer
Underwood Engineering Testing Co., Inc.

"Arvin Meyer" <a...@m.com> wrote in message

news:uEiMTN5mCHA.1928@TK2MSFTNGP09...

[Jan Il]

> Sorry Chris Mills,
> If we all could only compare to you're word-wrapping-url genius.
> We all make bone-head mistakes sometimes. Thanks, for the tip,
> I'm well aware of cut and paste, and how a long URL gets wrapped.
> I just replied to the post too quick, and without a better look. (As I
> stated...bone-head mistake) Maybe the mercy-shot candidate should
> be reconsidered. ---Arvin, thanks for the link, I liked
> it. Being URL challenged, I found it useful.
>
> --Chris, you don't impress anyone with that kind of attitude.

Didn't fare much better on a another MS ng either. Hi Chris <g>

Have a really great day :)

Jerk II :)

[Chris Mills]

Cheers! (no need to apologise!)

"Jan Il" <jan...@cox.net> wrote in message
news:hFzH9.23301$K64.7...@news2.west.cox.net...
> > Sorry Chris Mills,

[Jan Il]

Chris...you really should keep up...it was not *I* who made this statement,
just merely replied to the one made by Tom D. :)

Perhaps you misunderstood this part of his reply to your posts:

<--Chris, you don't impress anyone with that kind of attitude.>

Cheers!

>
>
>

[Chris Mills]

<sigh> So what ideas did you actually have on the thread subject?

(at least I post under my own name)

(Why all the spaces and circumflexes at the bottom of your post? Were you
replying to a null issue with a null reply to the last circumflexes?)

(If I accidentally left that in a program, it would not compile, I guess)

:-)

"Jan Il" <jan...@cox.net> wrote in message

news:rUfI9.2970$jf7.1...@news2.west.cox.net...