Can someone please help me get the " and ' right for this? (PARTNUMBER is a
text field). I just can't get it...argh!
DoCmd.OpenReport stDocName, acPreview, , "[PARTNUMBER] =" ' "&
Me.PARTNUMBER" ' "
|
|
0
|
|
|
|
Reply
|
 Utf
|
11/27/2007 3:07:00 AM |
|
DoCmd.OpenReport stDocName, acPreview, , "[PARTNUMBER] =""" &
Me.PARTNUMBER & """"
--
Duane Hookom
Microsoft Access MVP
"Gina K" wrote:
> Can someone please help me get the " and ' right for this? (PARTNUMBER is a
> text field). I just can't get it...argh!
>
> DoCmd.OpenReport stDocName, acPreview, , "[PARTNUMBER] =" ' "&
> Me.PARTNUMBER" ' "
|
|
|
0
|
|
|
|
Reply
|
Utf
|
11/27/2007 3:14:02 AM
|
|
You have an extra " right after the = and need a & after Me.PARTNUMBER
Try:
DoCmd.OpenReport stDocName, acPreview, , "[PARTNUMBER] = ' "& Me.PARTNUMBER
& " ' "
Gina K wrote:
>Can someone please help me get the " and ' right for this? (PARTNUMBER is a
>text field). I just can't get it...argh!
>
>DoCmd.OpenReport stDocName, acPreview, , "[PARTNUMBER] =" ' "&
>Me.PARTNUMBER" ' "
--
Boyd Trimmell
aka Hi Tech Coach
http://www.hitechcoach.com
http://www.officeprogramming.com
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200711/1
|
|
|
0
|
|
|
|
Reply
|
Boyd
|
11/28/2007 11:37:40 PM
|
|
|
2 Replies
715 Views
(page loaded in 0.112 seconds)
Similiar Articles: DoCmd.OpenReport - microsoft.public.access.reportsCan someone please help me get the " and ' right for this? (PARTNUMBER is a text field). I just can't get it...argh! DoCmd.OpenReport stDocName, a... DoCmd.OpenReport's "View" Parameter - microsoft ...On Thu, 03 Dec 2009 16:21:47 -0500, Randy Yates wrote: > I have a piece of code in a button event, > > Call DoCmd.OpenReport("Invoice", acPrint, , "OrderID ... Where Condition (OpenReport) - microsoft.public.access.reports ...I know the code below is wrong but I am looking for help on how to state the where condition: DoCmd.OpenReport "1", acViewPreview, , "[email] = " & Nz(lst.Column(1 ... DoCmd.OpenReport Error - microsoft.public.access.queries ...docmd.openreport runtime errors DataBase - DataBase Discussion ... hi, I am having unstable outcome from this command DoCmd.OpenReport report_StationSchedule-View ... OpenReport + Current Record Only - microsoft.public.access.forms ...The following is the code that is always the "one that works" as ive read in the other posts; DoCmd.OpenReport "Report_Name", acViewPreview, , "Report_ID_Field = "" & Me ... using DoCmd.OutputTo for reports: event code doesn't execute ...I use DoCmd.OpenReport and the Load event code gets executed. But when I use the DoCmd.OutputTo for the same report, the load event code does NOT e... DoCmd.OpenQuery - microsoft.public.accessExample in use within Access VB: DoCmd.OpenQuery "qry-append-BuildMonthlyUsage" DoCmd.OpenReport "rpt-ShowMonthlyUsage", acViewPreview Or is there another method ... The OpenReport action was Cancelled - microsoft.public.access ...Method to identify printer for docmd.printout - microsoft.public ... The OpenReport action was Cancelled - microsoft.public.access ... The User went back to her ... Report Filter In DoCmd.PrintOut ? - microsoft.public.access ...DoCmd.OpenReport Method PrintOut Method ... using the existing query Report Filter. Visual Basic for Applications; DoCmd.OpenReport "Sales Report", acViewNormal, "Report ... specified criteria with outputto? - microsoft.public.access ...Hi, If I want to print a report by specifying criterion I used DoCmd.OpenReport "rptMOFReceiveForm", acViewPreview, , "[Ref ID]=" & Me.Me_MOFRef_ID How can I ... DoCmd OpenReport in Microsoft AccessOpen Access reports using visual basic openreport command. Review Access database docmd open report sample code. DoCmd.OpenReport Method - Microsoft Corporation: Software ...The OpenReport method carries out the OpenReport action in Visual Basic. DoCmd.OpenReport - Toolbox for IT Groups - Database Community ...I have a problem w/ the 'DoCmd.OpenReport cmd. this is pretty straight forward. I want to open a report based on the same qry as ... docmd.OpenReport - Microsoft Access / VBAdocmd.OpenReport. Microsoft Access / VBA Forums on Bytes. ... I am trying to open a report to view an invoice for a specific invoice number. DoCmd.OpenReport Method - Access - Office.comThe OpenReport method carries out the OpenReport action in Visual Basic. Syntax expression .OpenReport( ReportName , View , FilterName , WhereCondition , WindowMode ... 7/20/2012 7:30:34 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
12 followers. 