Solved

Expert notify thread - For Experts Only

Posted on 2006-11-16
61
647 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
ID: 17956303
<<bookmark>>
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17956370
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
ID: 17956434
"Normal members should not post comments here"

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

-j-
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 65

Expert Comment

by:Jim Horn
ID: 17956499
Thanks JD.  Welcome back other JD.
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 17965499
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
ID: 17966298
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.
ID: 17968330
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
ID: 17981522
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
ID: 17983387
I stopped but this one still needs help: http://www.experts-exchange.com/Databases/MS_Access/Q_22042432.html

Nic;o)
0
 
LVL 84
ID: 18013965
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.
ID: 18041171
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
ID: 18099765
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
ID: 18110668
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 18137428
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
ID: 18138567
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
ID: 18155496
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]
ID: 18161540
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
ID: 18205267
0
 
LVL 77

Expert Comment

by:peter57r
ID: 18206948
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
ID: 18242376
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 18261218
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
ID: 18264171
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
ID: 18294323
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
ID: 18388046
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
ID: 18391983
For Experts: SQL And Or VB And Or ... {http:/Q_22135795.html}
(^v°)
0
 
LVL 58

Expert Comment

by:harfang
ID: 18449908
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
ID: 18476108
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
ID: 18489488
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
ID: 18508715
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
ID: 18508818
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
ID: 18508892
BUG report created: {http:/Community_Support/EE_Bugs/Q_22157981.html}
(°v°)
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 18509954
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
ID: 18510026
ditto!
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18523891
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
ID: 18528574
0
 
LVL 58

Expert Comment

by:harfang
ID: 18603418
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
ID: 18607349
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
ID: 18620184
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18637739
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
ID: 18669742
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
ID: 18692439
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
ID: 18696687
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
ID: 18698654
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
ID: 18701206
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
ID: 18708994
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
ID: 18722166
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
ID: 18722230

  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
ID: 18740614
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
ID: 21894330
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
ID: 21894351
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

815 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

9 Experts available now in Live!

Get 1:1 Help Now