"I can hard code the current rate and change the code when the rate changes"
Why not hard code the reference to the value stored in the table so you never have to change your code? Duane HookomMS Access MVP > To: MS_Access_Professionals@yahoogroups.com
> From: robinski@mymail.net.au
> Date: Sat, 4 Aug 2012 14:20:45 +1000
> Subject: RE: [MS_AccessPros] Look up fixed value
>
> Thanks Duane,
>
> This is another of my data on remote server and the operations of
> 'add', 'edit' and 'delete' being handled by ASP pages. Forms are not used.
>
> I can hard code the current rate and change the code when the rate changes.
>
> Robin Chapple.
>
>
> At 5/08/2012 04:52 AM, you wrote:
> >You solution won't work.
> >I would use a form to enter new records. In the On Open event of the
> >form, use some code to set the Default Value property of a control.
> >
> >If tServiceRate has only one record, you can try something like:
> >
> >Me.txtRate.DefaultValue = Dlookup("Rate","tServiceRate")
> >
> >Duane Hookom
> >MS Access MVP
> >
> >----------------------------------------
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: robinski@mymail.net.au
> > > Date: Sat, 4 Aug 2012 09:09:03 +1000
> > > Subject: [MS_AccessPros] Look up fixed value
> > >
> > >
> > > I have a Projects table that includes a currency field 'Rate'. I need
> > > each new entry to use the 'Rate' as recorded in a separate table
> > > 'tServiceRate'.
> > >
> > > I have used this:
> > >
> > > =[tServiceRate].[Rate]
> > >
> > > as the default value for 'Rate' in the Projects. Error reports
> > > "cannot find field".
> > >
> > > What have I missed?
> > >
> > > Many thanks,
> > >
> > > Robin Chapple.
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
> >
> >------------------------------------
> >
> >Yahoo! Groups Links
> >
> >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar