convert access 2.0 forms to 2007 without buying 2003

MS Office Access

    Sponsored Links

    Next

  • 1. Query Looking At Form's Field - but from VBA
    Got a report. Report's based on a query. Query looks at a dialog form to get a date. Date is used by the query in selecting records. Query works fine when it's just invoked by double clicking. But when it's the .RecordSource of the report, the report dies - saying it does not recognize the [Form].[FormName]![txtDateFieldname] referenced by the query. I've been here before and always gotten around it by having the report's .RecordSource set to Null and then using the query to create a work table in Form_Open - instantiating the query and explicitly setting the parm. But this query is a Pivot Table presentation - i.e. the fields may not be the same each time it is invoked. This breaks my little scheme of creating the work table via a .CopyObject of a model table into a work DB and seems to reduce me to a MakeTable query... I guess I could do that - but it would require writing code to manage the link - and that's a little more complicated because I make my apps Terminal-Server-Friendly. i.e. the work table's location varies depending on the user's ID and so-forth so the location of the query's target table would have tb changed dynamically also. What I'm hoping to hear is that I'm just doing something dumb back at the query and fixing it will make it run "as-is". Anybody? -- PeteCresswell

convert access 2.0 forms to 2007 without buying 2003

Postby UGF1bCBpbiBXSQ » Wed, 16 Apr 2008 22:32:01 GMT

I'm thinking about buying Access 2007.  I have applications with many forms 
created with Access 2.0.  Access 2007 won't import them -- they have to pass 
through 2000, 2002, or 2003.  Is there a way to do this upgrade without 
buying an interim version of Access?  

Paul in WI

RE: convert access 2.0 forms to 2007 without buying 2003

Postby SmVycnkgV2hpdHRsZQ » Wed, 16 Apr 2008 23:24:01 GMT

In a word: No.  Also there might be some problems with the forms unless they 
are very simple. Hopefully you can find someone with a version of Access that 
could do the intermediate upgrade for you.

Have you considered rebuilding the forms and reports from scratch? Possibly 
it's time for a look at the database to see how it could be improved.
-- 
Jerry Whittle, Microsoft Access MVP 
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.






Re: convert access 2.0 forms to 2007 without buying 2003

Postby Paul Matejcek » Thu, 17 Apr 2008 00:10:52 GMT

Thanks, Jerry.

Some of the databases are old; one has been in development for the past 
week.

Access 2.0 has served me well, and there are some issues with it that I 
hoped might be cleaned up in a new version.  Also, support would be nice, 
along with long file names.

I've downloaded the trial version of 2007, and I don't find the HMI very 
enticing...

Paul









Re: convert access 2.0 forms to 2007 without buying 2003

Postby RnJlZA » Thu, 17 Apr 2008 03:21:01 GMT

Have you considered running 2003?   It's HMI has a lot of continuity from 
previous versions.  

I have both.  In typical  Microsoft arrogance, they scrambled the whole HMI 
from 2003 to 2007.  If they ran the tool section at the hardware store they 
would rename all of the tools by example uses.      So everyone needs to 
invest $10,000 in learning curve time for the new HMI.   It's no wonder that 
Microsoft slipped from being the #1 known/liked brand name to #56...they have 
stopped listening to customers. I mothballed 2007 until I can set aside that 
much time to waste.   









Re: convert access 2.0 forms to 2007 without buying 2003

Postby Paul Matejcek » Fri, 18 Apr 2008 01:29:24 GMT

Using 2003 seems like a very good idea -- if only I could find a copy... 
Any idea where to try to buy it?

Paul














Re: convert access 2.0 forms to 2007 without buying 2003

Postby Larry Linson » Fri, 18 Apr 2008 15:20:51 GMT

"Paul Matejcek" < XXXX@XXXXX.COM > wrote

 > Using 2003 seems like a very good idea -- if only I could find a copy...
 > Any idea where to try to buy it?

Online... your favorite search engine will be your friend as you try to find 
a copy... try the online auction sites, too. You can likely find a copy of 
Access 2002 or 2003 (I am not certain, however, whether Access 2003 can 
convert an Access 2.0 file).

 Larry Linson
 Microsoft Office Access MVP



Similar Threads:

1.Convert Access 2.0 data to Access 2003

How can I find the Access 2.0 Converter which is no 
longer on line? 

2.Converting Access 2.0 to Access 2003

I just converted a legacy Access 2.0 app to Access 2003 (please don't laugh, 
yes I am coming out of the dark ages).  It compiles with no errors but when I 
try to execute the 2003 application, I get the following error:  "Unable to 
locate CPS Loans .ini file in path 'msacc30.ini' or 'mcacc30.ini'!"  CPS 
Loans is the name of my application. I can not find much information on the 
msacc30.ini file except something about backwards compatability.  I am 
starting on my Login screen and I am trying to execute from within Access 
2003.  I want to test my conversion, so I need to be able to execute in 
development mode.

