Solved

Expert notify thread - For Experts Only

Posted on 2006-11-16
61
643 Views
Last Modified: 2008-06-29
Hi Everyone,

  This "question" is for Experts only of the MS Access TA.  Normal members should not post comments here.  This question provides the ability for an Expert to ask for assistance from other Experts in getting member questions answered.

Experts:
  The idea behind this "question" is to allow an easy means of getting other Experts and the TA PE(s) to look at something or discuss something.

   It is a "notify* question in the sense that you initially only *subscribe* to the question, but *don't* post any comments.

  When you want to communicate with the other Experts, you post a new comment in this question that might look something like this:

Subject: Expert Topic - Member needs help with a tough one

"Member xyz needs help.  Please see

<link>

AccessExpert"

  All of us will then receive an e-mail notification (because we are subscribed to this thread) and can click on the link to find out what needs to be done or talked about.  Please do *not* post general comments or hold a discussion in this notify question.  Keep in mind that everyone receives an e-mail each time a comment is added and it takes longer for the page to load as it grows larger (some of us are still on dial-up).

  So feel free to use this to talk about any Expert issues or items that are specific to the MS Access TA by opening another question and putting a link in here as a comment.  Keep in mind that anyone will be able to see these questions (both members and Experts).  When creating your question topic, make sure you use "Expert Topic" at the start of the question title.  This will make it easy for everyone to spot these questions.

Jim Dettman
MS Access PE
0
Comment
61 Comments
 
LVL 26

Expert Comment

by:dannywareham
Comment Utility
<<bookmark>>
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
Good idea Jim, would be nice if there was a expert are under MS Access, what do u think? I say that cos this question will become very large over time time
0
 
LVL 32

Expert Comment

by:jadedata
Comment Utility
"Normal members should not post comments here"

....the only remaining presumption is that Experts are not "normal".

-j-
0
 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
Thanks JD.  Welcome back other JD.
0
 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
Change App.Caption in ADP Project
http://www.experts-exchange.com/Databases/Q_22063572.html

{Either this is something adp-specific, which I haven't done before, or the asker is somewhat clueless, or both}
0
 
LVL 39

Expert Comment

by:stevbe
Comment Utility
JD ... I know this would end up being time consuming but how about paring this post down to the necessaries and perhaps doing an occasional sanity check to remove posts for the linked questions that have been closed?

I almost hated making this post :-)

Steve


Steve,

  Even though deleted, comments are still considered part of the thread and there is some overhead associated with them being there, even though not visible.  Probably would decrease download time though for most (PE's, Mod's, and Admin's still see them).

  However I have always opted for the simpler approach; don't have the posts in the first place.   If we allowed this to be a free flowing discussion among experts, it would be at the very least a daily chore to shorten it up.  I'd rather spend what little free time I have answering questions (which over the past two years has been almost nil), rather then doing grunt work.

  Overall, the approach taken has worked pretty well over the past few years and has only gotten out of hand a couple of times.   In fact, it's worked so well that most TA's now have an alert thread running.

  For general discussions, there is nothing saying that we can't prefix question titles (ie. Expert Discussion - What's going on today?) and have a bunch of independent threads.  But those are problematic too because you have the issue of points getting passed around and the disccusions are not private.  Something I am hoping they have addressed with the new site.

JimD.
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
http://www.experts-exchange.com/Databases/MS_Access/Q_22051637.html

I have the basic function coded for him, but have just been slammed at work and don't have time to get him through the rest of the steps on setting up the button.
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
Can any one help here.  I can't understand his logic.

http://www.experts-exchange.com/Databases/MS_Access/Q_22054705.html#a17981294
0
 
LVL 54

Expert Comment

by:nico5038
Comment Utility
I stopped but this one still needs help: http://www.experts-exchange.com/Databases/MS_Access/Q_22042432.html

Nic;o)
0
 
