Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 25th, 2003, 07:32 AM
Registered User
Join Date: Oct 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to mhosneddine
Default Facing Problems with text in a Where Clause

I need someone to tell what is the correct syntax for a where clause having text.

I have a table with the following fields: Date, Company, Operation and Quantity. The operation field is a text field where company and Quantity fields are numeric. The date field is a date fomatted and the operation field is Text

I created a buttom with an event procedure as follows:

docmd.openreport stdocname,acpreview,,"date=[forms]![pvc]![text] and operation="w""
this is not working

I don't know know what the right code might be

I am using Microsoft access 2002

thanks in advance for any when who can help
Old October 25th, 2003, 08:53 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 184
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Jonax

Try this:
docmd.openreport stdocname,acpreview,,"date=[forms]![pvc]![text] and operation='w'"

Btw: This isn't the right forum for this - I think...

Old October 26th, 2003, 04:10 PM
Authorized User
Join Date: Oct 2003
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts

I'm possible not the best one to address this ( I'm new to the forum ).

With that having been said I'd try 'w' ( not "w" )
docmd.openreport stdocname,acpreview,,"date=[forms]![pvc]![text] and operation='w'"
Not this
docmd.openreport stdocname,acpreview,,"date=[forms]![pvc]![text] and operation="w""

I hope that this help.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form Corruption / Problems with Where Clause jeremy1048 Access 7 October 22nd, 2007 09:52 AM
facing problems C#.net remoting,please help me gourab C# 2005 0 June 30th, 2007 02:05 AM
Problems using case statement in where clause vghiya SQL Server 2000 3 May 28th, 2007 05:12 AM
C variable in WHERE clause problems turnbui MySQL 1 December 7th, 2006 12:55 PM
Facing problems using RDS in VB - Urgent Sri VB Components 0 November 4th, 2004 06:27 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.