asked on

Expert Notify Question

Hi Everyone,

This "question" is for the Experts in the MS Access TA. The idea behind it is to allow an easy means of getting other Experts and the TA PE to look at something or discuss something.

It's a "notify* question in the sense that you only *subscribe* to the question, but *don't* post any comments. When one of us wants to communicate with the others, post a new comment that might look something like this:

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

"Member xyz needs help. Please see

<link>

Jim Dettman
Expert MS Access TA"

All of us will then receive an e-mail and can click on the link to find out what needs to be done or talked about. Please do *not* post comments in this notify question. I've created one link so you can see what I'm talking about.

Feel free to use this to talk about any Expert issues or items that are specific to the MS Access TA. 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

Jim Dettman (EE MVE)

ASKER

Please see:

Expert Topic - Sample link for Expert Notify question

https://www.experts-exchange.com/questions/20917685/Expert-Topic-Sample-link-for-Expert-Notify-question.html

Jim Dettman
MS Access PE

Jim Dettman (EE MVE)

ASKER

Fellow Experts,

We have a couple of memebers that need help in getting a question answered. This is a 500 pointer. Please see:

Problems with Graph in a WebPage created in Access
https://www.experts-exchange.com/questions/20863067/Problems-with-Graph-in-a-WebPage-created-in-Access.html#10611912

Jim Dettman
MS Access PE

jadedata

Boys and Girls:

New Wizard, .. Let's give it up a little.
https://www.experts-exchange.com/questions/20922247/Attention-Experts-New-Wizard-on-the-Block.html

jadedata
MS Access As a Hobby

perkc

Help Anyone?

https://www.experts-exchange.com/questions/20922076/Open-Access-from-Excel.html

I don't have Access XP so I can't duplicate Alicia's problem.

perkc

Jeremyw

Good morning all:

I don't have Access 97 and LakshmanaRavula has a few issues that aren't working.

https://www.experts-exchange.com/questions/20921207/How-to-change-certain-properties-of-an-excel-cell-programatically.html

Thanks,

Jeremy

perkc

Anyone have a suggestion?

https://www.experts-exchange.com/questions/20925305/Set-Timer-on-Msg-Box.html

perkc

Jim Dettman (EE MVE)

ASKER

Hi Guys,

Just wanted to let everyone know that I've been very scarce of late because my mom's been in the hospital. I haven't had much of a chance to do anything and even when I do, I'm limited by a poor dialup connection.

I expect she’ll be in for several more days, so I probably won’t surface until the end of next week.

Take care everyone,
Jim.

jadedata

jim: We all wish your mom better. Take care of business until then. All the best til then. -j-

=======================================
Thanks very much. Well keep everyone updated.

BTW, aplogies to everyone for not starting a seperate question on this (I should have).

Jim.

jadedata

Boys and Girls:

New Wizard, .. Let's give it up a little.
https://www.experts-exchange.com/questions/20927255/Attention-Experts-New-Wizard-on-the-Block.html

jadedata
MS Access As a Hobby

Steve Bink

https://www.experts-exchange.com/questions/20929020/VBA.html

Why would Access say an UPDATE SQL statement is not an updateable query?

Jim Dettman (EE MVE)

ASKER

Just thought I'd pass this one along:

https://www.experts-exchange.com/questions/20860014/Date-format-problem-when-merging-with-Word.html#10686007

read the last comment.

This shows exactly why EE is what it is.

Jim Dettman
MS Access PE

perkc

I actually need help on this one. Any takers?

https://www.experts-exchange.com/questions/20933968/Automate-the-creation-of-an-Excel-file-With-Command-Buttons-Code-From-Access.html

Thanks,

perkc

peter57r

Anyone assist here?

https://www.experts-exchange.com/questions/20937297/Using-Inventory-transactions-to-create-a-history-of-inventory-levels.html

Pete

walterecook

Pete, Jack seems to be on the case.
This one could use an assist too, please.
https://www.experts-exchange.com/questions/20932143/Run-a-module-in-Access-to-run-a-macro-in-excel.html

Walt

jadedata

hey, I'm proud to split points with this crowd any day of the week!!

Steve Bink

The questioner needs a full-text search engine in Access. I have no clue. :) I probably could get something working with just one keyword, but somehow I'm pretty sure this is going to get ALOT more complicated.

https://www.experts-exchange.com/questions/20936266/Random-Response-Database.html

Jim Dettman (EE MVE)

ASKER

This looks like a tough one:

https://www.experts-exchange.com/questions/20935367/Data-Access-Pages-required-to-be-on-Trusted-Site-list.html

and I don't know the answer as I don't do any web work. It involves DAP pages and security. Can everyone have a look please?

Jim

walterecook

I could use some help with this one, please.
https://www.experts-exchange.com/questions/20943765/Filtering-thru-Data-Files.html

jadedata

geekboysteves is in SERIOUS need of some ideas...
FMS Inc Memo Control, special handling!!
https://www.experts-exchange.com/questions/20947313/Return-Height-of-a-CanGrow-Textbox-at-Runtime-Access-2000.html

Bon Chance.

Steve Bink

Can someone please help this guy out? It's a very complex query, and I just can't seem to get a handle on what he needs.

https://www.experts-exchange.com/questions/20936436/Using-'OR'-in-query-fields.html

nexusnation

Checking in...

Andrew

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Andrew,

Please do not post comments on this question unless you have a link to a problem question or another question thread to point to.

We want to try and keep this meaningfull. If everyone starts posting general comments, then we end up with a lot of notify e-mails that mean nothing and then folks start ignoring them (this is what happened in the PE TA).

Everyone else keep in mind that you don't need to post a comment in order to subscribe to a question.

