473,387 Members | 1,575 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,387 software developers and data experts.

will the vba still work when converting from access 97 to 2007

I have an access database that was created in 97, we are going to be moving to the office 2007, then the 2010 suite.

if you were to convert a file from 97 to 2007, will the vba still work correctly, and if not are there things that can be done to ensure the functionality is not interupted?
Mar 4 '11 #1

✓ answered by Rabbit

Depending on the complexity of the code, there will probably be at least a few issues. You'll just need to fix the code as they come up.

3 1598
Rabbit
12,516 Expert Mod 8TB
Depending on the complexity of the code, there will probably be at least a few issues. You'll just need to fix the code as they come up.
Mar 4 '11 #2
neelsfer
547 512MB
Its sometimes so complex. My one application works 100% with Windows XP + Access 2007, but with Windows 7 + Access 2007 certain code/functions don't work properly. Even the Office 2007 SP1 has affected it. Be aware of this.
Mar 6 '11 #3
what i am specifically working on is an email function that sends a confirmation email with user information.
it grabs the email address from active directory, accesses the exchange server, and sends an email with information from the record.
the get email and send email are in two seperate modules.
how would you suggest moving these modules?
Mar 7 '11 #4

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

Similar topics

10
by: powelly | last post by:
Hi i Know this looks weird by i done a database in 2000 all worked well than i had to convert it to 97. I had to redo all my code that was fine but i can not get the form to addnew when OnOpen runs...
0
by: umlv | last post by:
Hi, I understand that the runtime will be free with access 2007. I wonder about the following scenario: A user will have the full version of access 2003 installed (or an earlier version). A...
0
by: Wayne | last post by:
In an attempt to get around the extremely painful "reinstall" routine that takes place when using Access 2007 on machines that have earlier versions installed, I have tried the free "Altiris...
2
by: ARC | last post by:
Just curious if anyone is having issues with Acc 2007 once the number of objects and complexity increases? I have a fairly large app, with many linked tables, 100's of forms, queries, reports, and...
4
akabir77
by: akabir77 | last post by:
Hi I am using the following code to convert a access report into HTML format and then sending it via email. DoCmd.SendObject _ acSendReport, _ ...
1
by: BulbFresh | last post by:
Hi, Quick one for you, i'm importing a file which has a long date and time format, so once imported i update each date field with the correct format (dd/mm/yyyy). I wrote this in on click of a...
7
by: preeny8 | last post by:
Hi there, I recently updated to Access 2007, and I'm getting a couple of errors that i'm not sure how to deal with. I worked with a lot of databases in Access 2003 (.mdb), and for some reason...
0
by: susan | last post by:
i am a bear of very little brain so please don't use too many abbreviations or technical jargon or it might melt alltogether... I have created a database with Access 2007 and saved it, via the...
10
by: Anthony97 | last post by:
This is a problem I've been fighting through for the last month. I've been tasked with converting access 2007 queries to SQL Server 2005. I have been able to convert a number of queries associated...
3
by: Anthony97 | last post by:
I ran this code on my access 07 db and it updates a number of records 61,425, I try and run the query in SQL Server 2005 modifying the IIf to CASE WHEN and I get a number of sytax errors. ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.