conditional "required date'

Dave

Thank you again.

I understand your last response and once I'm able to define a project I may
get back to you.

Thank you, Tom

"Klatuu" wrote:

Yes I do private consulting.
I am not sure what you mean by "arrange it", but typically, I will be
referred by a previous client. Normally, I do not charge for the initial
meeting. I consider that more of a "sales call". Once I have a general
understanding of what the client wants, I will create a Scope document that
defines what the project will cover. The first phase is usually to write a
detailed requirements document. This is not a technical document, but a
business perspective of what the effort will produce.

Once the client and I have agreed on the requirements, I start with the data
requirements. From that I design the database. When the database is
complete, I work from the requirements to create the application.

Once the application is complete, I turn it over to the client for testing.
When their testing is complete, I hold a sign off meeting where they sign off
that each requirement is satisfied.

How I price it depends on the client. I usually charge an hourly rate for
the requirements gathering and creating the requirements document. I prefer
to keep it on an hourly rate basis, but some clients prefer a fixed bid
project. When I have to do fixed bid, I bid it high enough to allow for
issues I can't control.

The second most important thing is the agreement. It includes requirements
for change orders for anything not included in the requirements or anything
the client wants changed after the requirements have been accepted. I will
not budge without a signed written change order document.

The most important thing is getting paid That can be an issue. I will
not start the developement process until I have been paid for the
requirements. I also put in payment milestones. That is, when we get to
this point, I get a check, the check clears, then I go on to the next one.
This comes from lossing in the tens of thousands of dollars from trusting
people.

Hope that give you the info you need. Post back if you have other questions.
--
Dave Hargis, Microsoft Access MVP


"Tommy Boy" wrote:

Thank You, Thank You.

It worked.

Dave, I really appreciate your dedication. Couldn't of completed it without
your help.

As an aside, do you do consulting for Access project? If so how do you
arrange it and price it out?

Tom

"Klatuu" wrote:

You should never uses spaces in a name. Here is the basic rule:
Use only letters, numbers, and the underscore in names.
Do not use any Access reserved words as names (Date, Month, Name,
Description, etc)

To resolve the issue, use this syntax:
Me.[Last Name]
--
Dave Hargis, Microsoft Access MVP


"Tommy Boy" wrote:

Dave

I'm really really trying but I still get the same result.

The part of code in question is (me.control1).

I'm using (me.Last Name).

I getting an error here that says that they don't expect the space. The
fields name is Last Name. Do I need to use quotes or something? And I'm
assuming that the Me is correct.

Sorry to be so dense.

Tom

"Klatuu" wrote:

Control1 and Control2 are just names I used because I did not know the names
of the controls on your form.

Based on your original post:
As an example, if field "one" has data (not null) then you must put data
into field "two" before you can move onto another record.

Control1 should be the name of the control for field "one".
Control2 should be the name of the control for field "two".


--
Dave Hargis, Microsoft Access MVP


"Tommy Boy" wrote:

Thank You again for your help.

I'm close but the problem I still have is that I don't know what I should
use for the Me.Control1 and Me.Control2.

I've done what you suggested. The name of the Form I'm opening is "Monthly
Entries" and the two fields I'm working with are "Last Name" and "Age". All
of the data is defined in Table 1.

Can you help again??

Thanks Tom

"Klatuu" wrote:

This is code.
Open the form in design view.
Open the form's property dialog.
Select the events tab.
Select the Before Update event.
Click the small button to the right of the text box.
Select Code Builder.
The VBA editor will open with the cursor in the event sub.
paste the code into the VBA editor.

Me is shorthand for the current form object.

I don't know what actual control on your form you should use. Control1
should be the name of the form control you want to check to see if something
is required in Control2. You will only get the message if Control1 has a
value and Control2 does not. The code will present the message box, cancel
the update, and position the cursor in Control2.
--
Dave Hargis, Microsoft Access MVP


"Tommy Boy" wrote:

Thank you, I have a few questions please.

Is this an expression builder, macro or code?
What is the Me ?
Would control 1 be the fields name (like age, or last name)?

Sorry for the elementary questions, but I'm a newbe.

Thanks Tom

"Klatuu" wrote:

Use the form's Before Update event.

If Not IsNull(Me.Control1) And IsNull(Me.Control2) Then
Cancel = True
MsgBox "Data Is Required for Control2"
Me.Control2.Setfocus
End If

--
Dave Hargis, Microsoft Access MVP


"Tommy Boy" wrote:

In the form I'm doing I want "required data" in a field, only if a specific
field has data.

As an example, if field "one" has data (not null) then you must put data
into field "two" before you can move onto another record.

I went to the table view and the only option is yes or no for the required
data. I would think that this is where this parameter should be?

Thanks Tom

Are you saying you may need some assistance?
If so, I would be happy to work with you. If you would like to stay in
touch, post back with an E-mail address where I can contact you. Be sure to
mask your e-mail address to avoid the spammers. Do something like:

