473,320 Members | 2,177 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Upgrading Access 97 - DAO or dao. ?

446 Expert 256MB
Hi Guys

I'm finally converting some old Access 97 stuff to 2003 and as you know part of this procedure is to explicitly qualify Database, Recordset and TableDef objects as DAO.

When I have done this previously the 'autocorrect' feature changed lowercase 'dao.' to uppercase 'DAO.' but not today!

I have obviously checked that I have the right references (MS DAO 3.6 Object Library and MS VBA Extensibility 5.3) and even that they are in the same order in both systems. They are also both on the same laptop (XP) and they both compile ok.

I rely on the 'auto-correct' to rectify my atrocious typing so ame very concious when words do not 'capitalise' correctly.

Anybody any ideas?

Any other gottcha's in upgrading to watch for ?

Many thanks

S7
Jan 8 '08 #1
7 2370
puppydogbuddy
1,923 Expert 1GB
Hi Guys

I'm finally converting some old Access 97 stuff to 2003 and as you know part of this procedure is to explicitly qualify Database, Recordset and TableDef objects as DAO.

When I have done this previously the 'autocorrect' feature changed lowercase 'dao.' to uppercase 'DAO.' but not today!

I have obviously checked that I have the right references (MS DAO 3.6 Object Library and MS VBA Extensibility 5.3) and even that they are in the same order in both systems. They are also both on the same laptop (XP) and they both compile ok.

I rely on the 'auto-correct' to rectify my atrocious typing so ame very concious when words do not 'capitalise' correctly.

Anybody any ideas?

Any other gottcha's in upgrading to watch for ?

Many thanks

S7
Why can't you do a find and replace (for the project) using the VB editor code window?
Jan 8 '08 #2
sierra7
446 Expert 256MB
Why can't you do a find and replace (for the project) using the VB editor code window?
Yes, of course I am doing that (149 replacements, times 3, sort of. I dont want to try and find all of those by hand!) But they should all turn into Upper case.

I'm probably worrying about nothing but a lot of money goes through this system (not mine I hasten to add!!) and I don't want any screw-ups.

Thanks for the suggestion anyway.
Jan 8 '08 #3
puppydogbuddy
1,923 Expert 1GB
Yes, of course I am doing that (149 replacements, times 3, sort of. I dont want to try and find all of those by hand!) But they should all turn into Upper case.

I'm probably worrying about nothing but a lot of money goes through this system (not mine I hasten to add!!) and I don't want any screw-ups.

Thanks for the suggestion anyway.

You can also try this free global find and replace utility for Access.

http://www3.bc.sympatico.ca/starthere/findandreplace/
Jan 8 '08 #4
jaxjagfan
254 Expert 100+
Can you post some of the relevant code?

Make sure when you check "References" none are flagged as "Missing" if so uncheck these and try again. I have seen at times where these were not needed but were the cause of problems.
Jan 8 '08 #5
sierra7
446 Expert 256MB
The Panic is over !!

When I opened the project this morning I found everything capitalised OK.
So declarations are now appearing correctly like;-
Expand|Select|Wrap|Line Numbers
  1. Dim dbs As DAO.Database
  2. Dim rst As DAO.Recordset
instead of like;-
Expand|Select|Wrap|Line Numbers
  1. Dim dbs As dao.Database
  2. Dim rst As dao.Recordset
I know I could have done a Find & Replace and forced capitals but that was not my point. I wanted the compiler to understand what I had written. I always type in lower case and wait for the capitals to appear. The Perfect Programmer may well look upon this practise as a lazy cop-out; so be it.

With hindsight, I had seen something similar before, when typing single statements e.g.
Expand|Select|Wrap|Line Numbers
  1. Me.Ndate_Label.Caption = !nextdate
  2. 'would not automatically capitalise to;
  3. Me.Ndate_Label.Caption = !NextDate
Thanks all for giving you time and PuppyDogBuddy thanks for the utility. I will try it later but if it can search Queries without opening them it will be good.

S7
Jan 9 '08 #6
puppydogbuddy
1,923 Expert 1GB
The Panic is over !!

When I opened the project this morning I found everything capitalised OK.
So declarations are now appearing correctly like;-
Expand|Select|Wrap|Line Numbers
  1. Dim dbs As DAO.Database
  2. Dim rst As DAO.Recordset
instead of like;-
Expand|Select|Wrap|Line Numbers
  1. Dim dbs As dao.Database
  2. Dim rst As dao.Recordset
I know I could have done a Find & Replace and forced capitals but that was not my point. I wanted the compiler to understand what I had written. I always type in lower case and wait for the capitals to appear. The Perfect Programmer may well look upon this practise as a lazy cop-out; so be it.

With hindsight, I had seen something similar before, when typing single statements e.g.
Expand|Select|Wrap|Line Numbers
  1. Me.Ndate_Label.Caption = !nextdate
  2. 'would not automatically capitalise to;
  3. Me.Ndate_Label.Caption = !NextDate
Thanks all for giving you time and PuppyDogBuddy thanks for the utility. I will try it later but if it can search Queries without opening them it will be good.

S7
sierra7,

Here is another good free utility that you should have:

http://www.mztools.com/v3/features.aspx
Jan 9 '08 #7
sierra7
446 Expert 256MB
sierra7,

Here is another good free utility that you should have:

http://www.mztools.com/v3/features.aspx
WOW they look good but I am short of time today to experiment much.

I use mainly Access and have acquired the (lazy) habit of creating a suitably named phantom command button with the Wizard to give me a default error handling subroutine, then delete the button and remove the OnClick bits. These tools should be much better.

Thanks again
Jan 9 '08 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: wellington fan | last post by:
Dear newsies, My ISP has offered to upgrade my servers from 3.23 to 4.1. I'm excited by the potential gains in performance, and the ability to write subqueries, but am wary of any forward...
5
by: Mike Owen | last post by:
Hi, I have just used the import Wizard to import a VS 2003 app to VS 2005. I have a lot of work to do to enable it to compile successfully with all the errors and warnings it gave me, but as a...
13
by: Noesis Strategy | last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles. Recently, I have begun to design Access databases using an copy of Access 2002 from my previous laptop. It works fine,...
11
by: Aidan Tobin | last post by:
Hi, I have to upgrade a number of databases from Access 2.0, Access 97 and Access 2000 to work in Office 2003. These databases contain a number of Forms coded with VBA as well as a number of...
9
by: dotnettester | last post by:
Hi, Can any one point me to a good resource on what to expect for .NET Applications when upgrading from IIS 5.0 to IIS 6.0 We are thinking to move to IIS 6.0 but fear...... Thanks,
15
by: Asaf | last post by:
Hi, I have received a source code project written in C++ VS.NET 2003 on .NET 1.1 that compiles without a problem. I have opened this source code in VS.NET 2005 and the Log wizard says that...
4
by: John Dann | last post by:
Couple of questions about upgrading an existing installation of VB2003 (Pro) to 2005 (Pro): 1. Not having dabbled in VB2005 yet, I'd feel more comfortable also keeping a working VB2003...
5
by: John | last post by:
Hi I have an access 97 app which I have the option to upgrade to either access 2000 or access 2003. Which one should I choose. I have heard nasty things about access 2000. Thanks Regards
6
by: JimLad | last post by:
Hi, We have a major ASP app that we are in the process of upgrading to ASP.NET 1.1 and probably on to ASP.NET 2.0 in the middle of next year. (We will also be upgrading to SQL2K5 at the same...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.