Question Help with converting database from 2003 to 2010 (2 Viewers)

Mikeb185

Registered User.
Local time
Today, 05:00
Joined
Sep 18, 2019
Messages
55
Hi. For a control to receive the focus, it needs to be a Textbox or Combobox, or Listbox or subform, etc. It can't be a Label, or other controls that can't receive the focus. In addition, the control to receive the focus must also be Visible and Enabled. So, if you set Visible=Yes, also make sure Enabled=Yes. Hope it helps...

all are visable YES and enabled YES already unfortunatly
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:00
Joined
Oct 29, 2018
Messages
21,358
all are visable YES and enabled YES already unfortunatly
It might be time to consider posting a small copy of your db with some test/dummy data.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:00
Joined
Oct 29, 2018
Messages
21,358
thats fine,

How do i do that?
Remove any sensitive data and replace them with dummy data. Do a C&R. Zip the file. Then when you reply to this post, click on the Manage Attachments button below the reply input box and upload your zipped file.
 

Mikeb185

Registered User.
Local time
Today, 05:00
Joined
Sep 18, 2019
Messages
55
sorry but how would i remove the sensitive data?

I am completely new to this lol
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:00
Joined
Oct 29, 2018
Messages
21,358
sorry but how would i remove the sensitive data?

I am completely new to this lol
Ah, okay. It might be simpler to create a blank database file and then import the data definition into it.


1. Create a new blank database
2. Go to External Data tab and click on Import Access button
3. Select the original file and then pick all the tables. In the options, select Data Definition only
4. Select the rest of the objects such as queries, forms, macros, and modules from the original database
 

Mikeb185

Registered User.
Local time
Today, 05:00
Joined
Sep 18, 2019
Messages
55
Ah, okay. It might be simpler to create a blank database file and then import the data definition into it.


1. Create a new blank database
2. Go to External Data tab and click on Import Access button
3. Select the original file and then pick all the tables. In the options, select Data Definition only
4. Select the rest of the objects such as queries, forms, macros, and modules from the original database

Will this work if the database is split?

I mean it has 2 files i.e one is a backend
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:00
Joined
Oct 29, 2018
Messages
21,358
Will this work if the database is split?

I mean it has 2 files i.e one is a backend
No, maybe not. Let's try this for now, can you post a copy of the front end first? We just really need to see the form and the code. We'll worry about the backend later.
 

Mikeb185

Registered User.
Local time
Today, 05:00
Joined
Sep 18, 2019
Messages
55
sorry now attached
 

Attachments

  • database.zip
    362.8 KB · Views: 107

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:00
Joined
Oct 29, 2018
Messages
21,358
view purchase orders
Hi. I don't see any form with that name. There is a "PurOrders" form, but it doesn't look anything like the images you posted earlier. I found one that looks similar called "PurchaseFind", but it looks like you already changed the code to what Arnel suggested earlier. I was hoping to see the original code instead.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:00
Joined
Oct 29, 2018
Messages
21,358
Hi. I don't see any form with that name. There is a "PurOrders" form, but it doesn't look anything like the images you posted earlier. I found one that looks similar called "PurchaseFind", but it looks like you already changed the code to what Arnel suggested earlier. I was hoping to see the original code instead.
In the code I'm seeing, the following line is in red:
Code:
        .FindFirst "[CompanyName] = " & Chr(34) Me![FindSupplier] & Chr(34)
The reason for that is it's missing an ampersand like so:
Code:
        .FindFirst "[CompanyName] = " & Chr(34) [b]&[/b] Me![FindSupplier] & Chr(34)
 

Mikeb185

Registered User.
Local time
Today, 05:00
Joined
Sep 18, 2019
Messages
55
try this one
 

Attachments

  • database.zip
    351.6 KB · Views: 113

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:00
Joined
Oct 29, 2018
Messages
21,358
try this one
Sorry. Still, it doesn't have any form called "purchase orders" or "view purchase orders." It still has "PurOrders" and "PuchaseFind." However, PurchaseFind does not have any code behind the dropdown - it may have been deleted. I was expecting to see the macro you posted earlier.
 

Mikeb185

Registered User.
Local time
Today, 05:00
Joined
Sep 18, 2019
Messages
55
can you send me a screen shot of what you see when you open the database i sent please?
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:00
Joined
Oct 29, 2018
Messages
21,358
can you send me a screen shot of what you see when you open the database i sent please?
Here you go, but it probably won't help you. Remember, since I don't have your data file, I have to open it in design/dev mode.


 

Attachments

  • db.PNG
    db.PNG
    89.5 KB · Views: 245

Mikeb185

Registered User.
Local time
Today, 05:00
Joined
Sep 18, 2019
Messages
55
how do i pull up the code of the combo box to change it as suggested?
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:00
Joined
Oct 29, 2018
Messages
21,358
how do i pull up the code of the combo box to change it as suggested?
I was going to do it for you, if I only knew which form it was. To change the code, you do the steps I posted in post #7; but instead of copying and pasting the code, as I asked earlier, you would just simply change it.
 

Users who are viewing this thread

Top Bottom