microsoft.public.access.tablesdbdesign | Forum profile

  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...

  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...

  On Fri, 27 Nov 2009 15:15:01 -0800, janelegend <janelegend@discussions.microsoft.com> wrote: >The "Do you want to store multiple values for this lookup?" option does not >come up when I try to create a lookup column. Any ideas? Thanks. Since neither multivalue fields nor lookup fields are well designed or even necessary, I'd simply avoid the problem by never using either misfeature.

  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...

  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...

  janelegend, Sounds like you are using a database in Access 2007 but in MDB format. If this is so then no you will not see that option. You would need to convert your database.

  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],...

  I am creating a P/L in Access 2007 reports and have brought over all of my data and grouped and sorted by types with sum totals. I now want to take these totals and subtract one from the other but not sure how to do that. Any suggestions. I am really new at Access 2007 and if you could be really specific that would help. EggHeadCafe - Software Developer Portal of Choice Exchange UserCredential between client and webservice in.NET...

  I agree. I have been thinking about this since I sent the posting. I need to record the invoice, but I do not want duplicated data. Can I create a table that has a unique InvoiceID for each invoice and pointers to the data shown on the form and printed on the report? The form that has the command button to print the invoice is fporm with a subform. The form's control comes from a VB on_open event. The subform uses an SQL...

  Thanks for that, just to be sure, when you say 'use the import feature to link to tables on the server, in Access 2007, is that 'Link to the data source' option for tables. Thanks Tom van Stiphout wrote: > 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...