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

Datasheet views

P: n/a
Hey. Normally I play with something until I get it, but this form
needs to be finished by tomorrow. Here's what I'm trying to do (form
is in datasheet view):

1) Hide a field and assign it a value from a control file when a
record is added.

2) Open the form in add mode. They want to start at the bottom of the
list.

3) When "Section" field is entered, the field "location" becomes a
required entry.

Any ideas? I'm not used to working with a form in datasheet view.
Thanks.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"G. Miller" <gm*****@nospam-mobileregister.com> wrote in message
news:43*****************@newsgroups.bellsouth.net. ..
Hey. Normally I play with something until I get it, but this form
needs to be finished by tomorrow.
Homework time again? ;-p
Here's what I'm trying to do (form
is in datasheet view):

1) Hide a field and assign it a value from a control file when a
record is added.
Don't understand the question.

2) Open the form in add mode. They want to start at the bottom of the
list.
In design view, change the "Data Entry" property to "yes".

3) When "Section" field is entered, the field "location" becomes a
required entry.


You'd need a bit of code attached to form's Before Update event that tests
for null in both text boxes and handles the outcome accordingly (air code):

If Not IsNull(Me.txtSection) And IsNull(Me.txtLocation) Then
MsgBox "Enter a Location"
Me.txtLocation.SetFocus
Cancel = True
End If

HTH - Keith.
www.keithwilby.com
Nov 13 '05 #2

P: n/a
Heh, lots of homework....thanks Keith. That's what I was looking for.

On Tue, 8 Nov 2005 16:53:09 -0000, "Keith W" <he**@there.com> wrote:
"G. Miller" <gm*****@nospam-mobileregister.com> wrote in message
news:43*****************@newsgroups.bellsouth.net ...
Hey. Normally I play with something until I get it, but this form
needs to be finished by tomorrow.


Homework time again? ;-p
Here's what I'm trying to do (form
is in datasheet view):

1) Hide a field and assign it a value from a control file when a
record is added.


Don't understand the question.

2) Open the form in add mode. They want to start at the bottom of the
list.


In design view, change the "Data Entry" property to "yes".

3) When "Section" field is entered, the field "location" becomes a
required entry.


You'd need a bit of code attached to form's Before Update event that tests
for null in both text boxes and handles the outcome accordingly (air code):

If Not IsNull(Me.txtSection) And IsNull(Me.txtLocation) Then
MsgBox "Enter a Location"
Me.txtLocation.SetFocus
Cancel = True
End If

HTH - Keith.
www.keithwilby.com


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.