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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sub Forms



 
 
Thread Tools Display Modes
  #11  
Old May 25th, 2010, 04:06 PM posted to microsoft.public.access.gettingstarted
Aria via AccessMonster.com
external usenet poster
 
Posts: 19
Default Sub Forms

Ken,
smile You’re always helpful and provide useful information. I read a post
that said the termination of the Microsoft newsgroups would affect 3rd party
sites. I thought this would include Access Monster. I hope it doesn’t. Thank
you so much for the information and the links. While I’m not particularly
enamored with the MS forum to date, there’s always the hope that it will turn
out better than expected.


KenSheridan wrote:
Aria:

You don't need to use a newsreader if you prefer a web-based interface as
there are a number of the latter which will enable you to access the comp.
databases.ms-access newsgroup to which Larry referred. I've only just
realised that this is what the 'General 1' section does in AccessMonster,
which I'm using at the moment to access this group. Its other sections
access this newsgroup. I'm assuming that it will continue to operate after
this newsgroup is consigned to the dustbin of history. You can find it at:

http://www.accessmonster.com

Its free to use and setting up an account is only a few minutes work.

Google Groups is another web-based option which seems to be quite popular,
though I'm not too enamoured of it myself. You'll find the comp.databases.ms-
access group at:

http://groups.google.com/group/comp....-access/topics

I'm sure you'll find most of the names you've become familiar with here at
comp.databases.ms-access in the near future if not already, and there will be
no diminution in the level of help you'll receive. From the evidence to date
the new MS forums don't look promising.

Ken Sheridan
Stafford, England

Well, maybe I shouldn’t jump in here but I’ve been concerned ever since I
read the posts regarding the termination of these newsgroups. I’m really sad

[quoted text clipped - 14 lines]
of social.answers.microsoft.com -- nothing like the number of newsgroups has
been discussed, AFAIK.


--
Message posted via http://www.accessmonster.com

  #12  
Old May 25th, 2010, 07:10 PM posted to microsoft.public.access.gettingstarted
KenSheridan via AccessMonster.com
external usenet poster
 
Posts: 1,610
Default Sub Forms

Aria:

The sections in AccessMonster for this forum will obviously no longer be
available, but I hope the 'General 1' section which accesses the comp.
databases.ms-access newsgroup will still be functioning. It would then be
its only section of course. If not, the Google reader will still be
available for accessing the comp.databases.ms-access group, as it is a
general purpose web-based newsreader unlike AccessMonster.

I'm not optimistic about the MS forum.

There is also Utter Access: I did try it for a while, but its not to my taste.


Ken Sheridan
Stafford, England

Aria wrote:
Ken,
smile You’re always helpful and provide useful information. I read a post
that said the termination of the Microsoft newsgroups would affect 3rd party
sites. I thought this would include Access Monster. I hope it doesn’t. Thank
you so much for the information and the links. While I’m not particularly
enamored with the MS forum to date, there’s always the hope that it will turn
out better than expected.

Aria:

[quoted text clipped - 29 lines]
of social.answers.microsoft.com -- nothing like the number of newsgroups has
been discussed, AFAIK.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201005/1

  #13  
Old May 27th, 2010, 10:02 PM posted to microsoft.public.access.gettingstarted
Ray C
external usenet poster
 
Posts: 215
Default Sub Forms

Hi Ken
Access bing Access, I was probably a little premature in my excitement at
getting the thing to work.
I now have a dialogue box that pops up as Access is first opening up and
prior to the first screen being displayed saying
"The exprexssion is typed incorrectly or is too complicated, For example, a
numeric expression may containtoo many complicated elemements. Try
simplifying the expression by assigning parts of the expression to variables."
If I OK that, the first forms opens up and the database seems to work OK
from there on in.
Incidentally, if I completely remove the "Text Boxes" and the Dlookup
formula that you suggest, I still get the error message on opening.
Could you throw any light on the reason for this?

"Ray C" wrote:


Yipppppeeee !!! Great. Smashin. Fabulous. Magic our Mourice. Tha Reet Up our
Street kid.

