By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

easy data entry?

P: n/a
There may be a simple anwswer to this....

I have a client who's accustomed to entering his data into an Excel
spreadsheet. He has a lot of repetitive or sequential data, and he
likes using the Excel fill tool to drag down a column to fill in the
cells for him.

The question is, is it possible to do something similar to this in
Access?

TIA
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not exactly. You'd have to write some VBA code.

There's one method that is quite common: set the default property of a
control so it uses the last entered value as the new default. When a
new record is accessed the default value automatically fills the
controls' values property.

Usually, a toggle button is set next to the control. When it is
depressed (toggle = true) then the .Default is set to the .Value. When
the toggle is up (toggle = false) then the .Default setting is set to
nothing.

=== air code ===
Private Sub txtControlName_AfterUpdate()

If Me!txtToggle_ControlName = True Then
If Not IsNull(Me!txtControlName) Then
Me!txtControlName.Default = Me!txtControlName.Value
Else
Me!txtControlName.Default = ""
End If
Else
Me!txtControlName.Default = ""
End If

End Sub
=== end air code ===

I believe there is an article about this in the _Access Developer's
Handbook_, by K.Getz, et. al.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA+AwUBQRk28IechKqOuFEgEQLOuACYk/VJXGr0m34oxpl9thvdxldT7wCdG28e
eSKjDwuQbi6faqvRIpbC6vY=
=+Klh
-----END PGP SIGNATURE-----
tangel wrote:
There may be a simple anwswer to this....

I have a client who's accustomed to entering his data into an Excel
spreadsheet. He has a lot of repetitive or sequential data, and he
likes using the Excel fill tool to drag down a column to fill in the
cells for him.

The question is, is it possible to do something similar to this in
Access?


Nov 13 '05 #2

P: n/a
MGFoster <me@privacy.com> wrote in message news:<0G*******************@newsread1.news.pas.ear thlink.net>...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not exactly. You'd have to write some VBA code.

There's one method that is quite common: set the default property of a
control so it uses the last entered value as the new default. When a
new record is accessed the default value automatically fills the
controls' values property.

Usually, a toggle button is set next to the control. When it is
depressed (toggle = true) then the .Default is set to the .Value. When
the toggle is up (toggle = false) then the .Default setting is set to
nothing.

=== air code ===
Private Sub txtControlName_AfterUpdate()

If Me!txtToggle_ControlName = True Then
If Not IsNull(Me!txtControlName) Then
Me!txtControlName.Default = Me!txtControlName.Value
Else
Me!txtControlName.Default = ""
End If
Else
Me!txtControlName.Default = ""
End If

End Sub
=== end air code ===

I believe there is an article about this in the _Access Developer's
Handbook_, by K.Getz, et. al.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA+AwUBQRk28IechKqOuFEgEQLOuACYk/VJXGr0m34oxpl9thvdxldT7wCdG28e
eSKjDwuQbi6faqvRIpbC6vY=
=+Klh
-----END PGP SIGNATURE-----
tangel wrote:
There may be a simple anwswer to this....

I have a client who's accustomed to entering his data into an Excel
spreadsheet. He has a lot of repetitive or sequential data, and he
likes using the Excel fill tool to drag down a column to fill in the
cells for him.

The question is, is it possible to do something similar to this in
Access?


Or did you mean you could find the answer here:
http://www.mvps.org/access/forms/frm0012.htm
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.