Is there a way to increase a data field length using code.

I have an application that has a front end application and a back end
database. I would like to put a button on a form that allows a user to
increase the data field length to the corresponding field in the back end
database table.

Thank you in advance!

Dwight

On Apr 11, 11:02 am, Dwight <Dwi...@discussions.microsoft.com> wrote:
> Is there a way to increase a data field length using code.
>
> I have an application that has a front end application and a back end
> database. I would like to put a button on a form that allows a user to
> increase the data field length to the corresponding field in the back end
> database table.
>
> Thank you in advance!
>
> Dwight


Kind of a waste of time.
Either set the length in the table to the maximum you think will be
used, or make it a memo that people will likely never fill.
Constantly adjusting field settings would probably cause more problems
than it's worth.

Even if it is possible to adjust the length using code, the setting would
apply to all records. Somebody would eventually set the size to the maximum
(unless it is a Memo field), after which no further adjustments would be
possible. You may as well set the field to the needed size, as suggested
previously. I doubt you want to give your users design control over a back
end table in any case.

"Dwight" <(E-Mail Removed)> wrote in message
news:1D6ECD4E-231B-4B1C-B4D4-(E-Mail Removed)...
> Is there a way to increase a data field length using code.
>
> I have an application that has a front end application and a back end
> database. I would like to put a button on a form that allows a user to
> increase the data field length to the corresponding field in the back end
> database table.
>
> Thank you in advance!
>
> Dwight

I underestimated the field length when the application was released. I want
the user to be able to update the data field without losing his/her data. It
is a one-time fix.

Thanks!

"storrboy" wrote:

> On Apr 11, 11:02 am, Dwight <Dwi...@discussions.microsoft.com> wrote:
> > Is there a way to increase a data field length using code.
> >
> > I have an application that has a front end application and a back end
> > database. I would like to put a button on a form that allows a user to
> > increase the data field length to the corresponding field in the back end
> > database table.
> >
> > Thank you in advance!
> >
> > Dwight
>
>
> Kind of a waste of time.
> Either set the length in the table to the maximum you think will be
> used, or make it a memo that people will likely never fill.
> Constantly adjusting field settings would probably cause more problems
> than it's worth.
>
>

Hi Dwight

Storrboy is right. You will not lose any data by increasing the field size.

But, if a user were to increase a field and then fill it then another user
changed the sise so the 1st users data would not not fit - you (the IT dept)
would have a big problem.

--
Wayne
Manchester, England.



"Dwight" wrote:

> I underestimated the field length when the application was released. I want
> the user to be able to update the data field without losing his/her data. It
> is a one-time fix.
>
> Thanks!
>
> "storrboy" wrote:
>
> > On Apr 11, 11:02 am, Dwight <Dwi...@discussions.microsoft.com> wrote:
> > > Is there a way to increase a data field length using code.
> > >
> > > I have an application that has a front end application and a back end
> > > database. I would like to put a button on a form that allows a user to
> > > increase the data field length to the corresponding field in the back end
> > > database table.
> > >
> > > Thank you in advance!
> > >
> > > Dwight
> >
> >
> > Kind of a waste of time.
> > Either set the length in the table to the maximum you think will be
> > used, or make it a memo that people will likely never fill.
> > Constantly adjusting field settings would probably cause more problems
> > than it's worth.
> >
> >

The table consists of 1 record.
What I plan on doing is checking the field length when the form is loaded,
and if the field is not set at the length it needs to be, then it will be
increased to a length that I will code. If the field length is correct, the
button will not even be displayed. I am trying increase a field length on
the back end without putting out a new back end.

Thanks!

Dwight

"BruceM" wrote:

> Even if it is possible to adjust the length using code, the setting would
> apply to all records. Somebody would eventually set the size to the maximum
> (unless it is a Memo field), after which no further adjustments would be
> possible. You may as well set the field to the needed size, as suggested
> previously. I doubt you want to give your users design control over a back
> end table in any case.
>
> "Dwight" <(E-Mail Removed)> wrote in message
> news:1D6ECD4E-231B-4B1C-B4D4-(E-Mail Removed)...
> > Is there a way to increase a data field length using code.
> >
> > I have an application that has a front end application and a back end
> > database. I would like to put a button on a form that allows a user to
> > increase the data field length to the corresponding field in the back end
> > database table.
> >
> > Thank you in advance!
> >
> > Dwight
>
>
>

Wayne,
It is a single user application. I am just trying to prevent putting a new
back end.

Thanks!

Dwight

"Wayne-I-M" wrote:

> Hi Dwight
>
> Storrboy is right. You will not lose any data by increasing the field size.
>
> But, if a user were to increase a field and then fill it then another user
> changed the sise so the 1st users data would not not fit - you (the IT dept)
> would have a big problem.
>
> --
> Wayne
> Manchester, England.
>
>
>
> "Dwight" wrote:
>
> > I underestimated the field length when the application was released. I want
> > the user to be able to update the data field without losing his/her data. It
> > is a one-time fix.
> >
> > Thanks!
> >
> > "storrboy" wrote:
> >
> > > On Apr 11, 11:02 am, Dwight <Dwi...@discussions.microsoft.com> wrote:
> > > > Is there a way to increase a data field length using code.
> > > >
> > > > I have an application that has a front end application and a back end
> > > > database. I would like to put a button on a form that allows a user to
> > > > increase the data field length to the corresponding field in the back end
> > > > database table.
> > > >
> > > > Thank you in advance!
> > > >
> > > > Dwight
> > >
> > >
> > > Kind of a waste of time.
> > > Either set the length in the table to the maximum you think will be
> > > used, or make it a memo that people will likely never fill.
> > > Constantly adjusting field settings would probably cause more problems
> > > than it's worth.
> > >
> > >

