Re: Copying only a few fields from a record to a new record

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 03/15/05 

Date: Tue, 15 Mar 2005 05:34:01 -0800

Adam

Actually, you might find enough by checking Access HELP and the examples
given there. You can also check the mvps.org website, or search at
Google.com.

And try doing a search on the access.gettingstarted newsgroup...

Good luck

Jeff Boyce
<Access MVP>

"AdamGold08" <AdamGold08@discussions.microsoft.com> wrote in message
news:467CFC40-20EE-4F8B-94AF-D6639D9B3C9B@microsoft.com...
> Thanks Jeff-
>
> I was somewhat thinking that would be how I would do it - my issue is that
I
> am not familiar with creating code for buttons - I have used the wizards
> before and tried to manipulate them a bit to do what i wanted after the
> wizard was done - but to no avail.
>
> Any tips on where I can go on the internet to learn how to write the code
> for what i am trying to do?
>
> Again - thanks for anything you can provide.
>
> "Jeff Boyce" wrote:
>
> > One approach might be to add a control button to the order form that you
add
> > code to. The code creates a new record and adds the values from the
> > "current" record -- you decide which values.
> >
> > --
> > Good luck
> >
> > Jeff Boyce
> > <Access MVP>
> >
> > "AdamGold08" <AdamGold08@discussions.microsoft.com> wrote in message
> > news:9D4A6B44-9E5F-49FF-A549-BC070285DB28@microsoft.com...
> > > I have read many of the posts here and I can't find one that helps
with
> > what
> > > we are trying to do....
> > >
> > > We have a order entry form for a manufacturer. When we get reorders,
we
> > > want to duplicate certain fields from an old record to a new record.
For
> > > example:
> > >
> > > The table has fields such as material, product size, imprint colors,
etc -
> > > all of which we want to copy. It also has fields such as quantity,
price,
> > > ship date, etc that we don't want to copy, we want to fill those in
> > manually
> > > in the new record.
> > >
> > > I have tried the copy functions in the wizard and some of the code
people
> > > have suggested on other posts - even tried to manipluate it to work
for
> > this.
> > > I am not knowledgeable enough.
> > >
> > > Anyone - please help!
> > >
> > > Thanks in advance.
> >
> >

Quantcast