LVL 84
Comment Utility
Problems with performance after moving to an SBS server: http://www.experts-exchange.com/Databases/MS_Access/Q_22071992.html#a18012879
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
http://www.experts-exchange.com/Databases/MS_Access/Q_22076581.html

Basically he'll need a table that holds all the months, then loop through by month to get the results by group and write it to a "results" table.  I'm too busy to write code today, and I'll be out till Monday. If anyone want to take it on, feel free. Otherwise I'll write something up Monday.  

Thanks!!
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
Help needed here, print issue with runtime

http://www.experts-exchange.com/Databases/MS_Access/Q_22086171.html

Anyone with any ideas?
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
Any idea how

  SELECT TOP 1000 *
  FROM Table

where Table does include a unique ID, can return all 12000 records ?

http://www.experts-exchange.com/Databases/MS_Access/Q_22084552.html

Questioneer is a novice but my fantasy has reached a limit.

/gustav
0
 
LVL 58

Expert Comment

by:harfang
Comment Utility
Title: Change Order of Groups (Favorites etc)
http:/Q_22092975.html

Anybody knows of a hack for that one?
(°v°)
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
Need some help here.  Harfang, I think your Not Exists Subquery might do it but I'm having a bad day!

http://www.experts-exchange.com/Databases/MS_Access/Q_22091240.html
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
can the Access people take a look at this one, please:
http://www.experts-exchange.com/Databases/MS_Access/Q_22094950.html
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
0
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
http://www.experts-exchange.com/Databases/MS_Access/Q_22102099.html#a18205212

I can't work out what the Q is - perhaps someoone else will be more in tune with the questionner.
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
0
 
LVL 92

Expert Comment

by:Patrick Matthews
Comment Utility
Experts,

Looking at:
http://www.experts-exchange.com/Databases/MS_Access/Q_22113716.html
http://www.experts-exchange.com/Databases/MS_Access/Q_22113718.html
...

1) Should one of these Qs get purged?
2) Am I going at the structure the right way, or am I all wet?

Regards,

Patrick
0
 
LVL 92

Expert Comment

by:Patrick Matthews
Comment Utility
Netminder wrote:
> They appear (at a glance) to be different questions (one is about structure, the other is about
> a process), so I'm inclined to let them ride, but if either of the Jims feels differently, I'll defer to them.

Cool.

Thanks,

Patrick
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
I need some help over here.  The guy has a deadline and I have to leave for the rest of the day.

http://www.experts-exchange.com/Databases/MS_Access/Q_22118326.html
0
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
http://www.experts-exchange.com/Databases/MS_Access/Q_22134934.html#a18387698

Needs help with T_Sql syntax being used in Access.



0
 
LVL 58

Expert Comment

by:harfang
Comment Utility
For Experts: SQL And Or VB And Or ... {http:/Q_22135795.html}
(^v°)
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 58

Expert Comment

by:harfang
Comment Utility
Not enough experience for this one:

NEED better query for paging purposes {http:/Q_22146391.html}
(Trying to create a SELECT LIMIT query with reasonable speed: Access + MSSQL)
0
 
LVL 34

Expert Comment

by:jefftwilley
Comment Utility
Could use a few fresh ideas on this one.
Trying to use Conditional format on continuous forms
http://www.experts-exchange.com/Databases/MS_Access/Q_22141791.html
0
 
LVL 92

Expert Comment

by:Patrick Matthews
Comment Utility
Having trouble explaining the concept of abstracting repeated tasks into separate subs/functions.

http://www.experts-exchange.com/Databases/MS_Access/Q_22153373.html

The heavy lifting is done :)

Patrick
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
What's that with the "new" site:

http://www-new.experts-exchange.com/Microsoft/Development/MS_Access/viewOpenZoneQuestions.jsp?taid=39&loqOrderBy=null&loqSort=null

I can't find no way to browse for further open questions with IE 7.0.
Also, it appears much slower than the old page and cluttered with all sorts of stuff. Where is the progress - or am I getting old?

