statement
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 4845 articles for 2.741 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 statement in microsoft.public.access.modulesdaovba
Author: Douglas J. Steele
Date: Jun 8, 2010 03:55

On Jun 7, 11:56 pm, "Mike Schilling" <mscottschill...@hotmail.com> wrote: "plausible prose man" <Georgefha...@aol.com> wrote in messagenews:d841faec-bda8-4fdc-ab10-44570070fca5@r27g2000yqb.googlegroups.com... On Jun 5, 2:00 pm, "Mike Schilling" <mscottschill...@hotmail.com> wrote: "Shawn Wilson" <ikonoql...@gmail.com> wrote in message news:cdacfbbd-740d-4ec6
Show full article (3.45Kb) · Show article thread
"plausible prose man" <Georgefhaley@aol.com> wrote in message news:d841faec-bda8-4fdc-ab10-44570070fca5@r27g2000yqb.googlegroups.com... > On Jun 5, 2:00 pm, "Mike Schilling" <mscottschill...@hotmail.com> > wrote: >> "Shawn Wilson" <ikonoql...@gmail.com> wrote in message >> >> news:cdacfbbd-740d-4ec6-baa9-8f8009c65654@z13g2000prh.googlegroups.com... >> >> >> >> >> >> > On Jun 5, 10     

Group: alt.fan.ceciladams · Group Profile · Search for statement in alt.fan.ceciladams
Author: plausible prose man
Date: Jun 7, 2010 23:22

On 07/06/2010 4:08 PM, L V wrote: This is kind of last minute, but I just thought of this. When I write a relational algebra statement and I need to take a cross product, should I remove the unnecessary rows in the tables before the cross product or after taking the cross product? Shouldn't the efficiency be similar? (still m x n rows) Hi Venus, By removing the unnecessary
Show full article (3.82Kb) · Show article thread
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     

Group: alt.fan.ceciladams · Group Profile · Search for statement in alt.fan.ceciladams
Author: Mike Schilling
Date: Jun 7, 2010 20:56

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 (3.09Kb)
Do you mean each is a separate field in a separate table? IIF(tblUpdateHeat.[Points Earned]=0 OR tblWorklog.[Points Earned] OR [tblEscalation/Assignment]![Points Earned] = 0, 0, [tblEscalation/Assignment]![Points Earned]+tblUpdateHeat![Points Earned]+tblWorklog![Points Earned]) Basically the IIF consists of three arguments. First a conditional statement X=Y Second the response if the     

Group: uw.cs.cs338 · Group Profile · Search for statement in uw.cs.cs338
Author: kimiisa
Date: Jun 7, 2010 15:55

If you want to do this to all the text controls on the form, you don't have to use the tag property to tag them: Dim ctl As Access.Control For Each ctl In Me.Controls If ctl.ControlType = acTextBox Then If IsNull(ctl.Value) Then ctl.BackStyle = 0 ' Transparent ctl.BorderStyle = 1 Else ctl.BackStyle = 1
Show full article (0.63Kb) · Show article thread
On 14 May, 02:38, "T. Valko" <biffinp...@comcast.net> wrote: > Here's a couple more... > > =SUMPRODUCT(--(A_=1),--(B_=2),--(ISNUMBER(MATCH(C_,{1,2,3},0)))) > > =SUMPRODUCT(--(A_=1),--(B_=2),(C_=1)+(C_=2)+(C_=3)) > > -- > Biff > Microsoft Excel MVP > > "Matthew" <harriso...@btopenworld.com> wrote in message > > news:28541be3-44e4-4e84-99de-470950236f2b@k2g2000yqe.googlegroups.com... >     

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

Show full article (2.75Kb)
    

Group: uw.cs.cs338 · Group Profile · Search for statement in uw.cs.cs338
Author: L V
Date: Jun 7, 2010 13:08

Show full article (0.30Kb)
    

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

Show full article (2.04Kb)
    

Group: microsoft.public.access.queries · Group Profile · Search for statement in microsoft.public.access.queries
Author: John Spencer
Date: Jun 7, 2010 12:28

Show full article (2.45Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for statement in microsoft.public.access.formscoding
Author: david
Date: Jun 1, 2010 03:02

Show full article (1.45Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for statement in microsoft.public.excel.misc
Author: Matthew
Date: May 13, 2010 22:44

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