By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,709 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,709 IT Pros & Developers. It's quick & easy.

what is the difference between attributes and properties in things like fields?

P: n/a
Greetings once more,

I was wondering if someone figured out the difference between attributes and
properties.

I noticed that things like fields have a number of properties, but also
attributes.

For example, right now, I am looking for the rowsource property for a field
in a table. How do I find that?

Thank you

Nicolaas
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.698 / Virus Database: 455 - Release Date: 02/06/2004
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
The only thing I can think of that would need a RowSource in a table would
be a lookup field defined in the table. While this functionallity exists, I
recommend that you avoid it. It essentially places a combobox into your
table so that when you look at the table, the value you see if from the
lookup field, not the value actually stored in the table. This can get
confusing and cause problems later with wrong data types and such because
you're looking at the wrong thing. Tables are just for storing data, do work
such as lookups on a form. For more of an explanation on this and some other
quick tips, follow the link below.

http://www.mvps.org/access/tencommandments.htm

--
Wayne Morgan
MS Access MVP
"WindAndWaves" <ac****@ngaru.com> wrote in message
news:xG******************@news.xtra.co.nz...
Greetings once more,

I was wondering if someone figured out the difference between attributes and properties.

I noticed that things like fields have a number of properties, but also
attributes.

For example, right now, I am looking for the rowsource property for a field in a table. How do I find that?

Thank you

Nicolaas
---
Please immediately let us know (by phone or return email) if (a) this email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.698 / Virus Database: 455 - Release Date: 02/06/2004

Nov 13 '05 #2

P: n/a
Hi Nicolaas,

If you are perusing Lookup Fields in tables, DON'T! They are an abomination
and should never be used! If you use them they will lead you into trouble.
You only find the troubles as you are enhancing your initial design. Then
you have to go back and take out the Lookup Fields and put in the proper
fields and then you get to chase down all of the code that referred to the
old fields and deal with it ...

At some point overstressing distinctions and definitions leads right back
into Humpty Dumpty speak: "When I use a word it means just what I want it
to mean".

Use your MS Bookshelf dictionary or get out your Cambridge Unabridged,
Merriam Webster or other monster lex and I'm sure you'll find some
definitions almost interchangeable amongst attribute, property and
characteristic. I realize that you're trying hard to grasp everything at
once and resolve all ambiguities forever. Good Luck! Software types
develop their own terminology and jargon. However, we don't always invent
new words, we usually use words already in the language but restrict their
meanings to "what WE mean". :-) Try to absorb the meanings of things as
they are intended and recognize that you are being changed in the process.
Lest we get too proud, it has been pointed out that jargon and buzzwords are
much like bird calls: they serve more to identify members of the species
than to convey useful information.

Hope That Helps

--
-Larry-
--

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:xG******************@news.xtra.co.nz...
Greetings once more,

I was wondering if someone figured out the difference between attributes and properties.

I noticed that things like fields have a number of properties, but also
attributes.

For example, right now, I am looking for the rowsource property for a field in a table. How do I find that?

Thank you

Nicolaas
---
Please immediately let us know (by phone or return email) if (a) this email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.698 / Virus Database: 455 - Release Date: 02/06/2004

Nov 13 '05 #3

P: n/a
Hey guys,

Thank you for the warnings. The reason I actually wanted to find out about
the rowsource is so that I could make sure that they were taken out.

Having said that, I sometimes put a rowsource in at the beginning of
development so that I can quickly edit data in a table. In the end, I will
then take them out before deployment.

I am talking not about 'data' tables here, but about little tables that help
in running the database.

-Nicolaas
Anyway, i will now make 100% sure that they are all out.
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 06/06/2004
Nov 13 '05 #4

P: n/a
very funny story about the birds. lol
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 06/06/2004
Nov 13 '05 #5

P: n/a
"WindAndWaves" <ac****@ngaru.com> wrote in
news:xG******************@news.xtra.co.nz:
Greetings once more,

I was wondering if someone figured out the difference between attributes
and properties.


Typically attributes are bit values, 0, 1, 2, 4, 8 etc expressed in hex
(base 16); 128 becomes &H80 (8 sixteens and zero ones). They are either
true, 1, or false, 0. They have their own special "arithmetic" using
logical operators for setting them on and off and, by extension, combining
them. For example the hidden file attribute in VBA is 2, while the system
attribute is 4. If a file is both hidden and system then both its two flag
and the four flag are up. We don't however know that its attributes = 6, as
there may be other attributes turned on (flags up). Is the file's readonly
attribute also set? We test with Attributes And 1 (the readonly attribute).
If Attributes And 1 = 1 then the readonly is set, if zero then no. The
attribute names we use are simply constants for 0, 1, 2 etc. For example
vbReadOnly is simple a constant equalling 1.

Properties are likely to be values whose range is coincident with that of
their type. They are generally independent of each other.

--
Lyle
(for e-mail refer to http://ffdba.com/)
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.