Advertisement

07.17.2008 at 06:49AM PDT, ID: 23573169
[x]
Attachment Details

Access Submit button grayed on new record

Asked by Heather_D in Access Forms, Microsoft Access Database

Tags: Access, 2003

Greetings:

Currently I have the submit button disabled on a form if the user when to a new record.  This works, but the problem is that the user may need to go back to the record to add information.  Ex: Time In and then later go back the form to add Time OUt.

Here is my code:
Private Sub Form_Current()
Me.Command127.Visible = True
If Me.NewRecord = True Then
   Me!Command127.Enabled = True
Else
   Me!Command127.Enabled = False
End If
End Sub

How can I get the submit button to become disabled only the account has been closed?  Right now I have a account closed check box, and also a closer initial field.  I thought I might be able to use them but that is not working.

THanks,

HeatherStart Free Trial
 
Loading Advertisement...
 
[+][-]07.17.2008 at 06:52AM PDT, ID: 22025424

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.17.2008 at 08:16AM PDT, ID: 22026369

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Forms, Microsoft Access Database
Tags: Access, 2003
Sign Up Now!
Solution Provided By: koutny
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.17.2008 at 02:05PM PDT, ID: 22030321

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.18.2008 at 01:12AM PDT, ID: 22033680

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.20.2008 at 11:32AM PDT, ID: 22046515

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628