Adding control boxes automatically

[Fred's]

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

 

[Douglas J. Steele]

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.

 

[Fred's]

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

 

[Guest]

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?

 

[Douglas J. Steele]

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

 

[Fred's]

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)









- 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