[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Expert notify thread - For Experts Only

Posted on 2006-11-16
61
Medium Priority
?
656 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 66

Expert Comment

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

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 85
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 52

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 143

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 93

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 93

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 93

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 52

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 52

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 52

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 66

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 93

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 58

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 52

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

650 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