[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 657
  • Last Modified:

Expert notify thread - For Experts Only

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
Jim Dettman (Microsoft MVP/ EE MVE)
Asked:
Jim Dettman (Microsoft MVP/ EE MVE)
1 Solution
 
dannywarehamCommented:
<<bookmark>>
0
 
rockiroadsCommented:
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
 
jadedataMS Access Systems CreatorCommented:
"Normal members should not post comments here"

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

-j-
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks JD.  Welcome back other JD.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
 
stevbeCommented:
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
 
Jim P.Commented:
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
 
GRayLCommented:
Can any one help here.  I can't understand his logic.

http://www.experts-exchange.com/Databases/MS_Access/Q_22054705.html#a17981294
0
 
nico5038Commented:
I stopped but this one still needs help: http://www.experts-exchange.com/Databases/MS_Access/Q_22042432.html

Nic;o)
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Problems with performance after moving to an SBS server: http://www.experts-exchange.com/Databases/MS_Access/Q_22071992.html#a18012879
0
 
Jim P.Commented:
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
 
rockiroadsCommented:
Help needed here, print issue with runtime

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

Anyone with any ideas?
0
 
mbizupCommented:
0
 
Gustav BrockCIOCommented:
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
 
harfangCommented:
Title: Change Order of Groups (Favorites etc)
http:/Q_22092975.html

Anybody knows of a hack for that one?
(°v°)
0
 
GRayLCommented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can the Access people take a look at this one, please:
http://www.experts-exchange.com/Databases/MS_Access/Q_22094950.html
0
 
GRayLCommented:
0
 
peter57rCommented:
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
 
rockiroadsCommented:
0
 
Patrick MatthewsCommented:
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
 
Patrick MatthewsCommented:
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
 
GRayLCommented:
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
 
peter57rCommented:
http://www.experts-exchange.com/Databases/MS_Access/Q_22134934.html#a18387698

Needs help with T_Sql syntax being used in Access.



0
 
harfangCommented:
For Experts: SQL And Or VB And Or ... {http:/Q_22135795.html}
(^v°)
0
 
harfangCommented:
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
 
jefftwilleyCommented:
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
 
Patrick MatthewsCommented:
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
 
Gustav BrockCIOCommented:
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
 
harfangCommented:
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
 
harfangCommented:
BUG report created: {http:/Community_Support/EE_Bugs/Q_22157981.html}
(°v°)
0
 
Gustav BrockCIOCommented:
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
 
GRayLCommented:
ditto!
0
 
jefftwilleyCommented:
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
 
mbizupCommented:
0
 
harfangCommented:
My latest "expert question":

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

(°v°)
0
 
harfangCommented:
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
 
jefftwilleyCommented:
0
 
jefftwilleyCommented:
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
 
stevbeCommented:
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
 
jefftwilleyCommented:
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
 
billcuteCommented:
To all,
Hmmm...Interesting...
Take a look at this...
http://www.thescripts.com/forum/threadnav281570-1-10.html
Bill
0
 
Gustav BrockCIOCommented:
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
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
 
Patrick MatthewsCommented:
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
 
GRayLCommented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentAuthor Commented:

  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
 
GRayLCommented:
Opinion on Lookup fields in a table?  I say no but...

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22454631.html
0
 
Gustav BrockCIOCommented:
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
 
jjafferrCommented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now