Question Help with converting database from 2003 to 2010 (1 Viewer)

[Mikeb185]

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]

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.

 

[Mikeb185]

It might be time to consider posting a small copy of your db with some test/dummy data.

thats fine,

How do i do that?

 

[theDBguy]

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]

sorry but how would i remove the sensitive data?

I am completely new to this lol

 

[theDBguy]

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]

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]

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]

copy of the front end

 

[Mikeb185]

sorry now attached

 

[theDBguy]

sorry now attached

Hi. Thanks! What's the name of the form with the problem?

 

[Mikeb185]

view purchase orders

 

[theDBguy]

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]

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:

        .FindFirst "[CompanyName] = " & Chr(34) Me![FindSupplier] & Chr(34)

The reason for that is it's missing an ampersand like so:

        .FindFirst "[CompanyName] = " & Chr(34) [b]&[/b] Me![FindSupplier] & Chr(34)

 

[Mikeb185]

try this one

 

[theDBguy]

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]

can you send me a screen shot of what you see when you open the database i sent please?

 

[theDBguy]

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.

 

[Mikeb185]

how do i pull up the code of the combo box to change it as suggested?

 

[theDBguy]

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.