Seriously Ken, Thank you so much, I would never have got there without your
invaluable help. The Text Box with the DLookUp has done the trick and I will
spent the next few days reading the whole content of your post and trying to
work out why they did not work for me.

I don't know what we are going to do now that Microsoft look as though they
are closing this forum.

Many thanks anyway.

Regards Ray C


"KenSheridan via AccessMonster.com" wrote:

The combo box needs to be bound to the Supplier Number column in the
subform's underlying table or query. But if you want a text box then you can
either do as I originally advised and as the subform's RecordSource property
use a query which joins the Suppliers table to the Customers table and bind
the text box to the Supplier Name column, or use an unbound text box whose
ControlSource is an expression which calls the DLookup function:

=DLookup("[Supplier Name]", "[Suppliers]", "[Supplier Number] = " & [Supplier
Number 1])

or if Supplier nuber is a text data type rather than a number;

=DLookup("[Supplier Name]", "[Suppliers]", "[Supplier Number] = """ &
[Supplier Number 1] & """")

I've called the column in the subform's underlying table Supplier Number 1 in
this instance as you said you have three columns each referencing the
Suppliers table, so you'd do the same with each. This also means that if you
do use a query to pull in the supplier names the joins would probably have to
be LEFT OUTER JOINS to allow for a Null in any of the three columns.

The fact that you have three columns referencing Suppliers does suggest
however that the logical model is flawed. What you seem to be doing here is
representing different attributes of the relationship type (the type of
service provided in your case) between Customers and Suppliers as column
headings in Customers. Attributes are data, and data should only be stored
as explicit values at column positions in rows in tables. This was Codd's
Rule 1 (the Information Rule) when he first proposed the database relational
model back in 1970. The way to model this relationship would be as a table
with foreign key columns referencing the primary keys of Customers and
Suppliers, and a third column representing the nature of the realtionship.
This third column would also be a foreign key, in this case referencing a
table of the different types of relationship (i.e. the services) between
customers suppliers. The relationship type is therefore a ternary one
between the three entity types. So a customer with all three types of
relationship to suppliers would be represented as three rows in this table,
each with the same customer number, different values in the service type
column and either the same or different values in the supplier depending on
whether the services to that customer are provided by the same or different
suppliers. If a customer cannot receive the same service from more than one
supplier at any one point in time this should be enforced by means of a
unique index on the Supplier number and service type columns, in combination,
not individually.

Ken Sheridan
Stafford, England

--
Message posted via http://www.accessmonster.com

.

  #14  
Old May 27th, 2010, 10:28 PM posted to microsoft.public.access.gettingstarted
KenSheridan via AccessMonster.com
external usenet poster
 
Posts: 1,610
Default Sub Forms

It sounds like it's not the text box's expression that's the problem, but
something else. Without being able to do any hands-on debugging, however, I
can't hazard a guess as to what it might be.

Ken Sheridan
Stafford, England

Ray C wrote:
Hi Ken
Access bing Access, I was probably a little premature in my excitement at
getting the thing to work.
I now have a dialogue box that pops up as Access is first opening up and
prior to the first screen being displayed saying
"The exprexssion is typed incorrectly or is too complicated, For example, a
numeric expression may containtoo many complicated elemements. Try
simplifying the expression by assigning parts of the expression to variables."
If I OK that, the first forms opens up and the database seems to work OK
from there on in.
Incidentally, if I completely remove the "Text Boxes" and the Dlookup
formula that you suggest, I still get the error message on opening.
Could you throw any light on the reason for this?

Yipppppeeee !!! Great. Smashin. Fabulous. Magic our Mourice. Tha Reet Up our
Street kid.

[quoted text clipped - 57 lines]
Ken Sheridan
Stafford, England


--
Message posted via http://www.accessmonster.com

  #15  
Old May 29th, 2010, 04:48 AM posted to microsoft.public.access.gettingstarted
Larry Linson
external usenet poster
 
Posts: 3,112
Default Sub Forms

Microsoft cannot "end these newsgroups"; Microsoft can remove their servers
from the Internet, so you will have to find a new server. Microsoft can also
send an "authenticated something-or-other" to other servers requesting they
no longer carry these groups, but few news servers follow those directives,
I hear, because they have wreaked havoc in the past when forged.

I'll be moving the microsoft.public.access groups that I follow to my new
news server and hope they will not remove the groups.

So, except for the minimal trouble of changing news servers if you read
these groups at "news.microsoft.com" and the fact that the microsoft website
will no longer direct you to the groups or to their UI for the groups, you
may not see all that much drop-off of activity in the microsoft.public
newsgroups. There are some USENET newsgroups that were "officially replaced
by others broken down by subject" around 15 years ago that are still hanging
on in some servers -- comp.lang.basic.visual, for example.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"Aria via AccessMonster.com" u44643@uwe wrote in message
news:a88960101e312@uwe...
Ken,
smile You're always helpful and provide useful information. I read a
post
that said the termination of the Microsoft newsgroups would affect 3rd
party
sites. I thought this would include Access Monster. I hope it doesn't.
Thank
you so much for the information and the links. While I'm not particularly
enamored with the MS forum to date, there's always the hope that it will
turn
out better than expected.


KenSheridan wrote:
Aria:

You don't need to use a newsreader if you prefer a web-based interface as
there are a number of the latter which will enable you to access the comp.
databases.ms-access newsgroup to which Larry referred. I've only just
realised that this is what the 'General 1' section does in AccessMonster,
which I'm using at the moment to access this group. Its other sections
access this newsgroup. I'm assuming that it will continue to operate
after
this newsgroup is consigned to the dustbin of history. You can find it
at:

http://www.accessmonster.com

Its free to use and setting up an account is only a few minutes work.

Google Groups is another web-based option which seems to be quite popular,
though I'm not too enamoured of it myself. You'll find the
comp.databases.ms-
access group at:

http://groups.google.com/group/comp....-access/topics

I'm sure you'll find most of the names you've become familiar with here at
comp.databases.ms-access in the near future if not already, and there will
be
no diminution in the level of help you'll receive. From the evidence to
date
the new MS forums don't look promising.

Ken Sheridan
Stafford, England

Well, maybe I shouldn't jump in here but I've been concerned ever since I
read the posts regarding the termination of these newsgroups. I'm really
sad

[quoted text clipped - 14 lines]
of social.answers.microsoft.com -- nothing like the number of newsgroups
has
been discussed, AFAIK.


--
Message posted via http://www.accessmonster.com



  #16  
Old May 29th, 2010, 08:30 AM posted to microsoft.public.access.gettingstarted
Ray C
external usenet poster
 
Posts: 215
Default Sub Forms

Hi Ken
Thanks for your advice.and help anyway.

Regards Ray C

"KenSheridan via AccessMonster.com" wrote:

It sounds like it's not the text box's expression that's the problem, but
something else. Without being able to do any hands-on debugging, however, I
can't hazard a guess as to what it might be.

Ken Sheridan
Stafford, England

Ray C wrote:
Hi Ken
Access bing Access, I was probably a little premature in my excitement at
getting the thing to work.
I now have a dialogue box that pops up as Access is first opening up and
prior to the first screen being displayed saying
"The exprexssion is typed incorrectly or is too complicated, For example, a
numeric expression may containtoo many complicated elemements. Try
simplifying the expression by assigning parts of the expression to variables."
If I OK that, the first forms opens up and the database seems to work OK
from there on in.
Incidentally, if I completely remove the "Text Boxes" and the Dlookup
formula that you suggest, I still get the error message on opening.
Could you throw any light on the reason for this?

Yipppppeeee !!! Great. Smashin. Fabulous. Magic our Mourice. Tha Reet Up our
Street kid.

[quoted text clipped - 57 lines]
Ken Sheridan
Stafford, England


--
Message posted via http://www.accessmonster.com

.

 




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 10:31 PM.


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