Upgrade to 2007 breaks form link

  • Thread starter Thread starter David Teich
  • Start date Start date
D

David Teich

I finally upgraded to 2007 from 2003. I have a simple database to track
books, movies, etc.

Each type of media has an overview form listing all the database items.
Within an item, I could click the "detail" button and the info on the active
line would pop up in a new window. Now, with 2007, that code does nothing.

The code reads:
Private Sub Show_Detail_Click()
On Error GoTo Err_Show_Detail_Click

Dim stDocName As String

stDocName = "Book Detail"
stLinkCriteria = "[BookID]=" & Me![BookID]

DoCmd.OpenForm stDocName, , , stLinkCriteria


What changed in 2007 that broke that?
 
Is the folder that the database in trusted?
A lot of things don't work in 2007 in untrusted folders.
 
"Trusted"?? Is that a Vista thing?

Sorry, I forgot to mention I'm on XP SP3. I've dealt with folder properties
a lot and I don't remember seeing "trusted" as an option.

thanx,
David

Mike Painter said:
Is the folder that the database in trusted?
A lot of things don't work in 2007 in untrusted folders.
David said:
I finally upgraded to 2007 from 2003. I have a simple database to
track books, movies, etc.

Each type of media has an overview form listing all the database
items. Within an item, I could click the "detail" button and the info
on the active line would pop up in a new window. Now, with 2007, that
code does nothing.

The code reads:
Private Sub Show_Detail_Click()
On Error GoTo Err_Show_Detail_Click

Dim stDocName As String

stDocName = "Book Detail"
stLinkCriteria = "[BookID]=" & Me![BookID]

DoCmd.OpenForm stDocName, , , stLinkCriteria


What changed in 2007 that broke that?
Click to expand...
Click to expand...
 
No, it's an Access 2007 thing (probably Office 2007)

Click on:
a.. Office Button (top left)
b.. Access Options (bottom of dialog)
c.. Trust Center (left)
d.. Trust Center Settings (button)
e.. Trusted Locations (left)
f.. Add new location (button)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


David Teich said:
"Trusted"?? Is that a Vista thing?

Sorry, I forgot to mention I'm on XP SP3. I've dealt with folder
properties
a lot and I don't remember seeing "trusted" as an option.

thanx,
David

Mike Painter said:
Is the folder that the database in trusted?
A lot of things don't work in 2007 in untrusted folders.
David said:
I finally upgraded to 2007 from 2003. I have a simple database to
track books, movies, etc.

Each type of media has an overview form listing all the database
items. Within an item, I could click the "detail" button and the info
on the active line would pop up in a new window. Now, with 2007, that
code does nothing.

The code reads:
Private Sub Show_Detail_Click()
On Error GoTo Err_Show_Detail_Click

Dim stDocName As String

stDocName = "Book Detail"
stLinkCriteria = "[BookID]=" & Me![BookID]

DoCmd.OpenForm stDocName, , , stLinkCriteria


What changed in 2007 that broke that?
Click to expand...
Click to expand...
Click to expand...
 
Thanx, that is new. Sadly, that didn't work. Forms still not popping up from
other forms though I've added the directory to Trusted.

David

Douglas J. Steele said:
No, it's an Access 2007 thing (probably Office 2007)

Click on:
a.. Office Button (top left)
b.. Access Options (bottom of dialog)
c.. Trust Center (left)
d.. Trust Center Settings (button)
e.. Trusted Locations (left)
f.. Add new location (button)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


David Teich said:
"Trusted"?? Is that a Vista thing?

Sorry, I forgot to mention I'm on XP SP3. I've dealt with folder
properties
a lot and I don't remember seeing "trusted" as an option.

thanx,
David

Mike Painter said:
Is the folder that the database in trusted?
A lot of things don't work in 2007 in untrusted folders.
David Teich wrote:
I finally upgraded to 2007 from 2003. I have a simple database to
track books, movies, etc.

Each type of media has an overview form listing all the database
items. Within an item, I could click the "detail" button and the info
on the active line would pop up in a new window. Now, with 2007, that
code does nothing.

The code reads:
Private Sub Show_Detail_Click()
On Error GoTo Err_Show_Detail_Click

Dim stDocName As String

stDocName = "Book Detail"
stLinkCriteria = "[BookID]=" & Me![BookID]

DoCmd.OpenForm stDocName, , , stLinkCriteria


What changed in 2007 that broke that?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top