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
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
dannywareham
<<bookmark>>
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
"Normal members should not post comments here"
....the only remaining presumption is that Experts are not "normal".
-j-
....the only remaining presumption is that Experts are not "normal".
-j-
Thanks JD. Welcome back other JD.
Change App.Caption in ADP Project
https://www.experts-exchange.com/questions/22063572/MS-Access-2003-Changing-the-Captiopn-bar-text.html
{Either this is something adp-specific, which I haven't done before, or the asker is somewhat clueless, or both}
https://www.experts-exchange.com/questions/22063572/MS-Access-2003-Changing-the-Captiopn-bar-text.html
{Either this is something adp-specific, which I haven't done before, or the asker is somewhat clueless, or both}
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.
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.
https://www.experts-exchange.com/questions/22051637/Help-with-formula-to-populate-list-box.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.
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.
Can any one help here. I can't understand his logic.
https://www.experts-exchange.com/questions/22054705/add-series-of-date-to-table-in-three-part-with-differnt-value-with-differnt-rules.html?anchorAnswerId=17981294#a17981294
https://www.experts-exchange.com/questions/22054705/add-series-of-date-to-table-in-three-part-with-differnt-value-with-differnt-rules.html?anchorAnswerId=17981294#a17981294
I stopped but this one still needs help: https://www.experts-exchange.com/questions/22042432/how-to-build-small-access-database-that-takes-input-from-a-web-form.html
Nic;o)
Nic;o)
Problems with performance after moving to an SBS server: https://www.experts-exchange.com/questions/22071992/Moving-an-MDB-from-one-server-to-another-slowness-and-crashing-help.html?anchorAnswerId=18012879#a18012879
https://www.experts-exchange.com/questions/22076581/Query-JOIN-issue.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!!
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!!
Help needed here, print issue with runtime
https://www.experts-exchange.com/questions/22086171/Access-Form-Will-Print-Preview-but-not-Print.html
Anyone with any ideas?
https://www.experts-exchange.com/questions/22086171/Access-Form-Will-Print-Preview-but-not-Print.html
Anyone with any ideas?
Help! Over my Head in Hyperlinks:
https://www.experts-exchange.com/questions/22088105/Unable-to-open-hyperlinked-file-message.html?anchorAnswerId=18110297#a18110297
https://www.experts-exchange.com/questions/22088105/Unable-to-open-hyperlinked-file-message.html?anchorAnswerId=18110297#a18110297
Any idea how
SELECT TOP 1000 *
FROM Table
where Table does include a unique ID, can return all 12000 records ?
https://www.experts-exchange.com/questions/22084552/Randomly-pick-a-group-of-names.html
Questioneer is a novice but my fantasy has reached a limit.
/gustav
SELECT TOP 1000 *
FROM Table
where Table does include a unique ID, can return all 12000 records ?
https://www.experts-exchange.com/questions/22084552/Randomly-pick-a-group-of-names.html
Questioneer is a novice but my fantasy has reached a limit.
/gustav
Title: Change Order of Groups (Favorites etc)
http:/Q_22092975.html
Anybody knows of a hack for that one?
(°v°)
http:/Q_22092975.html
Anybody knows of a hack for that one?
(°v°)
Need some help here. Harfang, I think your Not Exists Subquery might do it but I'm having a bad day!
https://www.experts-exchange.com/questions/22091240/Function-in-Query.html
https://www.experts-exchange.com/questions/22091240/Function-in-Query.html
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
can the Access people take a look at this one, please:
https://www.experts-exchange.com/questions/22094950/MS-Access-dynamically-programatically-creating-Pivot-Charts-using-Office-Chart-component.html
https://www.experts-exchange.com/questions/22094950/MS-Access-dynamically-programatically-creating-Pivot-Charts-using-Office-Chart-component.html
https://www.experts-exchange.com/questions/22103620/Generating-a-report-containing-a-random-10-of-all-records-Access-ADP-project.html?anchorAnswerId=18205246#a18205246 - some help in passing parameters in ADP?
https://www.experts-exchange.com/questions/22102099/Multiple-calculations-in-Listbox.html?anchorAnswerId=18205212#a18205212
I can't work out what the Q is - perhaps someoone else will be more in tune with the questionner.
I can't work out what the Q is - perhaps someoone else will be more in tune with the questionner.
Not sure about this, can anyone help?
https://www.experts-exchange.com/questions/22107130/About-use-custom-paper-size-when-distribute.html
https://www.experts-exchange.com/questions/22107130/About-use-custom-paper-size-when-distribute.html
Experts,
Looking at:
https://www.experts-exchange.com/questions/22113716/Display-Text-instead-of-id-field-in-form.html
https://www.experts-exchange.com/questions/22113718/Organizing-data-into-tables-in-Access.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
Looking at:
https://www.experts-exchange.com/questions/22113716/Display-Text-instead-of-id-field-in-form.html
https://www.experts-exchange.com/questions/22113718/Organizing-data-into-tables-in-Access.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
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
> 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
I need some help over here. The guy has a deadline and I have to leave for the rest of the day.
https://www.experts-exchange.com/questions/22118326/Date-range-for-report.html
https://www.experts-exchange.com/questions/22118326/Date-range-for-report.html
https://www.experts-exchange.com/questions/22134934/Missing-Right-Parenthesis.html?anchorAnswerId=18387698#a18387698
Needs help with T_Sql syntax being used in Access.
Needs help with T_Sql syntax being used in Access.
For Experts: SQL And Or VB And Or ... {http:/Q_22135795.html}
(^v°)
(^v°)
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)
NEED better query for paging purposes {http:/Q_22146391.html}
(Trying to create a SELECT LIMIT query with reasonable speed: Access + MSSQL)
Could use a few fresh ideas on this one.
Trying to use Conditional format on continuous forms
https://www.experts-exchange.com/questions/22141791/Format-Highlight-field-depending-highest-value.html
Trying to use Conditional format on continuous forms
https://www.experts-exchange.com/questions/22141791/Format-Highlight-field-depending-highest-value.html
Having trouble explaining the concept of abstracting repeated tasks into separate subs/functions.
https://www.experts-exchange.com/questions/22153373/Transfer-Spreadsheet-and-make-workbook-protected-after-transfer.html
The heavy lifting is done :)
Patrick
https://www.experts-exchange.com/questions/22153373/Transfer-Spreadsheet-and-make-workbook-protected-after-transfer.html
The heavy lifting is done :)
Patrick
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
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
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°)
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°)
BUG report created: {http:/Community_Support/EE_Bugs/Q_22157981.html}
(°v°)
(°v°)
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
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
ditto!
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.
https://www.experts-exchange.com/questions/22310643/Access2003-Updating-a-table-from-a-Totals-query.html
Looking for a reason why he can't use an aggregate select query to update a field in a table.
https://www.experts-exchange.com/questions/22310643/Access2003-Updating-a-table-from-a-Totals-query.html
Access 97: Problem with the built-in menu
https://www.experts-exchange.com/questions/22163083/Menu-bar-in-customize-missing.html
https://www.experts-exchange.com/questions/22163083/Menu-bar-in-customize-missing.html
My latest "expert question":
Internal representation of pre-20th century dates... what do you think of this one?
http:/Q_22411487.html
(°v°)
Internal representation of pre-20th century dates... what do you think of this one?
http:/Q_22411487.html
(°v°)
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°)
MS SQL - Help With Query {http:/Q_22411016.html}
(°v°)
One for the SQL experts here.
https://www.experts-exchange.com/questions/22401459/How-do-i-get-the-first-last-or-top-10-records-for-each-one.html
https://www.experts-exchange.com/questions/22401459/How-do-i-get-the-first-last-or-top-10-records-for-each-one.html
This question raises an interesting On Error Syntax question that some of you have already participated in. It's a Luke Special.
https://www.experts-exchange.com/questions/22421541/On-Error-statement-syntax.html
https://www.experts-exchange.com/questions/22421541/On-Error-statement-syntax.html
Do I get in trouble if I post a pointer to my own Q :-)
https://www.experts-exchange.com/questions/22433474/Access-2003-Unbound-lookups.html
https://www.experts-exchange.com/questions/22433474/Access-2003-Unbound-lookups.html
This one sounds like a Harfang special....
cancelling a spooled output that's taking too long....programatically
https://www.experts-exchange.com/questions/22439939/Trap-PrintOut-Action-was-Canceled.html
cancelling a spooled output that's taking too long....programatically
https://www.experts-exchange.com/questions/22439939/Trap-PrintOut-Action-was-Canceled.html
To all,
Hmmm...Interesting...
Take a look at this...
http://www.thescripts.com/forum/threadnav281570-1-10.html
Bill
Hmmm...Interesting...
Take a look at this...
http://www.thescripts.com/forum/threadnav281570-1-10.html
Bill
Download mdb from page via FrontPage Extensions?
I don't know how:
https://www.experts-exchange.com/questions/22426624/Import-on-line-database-in-Access-2003.html
/gustav
I don't know how:
https://www.experts-exchange.com/questions/22426624/Import-on-line-database-in-Access-2003.html
/gustav
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
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
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
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
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!
https://www.experts-exchange.com/questions/22094376/From-Access-to-Excel-to-Word.html
https://www.experts-exchange.com/questions/22094376/From-Access-to-Excel-to-Word.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Opinion on Lookup fields in a table? I say no but...
https://www.experts-exchange.com/questions/22454631/Best-approach-to-using-multiple-versions-of-the-same-field-that-is-a-Lookup-Field-instead-of-creating-new-tables.html
https://www.experts-exchange.com/questions/22454631/Best-approach-to-using-multiple-versions-of-the-same-field-that-is-a-Lookup-Field-instead-of-creating-new-tables.html
ADO Problem with unbound form in Access 2007
https://www.experts-exchange.com/questions/23232337/ADO-Problem-with-unbound-form-in-Access-2007.html
/gustav
PS: Q_22450024.html has been deleted.
https://www.experts-exchange.com/questions/23232337/ADO-Problem-with-unbound-form-in-Access-2007.html
/gustav
PS: Q_22450024.html has been deleted.
gustav,
this post is closed, the other live post is:
https://www.experts-exchange.com/questions/22924086/Expert-Notify-Thread-For-Experts-only-those-answering-questions-in-the-MS-Access-Zone.html
jaffer
this post is closed, the other live post is:
https://www.experts-exchange.com/questions/22924086/Expert-Notify-Thread-For-Experts-only-those-answering-questions-in-the-MS-Access-Zone.html
jaffer