Conversion from 2007 to 2013 help!!

Preface:
-I'm fairly new to Access
-I am utilizing parts of a database that were created by someone else
-I am going from Access 2007 to Access 2013
-I am driving myself insane. :banghead:

What I'm working with:
-I have a form that is being used to collect a crazy amount of data.
-within that from are tabs to differentiate each data set: aka- 1 month data, 2 month data, 3 month data, etc... all for one record at a time.
-On the top of the 2007 form is a 'go to' drop down box that allows me to select a contact, and once one is selected it transmits all the information down onto the form so that the data can be added, changed, etc... and also changes the name at the to of the form so that the person entering data can see the record they are working on.

My problems:
1) When I first pull up the form:
'The LinkMasterFields property setting has produced this error: Expected:End of Statement'
I just hit ok a bunch of times and it brings up the form.

2) The GoTo box isn't functioning. It will ask for a Form!ID (which it never did before) I can select OK and it will show me the dropdown and let me select one, but will not change any of the data.

2) the Name field at the top is not functioning at all.




That's what the form looks like.



This is the macro that is in the 'After update' section in the go to fields properties



this is the macro that is in the 'On Got Focus' section in the go to fields properties


I am at a loss. I have looked and fiddled and I am clueless as to how to get this to work in 2013 when it worked just fine in 2007. GRRRRRRRR. ANY help would be very much appreciated, as I am kindof at a stand still until I can get this working...

Thank you!
Kelly

Because of your situation, with you using bits and pieces of someone else's work, done in 2007 and now being used in 2013, the first thing that comes to mind is that the Folder holding the Field hasn't been declared as 'trusted.'

To allow b]Code[/b] to run in 2007/2010/2013 you need to declare the Folder as 'Trusted.'

To trust your folder, in 2007/2010, you'd click:

1. Office Button (top left)
2. Access Options (bottom of dialog)
3. Trust Center (left)
4. Trust Center Settings (button) on far right
5. Trusted Locations (left)
6. Add new location (button)
7. Enter Folder Name
8. Click on Okay

I assume that the same instructions would hold for 2013. My guess is that you've taken a copy of the original File and placed it on a Folder on your machine. IF so, tend to this, first, and see what happens.

Of course, it could have to do with you only 'utilizing parts' of the original, or possibly both! But make sure that the Folder is 'trusted' and we can go from there.

Linq ;0)>

Thank you for the reply! I made the folder a trusted folder and still no dice .

As far as the 'using parts of another database' goes, when I complied it in 2007 last year I was using parts of an old database. It has been functioning fine in 2007 for about a year now. (my reason for explaining this was so that everyone knows that I did not write all the codes, thus I don't have an intricate knowledge of them all)

I got a new laptop and with it got Office 2013. Now that I open the Access database in 2013 it is throwing up errors. I appreciate the help

Kelly

Well, that had to be done, regardless, so it wasn't wasted time! OK, the bit about a new laptop with new Access brings up something else!

When apps run fine on one machine and not on another, or run fine in one version and not when run under a newer version, one the first things you have to think about are Missing References.

If you haven't checked for this kind of thing before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

Access Reference Problems

Linq ;0)>

I just went in and did each step described in the article. There were no missing references but I went ahead and followed the steps anyhow. Still nothing. Atleast I know the references are good now I have the 2007 version up on one CPU and the 2013 on my laptop and I compared the references. The only difference is in the 12.0 versus 15.0 versions on the Microsoft items.

kjshearon said:

I just went in and did each step described in the article. There were no missing references but I went ahead and followed the steps anyhow. Still nothing. Atleast I know the references are good now I have the 2007 version up on one CPU and the 2013 on my laptop and I compared the references. The only difference is in the 12.0 versus 15.0 versions on the Microsoft items.

Click to expand...

Can you go into the VBA window and then to DEBUG > COMPILE and see if any errors are thrown?

I COULD KISS YOU ON THE MOUTH!! I think I just scared everyone in my office from jumping up in excitement. lol There was a code that was in there that shouldn't have been!!!!!!! THANK YOU THANK YOU THANK YOU!!! You are the bomb.com!