Jim Dettman
MS Access PE.

BillPowell

Im out of ideas on this one regarding reports spontaneously changing sizes:

https://www.experts-exchange.com/questions/20949435/Paper-Size-keeps-changing-in-Page-Setup.html

Jim Dettman (EE MVE)

ASKER

Hi All,

This one is a repost:

https://www.experts-exchange.com/questions/20943765/Filtering-thru-Data-Files.html

I've had an off-line conversation Lady Dev and posted the results of that and I think we can move foreward now on this one. Everyone please have a look at it.

I picked it up thinking I could handle it, but it's dragged out and my mom's heading for surgery on wed (I'm leaving for Buffalo tomorrow), so I'll be absent again for a few days and I'm not sure that I'd be able to complete this.

Plus I'm certainly not an expert on the treeview control by any strech having used it only twice<g>

Last item, within the next week I will be starting up some converstations on some Expert do's and don'ts. I'll be looking foreward to everyones input on these topics as they affect us all. The end result will be a mini-training manual for new Experts. Some of this is already on the help pages, but I don't think it will hurt to talk about some issues that have come up recently.

Hope all of you are doing well and enjoyed the Easter Holiday.

Jim Dettman
MS Access PE

walterecook

I'll be passing on that one JD. AW and I tried to answer her poorly stated goals and she got pissy with us.

But I thank you for the assist.

-------------------------------------------------------------------------------------
Walter

I think the goals are now a little more clearly stated. I also think there is a little more understanding on the part of LadyDev that it's not quite so clear on the Expert side of what someone is asking for in all cases.

I hope that we can convince her that EE is worth it.

Jim.

Arthur_Wood

walter - I am choosing to stay out of that one.

=============================================

Can understand that. There is a lot she wants to accomplish. I don't thin the whole thing needs to be handled under that one question, but at least we need to get here started.

I plan to work on it latter (time allowing).

Jim.

jadedata

Jim: (Q_20943765.html) that one is a 500 pointer. That is gonna be one of those "all day suckers" again, even tho it was for walt and aw once already.

===================================================================

Understood. I'll start picking away at it a little latter if I have time.

Jim.

jadedata

EVERYONE ONE THIS ONE!!!
IF I DON'T SEE YOU POSTED YOU'LL BE HEARING FROM ME!
https://www.experts-exchange.com/questions/20953012/TWO-MILLIONAIRE-Why-do-you-like-being-an-Access-Expert.html

Jim Dettman (EE MVE)

ASKER

All right, time to move foreward now that we can all comunicate fairly well. Please see:

Some Expert Topics for discussion.

https://www.experts-exchange.com/questions/20966864/Some-Expert-Topics-for-discussion.html

Thoughts, comments and anything else welcome! Just keep it civial<g>. Remember, all members will be able to see the thread.

Jim Dettman
MS Access PE

nico5038

Subscribing, looks like I missed a lot of fun already :-)

Nic;o)

Alan Warren

Expert Topic - Question: Code to update an attendance table.
https://www.experts-exchange.com/questions/20956032/Code-to-update-an-attendance-table.html
Note - this question has long history.

Bit stuck for time at the moment for this one, started with all good intentions, it's one of those roll-over questions, the guy is polite and patient, recognises the scope increase, but it is becoming more of a job than a question. I'm thinking that the entire logic needs to be re-thunk.

Alan

ps. Glad to see you back on deck Jim.

jadedata

Graphics consultant needed:
https://www.experts-exchange.com/questions/20959531/Access-thumbnails.html#10883713

flavo

Not sure if anyone else noticed but capricorn1 has reached Sage level today (9:47 Aust EST).

https://www.experts-exchange.com/Databases/MS_Access/viewTAPoints.jsp?mid=597073

Totals on the side of the page haven't updated yet.

Congratulations Cap! Helped me on many occasions!

Hope this is now the right place for this...

Dave!

nico5038

Well noticed Dave, do you post a "Congrats question" in the topic area ?

Nic;o)

flavo

I was going to but after Jack's { https://www.experts-exchange.com/questions/20953012/TWO-MILLIONAIRE-Why-do-you-like-being-an-Access-Expert.html } didnt really want to get on the "bad side" of the mods....

Dave

nico5038

OK, then I'll take the heath <LOL>

Nic;o)

Mighty_Silly

Hi there EE gang,

Plz take a look at this... I can't quite get what the poster wants. Was going to make the Nico suggestion of QBF, but thought best to have Nico do it in "person".

Thanks much, I've expanded my Access knowledge much from here.
I know JDettman sez not to use this as conversational... but if anyone knows where Shane is, plz email me... Email in profile.

https://www.experts-exchange.com/questions/20968202/First-visible-row-in-form-property.html#10929441

-Silly-

Steve Bink

Hey guys. This is probably just something way stupid that I'm not seeing:

https://www.experts-exchange.com/questions/20969282/need-code-to-search-a-sub-form-from-main-form.html

The routine works...at least, it works for me! The questioner, however, is being told by Access that he cannot set the filter on the main form.

Steve Bink

DOH! nm....refreshed the question, and saw he found the problem.

Jim Dettman (EE MVE)

ASKER

Hi All!

Hope life is well. Have an Access/ASP question that needs to be looked at. Ian contacted me off-line via e-mail concerning his question.

https://www.experts-exchange.com/questions/20969790/Database-Viewing-Results-incorrectly-please-help.html

Jim.

walterecook

I just got called into a meeting for the rest of the day. Gotta call in the cavalry.
https://www.experts-exchange.com/questions/20969714/ComboBoxes-on-Form.html
(no slight to capricorn but he appears busy too)

Thanks

jadedata