MyEmail Dot Something At Somesite Dot Com
--
Dave Hargis, Microsoft Access MVP


"Tommy Boy" wrote:

Dave

Thank you again.

I understand your last response and once I'm able to define a project I may
get back to you.

Thank you, Tom

"Klatuu" wrote:

Yes I do private consulting.
I am not sure what you mean by "arrange it", but typically, I will be
referred by a previous client. Normally, I do not charge for the initial
meeting. I consider that more of a "sales call". Once I have a general
understanding of what the client wants, I will create a Scope document that
defines what the project will cover. The first phase is usually to write a
detailed requirements document. This is not a technical document, but a
business perspective of what the effort will produce.

Once the client and I have agreed on the requirements, I start with the data
requirements. From that I design the database. When the database is
complete, I work from the requirements to create the application.

Once the application is complete, I turn it over to the client for testing.
When their testing is complete, I hold a sign off meeting where they sign off
that each requirement is satisfied.

How I price it depends on the client. I usually charge an hourly rate for
the requirements gathering and creating the requirements document. I prefer
to keep it on an hourly rate basis, but some clients prefer a fixed bid
project. When I have to do fixed bid, I bid it high enough to allow for
issues I can't control.

The second most important thing is the agreement. It includes requirements
for change orders for anything not included in the requirements or anything
the client wants changed after the requirements have been accepted. I will
not budge without a signed written change order document.

The most important thing is getting paid That can be an issue. I will
not start the developement process until I have been paid for the
requirements. I also put in payment milestones. That is, when we get to
this point, I get a check, the check clears, then I go on to the next one.
This comes from lossing in the tens of thousands of dollars from trusting
people.

Hope that give you the info you need. Post back if you have other questions.
--
Dave Hargis, Microsoft Access MVP


"Tommy Boy" wrote:

Thank You, Thank You.

It worked.

Dave, I really appreciate your dedication. Couldn't of completed it without
your help.

As an aside, do you do consulting for Access project? If so how do you
arrange it and price it out?

Tom

"Klatuu" wrote:

You should never uses spaces in a name. Here is the basic rule:
Use only letters, numbers, and the underscore in names.
Do not use any Access reserved words as names (Date, Month, Name,
Description, etc)

To resolve the issue, use this syntax:
Me.[Last Name]
--
Dave Hargis, Microsoft Access MVP


"Tommy Boy" wrote:

Dave

I'm really really trying but I still get the same result.

The part of code in question is (me.control1).

I'm using (me.Last Name).

I getting an error here that says that they don't expect the space. The
fields name is Last Name. Do I need to use quotes or something? And I'm
assuming that the Me is correct.

Sorry to be so dense.

Tom

"Klatuu" wrote:

Control1 and Control2 are just names I used because I did not know the names
of the controls on your form.

Based on your original post:
As an example, if field "one" has data (not null) then you must put data
into field "two" before you can move onto another record.

Control1 should be the name of the control for field "one".
Control2 should be the name of the control for field "two".


--
Dave Hargis, Microsoft Access MVP


"Tommy Boy" wrote:

Thank You again for your help.

I'm close but the problem I still have is that I don't know what I should
use for the Me.Control1 and Me.Control2.

I've done what you suggested. The name of the Form I'm opening is "Monthly
Entries" and the two fields I'm working with are "Last Name" and "Age". All
of the data is defined in Table 1.

Can you help again??

Thanks Tom

"Klatuu" wrote:

This is code.
Open the form in design view.
Open the form's property dialog.
Select the events tab.
Select the Before Update event.
Click the small button to the right of the text box.
Select Code Builder.
The VBA editor will open with the cursor in the event sub.
paste the code into the VBA editor.

Me is shorthand for the current form object.

I don't know what actual control on your form you should use. Control1
should be the name of the form control you want to check to see if something
is required in Control2. You will only get the message if Control1 has a
value and Control2 does not. The code will present the message box, cancel
the update, and position the cursor in Control2.
--
Dave Hargis, Microsoft Access MVP


"Tommy Boy" wrote:

Thank you, I have a few questions please.

Is this an expression builder, macro or code?
What is the Me ?
Would control 1 be the fields name (like age, or last name)?

Sorry for the elementary questions, but I'm a newbe.

Thanks Tom

"Klatuu" wrote:

Use the form's Before Update event.

If Not IsNull(Me.Control1) And IsNull(Me.Control2) Then
Cancel = True
MsgBox "Data Is Required for Control2"
Me.Control2.Setfocus
End If

--
Dave Hargis, Microsoft Access MVP


"Tommy Boy" wrote:

In the form I'm doing I want "required data" in a field, only if a specific
field has data.

As an example, if field "one" has data (not null) then you must put data
into field "two" before you can move onto another record.

I went to the table view and the only option is yes or no for the required
data. I would think that this is where this parameter should be?

Thanks Tom