from what date error

[nishkrish@gmail.com]

Hi,
I am new to access

I created the form and report from Allen Browne's Frmwhat Date the way
he
has described but when i preview report it shows
StartDate: name?
Enddate: name?
am i suppose to attach this form or report to some table or query if
so how
do i do that? and also how do i attach this to my report since my
whole database is based on dates i need weekly matrics on reports.

its form project initation date to date of compelation but in between
it goes thru various stages of dates that are scheledule with vendors
for testing and turning up the telephonne lines. i will be needing to
know how many orders we have received , how many completed, deleted
before successful completion, items due in 1,2,3,5 or 10 days.

Any hepl is greatly appreciated

Thanks,

[Allen Browne]

Re: from what date error

Are you using Method 1 (parameter query) in this article:

http://allenbrowne.com/casu-08.html

If so, at step 4 you added a text box to the report and set its properties
like this:
Control Source =[StartDate]
Format Short Date
Name txtStartDate

The name you used in the query must match exactly. For example, if you used
a space in the name in the query, you must do the same on the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<nishkrish@gmai l.comwrote in message
news:1175624702 .528761.130630@ p77g2000hsh.goo glegroups.com.. .

Hi,
I am new to access
>
I created the form and report from Allen Browne's Frmwhat Date the way
he
has described but when i preview report it shows
StartDate: name?
Enddate: name?
am i suppose to attach this form or report to some table or query if
so how
do i do that? and also how do i attach this to my report since my
whole database is based on dates i need weekly matrics on reports.
>
its form project initation date to date of compelation but in between
it goes thru various stages of dates that are scheledule with vendors
for testing and turning up the telephonne lines. i will be needing to
know how many orders we have received , how many completed, deleted
before successful completion, items due in 1,2,3,5 or 10 days.
>
Any hepl is greatly appreciated
>
Thanks,

[access baby]

Re: from what date error

On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

Are you using Method 1 (parameter query) in this article:

http://allenbrowne.com/casu-08.html

>
If so, at step 4 you added a text box to the report and set its properties
like this:
Control Source =[StartDate]
Format Short Date
Name txtStartDate
>
The name you used in the query must match exactly. For example, if you used
a space in the name in the query, you must do the same on the report.
>
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>
<nishkr...@gmai l.comwrote in message
>
news:1175624702 .528761.130630@ p77g2000hsh.goo glegroups.com.. .
>
>
>

Hi,
I am new to access

>

I created the form and report from Allen Browne's Frmwhat Date the way
he
has described but when i preview report it shows
StartDate: name?
Enddate: name?
am i suppose to attach this form or report to some table or query if
so how
do i do that? and also how do i attach this to my report since my
whole database is based on dates i need weekly matrics on reports.

>

its form project initation date to date of compelation but in between
it goes thru various stages of dates that are scheledule with vendors
for testing and turning up the telephonne lines. i will be needing to
know how many orders we have received , how many completed, deleted
before successful completion, items due in 1,2,3,5 or 10 days.

>

Any hepl is greatly appreciated

>

Thanks,- Hide quoted text -

>
- Show quoted text -

Hi Allen,

i am using Method 2 also please help me how do i use this From what
date in my database i mean how do i attach this report to my database.

Thanks

[Allen Browne]

Re: from what date error

Okay, if you used method 2, make sure the form is still open until the
report is closed.

I did not understand the question about attaching the report to your
database. Presumably you already have the report in your database.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"access baby" <nishkrish@gmai l.comwrote in message
news:1176299183 .638949.61810@q 75g2000hsh.goog legroups.com...

On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

>Are you using Method 1 (parameter query) in this article:
> http://allenbrowne.com/casu-08.html
>>
>If so, at step 4 you added a text box to the report and set its
>properties
>like this:
> Control Source =[StartDate]
> Format Short Date
> Name txtStartDate
>>
>The name you used in the query must match exactly. For example, if you
>used
>a space in the name in the query, you must do the same on the report.
>>
><nishkr...@gma il.comwrote in message
>>
>news:117562470 2.528761.130630 @p77g2000hsh.go oglegroups.com. ..
>>
>>
>>

Hi,
I am new to access

>>

I created the form and report from Allen Browne's Frmwhat Date the way
he
has described but when i preview report it shows
StartDate: name?
Enddate: name?
am i suppose to attach this form or report to some table or query if
so how
do i do that? and also how do i attach this to my report since my
whole database is based on dates i need weekly matrics on reports.

>>