oops :)

Steve Bink

https://www.experts-exchange.com/questions/20969358/Still-a-problem.html

I don't see a way to do it through an single SQL statement, and I do not have the time this week to dedicate to coding a sub for him.

Jim Dettman (EE MVE)

ASKER

This question should not have been closed and it certainly does not belong in the PAQ's as it's meant strictly as a notification method for getting Experts attention.

Plus, I want my points back. It shouldn't cost me question points to do my job as a PE.

Please re-open this question. If that can't be done, then I'll open a new notify thread.

Jim Dettman
MS Access PE.

jadedata

speaking of input... a reminder:
https://www.experts-exchange.com/questions/20966864/Some-Expert-Topics-for-discussion.html
This question and your input to it are important to the TA at large, and all of us really do want to know where you are on these issues.
Especially if you DONT agree with me. :) This is your TA too. Lets hear it.
Free soap-boxes at the door!
-jadedata-

peter57r

Any Delphi specialists out there? Help required with ODBC from Delphi to Jet.

https://www.experts-exchange.com/questions/20987912/ODBC-problem.html#11074782

Pete

Mighty_Silly

Hi gang,

Plz take a look at this post:
https://www.experts-exchange.com/questions/20992152/Poor-performance-on-queries-when-running-Access-97-on-Windows-XP-with-MySQL-back-end.html

I'm pretty involved w/ my own app lately.

Thanks,
-Silly-

Mighty_Silly

Nic;o),

You in today?

This guy needs help...

https://www.experts-exchange.com/questions/21018004/Crosstab-Query-Report.html
(he specifically called you out in the post. tho I guess anyone here could help him... I'm a bit tied up at the moment.)

-Silly-

walterecook

I too got a bit tied up
https://www.experts-exchange.com/questions/21017933/Combo-Box-on-Subfrom-not-choosing-correctly.html

Mighty_Silly

Are we still using this as an S.O.S post ?

Need help here:

Use a form to prompt user for crosstab query column values
https://www.experts-exchange.com/questions/21021343/Use-a-form-to-prompt-user-for-crosstab-query-column-values.html#11285075

-Silly-

phileoca

Hey guys, someone help me out with this user. he butchered some code and i'm trying to help him as much as i can. I already fixed his table and field name issues, and, well you'll see. His most up to date code is on the bottom.

and meanwhile, all i need is 5pts to get my first certification. ^^
https://www.experts-exchange.com/questions/21026482/Email-code-problems.html

phileoca

Expert, please see question:

https://www.experts-exchange.com/questions/21038306/How-to-show-a-sub-form-only-if.html

Mourdekai

GrayL and I have been working on this one for about a week. It seems like something simple, but I'm out of ideas. Wroan keeps getting a 'openform action was cancelled' error. We just need a new set of eyes to tackle this problem.

https://www.experts-exchange.com/questions/21053641/open-a-form-from-a-list-box.html

walterecook

Anyone wanna take a crack at this one:
https://www.experts-exchange.com/questions/21063450/requery-refresh-not-working.html

perkc

I couldn't find any documentation to help this questioner. Anyone want to help?

https://www.experts-exchange.com/questions/21067615/Document-Summary-Information-retrieval.html

perkc

nico5038

For all experts,

There's an interesting Q in the feedback TA:
https://www.experts-exchange.com/questions/21071763/Working-Congratulations-EE-and-Experts.html

EE is in the technical TOP 50 and there's a poll with EE as one of the options...

Nic;o)

JohnK813

Question Title: How do I create a "dynamic" ADODB recordset in Access?
https://www.experts-exchange.com/questions/21071340/How-do-I-create-a-dynamic-ADODB-recordset-in-Access.html

I know it's in the VB DB area, but everything's being done in Access. The asker is trying to open one of 11 reports, populate it, then email it/them to the appropriate person/people. Not extrememly difficult, but my "real" work has been keeping me from being able to put time and effort into this.

I solved his original question, and I'll be following along with the current one, so I'll be there to help, just not as much as I'd like to.

Thanks.

nico5038

Running out of thoughts, please take a look at:
https://www.experts-exchange.com/questions/21079053/Access-2003-and-Form-object.html

Nic;o)

GRayL

Can anyone help us at:
https://www.experts-exchange.com/questions/21093322/Return-part-of-a-string-in-Query.html

SidFishes

Anyone have any ideas?:

https://www.experts-exchange.com/questions/21095922/Can't-access-records-in-ADP.html

Emanon_Consulting

Expert Topic - Question Title: stLinkCriteria

https://www.experts-exchange.com/questions/21098538/stLinkCriteria.html

Can someone pop by and give a hand???
I just got told to show up to a meeting and may not be out for a while...

Thanks
Cheers
M

Steve Bink

https://www.experts-exchange.com/questions/21096963/Access-Count-query-also-need-to-concatenate-fields.html

Hey guys. Stepping a little out of my area here, and could some syntax help.

Emanon_Consulting

Question Title: How to use variable in Access Queries?

https://www.experts-exchange.com/questions/21097567/How-to-use-variable-in-Access-Queries.html

Unfortunately, I have been told to show up to another meeting here at work so I won't be available for some time. (possibly a couple of days)
They did this to me yesterday and it seems I have had another project added to my already full plate.
I don't want to leave the Questioner hanging so...

Could someone stop by and have a look - the Questioner has even made the app available for download!

Cheers
M

GRayL

Experts: Need some help over here.

https://www.experts-exchange.com/questions/21034288/Problem-with-linked-tables-data-shows-in-Access-97-as-Deleted-in-all-fields-of-all-records.html#11846206

Steve Bink

