Rolename
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 104 articles for 0.304 sec
Ni idea! -- Salu2 ----------------------------------------- Microsoft MVP SQL Server Culminis Speaker ------------------------------------------ "Fch" <fchaparro@gmail.com> escribió en el mensaje news:1185203510.665495.256320@g4g2000hsf.googlegroups.com... On 22 jul, 12:39, "Maxi" <maxi...@infovia.com.ar.sacame> wrote: > Hola, este no es un foro de ERWIN sino de SQLServer > > -     

Group: microsoft.public.es.sqlserver · Group Profile · Search for Rolename in microsoft.public.es.sqlserver
Author: Maxi
Date: Jul 23, 2007 08:30

On 22 jul, 12:39, "Maxi" <maxi...@infovia.com.ar.sacame> wrote: Hola, este no es un foro de ERWIN sino de SQLServer -- ------------------------------------------------------------------------- Microsoft M.V.P en SQLServer SQLTotal Consulting - Servicios en SQLServer Email: maxi...@gmail.com.nospam -----------------------------------------------------------------------
Show full article (1.23Kb) · Show article thread
Hola, este no es un foro de ERWIN sino de SQLServer -- ------------------------------------------------------------------------- Microsoft M.V.P en SQLServer SQLTotal Consulting - Servicios en SQLServer Email: maxi.da@gmail.com.nospam ----------------------------------------------------------------------- "Fch" <fchaparro@gmail.com> escribió en el mensaje news:1185041978.577122.63720@r34g2000hsd     

Group: microsoft.public.es.sqlserver · Group Profile · Search for Rolename in microsoft.public.es.sqlserver
Author: Fch
Date: Jul 23, 2007 08:11

Thank you!!! That worked...everyone's help is much appreciated. "Douglas J. Steele" wrote: Hold on. I didn't look that closely at what you were doing before! Unfortunately, John's advice was incorrect. You cannot refer to fields in a table like that. In other words, the references to [tblProjectRates]![RoleName] and [tblProjectRates]![ProjectID] are incorrect. Assuming
Show full article (0.95Kb) · Show article thread
Hold on. I didn't look that closely at what you were doing before! Unfortunately, John's advice was incorrect. You cannot refer to fields in a table like that. In other words, the references to [tblProjectRates]![RoleName] and [tblProjectRates]![ProjectID] are incorrect. Assuming that the RoleName and ProjectID are contained on controls on your form, use Me![Rate] = DLookup("[Rate]",     

Group: microsoft.public.es.sqlserver · Group Profile · Search for Rolename in microsoft.public.es.sqlserver
Author: Maxi
Date: Jul 22, 2007 09:39

Thanks for the help. It's giving me a run time error now as follows: Run time error code '2465': Database can't find the field 'l' referred to in your expression When I click Debug, it highlights this statement as the problem. Any suggestions? Me![Rate] = DLookup("[Rate]", "[tblProjectRates]", "[Role]= '" & _ [tblProjectRates]![RoleName] & "' And [ProjectID] = '" & _ [tblProjectRates
Show full article (0.70Kb) · Show article thread
Yes. You'd need quotes around the value being used: Me![Rate] = DLookup("[Rate]", "[tblProjectRates]", "[Role]= '" & _ [tblProjectRates]![RoleName] & "' And [ProjectID] = '" & _ [tblProjectRates]![ProjectID] & "'") -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "larochy" <larochy@discussions.microsoft.com> wrote in message news     

Group: microsoft.public.es.sqlserver · Group Profile · Search for Rolename in microsoft.public.es.sqlserver
Author: Fch
Date: Jul 21, 2007 11:19

Thanks for the quick response John. Project ID is a text field, would that change the code? "John W. Vinson" wrote: On Thu, 4 Sep 2008 23:18:01 -0700, larochy <larochy@discussions.microsoft.com> wrote: I store rates in a table called [tblProjectRates] and the rate is tied to a RoleName and the specific ProjectID. When the user updates the [role] ComboBox in the form
Show full article (0.27Kb)
On Thu, 4 Sep 2008 23:18:01 -0700, larochy <larochy@discussions.microsoft.com> wrote: >I store rates in a table called [tblProjectRates] and the rate is tied to a >RoleName and the specific ProjectID. When the user updates the [role] >ComboBox in the form, I want it to automatically populate the [Rate] field >with the appropriate rate based on the ProjectID and the Role stored in the     

Group: microsoft.public.access.forms · Group Profile · Search for Rolename in microsoft.public.access.forms
Author: larochy
Date: Sep 5, 2008 11:20

Show full article (3.23Kb) · Show article thread
    

Group: microsoft.public.access.forms · Group Profile · Search for Rolename in microsoft.public.access.forms
Author: Douglas J. Steele
Date: Sep 5, 2008 10:48

Show full article (2.94Kb) · Show article thread
    

Group: microsoft.public.access.forms · Group Profile · Search for Rolename in microsoft.public.access.forms
Author: larochy
Date: Sep 5, 2008 09:40

Show full article (2.12Kb) · Show article thread
    

Group: microsoft.public.access.forms · Group Profile · Search for Rolename in microsoft.public.access.forms
Author: Douglas J. Steele
Date: Sep 5, 2008 07:28

Show full article (1.56Kb) · Show article thread
    

Group: microsoft.public.access.forms · Group Profile · Search for Rolename in microsoft.public.access.forms
Author: larochy
Date: Sep 5, 2008 00:11

Show full article (1.06Kb) · Show article thread
    

Group: microsoft.public.access.forms · Group Profile · Search for Rolename in microsoft.public.access.forms
Author: John W. Vinson
Date: Sep 4, 2008 23:53

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