its form project initation date to date of compelation but in between
it goes thru various stages of dates that are scheledule with vendors
for testing and turning up the telephonne lines. i will be needing to
know how many orders we have received , how many completed, deleted
before successful completion, items due in 1,2,3,5 or 10 days.

>>

Any hepl is greatly appreciated

>>

Thanks,- Hide quoted text -

>>
>- Show quoted text -

>
Hi Allen,
>
i am using Method 2 also please help me how do i use this From what
date in my database i mean how do i attach this report to my database.

[access baby]

Re: from what date error

On Apr 11, 7:08 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

Okay, if you used method 2, make sure the form is still open until the
report is closed.
>
I did not understand the question about attaching the report to your
database. Presumably you already have the report in your database.
>
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>
"access baby" <nishkr...@gmai l.comwrote in message
>
news:1176299183 .638949.61810@q 75g2000hsh.goog legroups.com...
>
>
>

On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

Are you using Method 1 (parameter query) in this article:
http://allenbrowne.com/casu-08.html

>

If so, at step 4 you added a text box to the report and set its
properties
like this:
Control Source =[StartDate]
Format Short Date
Name txtStartDate

>

The name you used in the query must match exactly. For example, if you
used
a space in the name in the query, you must do the same on the report.

>

<nishkr...@gmai l.comwrote in message

>

>news:117562470 2.528761.130630 @p77g2000hsh.go oglegroups.com. ..

>

Hi,
I am new to access

>

I created the form and report from Allen Browne's Frmwhat Date the way
he
has described but when i preview report it shows
StartDate: name?
Enddate: name?
am i suppose to attach this form or report to some table or query if
so how
do i do that? and also how do i attach this to my report since my
whole database is based on dates i need weekly matrics on reports.

>

its form project initation date to date of compelation but in between
it goes thru various stages of dates that are scheledule with vendors
for testing and turning up the telephonne lines. i will be needing to
know how many orders we have received , how many completed, deleted
before successful completion, items due in 1,2,3,5 or 10 days.

>

Any hepl is greatly appreciated

>

Thanks,- Hide quoted text -

>

- Show quoted text -

>

Hi Allen,

>

i am using Method 2 also please help me how do i use this From what
date in my database i mean how do i attach this report to my database.- Hide quoted text -

>
- Show quoted text -

shows an error when clicked OK Button If IsNull(Me.txtSt artDate)
Then , when i open report preview it shows StartDate #Error
End Date # Error

[Allen Browne]

Re: from what date error

That suggests you do not have a text box named txtStartDate on your form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"access baby" <nishkrish@gmai l.comwrote in message
news:1176302060 .713209.277020@ y5g2000hsa.goog legroups.com...

On Apr 11, 7:08 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

>Okay, if you used method 2, make sure the form is still open until the
>report is closed.
>>
>I did not understand the question about attaching the report to your
>database. Presumably you already have the report in your database.
>>
>"access baby" <nishkr...@gmai l.comwrote in message
>>
>news:117629918 3.638949.61810@ q75g2000hsh.goo glegroups.com.. .
>>
>>
>>

On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
>Are you using Method 1 (parameter query) in this article:
> http://allenbrowne.com/casu-08.html

>>

>If so, at step 4 you added a text box to the report and set its
>properties
>like this:
> Control Source =[StartDate]
> Format Short Date
> Name txtStartDate

>>

>The name you used in the query must match exactly. For example, if you
>used
>a space in the name in the query, you must do the same on the report.

>>

><nishkr...@gma il.comwrote in message

>>

>>news:11756247 02.528761.13063 0@p77g2000hsh.g ooglegroups.com ...

>>

Hi,
I am new to access

>>

I created the form and report from Allen Browne's Frmwhat Date the
way
he
has described but when i preview report it shows
StartDate: name?
Enddate: name?
am i suppose to attach this form or report to some table or query if
so how
do i do that? and also how do i attach this to my report since my
whole database is based on dates i need weekly matrics on reports.

>>

its form project initation date to date of compelation but in
between
it goes thru various stages of dates that are scheledule with
vendors
for testing and turning up the telephonne lines. i will be needing
to
know how many orders we have received , how many completed, deleted
before successful completion, items due in 1,2,3,5 or 10 days.

>>

Any hepl is greatly appreciated

>>

Thanks,- Hide quoted text -

>>

>- Show quoted text -

>>

Hi Allen,

>>

i am using Method 2 also please help me how do i use this From what
date in my database i mean how do i attach this report to my database.-
Hide quoted text -

>>
>- Show quoted text -