https://www.experts-exchange.com/questions/21100594/Ms-Sql-2000-Enterprise-Ms-Access-2003-Problems-Bugs.html

Questioner migrated the Access side of an ADP, and lost key values in a table stored on MSSQL. He (and I!) wants to know why...

nico5038

When there are some experts having experience with Access via Terminal Services/PcAnyWhere/GotoMyPC/etc, please checkout my question:
https://www.experts-exchange.com/questions/21097804/Terminal-Services-Citrix-or-PCAnywhere-for-remote-access.html

When there's enough information on the subject I'll turn this into an article for Jim and ofcourse will give the participants credits :-)

Nic;o)

Jim Dettman (EE MVE)

ASKER

Howdy all,

Last week I posted a message about the new EE program. As I said, I wasn't trying to exclude anyone. My only reason for starting with the top 15 is so I wouldn't get a on slought right off the bat.

So any and all experts who are interested in finding out about the new PE program and how they can contribute to EE beyond answering questions please drop me an e-mail at jimdettman'at'earthlink.net and I'll bring you up to speed about what's going on.

Jim.

walterecook

Jim
Don't worry I'll be replying
All others:
I just don't have the time right now to deal with this one. Not real hard, I'm just strapped
https://www.experts-exchange.com/questions/21103309/Queries-and-updates-forms-and-subforms.html

Thanks

JohnK813

I hate throwing in the towel, but I'm out of ideas for this one. Maybe "a fresh set of eyes" will help:

https://www.experts-exchange.com/questions/21067707/Access-link-on-Intranet-won't-open-and-hangs.html

User has an intranet site with links to several Access DBs. All DBs open OK except for one, which causes the Access process to start, but nothing else happens.

Steve Bink

Here's another one with inconsistent table updates.

https://www.experts-exchange.com/questions/21108716/Access-not-updating-SQL-table-consistently.html

walterecook

Need some help - I'm out of time.
https://www.experts-exchange.com/questions/21101518/Automatically-move-focus.html

Gracias.
Walt

Emanon_Consulting

Anyone know how to do this???
https://www.experts-exchange.com/questions/21113824/Rotating-image-90-degrees.html

I have a sample at home - just did not want the Questioner to have to wait if anyone here can help.

Cheers
M

Emanon_Consulting

Anyone work with a SQL BE and an Access FE?
https://www.experts-exchange.com/questions/21114073/Fill-List-Box-from-Combo-Box-section.html
What are we doing wrong?

Cheers
M

Nestorio

Please, take a look at this question (Data Access Pages). Thanks.

https://www.experts-exchange.com/questions/21115741/Export-Data-Access-Table-to-Excel.html

Jim Dettman (EE MVE)

ASKER

Hi All,

I have a member that is looking for help with Access/Excel import/export. I and another expert have already posted responses, but see if you want to add anything. Here's the link:

https://www.experts-exchange.com/questions/21147875/Importing-and-Exporting-data-form-MS-ACCESS-MS-EXCEL.html

Also, if your not part of the new PE program, please send an email to me at jimdettman"at"earthlink.net and I'll fill you in.

Thanks,
Jim.

GRayL

Help Folks: When I started with this one it looked rather straightforward. Right now I am stymied. I would appreciate your help.

https://www.experts-exchange.com/questions/21141311/Combine-data-from-2-fields-into-a-single-field-and-populate-a-table.html

Steve Bink

I took on more than my time will allow, I think. I'll try to keep coming back to them, but my schedule could go to crap again next week, and I'm the only one active on either:

https://www.experts-exchange.com/questions/21155584/Counting-text-entries-with-grouping-and-totals.html
https://www.experts-exchange.com/questions/21131847/create-a-report-and-export-it-to-TXT-with-some-specific-fields.html

jadedata

https://www.experts-exchange.com/questions/21164967/500-point-question-needs-more-Experts.html

SidFishes

https://www.experts-exchange.com/questions/21143076/How-to-set-up-the-size-of-popup-paremeter-windows-message-box-in-Access.html

SidFishes

Anyone do DAP's ?

https://www.experts-exchange.com/questions/21168384/DAP's-E-Fail-message-Windows-XP-ONLY.html

and thx Jack and Mi for your input in the thread from hell :)

SidFishes

problem with jpg's and xp dev edition

https://www.experts-exchange.com/questions/21181889/Problems-Showing-a-JPG.html

Steve Bink

A design-opinion question. Using a hidden form to store global values.

https://www.experts-exchange.com/questions/21233746/Best-Practice-One-Module-Multiple-Tasks-and-Forms.html

flavo

should be easy

https://www.experts-exchange.com/questions/21234382/Screen-flickers-or-a-lot-of-movement-is-seen-during-finding-a-certain-record.html

screen "flicking"

nico5038

FYI:
https://www.experts-exchange.com/questions/21241204/Thanks-for-the-great-service.html

Enjoy :-)

Nic;o)

peter57r

Help wanted here ADP/SQL server:

https://www.experts-exchange.com/questions/21242127/Write-Conflict-when-no-writing-should-be-taking-place.html#12831523

Pete

Gustav Brock

Expert Topic

I love people asking for help (re)building an entire application in one a) b) c) d) question and, at the same time, being "new to VBA". Honestly, I have neither the time nor the patience for that combination.

However, if anyone feel tempted, please visit:

https://www.experts-exchange.com/questions/21247178/DateStamp-and-Number-increment.html

/gustav

Jim Dettman (EE MVE)

ASKER

Hi All!

Just a reminder that you should not be working on databases off-line in the course of answering a question.

I was recently made aware of a situation where a member was consistently asking a question, then quickly offering up the database for the Expert to work on. Thus in effect getting an app written for free.

