create report based on data from other form?
in [Reports]
|
From: Seddon Acaster on 19 Apr 2010 06:15 My code is as follows: DoCmd.OpenReport "test", acViewPreview, , "[project_id] = " & Me![project_id] When button (with above code) is pressed I get following message box: Enter Parameter Value When I manually enter a value then the resulting report is displayed correctly. What am I doing wrong? "Seddon Acaster" wrote: > This may or may not be relevant but I am using MS Access 2007. > > "Stefan Hoffmann" wrote: > > > hi Seddon, > > > > On 17.04.2010 16:23, Seddon Acaster wrote: > > > Thx Stefan. I tried this and all it did was show all entries rather those > > > filered by project_id. > > Then check whether you have the data source of your report crafted > > correctly and that you have specified the parameter for the OpenReport > > in the right command order. It must be the fourth parameter: > > > > http://msdn.microsoft.com/en-us/library/aa220304%28office.11%29.aspx > > > > > > mfG > > --> stefan <-- > > . > >
From: Stefan Hoffmann on 19 Apr 2010 07:12 hi Seddon, On 19.04.2010 12:15, Seddon Acaster wrote: > When button (with above code) is pressed I get following message box: > > Enter Parameter Value Ah, good. > When I manually enter a value then the resulting report is displayed > correctly. > > What am I doing wrong? This means that we have either a typo or reference error. For the typo check the spelling of the parameter name as displayed in the input box you're getting. For a reference error take a close look at your reports data source: has the field a table name prefix in its design view? mfG --> stefan <--
From: John Spencer on 19 Apr 2010 08:32
Or it could be that Project_ID is not an number field. If that is the case you need to change the call to DoCmd.OpenReport "test", acViewPreview, , "[project_id]=""" & Me![project_id] & """" Or alternative using ' instead of " DoCmd.OpenReport "test",acViewPreview,, "[project_id]='" & Me![project_id] & "'" Watch out for the line wrap and that should all be on one line. The newsreader will make that two lines. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Stefan Hoffmann wrote: > hi Seddon, > > On 19.04.2010 12:15, Seddon Acaster wrote: >> When button (with above code) is pressed I get following message box: >> >> Enter Parameter Value > Ah, good. > >> When I manually enter a value then the resulting report is displayed >> correctly. >> >> What am I doing wrong? > This means that we have either a typo or reference error. For the typo > check the spelling of the parameter name as displayed in the input box > you're getting. For a reference error take a close look at your reports > data source: has the field a table name prefix in its design view? > > > mfG > --> stefan <-- |