We help IT Professionals succeed at work.

Expert Notify Thread - For those answering questions in the MS Access Zones

648 Views
Last Modified: 2013-03-14
Hi Everyone,

  This "question" is for those contributing in the MS Access Zone.  If your are not contributing as an Expert, please do 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 Zone Advisor or Page Editor to look at something or discuss something.

   It is a "notify* question in the sense that you initially only *subscribe* to the question (by using the "monitor" button), 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
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
I've posted a general discussion thread for anyone interested:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24546931.html

- Miriam
Top Expert 2006

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

http:Q_24579576.html#a24880627

J
Most Valuable Expert 2014

Commented:
The guy went from an Acc BE to a SQL BE. I'm thinking he's going to have to upgrade to ADO to pull off copying BE tables.

Anyone want to throw in their $0.02. I only have about $0.01 on ADO. ;-)

Copy a SQL Server Table using VBA
https://www.experts-exchange.com/Q_24548142.html
Most Valuable Expert 2014

Commented:
I'm stumped -- the code works fine for me -- he is saying it is failing. But maybe it is a sub-form issue.


Search string with wildcards in FindFirst property
https://www.experts-exchange.com/Q_24530359.html
Most Valuable Expert 2014

Commented:
a3 and I have pretty much answered this already -- and he pretty much agrees -- but if you have a pfennig or two to throw at it......

Switching ADO Connection from SQL Server to MS Access and Back Again
https://www.experts-exchange.com/Q_24592512.html

Commented:
I asked the question but no response.  Can anyone help.

Ray

https://www.experts-exchange.com/Web_Development/Images/Q_24644068.html#a25082292
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
I'm out of ideas for this one:

https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24660597.html#a25124680

"Microsoft Office Document Imaging Viewer Control" for displaying faxes in an Access 2003 form.
"There is no object in this control".

/gustav
CERTIFIED EXPERT

Commented:
A straightforward report grouping Q, but I can't make myself understood so perhaps someone else would like to take over.
https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24668688.html
Most Valuable Expert 2014

Commented:
Here's one that should be pretty straightforward for VBA/ADO coding -- I have got to practice it -- It would be pick up data from a local Access DB and feed it into a SQL Stored Proc.

https://www.experts-exchange.com/Q_24671883.html
Most Valuable Expert 2014

Commented:
Easy import basic Excel SS into an Acc db.
https://www.experts-exchange.com/Q_24673880.html

He's doing it with 07 though so need some experts who are there. ;-)
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Author

Commented:
Question using a linked table to SQL Server DB which contains multiple languages and shows #Deleted if the primary key is included:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24661368.html
JimD.
Most Valuable Expert 2014

Commented:
The guy wants to de-normalize to export to Word. Sounds like a bad idea.

https://www.experts-exchange.com/Q_24684941.html
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Author

Commented:
anyone want to take a stab at this?  Simple enough, but I just don't have the time right now, espeically when it's clear he's not even really willing to try :(
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24690848.html
JimD.
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
This could be for JimD as I'm out of ideas:

https://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Database/Q_24717513.html

Cause of "Jet database engine cannot find the input table or query [Table Name]" Errors

/gustav
Kevin CrossChief Technology Officer
CERTIFIED EXPERT
Most Valuable Expert 2011

Commented:
Anyone want to throw thoughts in about cross tab queries:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24720615.html

M-1
Have just been commenting on Access date handling issues, but now wonder if I'm raising unnecessary concerns. Is the problem liable to rear its ugly head at all if the dates are just being used within a form filter?

https://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24729088.html?cid=1572#a25335074
Most Valuable Expert 2014

Commented:
He wants to go from Access BE to ADP. Either way he is going to have to convert from DAO to ADO. I'm not quite sure of the ConnStr formulation.

https://www.experts-exchange.com/Q_24736693.html

Thanks.
Most Valuable Expert 2014

Commented:
https://www.experts-exchange.comexperts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24725223.html

Can someone take a look at this one. I can handle the FTP stuff. But I don't have Acc07.
aikimarkSocial distance; Wear a mask; Don't touch your face; Wash your hands for 20 seconds
CERTIFIED EXPERT
Top Expert 2014

Commented:
@jimpen

re: https://www.experts-exchange.com/Q_24736693.html