This goes against site guidelines. All exchanges should take place on the site. In *rare* cases, it may be required that you look at a MDB to determine the problem, but this should only be done after you having thoroughly discussed it with the questioner. In general, these situations should happen very rarely.

When it does happen, the solution should appear on the site. Under *no* circumstances should you be sending a MDB to someone and then post on the site "it's fixed". This diminishes the effectiveness of the PAQ's.

Jim Dettman
MS Access PE..

Gustav Brock

Anyone with knowledge on why short filenames appear in Access 97 running on WinXP:

https://www.experts-exchange.com/questions/21251047/Access97-on-WinXP-Get-CurrentPath.html

I have this combo running and it has always worked with long filenames as expected so I can't help George.

/gustav

Gustav Brock

I'm running out of ideas here - and have no test setup:

https://www.experts-exchange.com/questions/21254443/Inet-timing-problems.html

It's about Inet.

/gustav

nico5038

Sorry to bother you, but I found an interesting question in Community Support:
https://www.experts-exchange.com/questions/21258893/Working-Why-is-Nico5038-the-HIGHEST-RATED-expert.html

You're invited to answer the question "Why is Nico5038 the HIGHEST RATED expert?" posted by MitchellVII.

Please don't see this as an action to stop you from commenting on his questions now and in the future, as that's certainly NOT my intent ! I'm just not capable to "reach" this guy because of my "Top Expert status" that has blinded him, perhaps one of you can show him "the light".

And ofcourse all best wishes and much new Access knowledge for 2005 !

Nic;o)

nico5038

Who can help with a reconnect to MS SQL when the connection has dropped ?
https://www.experts-exchange.com/questions/21258454/How-do-I-reconnect-to-SQL-Server-in-a-adp-access-project.html

Nic;o)

Mighty_Silly

Calling all experts...

Plz lend advice to this:
https://www.experts-exchange.com/questions/21194568/Normalization-Issues-Please-help.html

Thanks!

-Silly-

Steve Bink

I hate this error...I ran into once before but can't remember how I resolved it. The questioner seems to be right on par with my level of frustration back then, too.

https://www.experts-exchange.com/questions/21262989/ADODB-Connection-error-'800a0e7a'.html

Steve Bink

Pivot Tables...How to save and restore the layout on the fly. I tried, but I have to recognize I'm in way unfamiliar territory.

https://www.experts-exchange.com/questions/21259888/MS-Access-2003-How-to-allow-a-user-to-save-their-Pivot-Table-settings-and-recall-them.html

peter57r

Would someone like to look at this 'Deletion via SQL ' question.
I thought I understood it but I don't seem to be in tune with the questioner..
There's 500 points in it!
https://www.experts-exchange.com/questions/21264240/Deleting-duplicate-records-from-a-query-created-from-three-tables.html

Pete

Gustav Brock

Any ideas to a #Error after "renaming a form" or whatever this guy did rename ...

https://www.experts-exchange.com/questions/21280147/Renamed-a-form-and-the-totals-in-the-subform-don't-work.html

/gustav

Gustav Brock

Oops - never mind - he found out!

/gustav

GRayL

Anyone with Access2000 experiece as a backend?

https://www.experts-exchange.com/questions/21276430/Dropouts-from-database.html

Steve Bink

This one needs assistance with including a custom VBS in an InstallShield deployment of their Access project.

https://www.experts-exchange.com/questions/21282243/VBA-Access-check-if-net-1-1-framework-is-installed.html

Steve Bink

This one needs to be laughed at:

https://www.experts-exchange.com/questions/21283427/500-Point-Queston-Needs-help-Just-moved-to-this-TA-this-morning.html

Gustav Brock

Looked like the normal Date() and Missing References issue - but maybe not (Access 2002):

https://www.experts-exchange.com/questions/21294395/Adding-the-Date-Function-to-Access-2002-runtime.html

/gustav

nico5038

Does someone has a copy of: http://www.officerecovery.com/access/index.htm ?

https://www.experts-exchange.com/questions/21298890/You-do-not-have-exclusive-access-to-the-database-at-this-time-shows-up-even-though-iam-the-only-person-logged-in-Ms-Access.html#13207032

Nic;o)

nico5038

Trouble with fresh installed Access 2003 version, please check:
https://www.experts-exchange.com/questions/21303431/Access-2003-Runtime-Error-When-Accessing-Code.html

Nic;o)

nico5038

Stuck with: SendObject from Access not working on Windows 98 machine. (Form required cannot be displayed)
https://www.experts-exchange.com/questions/21305230/SendObject-from-Access-not-working-on-Windows-98-machine-Form-required-cannot-be-displayed.html

Nic;o)

nico5038

RecordsetClone not completely filled when perfoming a find:
https://www.experts-exchange.com/questions/21308953/Insert-extra-time-into-event-code.html

Nic;o)

peter57r

500 points here.
https://www.experts-exchange.com/questions/21315011/Adding-a-score-to-a-group-of-records.html#13315014

I don't have the patience at the moment...

Pete

nico5038

Blank adp form after switching databases:
https://www.experts-exchange.com/questions/21315626/Opening-the-form.html

Nic;o)

nico5038

ADP project with Pivot chart trouble:
https://www.experts-exchange.com/questions/21316344/How-to-Create-Pivot-Table-Chart-form-without-Form-Controls.html

Nic;o)

nico5038

Sorry to bother you with this, but it looks like capricorn1 doesn't "cooperate" with me anymore after a discussion about a question with little knowledgebase value where he started calling me names.
I also ran into several questions where he posted similar comments as other experts without referencing to those comments and thus in violation of https://www.experts-exchange.com/help.jsp#hi242

