What am I doing wrong

S

SteveAman

I have been building access header forms with Subforms for over a decade now,
for some reason, in Access 2007 I get the following error
"The LinkMasterfields property setting has produced the following error:
"The Object Doesn't contain the Automation object "Section" when trying to
enter a new record into the subform.

(Section is the field in the parent table and the detail table that I have
tying the two tabels/forms together (Many sub-sections for a single section
identified by section, pretty basic stuff). What am I doing wrong?

Steve from Maine
 
D

Dirk Goldgar

SteveAman said:
I have been building access header forms with Subforms for over a decade
now,
for some reason, in Access 2007 I get the following error
"The LinkMasterfields property setting has produced the following error:
"The Object Doesn't contain the Automation object "Section" when trying to
enter a new record into the subform.

(Section is the field in the parent table and the detail table that I have
tying the two tabels/forms together (Many sub-sections for a single
section
identified by section, pretty basic stuff). What am I doing wrong?


I'm not sure, Steve, but "Section" is the name of an Access property (and
object), so maybe it's the name itself that is confusing things. You could
try changing that field name and see if that makes it work.
 
S

SteveAman

Dirk said:
I have been building access header forms with Subforms for over a decade
now,
[quoted text clipped - 7 lines]
section
identified by section, pretty basic stuff). What am I doing wrong?

I'm not sure, Steve, but "Section" is the name of an Access property (and
object), so maybe it's the name itself that is confusing things. You could
try changing that field name and see if that makes it work.
Dirk, you are the man!! That was it. I renamed my field callled Section to
(CStection!!) and it got rid of the error, if course I had to replace Section
in about a hundred lines of code and on many screen, but it worked and was
worth it!. Go fiqure "Section" is a reserved word!

thanks so much, You wouldn't know how to merge multiple pdf files within a
directory to one pdf would you?(In Code)

Steve
 
D

Dirk Goldgar

SteveAman said:
thanks so much,

You're welcome.
You wouldn't know how to merge multiple pdf files within a
directory to one pdf would you?(In Code)

Acrobat (full version) can do it manually, and maybe can be automated, but
also there are a number of PDF-merge utilities out there. I'll bet there's
at least one that can either be automated or can be executed with
command-line options to do the job -- and if a utility can be run via the
command-line, then you can use the Shell function to run it.
 
B

Bob Quintal

SteveAman said:
Dirk said:
I have been building access header forms with Subforms for over a
decade now,
[quoted text clipped - 7 lines]
section
identified by section, pretty basic stuff). What am I doing
wrong?

I'm not sure, Steve, but "Section" is the name of an Access
property (and object), so maybe it's the name itself that is
confusing things. You could try changing that field name and see
if that makes it work.
Dirk, you are the man!! That was it. I renamed my field callled
Section to (CStection!!) and it got rid of the error, if course I
had to replace Section in about a hundred lines of code and on
many screen, but it worked and was worth it!. Go fiqure "Section"
is a reserved word!

thanks so much, You wouldn't know how to merge multiple pdf files
within a directory to one pdf would you?(In Code)

Steve
Stephen Lebans has a tool to create and manipulate .pdf files
http://www.lebans.com/reporttopdf.htm

One function supplied is MergePDFDocuments(sMaster, sChild)

Just loop through the directory, adding one file at a time to the
master.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top