/gustav
0
 
LVL 58

Expert Comment

by:harfang
Comment Utility
Gustav,

First thing, switch to "expert skin" (link at upper right under "view my profile"). Much better layout and pages load about 10 times faster (that's no exageration).

As for the missing navigation links (after Page: at the bottom), you should post at EE Bugs {http:/Community_Support/EE_Bugs/}, although it's probably covered already. Perhaps linked to the silly double frame repeating "Questions Awaiting Answers: ..."

(°v°)
0
 
LVL 58

Expert Comment

by:harfang
Comment Utility
BUG report created: {http:/Community_Support/EE_Bugs/Q_22157981.html}
(°v°)
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
Thanks!
I should add that I had chosen the "Expert" skin but I still find this terrible cluttered.
It is a general misunderstanding that sites should be smart, rich and fancy. A good site is fast; everything else comes second.

/gustav
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
ditto!
0
 
LVL 34

Expert Comment

by:jefftwilley
Comment Utility
This one's beyond me
Looking for a reason why he can't use an aggregate select query to update a field in a table.
http://www.experts-exchange.com/Databases/Q_22310643.html

0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
0
 
LVL 58

Expert Comment

by:harfang
Comment Utility
My latest "expert question":

Internal representation of pre-20th century dates... what do you think of this one?
http:/Q_22411487.html

(°v°)
0
 
LVL 58

Expert Comment

by:harfang
Comment Utility
I gave a Jet-SQL answer to a MS-SQL question. Can someone look over my syntax? (uses suqueries and Exists)

MS SQL - Help With Query {http:/Q_22411016.html}

(°v°)
0
 
LVL 34

Expert Comment

by:jefftwilley
Comment Utility
0
 
LVL 34

Expert Comment

by:jefftwilley
Comment Utility
This question raises an interesting On Error Syntax question that some of you have already participated in. It's a Luke Special.

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22421541.html
0
 
LVL 39

Expert Comment

by:stevbe
Comment Utility
Do I get in trouble if I post a pointer to my own Q :-)
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22433474.html
0
 
LVL 34

Expert Comment

by:jefftwilley
Comment Utility
This one sounds like a Harfang special....

cancelling a spooled output that's taking too long....programatically

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_22439939.html
0
 
LVL 4

Expert Comment

by:billcute
Comment Utility
To all,
Hmmm...Interesting...
Take a look at this...
http://www.thescripts.com/forum/threadnav281570-1-10.html
Bill
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
Download mdb from page via FrontPage Extensions?
I don't know how:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22426624.html

/gustav
0
 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
Hi Bill

This question is for established Experts who answer Access questions all the time, and is not intended for askers to advertise their own questions.

I see you have created a question in CS, let's keep all conversation there.

Thanks.
-Jim
0
 
LVL 92

Expert Comment

by:Patrick Matthews
Comment Utility
Experts,

Here is a suggestion that we started in the Excel zone: when someone starts
a "congratulations question", post a link to it here in the "Experts notify"
thread.  I am sure I have missed threads to congratulate our fellow Experts
here simply because the high volume of questions in Access can bury the
congrats questions in a day or two.

Cheers,

Patrick
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
This user needs help embedding an 18 sheet workbook containing charts and table into designated areas of a Word document - I imagine using bookmarks?  Not my cup of tea!

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22094376.html
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 0 total points
Comment Utility

  Well this thread is starting to get a bit long, so here's the link to the new pointer question:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22450024.html

  Please make sure you only subscribe to the question; no need to post a comment.

Thanks,
Jim Dettman
MS Access PE
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
Opinion on Lookup fields in a table?  I say no but...

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22454631.html
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
ADO Problem with unbound form in Access 2007

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23232337.html

/gustav

PS: Q_22450024.html has been deleted.
0
 
LVL 27

Expert Comment

by:jjafferr
Comment Utility
gustav,
this post is closed, the other live post is:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22924086.html

jaffer
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now