Four requests from me to discuss this matter in the Community Support area have been ignored.

No problem for me as I can cope with this behaviour, I'm just concerned others might be suffering from this non-cooperative behaviour too so I've informed our Page Editor JDettman and only want to ask you to contact Jim when you run into the same "trouble".

Cheers and keep up the good work :-)

Nic;o)

Gustav Brock

So what names did he call you?

/gustav

nico5038

I don't think that's relevant gustav, just wanted to inform you and the other experts to contact Jim when running into a similar situation. I value the cooperation between experts highly and I'm not only sorry to see this happening, but very disappointed that he doesn't want to discuss this "off topic" in a CS question. Thus my posting here to inform the others.

Nic;o)

Gustav Brock

I know - were just looking for some fun a Monday morning ...

/gustav

dannywareham

Back to biz guys...
I have a prob on my own thread:
https://www.experts-exchange.com/questions/21315487/Database-viability-max-users-and-linked-mdbs.html

Gone a bit cold...
Any takers...?

:-)

perkc

Anyone interested in helping me with a VBA question about Outlook archiving?

https://www.experts-exchange.com/questions/21323433/Loop-through-folders-and-send-to-pst-file.html

perkc

perkc

Never mind. I figured it out.

nico5038

A97 Pivot tables not working under XP, please check:

https://www.experts-exchange.com/questions/21297840/Access-and-Pivot-Tables.html

Nic;o)

Jim Horn

NULL handling in MySQL
https://www.experts-exchange.com/questions/21340599/Data-Deleted-in-SQL.html

nico5038

Locking Access only when using Windows2000....
https://www.experts-exchange.com/questions/21340849/Opening-Access-Database-from-multiple-machines-at-the-same-time-causes-error.html

peter57r

Anybody good with ODBC problems?
https://www.experts-exchange.com/questions/21343328/MSAccess97-word2000-mailmerge-can't-use-DSNless-connection.html#13494980

Pete

Jim Horn

Access 2003 .MouseMove event, does anyone know if it is cancellable? (Last I remember it was not...)
https://www.experts-exchange.com/questions/21344504/How-to-prevent-form-from-going-to-another-record-if-rules-aren't-met.html

Jim Horn

50pt - How to price an Access development project for a small business. (Much more philosophical than technical)
https://www.experts-exchange.com/questions/21347397/Price-Question.html

SidFishes

here's a self serving post... it's not Access related (well i do parse and pass the xml in access but that's not the problem) but you folks are just so darned smart ;)

Anybody worked with openXML?

https://www.experts-exchange.com/questions/21347878/OPENXML-importing-blanks-rows.html

Jim Horn

Use InStr to reference a query.field
https://www.experts-exchange.com/questions/21345512/Little-help-on-some-Access-VB-Code-please.html#13535639

I could probably handle this myself, but am in a time crunch going from one client to another.

TIA
-Jim

nico5038

Report coding assistance:
https://www.experts-exchange.com/questions/21337346/How-can-I-put-a-continuation-footer-at-the-end-of-each-individual-column-in-a-multi-column-report.html

Nic;o)

Jim Horn

Graph9.exe not unloading and hogging 99% of CPU usage. (apparently Set object = Nothing is not doing it.)
https://www.experts-exchange.com/questions/21352912/Graph9-exe-not-unloading-and-hogging-99-of-CPU-usage.html

Gustav Brock

Would someone please help here on basics on how to create an update and an append query for tables linked from Excel?
Not difficult, but I'm running out of time:

https://www.experts-exchange.com/questions/21353617/Linked-Table-creating-problems.html#13566423

/gustav

Jim Horn

VB6 Connect to Access .mdb over the Internet
https://www.experts-exchange.com/questions/21360809/VB-6-Best-Way-to-connect-to-an-Access-MDB-file-of-the-the-internet.html

I remember one of the Access TA experts saying that they've near perfected it, I just can't remember who it was.

shanesuebsahakarn

Jim (JDettman), in case you missed my FAO Q in the TA, could you please take a look at:
https://www.experts-exchange.com/questions/21365881/Working-Hangout-TA-s.html

And anyone else who thinks that a hangout place in Access might be a good idea :)

Gustav Brock

Could someone please direct Arthur Wood to this question about blobs and pictures:

https://www.experts-exchange.com/questions/21366493/Display-RAW-BMP-Image-stored-in-a-field.html

I can't locate neither Arthur nor his homepage ...

/gustav

dannywareham

Publishing a report to word:
https://www.experts-exchange.com/questions/21341998/Publishing-to-Word-from-Access.html

Can't see any probs - could be an install error (hit a dead end)

:-)

Jim Horn

SQL Help: Select with grouping IN (SELECT...UNION SELECT), and executing from Excel VBA

https://www.experts-exchange.com/questions/21371919/UNION-query-as-a-table.html

dannywareham

Hi all
https://www.experts-exchange.com/questions/21372820/Reading-Microsoft-Project-gant-chart-from-a-Microsoft-Access-application.html
Reading FROM a gant chart into Access
(I can do the otehr way, but am having a problem with the object coding here)

peter57r

Problem running reports in A2003 after conversion from A97.
https://www.experts-exchange.com/questions/21375214/Problem-opening-a-report-after-converting-to-2003.html#13696443

Pete

Steve Bink

https://www.experts-exchange.com/questions/21375841/One-of-your-Parameters-is-invalid-when-passing-from-macro-to-query.html

ADP running a remote query using a parameter on a local form.

Gustav Brock

Someone with spare time for an intro to VBA programming from level zero?
About exporting 1 mio. records to a batch of worksheets ...

