Help converting 2003 database to new 2010+

[Gasman]

Well check those control names as whilst you can have the same source more than once, you cannot have the same name.?
It would be quicker to upload the DB.?

 

[Mikeb185]

sorry to sound stupid but where do i check?

 

[Gasman]

In design mode, select each control that has a source as CompanyName and then choose Other on the Properties window.
Then post back what each name is.

 

[Mikeb185]

In design mode, select each control that has a source as CompanyName and then choose Other on the Properties window.
Then post back what each name is.

thanks, where does it tell you the source?

 

[Gasman]

In the ControlSource property on the Data tab?
You can see what the source is from your pictures?

 

[Mikeb185]

In design mode, select each control that has a source as CompanyName and then choose Other on the Properties window.
Then post back what each name is.

Just to clarify what is a control? are text boxes controls? thanks

 

[arnelgp]

check the Macro (FindSupplier).
if you can .zip your db and upload it here, it would be of help.

 

[Gasman]

Just to clarify what is a control? are text boxes controls? thanks

Yes, all the objects on your form/report that can contain data are called controls. Not sure if a line would be called a control, but here we are talking about the textboxes.

 

[Gasman]

check the Macro (FindSupplier).
if you can .zip your db and upload it here, it would be of help.

It would be of great help, considering the expertise of the o/p.
They would get the help they are seeking so much faster.

 

[Mikeb185]

In design mode, select each control that has a source as CompanyName and then choose Other on the Properties window.
Then post back what each name is.

So the only ones are as below

and as below

 

[Mikeb185]

It would be of great help, considering the expertise of the o/p.
They would get the help they are seeking so much faster.

It contains sensitive data that i cannot share unfortunately

 

[Gasman]

OK, so the other is a label?
Show the data tab for that control as well.

 

[Gasman]

It contains sensitive data that i cannot share unfortunately

You can copy the DB with no data?, that would be better than nothing.

 

[Mikeb185]

OK, so the other is a label?
Show the data tab for that control as well.

 

[Mikeb185]

View attachment 88150

 

[Mikeb185]

You can copy the DB with no data?, that would be better than nothing.

How do i do that?

 

[arnelgp]

if you have Winzip or Winrar, create a .Zip file from your mdb/accdb.
click at the "Attach files" button and attached your zip.

 

[Mikeb185]

if you have Winzip or Winrar, create a .Zip file from your mdb/accdb.
click at the "Attach files" button and attached your zip.

Surely the data will still be in it though?

 

[Gasman]

Copy the DB, then delete any sensitive data. Zip it (right click and Send to Cpmpressed (zipped) folder then upload that.

You can also copy tables structure only?

 

[Gasman]

We are just going around in circles?

https://www.access-programmers.co.u...converting-database-from-2003-to-2010.306904/