3.Toolbars, Autoexec macros -converting an Access 2.0 to Access 2003

After everyone else in the office turned down this project, this upgrade 
project fell on my desk.  It's been about 8 years since I last created a big 
app in VFP and never in Access.  Until I start traiing next week, I been 
poking around - running the original app under 2.0 on one box and upgrading 
and debuggin on a second box.  I can't seem to get past the autoexec macro in 
this 2.0 app to rununder 2003

The three lines that are vexing me are:

DoMenuItem (arguments - database, Window, hide)
ShowToolbar (arguments - Select, No)
ShowToolbar (arguments - SelectM, No)

It appears (from MSDN and other reearch) that DoMenuItem and ShowToolbar 
been replaced , but I can't seem to find the right procedures/functions to 
replace it.

The toolbars have been imported into the new 2003 upgraded database, but 
obviously the language support has changed.

Can anyone give me clue to get on the fast track with this?

THANKS!



-- 
Jim McDermott

4.Problem converting VB Code from Access 2.0 to Access 2003

When attempting to convert a database to 2003 I get a 
message unable to compile.  When I then try to print a 
label using a macro mcrPrintLabel it states unable to 
find function.

The Arboretum Foundation has used the macro which opens a 
query to create a table called TempTable and then calls 
for VBA with the line "RunCode" calling for function 
Print_Label().  The function is as follows:

Function Print_Label()

    ' This sets up using the tblTempTable with a primary 
key.

        Dim MYDB As Database, tblMasterTable As Table, 
tblLabelTable As Table
        Set MYDB = CurrentDb()
        Set tblMasterTable = MYDB.OpenTable("tblTemp")
        Set tblLabelTable = MYDB.OpenTable("tblLabel")
        tblMasterTable.Index = PRIMARYKEY

    ' Goto the first record of the table.
        tblMasterTable.MoveFirst

    ' Read the record.
        Do Until tblMasterTable.EOF
            tblMasterTable.Edit
            X = tblMasterTable("NumberOfLabels")
            
    ' Copy the record a certain number of times
            For J = 1 To X
                tblLabelTable.AddNew
                
                tblLabelTable("Vendor") = tblMasterTable
("Vendor")
                tblLabelTable("Department") = 
tblMasterTable("Department")
                tblLabelTable("Classification") = 
tblMasterTable("Classification")
                tblLabelTable("Name") = tblMasterTable
("Name")
                tblLabelTable("BloomTime") = 
tblMasterTable("BloomTime")
                tblLabelTable("Tallness") = tblMasterTable
("Tallness")
                
                tblLabelTable("Color") = tblMasterTable
("Color")
                tblLabelTable("SellPrice") = 
tblMasterTable("SellPrice")
                tblLabelTable("BulbsInBag") = 
tblMasterTable("BulbsInBag")

                tblLabelTable.Update

            Next J

    ' Go back to the first table and get the next record.
        tblMasterTable.MoveNext
        Loop

    ' Print the report for the temp table.
        DoCmd.OpenReport "rptLabels3Across", A_PREVIEW


    ' Delete the temp table.
        tblMasterTable.Close
    
        tblLabelTable.MoveFirst

    ' Delete each record in a loop
        Do Until tblLabelTable.EOF
            tblLabelTable.Delete
            tblLabelTable.MoveNext
        Loop

    ' Close the tblLabel Table
        tblLabelTable.Close

End Function

Any help would be appreciated.


5.Problem Converting Access 2.0 to Access 2003

I have successfully converted an Access 2.0 database to Access 2003 (sort 
of).  I still have some lingering problems.  On the main application form, 
clicking any of the buttons produces the following error:

"The expression OnClick you entered as the event property setting produced 
the following error:
The expression you entered has a function name that Microsoft Office Access 
can't find."

The OnClick Property on the original machine, which is working, has the 
following text:

=UCmdOpenForm("RQ-MCC lender")

That is the same text listed in the OnClick property of the converted 
database.  There is a form named RQ-MCC lender in the converted database and 
it opens manually without problems.

I'm not sure what I should be looking for at this point, but I think I just 
need to be pointed in the right direction.  Any tips or suggestions would be 
greatly appreciated.

Carl 


6. Converting Access 2.0 to 2003...

7. converting from access 2.0 to 2003

8. Convert access 2007 to 2003 forms controls not working



Return to MS Office Access

 

Who is online

Users browsing this forum: No registered users and 99 guest