As I commented in the thread, I don't think this is an MS-Access version problem.
I think the solution I offered is a step in the right direction, but he's using 2007, and I'm not.

https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24740614.html#a25388677
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Author

Commented:
Hopefully someone is using Access 2007 and can help out with this. Guy is building an assets database and I suggested some changes to his asset movement file. He's trying to finish this app up and is a bit lost when it comes to doing things in code.
Seems like he is more then willing to try and do things, but he's really stuck. However without A2007, were doing a lot of back and form because I can't see all his field/control names.
What he needs to do is write a little code in the BeforeUpdate event of his main asset form. On that form, he has a combo to select the assets location. What needs to happen is if the location is changed, he needs to write a record out to a historical transaction table, which records some specifics about the move. That record also needs to be linked to the prior move as when looking at a move, he wants to see a from / to display.
he also has another unbound transactional type form where the same piece of code is needed. Maybe even call this second form from frmAssets when a location change is detected. He would need a popup form anyway from frmAssets to collect some of the data required to write the move records.
I have no hesitations about trying to continue to work with him, but he is under a bit of a dead line and I can feel the frustration level picking up.
I'm hoping someone else can jump in and speed up the process a bit for him.

https://www.experts-exchange.com/Microsoft/Development/MS_Access//Q_24769935.html?cid=1330#a25452437 
JimD.
Kevin CrossChief Technology Officer
CERTIFIED EXPERT
Most Valuable Expert 2011

Commented:
Jim,

Posted in the Q some instructions to user to get the file (hopefully) converted, so you can keep helping, but also how to get uploaded.  If I am around when it is uploaded, my first attempt will be to convert the db to MDB for you to continue working this; however, I will help as much as I can since I have Office 2007 installed.

M-1

