Hi Folks,

I'm completly jammed here, I've been trying to find a way to add
control box to a form by clicking a bottom.
Unfortunately, I've keep failed.

Could someone help me on this matter.

Your help will be very appreciated

That's an extremely unusual thing to have to do in a production application.

Perhaps you can explain your situation, and someone will be able to suggest
an alternative.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Fred's" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Folks,
>
> I'm completly jammed here, I've been trying to find a way to add
> control box to a form by clicking a bottom.
> Unfortunately, I've keep failed.
>
> Could someone help me on this matter.
>
> Your help will be very appreciated
>

I'm expaining,

Each day, we are receiving phone calls, fax and emails from supplier
to schedules orders deliveries to our compagny. (Order number and
carton qty). presently, we are entering this information in excel
ligne by ligne: time of deliveries, the orders number to be received
and the quantity per container, etc..

But, we already own an access database for all the other purpose. The
purpose of this access form will be to replace the excel one's to an
access form in order to do the same. However, I need to be able to add
text boxes on the access form via a control button.

Thanking you in advance for your help!

Fred's



On Oct 29, 12:27 pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:
> That's an extremely unusual thing to have to do in a production application.
>
> Perhaps you can explain your situation, and someone will be able to suggest
> an alternative.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>
> "Fred's" <frederic10_m...@hotmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > Hi Folks,
>
> > I'm completly jammed here, I've been trying to find a way to add
> > control box to a form by clicking a bottom.
> > Unfortunately, I've keep failed.
>
> > Could someone help me on this matter.
>
> > Your help will be very appreciated- Hide quoted text -
>
> - Show quoted text -

Unless there's something I'm completely missing, I'm not seeing a need to add
controls dynamically to your form.

You can use the access forms wizard to create a "datasheet form" which will
have the same row & column format of an excel spreadsheet.

Or you can make a single record view, with a control for each field set up
at design time.

Both are easy to make, and will do everything you described and more. What,
specifically, were you wanting to do with the new control?


"Fred's" wrote:

> I'm expaining,
>
> Each day, we are receiving phone calls, fax and emails from supplier
> to schedules orders deliveries to our compagny. (Order number and
> carton qty). presently, we are entering this information in excel
> ligne by ligne: time of deliveries, the orders number to be received
> and the quantity per container, etc..
>
> But, we already own an access database for all the other purpose. The
> purpose of this access form will be to replace the excel one's to an
> access form in order to do the same. However, I need to be able to add
> text boxes on the access form via a control button.
>
> Thanking you in advance for your help!
>
> Fred's
>
>
>
> On Oct 29, 12:27 pm, "Douglas J. Steele"
> <NOSPAM_djsteele@NOSPAM_canada.com> wrote:
> > That's an extremely unusual thing to have to do in a production application.
> >
> > Perhaps you can explain your situation, and someone will be able to suggest
> > an alternative.
> >
> > --
> > Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> > (no e-mails, please!)
> >
> > "Fred's" <frederic10_m...@hotmail.com> wrote in message
> >
> > news:(E-Mail Removed)...
> >
> >
> >
> > > Hi Folks,
> >
> > > I'm completly jammed here, I've been trying to find a way to add
> > > control box to a form by clicking a bottom.
> > > Unfortunately, I've keep failed.
> >
> > > Could someone help me on this matter.
> >
> > > Your help will be very appreciated- Hide quoted text -
> >
> > - Show quoted text -
>
>
>

I'm with Lance. There's nothing in what you've described that suggests you
need to dynamically add controls.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Fred's" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm expaining,
>
> Each day, we are receiving phone calls, fax and emails from supplier
> to schedules orders deliveries to our compagny. (Order number and
> carton qty). presently, we are entering this information in excel
> ligne by ligne: time of deliveries, the orders number to be received
> and the quantity per container, etc..
>
> But, we already own an access database for all the other purpose. The
> purpose of this access form will be to replace the excel one's to an
> access form in order to do the same. However, I need to be able to add
> text boxes on the access form via a control button.
>
> Thanking you in advance for your help!
>
> Fred's
>
>
>
> On Oct 29, 12:27 pm, "Douglas J. Steele"
> <NOSPAM_djsteele@NOSPAM_canada.com> wrote:
>> That's an extremely unusual thing to have to do in a production
>> application.
>>
>> Perhaps you can explain your situation, and someone will be able to
>> suggest
>> an alternative.
>>
>> --
>> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
>> (no e-mails, please!)
>>
>> "Fred's" <frederic10_m...@hotmail.com> wrote in message
>>
>> news:(E-Mail Removed)...
>>
>>
>>
>> > Hi Folks,
>>
>> > I'm completly jammed here, I've been trying to find a way to add
>> > control box to a form by clicking a bottom.
>> > Unfortunately, I've keep failed.
>>
>> > Could someone help me on this matter.
>>
>> > Your help will be very appreciated- Hide quoted text -
>>
>> - Show quoted text -
>
>

On Oct 29, 8:19 pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:
> I'm with Lance. There's nothing in what you've described that suggests you
> need to dynamically add controls.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no private e-mails, please)
>
> "Fred's" <frederic10_m...@hotmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > I'm expaining,
>
> > Each day, we are receiving phone calls, fax and emails from supplier
> > to schedules orders deliveries to our compagny. (Order number and
> > carton qty). presently, we are entering this information in excel
> > ligne by ligne: time of deliveries, the orders number to be received
> > and the quantity per container, etc..
>
> > But, we already own an access database for all the other purpose. The
> > purpose of this access form will be to replace the excel one's to an
> > access form in order to do the same. However, I need to be able to add
> > text boxes on the access form via a control button.
>
> > Thanking you in advance for your help!
>
> > Fred's
>
> > On Oct 29, 12:27 pm, "Douglas J. Steele"
> > <NOSPAM_djsteele@NOSPAM_canada.com> wrote:
> >> That's an extremely unusual thing to have to do in a production
> >> application.
>
> >> Perhaps you can explain your situation, and someone will be able to
> >> suggest
> >> an alternative.
>
> >> --
> >> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> >> (no e-mails, please!)
>
> >> "Fred's" <frederic10_m...@hotmail.com> wrote in message
>
> >>news:(E-Mail Removed)...
>
> >> > Hi Folks,
>
> >> > I'm completly jammed here, I've been trying to find a way to add
> >> > control box to a form by clicking a bottom.
> >> > Unfortunately, I've keep failed.
>
> >> > Could someone help me on this matter.
>
> >> > Your help will be very appreciated- Hide quoted text -
>
> >> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

Thanks guys,

I've just realize that a simple datasheet form will do the same as you
wrote
Thanks you..
Fred's