Solved

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

Posted on 2009-07-06
68
559 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
0
Comment
68 Comments
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
I've posted a general discussion thread for anyone interested:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24546931.html

- Miriam
0
 
LVL 34

Expert Comment

by:jefftwilley
Comment Utility
Problems Cutting and Pasting an A2007 table object. Anyone else seen this issue?

http:Q_24579576.html#a24880627

J
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
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
http://www.experts-exchange.com/Q_24548142.html
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
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
http://www.experts-exchange.com/Q_24530359.html
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
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
http://www.experts-exchange.com/Q_24592512.html
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
I asked the question but no response.  Can anyone help.

Ray

http://www.experts-exchange.com/Web_Development/Images/Q_24644068.html#a25082292
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
I'm out of ideas for this one:

http://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
0
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
A straightforward report grouping Q, but I can't make myself understood so perhaps someone else would like to take over.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24668688.html
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
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.

http://www.experts-exchange.com/Q_24671883.html
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
Easy import basic Excel SS into an Acc db.
http://www.experts-exchange.com/Q_24673880.html

He's doing it with 07 though so need some experts who are there. ;-)
0
 
LVL 57

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
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.
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
The guy wants to de-normalize to export to Word. Sounds like a bad idea.

http://www.experts-exchange.com/Q_24684941.html
0
 
LVL 57

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
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.
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
This could be for JimD as I'm out of ideas:

http://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
0
 
LVL 59

Expert Comment

by:Kevin Cross
Comment Utility
Anyone want to throw thoughts in about cross tab queries:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24720615.html

M-1
0
 
LVL 10

Expert Comment

by:calpurnia
Comment Utility
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?

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24729088.html?cid=1572#a25335074
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
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.

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

Thanks.
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
http://experts-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.
0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
@jimpen

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

As I commented in the thread, I don't think this is an MS-Access version problem.
0
 
LVL 10

Expert Comment

by:calpurnia
Comment Utility
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24741301.html?cid=1572#a25362414

Would anyone care to hazard a guess what he means by 'sort of'?
0
 
LVL 10

Expert Comment

by:calpurnia
Comment Utility
I think the solution I offered is a step in the right direction, but he's using 2007, and I'm not.

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24740614.html#a25388677
0
 
LVL 57

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
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.

http://www.experts-exchange.com/Microsoft/Development/MS_Access//Q_24769935.html?cid=1330#a25452437
JimD.
0
 
LVL 59

Expert Comment

by:Kevin Cross
Comment Utility
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!)
0
 
LVL 58

Expert Comment

by:harfang
Comment Utility
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°)
0
 
LVL 58

Expert Comment

by:harfang
Comment Utility
Again Access 2007: changing the monitor affects reports (both preview and printing).
http:/Q_24857530.html
(°v°)
0
 
LVL 34

Expert Comment

by:jefftwilley
Comment Utility
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
0
 
LVL 34

Expert Comment

by:jefftwilley
Comment Utility
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
0
 
LVL 58

Expert Comment

by:harfang
Comment Utility
Does anyone have experience with adp interface issues?
How to resize the form ... http:/Q_24941297.html
(°v°)
0
 
LVL 57

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
Pinging "abandoned" question.
Nothing to do and no need to respond to anything.

Holidays are almost here!
 
Jim Dettman
MS Access Zone Advisor
0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
Here's a strange A2007 problem:
http://www.experts-exchange.com/Q_24927890.html
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 59

Expert Comment

by:Kevin Cross
Comment Utility
Asker looking to PIVOT decimal values, but "." coming up as underscores in resulting column names.
http://www.experts-exchange.com/Q_25001927.html
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
http://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?
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
http://experts-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.
0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
This was a particularly tricky problem:
http://www.experts-exchange.com/Q_25111596.html
0
 
LVL 57

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
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.
0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
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?
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
@MX

Thanks.
0
 
LVL 20

Expert Comment

by:GrahamMandeno
Comment Utility
Hi aikimark
There's another free one (V-Tools) here:
http://www.skrol29.com/us/vtools.php
--
Graham
0
 
LVL 57

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
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:
http://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>
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
I'm out of ideas. Please feel free to jump in.

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

0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
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
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
Oh. When I posted that comment, they went away! Ghosts are in the machine.

/gustav
0
 
LVL 84
Comment Utility
The icon thing is a new "feature" being introduced to EE ... it'll be buggy for a bit, I'm sure.
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
0
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
If you are good with record locking then you might like to look at this problem..

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_25489180.html
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
Jim, it was freezing in Montreal this AM when I got up - we should be so lucky!
0
 
LVL 84
Comment Utility
What do ya mean "going to come"???? We've hit 90 for the past 3 days!!!!
0
 
LVL 84
Comment Utility
South Carolina AKA: God's Country

0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
Can I get some additional experts to advise her. It sounds like she just needs guidance.

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-Design/Q_25786560.html
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
0
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
Locking problem on single user machine - you need Visio to be installed  to run the attached file.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_25872125.html?
0
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
A real <*&^%$£ of a problem.
New records being automatically and erroneously generated in a table via a form, for no reason I can see.
http://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.

0
 
LVL 84
Comment Utility
I can't seem to get through to this guy:

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

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

Expert Comment

by:harfang
Comment Utility
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°)
0
 
LVL 57

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
Anyone that's used Sage care to comment?
http://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.
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Guess that brings the price down to $649.98 :-)

I made a comment ...

mx
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
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?

http://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?
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 0 total points
Comment Utility
Link to new notify thread:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26292675.html
Please click "monitor" to join the new thread.
Jim Dettman
MS Access ZA.
0
 
LVL 57

Author Closing Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
Notify thread closed.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now