https://www.experts-exchange.com/questions/21376867/Is-there-a-way-for-Access-to-automatically-export-data-larger-than-65k-into-different-Excel-sheets.html

/gustav

dannywareham

Second ping.
Can anyone help with reading from MS Project?
https://www.experts-exchange.com/questions/21372820/Reading-Microsoft-Project-gant-chart-from-a-Microsoft-Access-application.html

Thanks

dannywareham

https://www.experts-exchange.com/questions/21261326/RunApp-issue-across-different-Office-versions.html
RunApp issue with different OS and versions.

No joy so far.
:-(

SidFishes

https://www.experts-exchange.com/questions/21387123/Calendar-control-question.html

how could something so simple be so difficult...

dannywareham

https://www.experts-exchange.com/questions/21389193/You-can't-go-to-the-specified-record-You-may-be-at-the-end-of-a-recordset-error.html

Single user db deployment problem

flavo

https://www.experts-exchange.com/questions/21396114/CreateObject-Access-Application-Object-library-feature-not-supported-when-compiling-VBA-code-in-Access-module.html

VBA code to make a mde...

Gustav Brock

Can anyone confirm for sure if signing VBA code with a digital certificate is possible or not in Access 2000?

https://www.experts-exchange.com/questions/21393203/Add-a-digital-certificate-to-an-Access-2000-project.html#13827649

/gustav

peter57r

Problem with a combo - I can't see the problem - needs fresh eyes.

https://www.experts-exchange.com/questions/21392835/Default-Combo-Box-Value-Problem.html#13842020

Pete

peter57r

500 points .... if you know about how spell checker works in Access.
https://www.experts-exchange.com/questions/21396911/Grab-updated-words.html#13849369

Pete

dannywareham

https://www.experts-exchange.com/questions/21397721/Saving-Passwords-with-ODBC-SQL-Server-linked-tables.html
Passwords on linked ODBC tables..

My solution doesn't work, and we're stuck

Thanks

Jim Horn

https://www.experts-exchange.com/questions/21402926/My-Awesome-App-Support-Powers.html
Application support issue

phileoca

Is this possible?
https://www.experts-exchange.com/questions/21402114/Active-Directory-Exchange-windows-logon-authentication.html

Jim Dettman (EE MVE)

ASKER

Member with web related question:

https://www.experts-exchange.com/questions/21403232/Run-a-report-through-access-and-save-it-in-snapshot-or-PDF-format-then-display-through-the-web.html

NOTE: I've already fore warned him that this will need to be broken down into multiple questions as it is extensive.

Jim.

Gustav Brock

Is it a well known fact that a Listbox - with a table/recordset as source - returns a ListCount of 1 even when the recordset is empty and no ColumnHeads are turned on?

https://www.experts-exchange.com/questions/21408560/ListCount-is-1-when-the-list-is-empty.html

/gustav

Bat17

I am having trouble working out quite what is happening in this Q. :-(

I suspect that a custom control is creating SQL in the background which is causing the problem but I may just have been looking at it too long and am missing something obvious

https://www.experts-exchange.com/questions/21404550/I-Need-to-add-an-IIf-statement-to-a-calculation-HELP-PLease.html#13939846

Peter

perkc

Can someone please finish helping this questioner. It should be easy points but I've got to jump on a flight to Vegas, Yay!

https://www.experts-exchange.com/questions/21415162/Increment-value-onClick.html#13945503

Thanks,

perkc

dannywareham

Any help on this one guys..

Date format from SQL back end to Access front end...

https://www.experts-exchange.com/questions/21416011/Date-Parameters.html

Jim Horn

SQL: SELECT * from one table, and select dups from all other table with common keys.
https://www.experts-exchange.com/questions/21416145/Select-portions-from-a-duplicate-query-dynaset.html

Steve Bink

Does it work? No. Did you try it? No, because it doesn't work. <sigh>

https://www.experts-exchange.com/questions/21409471/Import-excel-data.html

Jim Horn

Wow. All that for a C.

stevbe

Those are the kind of posts I find the most difficult to follow up and finish to the askers satisfaction, sometimes it is just not popssible for them to accept anything and once it goes bad in their mind there is no turning them back. I am hardly one for espousing moderation but I *try* to ectricate myself from impossib;le situations by suggesting that perhaps another Expert can help them, whether I am *right* or not I am too easily sucked in.

Steve

Jim Horn

With a question like that, I wouldn't jump in even if asked, since it appears that Routinet covered the question, and it could be construed as point hogging.

I'm interpreting this as the asker had some mental block which prevented him from implimenting Routinet's solution, as the answer wasn't 'do my work for me' enough for him, so he basically bailed on his own question with a C grade.

I don't think there would be too much problems with going to CS and requesting a grade change.

Steve Bink

Yeah, that's in process. Hogging, schmogging...SOMEBODY give that boy some help! :þ

stevbe

I am with routinet this one, somtimes there is nothing that can be done, fortunately I come across this quite rarely.

Jim Horn

... unofficial clarification...

With a question like that, I wouldn't jump in even if asked, since it appears that Routinet covered the question, and it could be construed as point hogging, and I just don't have the patience to review 57 iterations of asker Q/expert A to find the few select nuggets 'o knowledge that would lead the asker to a solution, or even worse have to hit the asker over the head over the nuggets that were but not implimented, or even worse verify that all facts stated are correct, and to ask for more facts that are needed to answer this question, <insert your own rant here>, and all for little to no points.

All of that while on somebody else's nickel.

Jim Horn

<change of subject>

I'm asking a series of questions in the Adobe Acrobat TA https://www.experts-exchange.com/Web/Graphics/Adobe_Acrobat/ surrounding the ability to create Access reports in .pdf that includes editable fields where these .pdf reports can be emailed to users, they enter data in them, email them back to me, and I import this user-edited data back into my Access database.

If anyone wants to learn how to do this, or if you already know and want to pick up some Adobe Acrobat TA expert points, feel free to monitor this TA.

-Jim

flavo

Doing cleanup and found this poor guy.. Still looking for an answer from 06-Jan

https://www.experts-exchange.com/questions/21264260/MS-Word-VBA-integration-w-Access.html

stevbe

any suggestions?
https://www.experts-exchange.com/questions/21421945/Audit-Trail-History.html

Steve Bink

This one got a little side-tracked with design theory, but I THINK he needs help with pivot construction:

https://www.experts-exchange.com/questions/21423535/Multiple-Records-as-One-Updatable-Record-in-a-Form.html

Bob Lamberson

Need some help on this one

https://www.experts-exchange.com/questions/20917681/Expert-Notify-Question.html

thanks - Bob

peter57r

Bob
That's a link to this page....

Pete

dannywareham

Bob - you've posted a link to this question

:-)

Bob Lamberson

Sorry everyone, Guess I needed help worse than I realized

it should be https://www.experts-exchange.com/questions/21433012/Progress-bar-on-form-while-query-running.html

Bob

Jim Horn

Well I was going to say 'Congrats on getting your Master certification', but perhaps some remedial training is in order. :)

