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

Gasman

Enthusiastic Amateur
Local time
Today, 01:39
Joined
Sep 21, 2011
Messages
14,048
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.?
 

Gasman

Enthusiastic Amateur
Local time
Today, 01:39
Joined
Sep 21, 2011
Messages
14,048
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

Registered User.
Local time
Today, 01:39
Joined
Sep 18, 2019
Messages
55
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

Enthusiastic Amateur
Local time
Today, 01:39
Joined
Sep 21, 2011
Messages
14,048
In the ControlSource property on the Data tab?
You can see what the source is from your pictures?
 

Mikeb185

Registered User.
Local time
Today, 01:39
Joined
Sep 18, 2019
Messages
55
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

..forever waiting... waiting for jellybean!
Local time
Today, 09:39
Joined
May 7, 2009
Messages
19,169
check the Macro (FindSupplier).
if you can .zip your db and upload it here, it would be of help.
 

Gasman

Enthusiastic Amateur
Local time
Today, 01:39
Joined
Sep 21, 2011
Messages
14,048
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

Enthusiastic Amateur
Local time
Today, 01:39
Joined
Sep 21, 2011
Messages
14,048
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

Registered User.
Local time
Today, 01:39
Joined
Sep 18, 2019
Messages
55
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
1610359102006.png

and as below
1610359049654.png
 

Attachments

  • 1610358969193.png
    1610358969193.png
    353.9 KB · Views: 100

Mikeb185

Registered User.
Local time
Today, 01:39
Joined
Sep 18, 2019
Messages
55
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

Enthusiastic Amateur
Local time
Today, 01:39
Joined
Sep 21, 2011
Messages
14,048
OK, so the other is a label?
Show the data tab for that control as well.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 09:39
Joined
May 7, 2009
Messages
19,169
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

Registered User.
Local time
Today, 01:39
Joined
Sep 18, 2019
Messages
55
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

Enthusiastic Amateur
Local time
Today, 01:39
Joined
Sep 21, 2011
Messages
14,048
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?
 

Users who are viewing this thread

Top Bottom