[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:

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

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
Jim Dettman (Microsoft MVP/ EE MVE)
Asked:
Jim Dettman (Microsoft MVP/ EE MVE)
1 Solution
 
mbizupCommented:
I've posted a general discussion thread for anyone interested:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24546931.html

- Miriam
0
 
jefftwilleyCommented:
Problems Cutting and Pasting an A2007 table object. Anyone else seen this issue?

http:Q_24579576.html#a24880627

J
0
 
Jim P.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
http://www.experts-exchange.com/Q_24548142.html
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Jim P.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
http://www.experts-exchange.com/Q_24530359.html
0
 
Jim P.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
http://www.experts-exchange.com/Q_24592512.html
0
 
GRayLCommented:
I asked the question but no response.  Can anyone help.

Ray

http://www.experts-exchange.com/Web_Development/Images/Q_24644068.html#a25082292
0
 
Gustav BrockCIOCommented:
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
 
peter57rCommented:
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
 
Jim P.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.

http://www.experts-exchange.com/Q_24671883.html
0
 
Jim P.Commented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentAuthor 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.
0
 
Jim P.Commented:
The guy wants to de-normalize to export to Word. Sounds like a bad idea.

http://www.experts-exchange.com/Q_24684941.html
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentAuthor 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.
0
 
Gustav BrockCIOCommented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
calpurniaCommented:
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
 
Jim P.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.

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

Thanks.
0
 
Jim P.Commented:
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
 
aikimarkCommented:
@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
 
calpurniaCommented:
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
 
calpurniaCommented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentAuthor 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.

http://www.experts-exchange.com/Microsoft/Development/MS_Access//Q_24769935.html?cid=1330#a25452437 
JimD.
0
 
Kevin CrossChief Technology OfficerCommented:
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
 
harfangCommented:
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
 
harfangCommented:
Again Access 2007: changing the monitor affects reports (both preview and printing).
http:/Q_24857530.html
(°v°)
0
 
jefftwilleyCommented:
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
 
jefftwilleyCommented:
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
 
harfangCommented:
Does anyone have experience with adp interface issues?
How to resize the form ... http:/Q_24941297.html
(°v°)
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentAuthor Commented:
Pinging "abandoned" question.
Nothing to do and no need to respond to anything.

Holidays are almost here!
 
Jim Dettman
MS Access Zone Advisor
0
 
aikimarkCommented:
Here's a strange A2007 problem:
http://www.experts-exchange.com/Q_24927890.html
0
 
Kevin CrossChief Technology OfficerCommented:
Asker looking to PIVOT decimal values, but "." coming up as underscores in resulting column names.
http://www.experts-exchange.com/Q_25001927.html
0
 
GRayLCommented:
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
 
Jim P.Commented:
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
 
aikimarkCommented:
This was a particularly tricky problem:
http://www.experts-exchange.com/Q_25111596.html
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentAuthor 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.
0
 
aikimarkCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
0
 
aikimarkCommented:
@MX

Thanks.
0
 
GrahamMandenoCommented:
Hi aikimark
There's another free one (V-Tools) here:
http://www.skrol29.com/us/vtools.php
--
Graham
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentAuthor 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:
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
 
Jim P.Commented:
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
 
Gustav BrockCIOCommented:
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
 
Gustav BrockCIOCommented:
Oh. When I posted that comment, they went away! Ghosts are in the machine.

/gustav
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The icon thing is a new "feature" being introduced to EE ... it'll be buggy for a bit, I'm sure.
0
 
GRayLCommented:
0
 
peter57rCommented:
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
 
GRayLCommented:
Jim, it was freezing in Montreal this AM when I got up - we should be so lucky!
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What do ya mean "going to come"???? We've hit 90 for the past 3 days!!!!
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
South Carolina AKA: God's Country

0
 
Jim P.Commented:
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
 
Jim P.Commented:
0
 
peter57rCommented:
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
 
peter57rCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
harfangCommented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Guess that brings the price down to $649.98 :-)

I made a comment ...

mx
0
 
GRayLCommented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentAuthor Commented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentAuthor Commented:
Notify thread closed.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now