>
shows an error when clicked OK Button If IsNull(Me.txtSt artDate)
Then , when i open report preview it shows StartDate #Error
End Date # Error
>

[access baby]

Re: from what date error

On Apr 11, 7:44 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

That suggests you do not have a text box named txtStartDate on your form.
>
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>
"access baby" <nishkr...@gmai l.comwrote in message
>
news:1176302060 .713209.277020@ y5g2000hsa.goog legroups.com...
>
>
>

On Apr 11, 7:08 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

Okay, if you used method 2, make sure the form is still open until the
report is closed.

>

I did not understand the question about attaching the report to your
database. Presumably you already have the report in your database.

>

"access baby" <nishkr...@gmai l.comwrote in message

>

>news:117629918 3.638949.61810@ q75g2000hsh.goo glegroups.com.. .

>

On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
Are you using Method 1 (parameter query) in this article:
http://allenbrowne.com/casu-08.html

>

If so, at step 4 you added a text box to the report and set its
properties
like this:
Control Source =[StartDate]
Format Short Date
Name txtStartDate

>

The name you used in the query must match exactly. For example, if you
used
a space in the name in the query, you must do the same on the report.

>

<nishkr...@gmai l.comwrote in message

>

>news:117562470 2.528761.130630 @p77g2000hsh.go oglegroups.com. ..

>

Hi,
I am new to access

>

I created the form and report from Allen Browne's Frmwhat Date the
way
he
has described but when i preview report it shows
StartDate: name?
Enddate: name?
am i suppose to attach this form or report to some table or query if
so how
do i do that? and also how do i attach this to my report since my
whole database is based on dates i need weekly matrics on reports.

>

its form project initation date to date of compelation but in
between
it goes thru various stages of dates that are scheledule with
vendors
for testing and turning up the telephonne lines. i will be needing
to
know how many orders we have received , how many completed, deleted
before successful completion, items due in 1,2,3,5 or 10 days.

>

Any hepl is greatly appreciated

>

Thanks,- Hide quoted text -

>

- Show quoted text -

>

Hi Allen,

>

i am using Method 2 also please help me how do i use this From what
date in my database i mean how do i attach this report to my database.-
Hide quoted text -

>

- Show quoted text -

>

shows an error when clicked OK Button If IsNull(Me.txtSt artDate)
Then , when i open report preview it shows StartDate #Error
End Date # Error- Hide quoted text -

>
- Show quoted text -

no i do have have txt startdate and end date on form and the commond
button ok and cancel i created the way you have mentioned in your site
and i copied pasted the syntax for Ok and Cancel that you have written.

[Allen Browne]

Re: from what date error

You will find that writing code is very pedantic.

If you have a text box named
txt startdate
(i.e. the name contains a space), it won't match.

You will need to handle this kind of debugging yourself: we cannot do it for
you here, as we cannot even see your database.

Be sure to include this line at the top of your module:
Option Explicit

Then choose Compile on the Debug menu (in the code window), and solve any
errors before you try to run the code.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"access baby" <nishkrish@gmai l.comwrote in message
news:1176303093 .375868.47160@n 59g2000hsh.goog legroups.com...

On Apr 11, 7:44 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

>That suggests you do not have a text box named txtStartDate on your form.
>>
>--
>Allen Browne - Microsoft MVP. Perth, Western Australia
>Tips for Access users -http://allenbrowne.com/tips.html
>Reply to group, rather than allenbrowne at mvps dot org.
>>
>"access baby" <nishkr...@gmai l.comwrote in message
>>
>news:117630206 0.713209.277020 @y5g2000hsa.goo glegroups.com.. .
>>
>>
>>

On Apr 11, 7:08 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
>Okay, if you used method 2, make sure the form is still open until the
>report is closed.

>>

>I did not understand the question about attaching the report to your
>database. Presumably you already have the report in your database.

>>

>"access baby" <nishkr...@gmai l.comwrote in message

>>

>>news:11762991 83.638949.61810 @q75g2000hsh.go oglegroups.com. ..

>>

On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote:
>Are you using Method 1 (parameter query) in this article:
> http://allenbrowne.com/casu-08.html

>>

>If so, at step 4 you added a text box to the report and set its
>properties
>like this:
> Control Source =[StartDate]
> Format Short Date
> Name txtStartDate

>>

>The name you used in the query must match exactly. For example, if
>you
>used
>a space in the name in the query, you must do the same on the
>report.

>>

><nishkr...@gma il.comwrote in message

>>

>>news:11756247 02.528761.13063 0@p77g2000hsh.g ooglegroups.com ...

