Solved

Problems going from Access 2003 to 2010

Posted on 2012-03-16
3
1,392 Views
Last Modified: 2012-06-27
Hi

I installed Office 2010 including Access over Ofice 2003, and I get a number of problems with some apps which worked flawlessly under 2003:
- first problem was with PtrSafe, that was easy to fix
- second problem was with an MS progress meter (of class MSComctlLib.ProgCtrl.2), which did not work any more because the .Value attribute was not a valid attribute at run time. What's the natural replacement in 2010 for an "old" progress meter ? Or is there a way to have the old one working ?
- When I tried to repalce that progress meter with an ActiveX ProgView class (hoping it was a progress meter...), Access told me the OLE server was missing and I should reinstall it. How do I do that ?
- When running code which saves form fields to a SQLServer DB, some text box fields returned padded with a lot of trailing spaces, so that they are too long for the corresponding DB field (same symptom as when one declares a field in the DB as char(x) instead of varchar(x)and fetches the DB field content, only here it's the other way around: a new, empty field is populated based on a fixed value list with items of, say, length 1, but the reurned field contant has a length of 8 or 10 characters because of the trailing spaces). Which text box attribute is causing that, and why are only certain text boxes affected and not all ?

Thanks for your help.
Bernard
0
Comment
Question by:bthouin
  • 2
3 Comments
 
LVL 84
ID: 37731453
You have several questions in here. EE really works much better when you ask one question per posting.

However:

Is this a 64 bit machine, running 64 bit Office? If so, then you can't use the ActiveX controls you mention (and you shouldn't be using them in access anyway, since they're not built for that platform). Instead, use one of the "native" methods of showing a Progress bar.

Is this a Bound form application (i.e. you have a Recordsource for the Form, and a ControlSource for your controls)?
0
 
LVL 1

Author Comment

by:bthouin
ID: 37732139
Hi

Thanks for answers. I know I asked 3 questions in one post, and there is a reason to that: I am currently on a short holiday in Sweden in a place where there is no land line and virtually no GSM reception, so the Internet down/upload speeds to my USB modem-equipped laptop are measured in double-digits kbps, typically in the 20 to 30 kbps (!), so every post takes ages and is a real torture with the current fancy web sites like the EE site. That's why I packed all in one post.

Yes, it's a 64 bit machine adn Office 2010 64-bit.

What are the "native methods" of showing a progress bar ? Can you be more specific ?

I found the problem on the text and combo boxes. It was my fault. Some of the fields in the DB were wrongly defined with fixed length, and this seemed not to disturb Access 2003 at all, but did really come through with full force in Access 2010. I'll have to check all my 60-odd tables before continuing...

So, there remains only one question now, the one about the progress bar :-)

Regards
Bernard
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 300 total points
ID: 37734507
Since you're using 64-bit Office, you cannot use ActiveX controls, so that is out. ActiveX controls don't work on the 64-bit platform unless they've been reworked to do so, and very, very few of them have taken this step thus far.

The "native" method involves either (a) using the builtin SysCmd Progress bar or (b) building your own progress bar using boxes and labels and such.

For (a), see this link: support.microsoft.com/kb/210474. It's for Access 2000, but the same concepts apply today.

For (b) see this link: support.microsoft.com/kb/304581. This shows how to build a form-based progress bar. I've also attached a small project that illustrates how to do this.
ProgBar.zip
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
TRIM a textbox value MS Access 10 23
Print focus keeps focusing to the caller form 3 25
Create Form using Wizard 14 29
MS Access Tables Linking 6 40
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…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

929 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

11 Experts available now in Live!

Get 1:1 Help Now