|
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:
|
19
|
82
|
334
|
|
Post:
|
41
|
212
|
992
|
|
|
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:
Need guidance for Inventory...
Published (2009-11-02 23:10:00)
Thanks for the John, There definitely are multiple items per invoice. My table structure is the following: Invoice table > transactions table > products table. Multiple transactions per table. Can you describe a little bit further your statement "InvoiceDetails table typically - you can do so in the afterupdate event of an item combo box, or some other appropriate event." also if you have an example...
user's latest post:
real estate database design in...
Published (2009-11-03 18:23:00)
in nutting through this myself i'm thinking this can be fixed by creating a totals query for the search field but this doesnt work and i get this error You created an SQL statement with an ALL, DISTINCT, or DISTINCTROW predicate and an ORDER BY clause that contains a field not listed in the SELECT statement. Remove the DISTINCT reserved word, or remove the specified field from the ORDER BY clause. i'm not really good with...
user's latest post:
real estate database design in...
Published (2009-11-02 23:10:00)
On Mon, 2 Nov 2009 17:41:01 -0800, deb <deb@discussions.microsoft.com> wrote: >now my lookup/search combo box is duplicating all the records because of the >car parking spaces Then correct the errors in your form or query design. If you would like help doing so please post the structure of your tables and your form. -- John W. Vinson [MVP] .
user's latest post:
Need Help Updating Table in...
Published (2009-11-02 16:35:00)
>>They then close out the form and the table is updated with the information that they entered. I asked how this is accomplished. If you post that information I may be able to tell you how to modify it so the rest of the data is passed. Do you have a one-to-many relationship between the two tables? -- Build a little, test a little. "Brent Sweet" wrote: > Hi Karl, > > Ok So...
user's latest post:
Field Privacy in...
Published (2009-11-06 07:25:00)
It's going to be pretty much work if the SSN must be hidden from all other users. Also you won't be able to use it as the primary key field. Note: using a SSN as the PK is a bad idea anyway. What happens if you have an employee who is not a US citizen and therefore doesn't have a SSN? 1. You'll need to implement user-level security. Note that Access 2007 accdb files do not support user-level security. 2....
user's latest post:
Need guidance for Inventory...
Published (2009-11-02 23:10:00)
plisvb, I would have... tblInvoice iInvoiceiD (PK) iDate iCustomerID (FK linked to PK in tblCustomers) etc... tblInvoiceDetails idInvoiceDetailID (PK) idInvoiceID (FK linked to PK in tblInvoice) idQuantity idUnitOfMeasure (Optional field) idGroceryID (FK linked to PK in tblGroceries) idDescription idPrice idBackOrdered (Optional field) idApplyCoupon (Optional field) tblGroceries gGroceryID (PK) gItemID gBrandID (Optional field)...
user's latest post:
Need Help Updating Table in...
Published (2009-11-02 14:22:00)
Hi Karl, Ok So basically form 1 has information about the customer, then we click log interaction which brings up form 2. Some of the fields such as member ID are carried over from form 1. Then the rest of the fields are entered by the user interacting with the customer manually. They then close out the form and the table is updated with the information that they entered. The problem we have is the things passed from form 1 to form...
user's latest post:
Where should relationships be...
Published (2009-11-03 06:52:00)
Gina, Did you mean that: - you never use a query as one side of a relationship? or - you never create relationships in the query design screen? Thanx Fred
|
|
|
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 1 day ago (2009-11-10 18:27:00)
by Gina Whipp
snlcoy,
Your need is quite specific and you are not likely to find the exact
database. (Especially here in a forum where people come to get help with
their exisitng databases.) You will find ones, as you have seen, that can
be modified with some elbow grease and some help for FREE from the folks
here. However, if you ...
Started 1 day, 7 hours ago (2009-11-10 11:36:00)
by BruceM via AccessMonster.com
This is where I learned a lot of what I know about Access. Glad to pass
along some of it in turn. Good luck with the project.
gorsoft@hotmail.com wrote:
>> It sounds as if your term for line items is enquiry. It would help to know a
>> little more about the structure, but I will use part of the field list you
>[quoted text ...
Started 5 days, 11 hours ago (2009-11-06 07:25:00)
by Jerry Whittle
It's going to be pretty much work if the SSN must be hidden from all other
users.
Also you won't be able to use it as the primary key field. Note: using a SSN
as the PK is a bad idea anyway. What happens if you have an employee who is
not a US citizen and therefore doesn't have a SSN?
1. You'll need to implement user-...
Started 6 days, 12 hours ago (2009-11-05 06:41:00)
by Dorian
I don't know but autonumbers are guaranteed to be unique, beyond that is not
guaranteed. You cannot assume they will be sequential.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
"MTSmith" wrote:
> I am appending one table to another. The autonumber ...
Started 1 week ago (2009-11-04 10:17:00)
by Klatuu
"What would be wrong with that?"
Almost everything.
The common design of a header and transactions in separate but related
tables is always the correct way to accomplish this.
If you had one table to hold it all, how many individual transactions could
such a table hold? Well, with a limit of 256 fields in a table, you will...
Started 1 week ago (2009-11-04 10:20:00)
by Martin Hore
I think I have the same problem as mckenned, following a migration of my design master and all my replicas from one server to another. I even got our server team to re-open the old server from which my design master and replicas had been migrated, and I migrated them back again, but still no joy with synchronisation - I get the identical error message....
Started 1 week, 2 days ago (2009-11-02 17:40:00)
by deb
well i've managed to figure this out - sub form in my main form but...
now my lookup/search combo box is duplicating all the records because of the
car parking spaces
help
--
deb
"deb" wrote:
> I 'm creating a database with several commercial buildings, lots of tenants
> and lots of car ...
|
|
Hot threads for last week on www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.tablesdbdesign:
Started 1 week, 2 days ago (2009-11-02 17:40:00)
by deb
well i've managed to figure this out - sub form in my main form but...
now my lookup/search combo box is duplicating all the records because of the
car parking spaces
help
--
deb
"deb" wrote:
> I 'm creating a database with several commercial buildings, lots of tenants
> and lots of car ...
Started 1 week, 2 days ago (2009-11-02 14:19:00)
by KARL DEWEY
You did not say how form 2 data is updated in the table when form 2 is closed.
Do you know the method used?
--
Build a little, test a little.
"Brent Sweet" wrote:
> I have a form that has some fields on it. When you click a button it opens
> another form that the first form passes data to. For instance ...
Started 1 week, 1 day ago (2009-11-02 23:10:00)
by plisvb
Thanks for the John,
There definitely are multiple items per invoice.
My table structure is the following:
Invoice table > transactions table > products table.
Multiple transactions per table.
Can you describe a little bit further your statement "InvoiceDetails table
typically - you can do so in the ...
Started 1 week ago (2009-11-04 10:17:00)
by Klatuu
"What would be wrong with that?"
Almost everything.
The common design of a header and transactions in separate but related
tables is always the correct way to accomplish this.
If you had one table to hold it all, how many individual transactions could
such a table hold? Well, with a limit of 256 fields in a table, you will...
Started 6 days, 12 hours ago (2009-11-05 06:41:00)
by Dorian
I don't know but autonumbers are guaranteed to be unique, beyond that is not
guaranteed. You cannot assume they will be sequential.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
"MTSmith" wrote:
> I am appending one table to another. The autonumber ...
Started 1 week, 2 days ago (2009-11-02 15:12:00)
by Stefan Hoffmann
hi Bruce,
BruceM via AccessMonster.com wrote:
> I couldn't think of a good, brief subject line for this thread. I have an
> Employee database with EmployeeID (PK), FirstName, LastName, etc. Some
> employees hold Certificate A, others hold License B, others can sign certain
> documents, others can train new employees, and so ...
Started 1 week, 1 day ago (2009-11-02 23:10:00)
by plisvb
Thanks Gina for the reply,
The invoice details table seems to be a common answer. Could you further
elaborate on how I would store that calculated value.
I thought of the pdf idea also, not sure if it will be acceptable for my
accountant though. Also, I have a whole bunch of reports (monthly/yearly)
that won't be accurate...
Started 1 week, 2 days ago (2009-11-02 08:43:00)
by KARL DEWEY
See post by ThomasAJ and responses 10/24/2009
Where to define Relationships - FE or BE?
--
Build a little, test a little.
"lpierce819" wrote:
> I am trying to clarify where the prefered location is for relationships. I
> am working as a contract employee to "cleanup" a database created by someone...
Started 1 week ago (2009-11-04 10:20:00)
by Martin Hore
I think I have the same problem as mckenned, following a migration of my design master and all my replicas from one server to another. I even got our server team to re-open the old server from which my design master and replicas had been migrated, and I migrated them back again, but still no joy with synchronisation - I get the identical error message....
Started 5 days, 11 hours ago (2009-11-06 07:25:00)
by Jerry Whittle
It's going to be pretty much work if the SSN must be hidden from all other
users.
Also you won't be able to use it as the primary key field. Note: using a SSN
as the PK is a bad idea anyway. What happens if you have an employee who is
not a US citizen and therefore doesn't have a SSN?
1. You'll need to implement user-...
|
|
Size: 2,127 bytes
