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

from what date error

P: n/a
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,

Apr 3 '07 #1
Share this Question
Share on Google+
8 Replies


P: n/a
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.

<ni*******@gmail.comwrote in message
news:11**********************@p77g2000hsh.googlegr oups.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,
Apr 4 '07 #2

P: n/a
On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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...@gmail.comwrote in message

news:11**********************@p77g2000hsh.googlegr oups.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

Apr 11 '07 #3

P: n/a
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" <ni*******@gmail.comwrote in message
news:11*********************@q75g2000hsh.googlegro ups.com...
On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
>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...@gmail.comwrote in message

news:11**********************@p77g2000hsh.googleg roups.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.
Apr 11 '07 #4

P: n/a
On Apr 11, 7:08 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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...@gmail.comwrote in message

news:11*********************@q75g2000hsh.googlegro ups.com...
On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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...@gmail.comwrote in message
>news:11**********************@p77g2000hsh.googleg roups.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.txtStartDate)
Then , when i open report preview it shows StartDate #Error
End Date # Error

Apr 11 '07 #5

P: n/a
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" <ni*******@gmail.comwrote in message
news:11**********************@y5g2000hsa.googlegro ups.com...
On Apr 11, 7:08 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
>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...@gmail.comwrote in message

news:11*********************@q75g2000hsh.googlegr oups.com...
On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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...@gmail.comwrote in message
>>news:11**********************@p77g2000hsh.google groups.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.txtStartDate)
Then , when i open report preview it shows StartDate #Error
End Date # Error
Apr 11 '07 #6

P: n/a
On Apr 11, 7:44 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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...@gmail.comwrote in message

news:11**********************@y5g2000hsa.googlegro ups.com...
On Apr 11, 7:08 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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...@gmail.comwrote in message
>news:11*********************@q75g2000hsh.googlegr oups.com...
On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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...@gmail.comwrote in message
>news:11**********************@p77g2000hsh.googleg roups.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.txtStartDate)
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.

Apr 11 '07 #7

P: n/a
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" <ni*******@gmail.comwrote in message
news:11*********************@n59g2000hsh.googlegro ups.com...
On Apr 11, 7:44 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
>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...@gmail.comwrote in message

news:11**********************@y5g2000hsa.googlegr oups.com...
On Apr 11, 7:08 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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...@gmail.comwrote in message
>>news:11*********************@q75g2000hsh.googleg roups.com...
On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@SeeSig.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...@gmail.comwrote in message
>>news:11**********************@p77g2000hsh.google groups.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.txtStartDate)
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.
Apr 11 '07 #8

P: n/a
On Apr 11, 8:20 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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...@gmail.comwrote in message

news:11*********************@n59g2000hsh.googlegro ups.com...
On Apr 11, 7:44 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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...@gmail.comwrote in message
>news:11**********************@y5g2000hsa.googlegr oups.com...
On Apr 11, 7:08 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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...@gmail.comwrote in message
>news:11*********************@q75g2000hsh.googlegr oups.com...
On Apr 4, 2:19 am, "Allen Browne" <AllenBro...@SeeSig.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...@gmail.comwrote in message
>news:11**********************@p77g2000hsh.googleg roups.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.txtStartDate)
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 .

Apr 11 '07 #9

This discussion thread is closed

Replies have been disabled for this discussion.