Appolige
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 137 articles for 0.280 sec
I appoligize. HEre are the perms: c:\shared\CNC Programs BUILTIN\Administrators:(OI)(CI)F OFFICE\CNC Programs Group:(OI)(CI)(special access:) READ_CONTROL SYNCHRONIZE FILE_GENERIC_READ     

Group: microsoft.public.windows.server.general · Group Profile · Search for Appolige in microsoft.public.windows.server.general
Author: 116
Date: Sep 13, 2008 07:58

Thanks again John, I'm still getting an error: (Invalid SQL statement, expected 'DELETE', INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE', Not sure what its wanting here. It CANNOT be the primary key for the new table! There will be (up to) 20 records for each Review_ID value, and the primary key must, by definition, be unique. You may want to use a two-field primary key consisting
Show full article (2.89Kb) · Show article thread
John, I don't want to be a pest, but here is the structure of both tables: Table: Review (Catch All) [Review_ID] (Primary Key) [Observation1] [Recommendation1] [Observation2] [Recommendation2] etc. New Table: ReviewOB [Review_ID] (Primary Key) [SeqNo] (New Field) [Observation] [Recommendation] Hope this helps. -- Eric the Rookie "John W. Vinson" wrote: > On Mon     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Appolige in microsoft.public.access.modulesdaovba
Author: Eric
Date: Aug 18, 2008 14:48

John, one other thing.... The field [Review_ID] is The Primary Key for both the Review Table (Catch all) and the new Table. Thanks -- Eric the Rookie "John W. Vinson" wrote: On Mon, 18 Aug 2008 08:17:01 -0700, Eric <Eric@discussions.microsoft.com> wrote: Thanks John, this is exactly what I need. I have never built a Union Query. The example you gave looks like what
Show full article (3.72Kb) · Show article thread
John I think this is going to be great, but I'm getting a sytex error. The Catch all Table is named "Review". In the "Review" Table, [Review_ID] is the unique field (Primary Key). There can be nulls in either Observation or Recommendation, so I think your statement is correct as it is. The "SeqNo" is a field that I will use in the new Field upon append. Here is the code as transcribed     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Appolige in microsoft.public.access.modulesdaovba
Author: Eric
Date: Aug 18, 2008 13:02

On Mon, 18 Aug 2008 08:17:01 -0700, Eric <Eric@discussions.microsoft.com> wrote: Thanks John, this is exactly what I need. I have never built a Union Query. The example you gave looks like what you want me to use, I just need some help in making up the code in the SQL window? Also how do I incorporate with the Append Query? Here is the strucure: Flat table (Catch ALL) Observation1
Show full article (2.36Kb) · Show article thread
Thanks John, this is exactly what I need. I have never built a Union Query. The example you gave looks like what you want me to use, I just need some help in making up the code in the SQL window? Also how do I incorporate with the Append Query? Here is the strucure: Flat table (Catch ALL) Observation1 (1-20) Recommendation 1 (1-20) New Table SeqNo (new field) Observation     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Appolige in microsoft.public.access.modulesdaovba
Author: Eric
Date: Aug 18, 2008 12:51

I have to appoligize, I also usually use the tab control, I should of been flamed. Must be thinking about Friday. Pete D. "John W. Vinson/MVP" <please.reply@to.the.newsgroup> wrote in message news:soov74plasfa2jgn57qlg8hlii89ckf3na@4ax.com... On Thu, 17 Jul 2008 23:18:48 GMT, "Linq Adams via AccessMonster.com" <u28780@uwe> wrote: Here's a quick little tutorial I give people
Show full article (2.16Kb) · Show article thread
<truthteller@nospam.net> wrote in message news:ZBqbk.77$0V1.75@trndny01... > In <6Zobk.20570$Xe.18766@bignews1.bellsouth.net>, on > 07/04/2008 > at 07:49 AM, "Kent Finnell" <kentfinn@bellsouth.net> > said: > > > >><truthteller@nospam.net> wrote in message >>news:J4obk.218$rb1.163@trndny08... >>> In <28SdnYcGOOpoHfDVnZ2dnUVZ_r_inz2d@earthlink.com>, on >>> 07/03/2008 >>> at 08:46     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Appolige in microsoft.public.access.modulesdaovba
Author: Eric
Date: Aug 18, 2008 12:29

<truthteller@nospam.net> wrote in message news:ZBqbk.77$0V1.75@trndny01... In <6Zobk.20570$Xe.18766@bignews1.bellsouth.net>, on 07/04/2008 at 07:49 AM, "Kent Finnell" <kentfinn@bellsouth.net> said: <truthteller@nospam.net> wrote in message news:J4obk.218$rb1.163@trndny08... In <28SdnYcGOOpoHfDVnZ2dnUVZ_r_inz2d@earthlink.com>, on 07/03/2008 at 08:46
Show full article (3.37Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Appolige in microsoft.public.access.modulesdaovba
Author: John W. Vinson
Date: Aug 18, 2008 09:40

Show full article (1.86Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Appolige in microsoft.public.access.modulesdaovba
Author: Eric
Date: Aug 18, 2008 08:17

Show full article (2.73Kb) · Show article thread
    

Group: microsoft.public.access.forms · Group Profile · Search for Appolige in microsoft.public.access.forms
Author: Pete D.
Date: Jul 17, 2008 17:39

Show full article (0.66Kb) · Show article thread
    

Group: soc.veterans · Group Profile · Search for Appolige in soc.veterans
Author: Kent Finnell
Date: Jul 4, 2008 12:41

Show full article (4.43Kb) · Show article thread
    

Group: rec.motorcycles · Group Profile · Search for Appolige in rec.motorcycles
Author: Kent Finnell
Date: Jul 4, 2008 12:41

Show full article (4.43Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next