I misunderstood the question. However, the user would need permission to
modify the table's design using code (again, assuming it's possible). If
so, I would think the user could modify the back end directly. Are you in
another location that prevents you from modifying the back end yourself?

"Dwight" <(E-Mail Removed)> wrote in message
news:708ADF65-818B-4D0E-9A26-(E-Mail Removed)...
> The table consists of 1 record.
> What I plan on doing is checking the field length when the form is loaded,
> and if the field is not set at the length it needs to be, then it will be
> increased to a length that I will code. If the field length is correct,
> the
> button will not even be displayed. I am trying increase a field length on
> the back end without putting out a new back end.
>
> Thanks!
>
> Dwight
>
> "BruceM" wrote:
>
>> Even if it is possible to adjust the length using code, the setting would
>> apply to all records. Somebody would eventually set the size to the
>> maximum
>> (unless it is a Memo field), after which no further adjustments would be
>> possible. You may as well set the field to the needed size, as suggested
>> previously. I doubt you want to give your users design control over a
>> back
>> end table in any case.
>>
>> "Dwight" <(E-Mail Removed)> wrote in message
>> news:1D6ECD4E-231B-4B1C-B4D4-(E-Mail Removed)...
>> > Is there a way to increase a data field length using code.
>> >
>> > I have an application that has a front end application and a back end
>> > database. I would like to put a button on a form that allows a user to
>> > increase the data field length to the corresponding field in the back
>> > end
>> > database table.
>> >
>> > Thank you in advance!
>> >
>> > Dwight
>>
>>
>>

Dwight

Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE%20Update%20Utility.mdb'

which will do this for you.

Peter Hibbs

On Wed, 11 Apr 2007 08:42:04 -0700, Dwight
<(E-Mail Removed)> wrote:

>The table consists of 1 record.
>What I plan on doing is checking the field length when the form is loaded,
>and if the field is not set at the length it needs to be, then it will be
>increased to a length that I will code. If the field length is correct, the
>button will not even be displayed. I am trying increase a field length on
>the back end without putting out a new back end.
>
>Thanks!
>
>Dwight
>
>"BruceM" wrote:
>
>> Even if it is possible to adjust the length using code, the setting would
>> apply to all records. Somebody would eventually set the size to the maximum
>> (unless it is a Memo field), after which no further adjustments would be
>> possible. You may as well set the field to the needed size, as suggested
>> previously. I doubt you want to give your users design control over a back
>> end table in any case.
>>
>> "Dwight" <(E-Mail Removed)> wrote in message
>> news:1D6ECD4E-231B-4B1C-B4D4-(E-Mail Removed)...
>> > Is there a way to increase a data field length using code.
>> >
>> > I have an application that has a front end application and a back end
>> > database. I would like to put a button on a form that allows a user to
>> > increase the data field length to the corresponding field in the back end
>> > database table.
>> >
>> > Thank you in advance!
>> >
>> > Dwight
>>
>>
>>

"BruceM" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I misunderstood the question. However, the user would need permission to
>modify the table's design using code (again, assuming it's possible). If
>so, I would think the user could modify the back end directly. Are you in
>another location that prevents you from modifying the back end yourself?
>
> "Dwight" <(E-Mail Removed)> wrote in message
> news:708ADF65-818B-4D0E-9A26-(E-Mail Removed)...
>> The table consists of 1 record.
>> What I plan on doing is checking the field length when the form is
>> loaded,
>> and if the field is not set at the length it needs to be, then it will be
>> increased to a length that I will code. If the field length is correct,
>> the
>> button will not even be displayed. I am trying increase a field length
>> on
>> the back end without putting out a new back end.
>>
>> Thanks!
>>
>> Dwight
>>
>> "BruceM" wrote:
>>
>>> Even if it is possible to adjust the length using code, the setting
>>> would
>>> apply to all records. Somebody would eventually set the size to the
>>> maximum
>>> (unless it is a Memo field), after which no further adjustments would be
>>> possible. You may as well set the field to the needed size, as
>>> suggested
>>> previously. I doubt you want to give your users design control over a
>>> back
>>> end table in any case.
>>>
>>> "Dwight" <(E-Mail Removed)> wrote in message
>>> news:1D6ECD4E-231B-4B1C-B4D4-(E-Mail Removed)...
>>> > Is there a way to increase a data field length using code.
>>> >
>>> > I have an application that has a front end application and a back end
>>> > database. I would like to put a button on a form that allows a user
>>> > to
>>> > increase the data field length to the corresponding field in the back
>>> > end
>>> > database table.
>>> >
>>> > Thank you in advance!
>>> >
>>> > Dwight
>>>
>>>
>>>
>
>