A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

What am I doing wrong



 
 
Thread Tools Display Modes
  #1  
Old January 25th, 2010, 04:11 PM posted to microsoft.public.access.forms
SteveAman
external usenet poster
 
Posts: 2
Default What am I doing wrong

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

  #2  
Old January 25th, 2010, 04:56 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default What am I doing wrong

"SteveAman" u57757@uwe wrote in message news:a2a4ad7c7f855@uwe...
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.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

  #3  
Old January 25th, 2010, 06:14 PM posted to microsoft.public.access.forms
SteveAman
external usenet poster
 
Posts: 2
Default What am I doing wrong

Dirk Goldgar wrote:
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

  #4  
Old January 25th, 2010, 06:24 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default What am I doing wrong

"SteveAman" u57757@uwe wrote in message news:a2a5c1f224bf4@uwe...
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.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

  #5  
Old January 26th, 2010, 12:48 AM posted to microsoft.public.access.forms
Bob Quintal
external usenet poster
 
Posts: 939
Default What am I doing wrong

"SteveAman" u57757@uwe wrote in news:a2a5c1f224bf4@uwe:

Dirk Goldgar wrote:
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.


--
Bob Quintal

PA is y I've altered my email address.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.