Prev: Rounding Time
Next: Crunch numbers with MS Access: is this possible?
From: Aria via AccessMonster.com on 25 May 2010 11:06
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.databases.ms-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

From: KenSheridan via AccessMonster.com on 25 May 2010 14:10
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/Forums.aspx/access-gettingstarted/201005/1

From: Ray C on 27 May 2010 17:02
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
> >
> > .
> >
From: KenSheridan via AccessMonster.com on 27 May 2010 17:28
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

From: Larry Linson on 28 May 2010 23:48
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(a)uwe> wrote in message
news:a88960101e312(a)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.databases.ms-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
>


First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: Rounding Time
Next: Crunch numbers with MS Access: is this possible?