Help converting 2003 database to new 2010+

[Mikeb185]

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]

How local do you need?
What type of errors are you getting?

 

[Uncle Gizmo]

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]

How local do you need?
What type of errors are you getting?

west Sussex ideally

 

[Mikeb185]

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]

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?

 

[Mikeb185]

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

any ideas please?

 

[Gasman]

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]

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]

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

 

[Gasman]

Again, which control is meant to be CompanyName?

 

[Mikeb185]

Again, which control is meant to be CompanyName?

How do i find out? im not sure

 

[Gasman]

You need to open the form in design view and look through the controls combo

 

[Gasman]

So same error as Sept 2018?

https://www.access-programmers.co.u...tabase-from-2003-to-2010.306904/#post-1640768

 

[Mikeb185]

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

 

[Gasman]

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]

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.

 

[Mikeb185]

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.

 

[Mikeb185]

 

[Mikeb185]