Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-18-2019, 11:39 AM   #31
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,687
Thanks: 50
Thanked 1,078 Times in 1,059 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Help with converting database from 2003 to 2010

Quote:
Originally Posted by Mikeb185 View Post
sorry now attached
Hi. Thanks! What's the name of the form with the problem?

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-18-2019, 11:40 AM   #32
Mikeb185
Newly Registered User
 
Join Date: Sep 2019
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Mikeb185 is on a distinguished road
Re: Help with converting database from 2003 to 2010

view purchase orders
Mikeb185 is offline   Reply With Quote
Old 09-18-2019, 11:42 AM   #33
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,687
Thanks: 50
Thanked 1,078 Times in 1,059 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Help with converting database from 2003 to 2010

Quote:
Originally Posted by Mikeb185 View Post
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.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-18-2019, 11:44 AM   #34
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,687
Thanks: 50
Thanked 1,078 Times in 1,059 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Help with converting database from 2003 to 2010

Quote:
Originally Posted by theDBguy View Post
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) & Me![FindSupplier] & Chr(34)
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-18-2019, 11:48 AM   #35
Mikeb185
Newly Registered User
 
Join Date: Sep 2019
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Mikeb185 is on a distinguished road
Re: Help with converting database from 2003 to 2010

try this one
Attached Files
File Type: zip database.zip (351.6 KB, 4 views)
Mikeb185 is offline   Reply With Quote
Old 09-18-2019, 11:53 AM   #36
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,687
Thanks: 50
Thanked 1,078 Times in 1,059 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Help with converting database from 2003 to 2010

Quote:
Originally Posted by Mikeb185 View Post
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.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-18-2019, 12:01 PM   #37
Mikeb185
Newly Registered User
 
Join Date: Sep 2019
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Mikeb185 is on a distinguished road
Re: Help with converting database from 2003 to 2010

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

Mikeb185 is offline   Reply With Quote
Old 09-18-2019, 12:07 PM   #38
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,687
Thanks: 50
Thanked 1,078 Times in 1,059 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Help with converting database from 2003 to 2010

Quote:
Originally Posted by Mikeb185 View Post
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.


Attached Images
File Type: png db.PNG (89.5 KB, 53 views)
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-18-2019, 12:15 PM   #39
Mikeb185
Newly Registered User
 
Join Date: Sep 2019
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Mikeb185 is on a distinguished road
Re: Help with converting database from 2003 to 2010

how do i pull up the code of the combo box to change it as suggested?
Mikeb185 is offline   Reply With Quote
Old 09-18-2019, 12:20 PM   #40
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,687
Thanks: 50
Thanked 1,078 Times in 1,059 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Help with converting database from 2003 to 2010

Quote:
Originally Posted by Mikeb185 View Post
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.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-18-2019, 12:28 PM   #41
Mikeb185
Newly Registered User
 
Join Date: Sep 2019
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Mikeb185 is on a distinguished road
Re: Help with converting database from 2003 to 2010

When i click the ... it doesnt give me an option to change the code
Attached Images
File Type: jpg Untitled.jpg (103.3 KB, 3 views)
Mikeb185 is offline   Reply With Quote
Old 09-18-2019, 12:29 PM   #42
Mikeb185
Newly Registered User
 
Join Date: Sep 2019
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Mikeb185 is on a distinguished road
Re: Help with converting database from 2003 to 2010

it goes straight to this
Attached Images
File Type: png Untitled.png (78.3 KB, 4 views)
Mikeb185 is offline   Reply With Quote
Old 09-18-2019, 12:32 PM   #43
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,687
Thanks: 50
Thanked 1,078 Times in 1,059 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Help with converting database from 2003 to 2010

Quote:
Originally Posted by Mikeb185 View Post
it goes straight to this
Right, that's where you would change the code. What is the name of this form, so I could give it a try on my end as well?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 09-18-2019, 12:35 PM   #44
Mikeb185
Newly Registered User
 
Join Date: Sep 2019
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Mikeb185 is on a distinguished road
Re: Help with converting database from 2003 to 2010

find supplier
Mikeb185 is offline   Reply With Quote
Old 09-18-2019, 12:39 PM   #45
theDBguy
I知 here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,687
Thanks: 50
Thanked 1,078 Times in 1,059 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Help with converting database from 2003 to 2010

Quote:
Originally Posted by Mikeb185 View Post
find supplier
Sorry, I don't see any form with that name either.


Attached Images
File Type: png supplier.PNG (77.6 KB, 35 views)

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Converting an Access 2010 database to Excel molsen General 6 05-26-2015 06:33 AM
Converting 2003 to 2010 wilpeter General 14 05-17-2013 10:27 AM
Converting Access 2010 to 2003 Ani General 0 06-08-2012 06:08 AM
problem converting 2003 to 2010 baghian364 General 2 07-03-2011 02:14 AM
Need help with VBA, after converting from 2003 to 2010 problem with finding data hawaiianwarrior Modules & VBA 4 04-07-2011 12:35 PM




All times are GMT -8. The time now is 07:21 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World