>>

Hi,
I am new to access

>>

I created the form and report from Allen Browne's Frmwhat Date
the
way
he
has described but when i preview report it shows
StartDate: name?
Enddate: name?
am i suppose to attach this form or report to some table or query
if
so how
do i do that? and also how do i attach this to my report since my
whole database is based on dates i need weekly matrics on
reports.

>>

its form project initation date to date of compelation but in
between
it goes thru various stages of dates that are scheledule with
vendors
for testing and turning up the telephonne lines. i will be
needing
to
know how many orders we have received , how many completed,
deleted
before successful completion, items due in 1,2,3,5 or 10 days.

>>

Any hepl is greatly appreciated

>>

Thanks,- Hide quoted text -

>>

>- Show quoted text -

>>

Hi Allen,

>>

i am using Method 2 also please help me how do i use this From what
date in my database i mean how do i attach this report to my
database.-
Hide quoted text -

>>

>- Show quoted text -

>>

shows an error when clicked OK Button If IsNull(Me.txtSt artDate)
Then , when i open report preview it shows StartDate #Error
End Date # Error- Hide quoted text -

>>
>- Show quoted text -

>
no i do have have txt startdate and end date on form and the commond
button ok and cancel i created the way you have mentioned in your site
and i copied pasted the syntax for Ok and Cancel that you have written.

[access baby]

Re: from what date error

On Apr 11, 8:20 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

You will find that writing code is very pedantic.
>
If you have a text box named
txt startdate
(i.e. the name contains a space), it won't match.
>
You will need to handle this kind of debugging yourself: we cannot do it for
you here, as we cannot even see your database.
>
Be sure to include this line at the top of your module:
Option Explicit
>
Then choose Compile on the Debug menu (in the code window), and solve any
errors before you try to run the code.
>
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>
"access baby" <nishkr...@gmai l.comwrote in message
>
news:1176303093 .375868.47160@n 59g2000hsh.goog legroups.com...
>
>
>

On Apr 11, 7:44 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:

That suggests you do not have a text box named txtStartDate on your form.

>

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>

"access baby" <nishkr...@gmai l.comwrote in message

>

>news:117630206 0.713209.277020 @y5g2000hsa.goo glegroups.com.. .

>

On Apr 11, 7:08 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
Okay, if you used method 2, make sure the form is still open until the
report is closed.

>

I did not understand the question about attaching the report to your
database. Presumably you already have the report in your database.

>

"access baby" <nishkr...@gmai l.comwrote in message

>

>news:117629918 3.638949.61810@ q75g2000hsh.goo glegroups.com.. .

>

On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote:
Are you using Method 1 (parameter query) in this article:
http://allenbrowne.com/casu-08.html

>

If so, at step 4 you added a text box to the report and set its
properties
like this:
Control Source =[StartDate]
Format Short Date
Name txtStartDate

>

The name you used in the query must match exactly. For example, if
you
used
a space in the name in the query, you must do the same on the
report.

>

<nishkr...@gmai l.comwrote in message

>

>news:117562470 2.528761.130630 @p77g2000hsh.go oglegroups.com. ..

>

Hi,
I am new to access

>

I created the form and report from Allen Browne's Frmwhat Date
the
way
he
has described but when i preview report it shows
StartDate: name?
Enddate: name?
am i suppose to attach this form or report to some table or query
if
so how
do i do that? and also how do i attach this to my report since my
whole database is based on dates i need weekly matrics on
reports.

>

its form project initation date to date of compelation but in
between
it goes thru various stages of dates that are scheledule with
vendors
for testing and turning up the telephonne lines. i will be
needing
to
know how many orders we have received , how many completed,
deleted
before successful completion, items due in 1,2,3,5 or 10 days.

>

Any hepl is greatly appreciated

>

Thanks,- Hide quoted text -

>

- Show quoted text -

>

Hi Allen,

>

i am using Method 2 also please help me how do i use this From what
date in my database i mean how do i attach this report to my
database.-
Hide quoted text -

>

- Show quoted text -

>

shows an error when clicked OK Button If IsNull(Me.txtSt artDate)
Then , when i open report preview it shows StartDate #Error
End Date # Error- Hide quoted text -

>

- Show quoted text -

>

no i do have have txt startdate and end date on form and the commond
button ok and cancel i created the way you have mentioned in your site
and i copied pasted the syntax for Ok and Cancel that you have written.- Hide quoted text -

>
- Show quoted text -

Sorry and thanks for all your help .