|
More site info...
www.microsoft.com/communities/newsgroups/list/e... - www.microsoft.com/communities/newsgroups... | Site profile
|
|
Site profile page for http://www.microsoft.com/communities/newsgroups....
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups....
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.microsoft.com/communities/newsgroups... is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
30
|
107
|
326
|
|
Post:
|
69
|
256
|
926
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign (http://www.microsoft.com/communities/newsgroups...)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign Alexa graph:
|
Top authors on www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign during last week:
user's latest post:
How big a record size is too big...
Published (2009-11-24 09:25:00)
Dennis Use Access HELP and check "specifications". I believe you'll find that the max record length in Access is 2K. That said, a record with that much data may result from a less-than-well-normalized table structure. If you'll describe more specifically what data you are trying to store in your table(s), folks here may be able to offer more specific suggestions. By the way, 10,000 records is a pittance...
user's latest post:
How do I link one person to...
Published (2009-11-24 14:04:00)
Use an Autonumber field as primary key field in the Contacts table. If the known contacts are only one way like employes to supervisor add a number - long integer field also as Supervisor. Then in the relations window add the Contacts table twice (Access will add a sufix, Contacts_1 to the second instance). Create a one-to-many from first table primary key field to the Supervisor field of the second (many employes can have the same...
user's latest post:
changing info layout in...
Published (2009-11-26 12:05:00)
On Thu, 26 Nov 2009 04:05:01 -0800, Bob Mansell <BobMansell@discussions.microsoft.com> wrote: Perhaps this will help: http://www.mvps.org/access/modules/mdl0004.htm -Tom. Microsoft Access MVP >This is the third time I've tried to post this but it never appears. > >I'm new to Access but have managed to compile a database that mostly suits >my needs. > >My one problem...
Coco111 via AccessMonster.com
3
user's latest post:
Hiding zero values in report in...
Published (2009-11-18 05:35:00)
Sorry I dont get it....in SQL see as below:- SELECT Products.ID AS [Product ID], Products.[Product Name], Products. [Product Code], Nz([Quantity Purchased],0) AS [Qty Purchased], Nz([Quantity Sold],0) AS [Qty Sold], Nz([Quantity On Hold],0) AS [Qty On Hold], [Qty Purchased]-[Qty Sold] AS [Qty On Hand], [Qty Purchased]-[Qty Sold]-[Qty On Hold] AS [Qty Available], Nz([Quantity On Order],0) AS [Qty On Order], Nz( [Quantity On Back...
BruceM via AccessMonster.com
3
user's latest post:
Hiding zero values in report in...
Published (2009-11-18 08:55:00)
It doesn't look like anything in my copy of Northwind (Access 2003). I don't see where you specified a criteria. You need something like this at the end: WHERE ([Quantity Purchased]-[Quantity Sold]) > 0 Was this query showing the correct data (other than showing 0 where you didn't want it)? Coco111 wrote: >Sorry I dont get it....in SQL see as below:- > >SELECT Products.ID AS [Product ID],...
user's latest post:
Classification and the role of...
Published (2009-11-23 14:37:00)
A good way to impress people about you being great folks to do business with & who will follow good business practices is to violate and abuse this forum by putting spam into it. So they can respond by getting you and your phone number blacklisted.
user's latest post:
How do I link one person to...
Published (2009-11-24 14:25:00)
E289, Try creating using a Query based on that table and use the Query as the RowSource in the Combo Box on your form.
user's latest post:
want to save the record number...
Published (2009-11-24 19:40:00)
On Tue, 24 Nov 2009 10:33:03 -0800, fransquest <fransquest@discussions.microsoft.com> wrote: >This shold be simple, but I can't find and info on it. When starting a new >record I would like to populate a field with the record number and save it in >in the table. What do YOU mean by "a record number"? Access doesn't have record numbers, so you'll need to implement...
user's latest post:
new db with 25 items w/...
Published (2009-11-26 19:17:00)
Thank you John, This helps. I have re-look at my data, although I feel I'm not setting this up correctly. I will continue testing some more and hope to come up with a workable db soon. Thanks again. "John_G via AccessMonster.com" wrote: > Hi - > > From the example data you have shown it looks as if the 5 "items" all refer > to (or are properties of) the same thing...
user's latest post:
Your Input and link record to...
Published (2009-11-18 16:08:00)
Thank you Karl, that is some great advice. I followed it to the "T". I still have one more question if its not too much to ask. I am not having any success getting the combo box to display the different activity types using the combo box wizard. Do you have any recommendations. "KARL DEWEY" wrote: > One table (maybe two, see below). > tblActivity -- > ActivityID - Autonumber...
|
|
|
Top 10 active forums on www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign during last week:
|
|
Top 10 forums on www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign:
|
|
|
|
Latest active threads on www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign:
Started 2 days, 12 hours ago (2009-11-25 18:10:00)
by John_G via AccessMonster.com
From the sounds of it, you are using the same table to store different type
of data, and this is not usually a good setup. (This is particularly true if
you are dealing with currency - you generally want to use the "Currency" data
type. ). It is never good design when the type or meaning of data in one
field is dependant on the value in ...
Started 1 day, 18 hours ago (2009-11-26 12:05:00)
by Tom van Stiphout
On Thu, 26 Nov 2009 04:05:01 -0800, Bob Mansell
<BobMansell@discussions.microsoft.com> wrote:
Perhaps this will help:
http://www.mvps.org/access/modules/mdl0004.htm
-Tom.
Microsoft Access MVP
>This is the third time I've tried to post this but it never appears.
>
>I'm new to Access but have ...
Started 1 day, 19 hours ago (2009-11-26 11:35:00)
by Steve
How about the following tables ........
TblProcedure
ProcedureID
Procedure
TblObserver
ObserverID
FirstName
LastName
etc
TblLocation
LocationID
Location
TblObservation
ObservationID
ObservationDate
ObserverID
TblLocationObservation
...
Started 1 day, 19 hours ago (2009-11-26 11:10:00)
by Monkey Butler
On Nov 25, 1:55Â pm, Hutch <Hu...@discussions.microsoft.com> wrote:
> I've created a simple CRM database suing Access 2007 on our companies share
> drive. Â We have a small office with only 5 people using the database.
>
> Is it possible to collect from data off line while visiting a client and
> sync to the database when I'm back in the...
Started 3 days, 21 hours ago (2009-11-24 09:25:00)
by Jeff Boyce
Dennis
Use Access HELP and check "specifications". I believe you'll find that the
max record length in Access is 2K.
That said, a record with that much data may result from a
less-than-well-normalized table structure.
If you'll describe more specifically what data you are trying to store in
your table(s), ...
Started 3 days, 20 hours ago (2009-11-24 10:42:00)
by KARL DEWEY
Record numbers you see at the bottom of the display are 'relative' only.
Access stores records like a barrel of bricks, all in a jumble. You have to
sort the records in a query, form, or report.
But you can use a field with an Autonumber to number records. The numbers
may not be continous without gaps but will be a unique value.
Started 3 days, 16 hours ago (2009-11-24 14:04:00)
by KARL DEWEY
Use an Autonumber field as primary key field in the Contacts table.
If the known contacts are only one way like employes to supervisor add a
number - long integer field also as Supervisor. Then in the relations
window add the Contacts table twice (Access will add a sufix, Contacts_1 to
the second instance). Create a one-to-...
Started 4 days, 16 hours ago (2009-11-23 14:37:00)
by Fred
A good way to impress people about you being great folks to do business with
& who will follow good business practices is to violate and abuse this forum
by putting spam into it. So they can respond by getting you and your phone
number blacklisted.
|
|
Hot threads for last week on www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign:
Started 3 days, 21 hours ago (2009-11-24 09:25:00)
by Jeff Boyce
Dennis
Use Access HELP and check "specifications". I believe you'll find that the
max record length in Access is 2K.
That said, a record with that much data may result from a
less-than-well-normalized table structure.
If you'll describe more specifically what data you are trying to store in
your table(s), ...
Started 2 days, 12 hours ago (2009-11-25 18:10:00)
by John_G via AccessMonster.com
From the sounds of it, you are using the same table to store different type
of data, and this is not usually a good setup. (This is particularly true if
you are dealing with currency - you generally want to use the "Currency" data
type. ). It is never good design when the type or meaning of data in one
field is dependant on the value in ...
Started 1 week, 1 day ago (2009-11-19 14:15:00)
by KARL DEWEY
Is it a 'Lookup' field by chance?
Post the SQL of your query and sample data.
Started 6 days, 21 hours ago (2009-11-21 09:25:00)
by Tom van Stiphout
On Sat, 21 Nov 2009 16:25:38 +0000, Bob H <bob@despammer.com> wrote:
I would first make a backup.
Then copy my db to the server.
Then on my workstation's version delete all the tables.
Then use the Import feature to link to the tables on the server.
Then on the server remove all objects but the tables.
Done.
-Tom....
Started 3 days, 16 hours ago (2009-11-24 14:04:00)
by KARL DEWEY
Use an Autonumber field as primary key field in the Contacts table.
If the known contacts are only one way like employes to supervisor add a
number - long integer field also as Supervisor. Then in the relations
window add the Contacts table twice (Access will add a sufix, Contacts_1 to
the second instance). Create a one-to-...
Started 1 week, 1 day ago (2009-11-19 11:33:00)
by KARL DEWEY
A combo can be from a table with only one field and use it bound.
Started 1 week ago (2009-11-20 09:15:00)
by Jeff Boyce
Wouldn't that entail duplicating the data you already have?
If you are able to generate a report, the data has to be coming from
somewhere. No, not from the form, because the form is just a window on the
underlying data, which, in Access, is stored in tables.
If you take a look at the data source for the form, it will either ...
Started 4 days, 18 hours ago (2009-11-23 12:23:00)
by KARL DEWEY
Access stores records like a barrel of brick - just a jumble, no set order.
Do not view records at the table level but use a query, form or report.
These can be sorted in any manner that you need to display.
Started 5 days, 2 hours ago (2009-11-23 04:45:00)
by Jeff Boyce
Jason
A common approach to migrating 'flat' Excel data into relational tables is
to first link to (or import) the Excel data as "raw".
Then create "normalizing" queries that distribute the raw data appropriately
among the tables. You can run these queries individually, or bundle them
together using code or a macro....
Started 3 days, 20 hours ago (2009-11-24 10:42:00)
by KARL DEWEY
Record numbers you see at the bottom of the display are 'relative' only.
Access stores records like a barrel of bricks, all in a jumble. You have to
sort the records in a query, form, or report.
But you can use a field with an Autonumber to number records. The numbers
may not be continous without gaps but will be a unique value.
|
|
Size: 2,004 bytes