Congrats on getting your Master certification Bob.

-Jim

Bob Lamberson

Thanks Jim, :) I'm always open for more training.

Bob

JohnK813

Anyone familiar with setting up a Javascript/ASP/whatever website to connect to an MS Access DB when the computer doesn't have Access installed?

http:Q_21439091.html

(Note that we've already established that the guy can't solicit work here.)

Jim Horn

Running Access reports from a VB6 .exe
https://www.experts-exchange.com/questions/21446126/Access-Runtime-throwing-Run-time-Error-429.html

Steve Bink

I showed him where the path is, but someone will have to hold his hand, I'm sure:

https://www.experts-exchange.com/questions/21448524/Does-anyone-know-of-a-address-book-that-will-share-data-with-Access-2003-and-snyc-with-a-calander-on-a-Pocket-PC.html

dannywareham

Hey guys

https://www.experts-exchange.com/questions/21449127/The-search-key-was-not-found-in-any-record-Help.html

"bumming out" (apparently) on replication syncronisation.
Any offers...?

:-)

dannywareham

Another one:
https://www.experts-exchange.com/questions/21451217/Corrupt-Database.html

Corruption (tried the usual)
Looking bad for the questionner

peter57r

https://www.experts-exchange.com/questions/21453642/Snapshot-Filename.html#14187800

500 points for automating the export of .snp files.

Pete

dannywareham

Hi all
https://www.experts-exchange.com/questions/21451345/SendKeys-to-a-minimzed-window.html

My hatred of SendKeys is blinding me to help

Sorry

:-)

Jim Horn

If anyone has experience coding in Access in the Adobe Acrobat 7 Type Library / JavaScript Object Model, I have three open questions in the 'Adobe Acrobat' TA. -Jim

GRayL

I could use some help here. Group By and Having not working ...

https://www.experts-exchange.com/questions/21447253/SQL-Statement-with-GROUP-BY-and-HAVING-not-working.html#14195784

GRayL

Networking issue with printer bins. Need help.

https://www.experts-exchange.com/questions/21457275/Changing-printer-bin-in-Access.html

peter57r

https://www.experts-exchange.com/questions/21461851/VB-HTTP-Post-Code-errors.html#14241250

500 points but you have been warned!!!

Pete

stevbe

https://www.experts-exchange.com/questions/21463978/Urgent-How-do-prevent-an-exported-Ms-Access-2003-Form-for-use-as-a-data-entry-form-html-page-on-my-Web-site-from-shutting-down-IE.html#14257170

Access form to HTML, sporadic crash ???

GRayL

User running A2003 under XP Pro and not able to see a printer. All other Office Apps OK. Help anyone.

https://www.experts-exchange.com/questions/21436861/No-printer-available-in-Access-2003.html

Scott McDaniel (EE MVE )

Recordset not updateable after upsizing 2000 to 2003 ADP:

https://www.experts-exchange.com/questions/21468402/Recordset-not-updatable-when-using-requery.html

dannywareham

https://www.experts-exchange.com/questions/21477849/Does-anyone-know-of-a-calculator-control.html

One for me - no takers yet...
Easy 500
:-)

flavo

https://www.experts-exchange.com/questions/21477630/Can-I-export-a-query-view-in-MS-Access-Project-with-tranferspreadsheet-or-transfertext.html

"Can I export a query view in MS Access Project with tranferspreadsheet or transfertext?"

ADP's

500 big ones up for grabs.

Jim Horn

If anyone has any code handy to loop through table of reports, and print each one to a pdf/snp file...
https://www.experts-exchange.com/questions/21483634/ODBC-Polling.html#14390840

Hugs and kisses.
-Jim

flavo

http:Q_21487114.html

Mail merge formatting date and time mayhems.

500 big ones.

ASKER CERTIFIED SOLUTION

flavo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dannywareham

https://www.experts-exchange.com/questions/21493800/Populating-Treeview-from-Table.html

Tree view issue
(posted on new thread too)

:-)

dannywareham

Jim

I've posted here purely to "notify" the experts.
Only RoutineT has posted on the other thread - so none of the others would get an alert mail.

:-(

GRayL

Experts: I need some help on Access Charts over here.

http:Q_21569342.html#14944635

jefftwilley

Problems Cutting and Pasting an A2007 table object. Anyone else seen this issue?

http:Q_24579576.html#a24880627

J