Where condition

[Sigurd Bruteig]

Hi!
The following code give me an error message (syntax error 3075) and I can't
figure out what is wrong! Any suggestions?

Sigurd

Dim stDocName As String
stDocName = "rptFaktura"
Dim stLinkCriteria As String
stLinkCriteria = "[Invoicedate]= " & Date

DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

[Tom van Stiphout]

On Fri, 3 Oct 2003 15:47:40 +0200, "Sigurd Bruteig"
<s-********@online.no> wrote:

Try this:
stLinkCriteria = "[Invoicedate]=#" & Date & "#"

-Tom.

Hi!
The following code give me an error message (syntax error 3075) and I can't
figure out what is wrong! Any suggestions?

Sigurd

Dim stDocName As String
stDocName = "rptFaktura"
Dim stLinkCriteria As String
stLinkCriteria = "[Invoicedate]= " & Date

DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

[Sigurd Bruteig]

"Tom van Stiphout" <to*****@no.spam.cox.net> skrev i melding
news:dl********************************@4ax.com...

On Fri, 3 Oct 2003 15:47:40 +0200, "Sigurd Bruteig"
<s-********@online.no> wrote:

Try this:
stLinkCriteria = "[Invoicedate]=#" & Date & "#"

Thank you Tom, but it is still the same error. The date is correct it seems
(when i hold the cursor over the date it is displayed correctly).
[Invoicedate] is a field in a table, present in the report.

Sigurd

[bebelino]

On Fri, 3 Oct 2003 15:47:40 +0200, "Sigurd Bruteig"
<s-********@online.no> wrote:

Dim stDocName As String
stDocName = "rptFaktura"
Dim stLinkCriteria As String
stLinkCriteria = "[Invoicedate]= " & Date

DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

Maybe stupid, but are you sure that the name [Invoicedate] is part of
your query behind the report?
--
bebelino

[Sigurd Bruteig]

Thanks! The solution to a problem could often be a stupid detail that have
been overseen. But in this case the field is in the recordsource of the
report.

Sigurd
"bebelino" <a.*@c.d> skrev i melding
news:6p********************************@4ax.com...

On Fri, 3 Oct 2003 15:47:40 +0200, "Sigurd Bruteig"
<s-********@online.no> wrote:

Dim stDocName As String
stDocName = "rptFaktura"
Dim stLinkCriteria As String
stLinkCriteria = "[Invoicedate]= " & Date

DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

Maybe stupid, but are you sure that the name [Invoicedate] is part of
your query behind the report?
--
bebelino

[Ross Presser]

"Sigurd Bruteig" <s-********@online.no> wrote in
news:gL*******************@news4.e.nsc.no:

"Tom van Stiphout" <to*****@no.spam.cox.net> skrev i melding
news:dl********************************@4ax.com...

On Fri, 3 Oct 2003 15:47:40 +0200, "Sigurd Bruteig"
<s-********@online.no> wrote:

Try this:
stLinkCriteria = "[Invoicedate]=#" & Date & "#"

Thank you Tom, but it is still the same error. The date is correct it
seems (when i hold the cursor over the date it is displayed
correctly). [Invoicedate] is a field in a table, present in the
report.

[notices ".no" at end of email address]
You may be being tripped up by the localization of your date format. Try

stLinkCriteria = "[Invoicedate]=#" & format(date,"yyyy-mm-dd") & "#"

--
Ross Presser -- rpresser AT imtek DOT com
"... VB is essentially the modern equivalent of vulgar Latin in 13th Centurary Europe. Understand it, and
you can travel to places you never heard of and still understand some people." -- Alex K. Angelopoulos

[Bruce M. Thompson]

> The following code give me an error message (syntax error 3075) and I can't

figure out what is wrong! Any suggestions?

Sigurd

Dim stDocName As String
stDocName = "rptFaktura"
Dim stLinkCriteria As String
stLinkCriteria = "[Invoicedate]= " & Date

DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

Is the field "Invoicedate" a Date/Time data type? If not, you might look for
entries in that field that contain invalid characters.

See http://support.microsoft.com/default...b;en-us;178070.

--
Bruce M. Thompson
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

[Sigurd Bruteig]

"Sigurd Bruteig" <s-********@online.no> skrev i melding
news:66*******************@news4.e.nsc.no...

Hi!
The following code give me an error message (syntax error 3075) and I can't figure out what is wrong! Any suggestions?

Sigurd

Dim stDocName As String
stDocName = "rptFaktura"
Dim stLinkCriteria As String
stLinkCriteria = "[Invoicedate]= " & Date

Thank you all! After hours with trying and failing, I finaly found the right
syntax:
stLinkCriteria = "[Invoicedate] = Date()"
DoCmd.OpenReport stDocName, , , stLinkCriteria

Sigurd