(guess I shouldn't have replied in this thread since it is a notify -- sorry!)

Commented:
Any Access 2007 Guru? Wrong order of records when using 2007 to import a text file into a 2003 database... http:/Q_24828382.html
(°v°)

Commented:
Again Access 2007: changing the monitor affects reports (both preview and printing).
http:/Q_24857530.html
(°v°)
Top Expert 2006

Commented:
All is well in Houston and we're looking for Access Developers. Anyone interested, qualified and in need of employment in this rough economy, drop me a line.
Access 2003, SQL2005, Excel, .NET ane various other odds and ends.
J
Top Expert 2006

Commented:
I also have a Q open here with perhaps no hope of a solution, but I thought I'd throw it out to you guys (and girls) to see if anyone else has thoughts on it.
http:/Q_24869185.html
J

Commented:
Does anyone have experience with adp interface issues?
How to resize the form ... http:/Q_24941297.html
(°v°)
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Author

Commented:
Pinging "abandoned" question.
Nothing to do and no need to respond to anything.

Holidays are almost here!
 
Jim Dettman
MS Access Zone Advisor
aikimarkSocial distance; Wear a mask; Don't touch your face; Wash your hands for 20 seconds
CERTIFIED EXPERT
Top Expert 2014

Commented:
Here's a strange A2007 problem:
https://www.experts-exchange.com/Q_24927890.html
Kevin CrossChief Technology Officer
CERTIFIED EXPERT
Most Valuable Expert 2011

Commented:
Asker looking to PIVOT decimal values, but "." coming up as underscores in resulting column names.
https://www.experts-exchange.com/Q_25001927.html

Commented:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_25078392.html?cid=1331#a26396127

Do we have any Arabic speaking EE members who might be able to help here?
Most Valuable Expert 2014

Commented:
https://www.experts-exchange.comexperts-exchange.com/Microsoft/Development/MS_Access/Q_25092601.html

I think it is just a difference between 32 and 64 bit OLE drivers, but I can't answer right ioff.
aikimarkSocial distance; Wear a mask; Don't touch your face; Wash your hands for 20 seconds
CERTIFIED EXPERT
Top Expert 2014

Commented:
This was a particularly tricky problem:
https://www.experts-exchange.com/Q_25111596.html
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Author

Commented:
Can anyone with OLEDB/Oracle experience take a look at this:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_25077041.html
This guy is trying to have a check at startup test a ODBC DSN connection. I the past, I've done that by simply opening a ADO connection using the DSN (so I can get specific error messages). The code which I gave him is tossing back a very generic error message number, yet from the ODBC manager he can test the connection and it works fine (although he gets a user name and password prompt). Linked tables within the Access DB work fine as well.
It must have something to do with the connection string, but for the life of me can't figure out what. This has dragged on way too long already for this guy.
Any help appreciated...
JimD.
aikimarkSocial distance; Wear a mask; Don't touch your face; Wash your hands for 20 seconds
CERTIFIED EXPERT
Top Expert 2014

Commented:
I'm blanking on the name of the utility/add-in that helps developers find instances of field names in forms and queries.  Anyone know this off the top of your head?

Note:
I'm helping DanRollins on his edit of an article about backing up an Access database.  The article describes processes that seem very inefficient and sloooow.  Does anyone know about performance issues involved in make table queries with the (From) IN clause?  Push vs Pull performance?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
aikimarkSocial distance; Wear a mask; Don't touch your face; Wash your hands for 20 seconds
CERTIFIED EXPERT
Top Expert 2014

Commented:
@MX

Thanks.
Graham MandenoConsultant
CERTIFIED EXPERT

Commented:
Hi aikimark
There's another free one (V-Tools) here:
http://www.skrol29.com/us/vtools.php
--
Graham
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Author

Commented:
Hey guys (and all), just a gentle reminder, from the original post for this thread:
"Please do *not* post general comments or hold a discussion in this notify question."
and the first comment after that:
"I've posted a general discussion thread for anyone interested:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24546931.html

- Miriam"
  Please use the discussion thread for anything but notifications of problems.  
Thanks,
JimD.
PS.   Hey and besides that, why wasn't this a question?<g>
Most Valuable Expert 2014

Commented:
I'm out of ideas. Please feel free to jump in.

Access 2000 Import table always links instead
https://www.experts-exchange.com/Q_25158646.html

CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
Suddenly an icon or avatar for the author is displayed at each and every comment!
What did I do? How to get rid of these?

/gustav
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
Oh. When I posted that comment, they went away! Ghosts are in the machine.

/gustav
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
The icon thing is a new "feature" being introduced to EE ... it'll be buggy for a bit, I'm sure.
CERTIFIED EXPERT

Commented:
If you are good with record locking then you might like to look at this problem..

https://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_25489180.html

Commented:
Jim, it was freezing in Montreal this AM when I got up - we should be so lucky!
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
What do ya mean "going to come"???? We've hit 90 for the past 3 days!!!!
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
South Carolina AKA: God's Country

Most Valuable Expert 2014

Commented:
Can I get some additional experts to advise her. It sounds like she just needs guidance.

https://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-Design/Q_25786560.html
Most Valuable Expert 2014

Commented:
CERTIFIED EXPERT

Commented:
Locking problem on single user machine - you need Visio to be installed  to run the attached file.
https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_25872125.html?
CERTIFIED EXPERT

Commented:
A real <*&^%$£ of a problem.
New records being automatically and erroneously generated in a table via a form, for no reason I can see.
https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_25866298.htm

If you download the poster's database then open the form frmData. Use the Last record icon to move - not the date in the Statusdate at the top right.
Move to the next record using the icon - this takes you to a new record of course, but you immediately get the same date as the previous record and an autonumber is allocated.
I have posted comments on what I have done in my final response in the question thread.

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
I can't seem to get through to this guy:

https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26188617.html

Posted an RFA but thought I'd place one here as well.

Commented:
I'm out of ideas, perhaps one of you has a a few more?

Design lock: http:/Q_26239636.html

Application no longer works as before on a new laptop: after running code from the FE (involving an mda add-on), design-view is locked, and ldb shows two connections. But it still works on the desktop PC, as it has for years.

(°v°)
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Author

Commented:
Anyone that's used Sage care to comment?
https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26274911.html#a33037996
Asker wants to know if it's worth the $650.  I've added my .02
JimD.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Guess that brings the price down to $649.98 :-)

I made a comment ...

mx

Commented:
This question needs some help.  Too much stuff I am not familiar with.

Can a legacy Access 2000 (SolarWinds IP Address Management) Database file be used as a linked SharePoint List?

https://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_26259578.html?cid=1330#a33088537

BTW, is this thread getting a bit long?
President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Author

Commented:
Notify thread closed.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.