Inserter
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 1246 articles for 2.538 sec
CurrentDb.Execute "insert into tbl_details (ID) values (" & NumID & ")", dbFailOnError If it were text, you'd need to use CurrentDb.Execute "insert into tbl_details (ID) values (""" & TextID & """)", dbFailOnError or CurrentDb.Execute "insert into tbl_details (ID) values ('" & TextID & "')", dbFailOnError -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Inserter in microsoft.public.access.modulesdaovba
Author: Douglas J. Steele
Date: Jun 8, 2010 03:55

Star Trek Collector Sets-Inserts-Holograms I have for sale the following Star Trek Collector Cards in MINT condition. Prices US plus postage + 1991 25th. Anniversary Edition (310-Card Set) $24. + 1991 25th. Anniversary Edition Series I (160-Card Set) $12. + 1991 25th. Anniversary Edition Series II (150-Card Set) $12. + 1991 25th Anniversary Hologram #H2 TNG Enterprise $15. + 1992 The
Show full article (3.45Kb) · Show article thread
Non-Sports INSERTS Cards/Sets I have for sale the following Non-Sports INSERTS Cards/Sets in MINT condition. Price US plus postage + 'Ongoing / Wizard Mag./ Wizard Ash Vitals (slabbed & #d) #9 $10. + Harris Comics - "Cain" Image Card #1 of 2 $3. + '77 Superman (DC) Card #7 Christopher Reeves $8. + '90 Comic Ball (Upper Deck) Hologram Singles ($3. each) + '90 Comic Ball (Upper Deck     

Group: rec.collecting.cards.nonsports · Group Profile · Search for Inserter in rec.collecting.cards.nonsports
Author: j. r. sinclair
Date: Jun 8, 2010 02:33

1993-94 NHL Topps/OPC "Premier Finest" Factory-Sealed Insert-Set I have for sale the 1993-94 NHL Topps/OPC "Premier Finest" 12-Card Metallic Chromium Insert Factory-Sealed Set. "The players included in this set were all picked first overall in their first draft year." The set includes the following NHL Players: Alexandre Daigle, Roman Hamrlik, Eric Lindros, Owen Nolan, Mats Sundin, Mike Modano
Show full article (0.91Kb)
I did not realize that about SQL and VBA. That helped, thanks. Using Douglas' method, do you know how to use a numeric (dim as long) variable? Thanks for your help. "John W. Vinson" wrote: > On Mon, 7 Jun 2010 11:06:13 -0700, laavista > <laavista@discussions.microsoft.com> wrote: > > >private sub cmdDetails_click() > > > >if me.newrecord = -1 then > > ' insert into tbl_details     

Group: rec.collecting.cards.nonsports · Group Profile · Search for Inserter in rec.collecting.cards.nonsports
Author: j. r. sinclair
Date: Jun 8, 2010 02:33

I have one more question. I need to use a variable in the query for the field name (e.g., ID). In the module, I set NumID=to the value in the MainInfo form (the variable does contain the ID). I tried just using it in the statement below and it didn't work. I found 'help' on using a variable in a query that says you use a function. So, I tried calling a function using: NumID = forms
Show full article (15.55Kb)
On Mon, 7 Jun 2010 11:06:13 -0700, laavista <laavista@discussions.microsoft.com> wrote: >private sub cmdDetails_click() > >if me.newrecord = -1 then > ' insert into tbl_details ([ID]) values (me.id) > insert into tbl_details ([ID]) values (999) 'value of 999 to test >end if > >exit sub VBA is one language; SQL is a different language. You can't just switch into SQL in the middle     

Group: rec.collecting.sport.hockey · Group Profile · Search for Inserter in rec.collecting.sport.hockey
Author: j. r. sinclair
Date: Jun 8, 2010 02:16

Thank you so much. This worked! I really appreciate you taking the time to respond to my question. "Douglas J. Steele" wrote: private sub cmdDetails_click() if me.newrecord = -1 then ' insert into tbl_details ([ID]) values (me.id) CurrentDb.Execute "insert into tbl_details ([ID]) values (999)", dbFailOnError end if exit sub -- Doug Steele, Microsoft
Show full article (0.74Kb)
1993-94 Parkhurst Reprint "Case Insert" 6-Card Set I have for sale the following 1993-94 Parkhurst "Case Insert" Series I 6-Card "DPR" (Factory-Sealed) Set in MINT condition. (Series 1) DPR #1 to #6: Gordie Howe, Milt Schmidt, Tim Horton, Al Rollins, Maurice Richard, and Harry Howell. Price $35. US plus postage Please include your "postal mailing address" so I can calculate postage     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Inserter in microsoft.public.access.modulesdaovba
Author: laavista
Date: Jun 7, 2010 14:50

Package: wnpp Owner: Alan Haggai Alavi <alanhaggai@alanhaggai.org> Severity: wishlist *** Please type your report below this line *** * Package name : libtemplate-plugin-cycle-perl Version : 1.06 Upstream Author : Adam Kennedy <adamk@cpan.org> * URL : http://search.cpan.org/dist/Template-Plugin-Cycle/ * License : GPL, Artistic Programming Lang: Perl
Show full article (0.89Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Inserter in microsoft.public.access.modulesdaovba
Author: laavista
Date: Jun 7, 2010 14:24

Show full article (2.75Kb)
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Inserter in microsoft.public.access.modulesdaovba
Author: John W. Vinson
Date: Jun 7, 2010 12:45

Show full article (0.64Kb)
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Inserter in microsoft.public.access.modulesdaovba
Author: laavista
Date: Jun 7, 2010 12:37

Show full article (2.04Kb)
    

Group: rec.collecting.sport.hockey · Group Profile · Search for Inserter in rec.collecting.sport.hockey
Author: j. r. sinclair
Date: Jun 1, 2010 03:04

Show full article (0.43Kb)
    

Group: linux.debian.bugs.dist · Group Profile · Search for Inserter in linux.debian.bugs.dist
Author: Alan Haggai Alavi
Date: May 31, 2010 23:10

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