Help converting 2003 database to new 2010+ (1 Viewer)

Mikeb185

Registered User.
Local time
Today, 12:02
Joined
Sep 18, 2019
Messages
55
Hi all,

I'm looking for someone local to me who can assist me with converting my 2003 database to the newer format.

When i use the database converter i am getting errors that i don't know how to fix.
I am located near to Littlehampton in west Sussex UK

Thanks
 

isladogs

MVP / VIP
Local time
Today, 12:02
Joined
Jan 14, 2017
Messages
18,186
How local do you need?
What type of errors are you getting?
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 12:02
Joined
Jul 9, 2003
Messages
16,245
When i use the database converter i am getting errors that i don't know how to fix.

I would suggest that before you do the conversion, make sure all modules, form modules and stand-alone modules, have the line "Option Explicit" at the top. Then do a compile, and then run compact and repair.
 

Mikeb185

Registered User.
Local time
Today, 12:02
Joined
Sep 18, 2019
Messages
55
I would suggest that before you do the conversion, make sure all modules, form modules and stand-alone modules, have the line "Option Explicit" at the top. Then do a compile, and then run compact and repair.
Sorry to sound useless but how would i do that?
 

isladogs

MVP / VIP
Local time
Today, 12:02
Joined
Jan 14, 2017
Messages
18,186
Open the Visual Basic Editor then go to Tools...Options and tick Require Variable Declaration.
That will add Option Explicit as the second line of each new module created and ensure you have no undeclared variables in future reducing the chances of your code crashing unexpectedly.
However it won't do so with existing modules. Open each in turn and add the line Option Explicit immediately after Option Compare Database at the top of each module.

Still in the VBE, click Debug...Compile. If it stops and highlights something you will need to take action as appropriate e.g. add a line something like Dim YourVariableName As String (alter as necessary). Keep clicking Compile until all errors are fixed at which point the Compile command will be disabled.

Exit the VBE, and next make a backup ...just in case.
Finally go to Database Tools ...Compact & Repair.

BTW - why do you need someone so very local when almost all support can be done online / by phone / email
And once again, what type of errors are you getting?
 
Last edited:

Mikeb185

Registered User.
Local time
Today, 12:02
Joined
Sep 18, 2019
Messages
55
Sorry for the late reply!

so the error im having is when i try and select a supplier from the drop down list is giving the error
1610299533926.png



any ideas please?
 

Gasman

Enthusiastic Amateur
Local time
Today, 12:02
Joined
Sep 21, 2011
Messages
14,051
Have you checked that none of those causes are true?
Which control is meant to be the CompanyName?

FWIW, you would still get that error even if you upgraded Access.?
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 12:02
Joined
Sep 12, 2006
Messages
15,614
A A2003 dbs should just run in current Access. Do you get errors if you run it without converting?

In which case, just save as, with a new name, and in the version you want.
That should work.
 

Mikeb185

Registered User.
Local time
Today, 12:02
Joined
Sep 18, 2019
Messages
55
Have you checked that none of those causes are true?
Which control is meant to be the CompanyName?

FWIW, you would still get that error even if you upgraded Access.?

Just to add im a complete novice so need step by step instructions as i didnt write the database.
A A2003 dbs should just run in current Access. Do you get errors if you run it without converting?

In which case, just save as, with a new name, and in the version you want.
That should work.
i get the same error... runs fine in 2003
 

Attachments

  • 1610300310535.png
    1610300310535.png
    344.8 KB · Views: 105

Gasman

Enthusiastic Amateur
Local time
Today, 12:02
Joined
Sep 21, 2011
Messages
14,051
Again, which control is meant to be CompanyName?
 

Gasman

Enthusiastic Amateur
Local time
Today, 12:02
Joined
Sep 21, 2011
Messages
14,051
You need to open the form in design view and look through the controls combo
 

Mikeb185

Registered User.
Local time
Today, 12:02
Joined
Sep 18, 2019
Messages
55
You need to open the form in design view and look through the controls combo
the dropdown box marked unbound is causing the issue, im getting the same problem on add purchase order and view purchase order
1610301089600.png

1610301103253.png
 

Gasman

Enthusiastic Amateur
Local time
Today, 12:02
Joined
Sep 21, 2011
Messages
14,051
No, it is not causing the issue at all. It is the event attached to that control which is causing the error.
That is not even the same form you originally posted. :(

That one DOES have a CompanyName?
 

Mikeb185

Registered User.
Local time
Today, 12:02
Joined
Sep 18, 2019
Messages
55
No, it is not causing the issue at all. It is the event attached to that control which is causing the error.
That is not even the same form you originally posted. :(

That one DOES have a CompanyName?
I get the same error on both forms.
1610302012387.png

1610302012387.png
 

Mikeb185

Registered User.
Local time
Today, 12:02
Joined
Sep 18, 2019
Messages
55
so just for a test i removed the info from the after update box under the event tab and now i can select a customer without the error.

only problem is no information is displayed I.e previous orders and details.
 

Users who are viewing this thread

Top Bottom