Thanks Glen
--- In MS_Access_Professionals@yahoogroups.com, "Glenn Lloyd" <argeedblu@...> wrote:
>
> Hi Jane,
>
>
>
> You can use a form or report object to do this. The general pattern for a
> report is this:
>
>
>
> Sub ReportOpenAndDisplay()
>
> 'declare the object
>
> Dim rpt As Access.Report
>
>
>
>
>
> 'instantiate the object
>
>
>
> 'report must have a module for it to appear in the project explorer
>
> Set rpt = Report_rptTestLogErrors 'substitute your report name
>
>
>
> With rpt
>
> 'assign record source
>
> .RecordSource = ""
>
>
>
> 'display the report
>
> .Visible = True
>
> End With
>
>
>
>
>
> End Sub
>
>
>
> Glenn
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jane
> Sent: Wednesday, July 31, 2013 4:52 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Runtime 2007 with Access 2003 db
>
>
>
>
>
> Thanks Glen. That will help - I didn't know about the runtime switch, I was
> looking around to install runtime on a access clean PC.
>
> Also what do you mean by setting the recordsource & captions via a statement
> rather than in design view.
> At the moment I have a PrintReport function that I pass the recordsource and
> the caption. It opens the report in design view, sets the recordsource &
> caption & prints to the default printer for that report. How would I do it
> not in design view?
> Many thanks
> Jane
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Glenn Lloyd"
> <argeedblu@> wrote:
> >
> > Jane,
> >
> >
> >
> > You might want to try running your application with the runtime instead of
> > full access. I have a virtual machine without office installed to do that
> > sort of testing but it is possible also to use the /runtime switch in your
> > normal environment. See this article
> > <http://support.microsoft.com/kb/209207> .
> >
> >
> >
> > You will have to change how you modify the recordsource, captions, etc. as
> > you won't be able to open anything in design view. To do this you use a
> > statement that assigns what you want to the relevant property of the form,
> > control, etc. For the recordsource of a form, for example, you can assign
> an
> > sql statement. On caution, test your sql in a normal query to make sure a)
> > that it works and b) that it works correctly. If your sql isn't quite
> > correct, you won't necessarily see an error. An error in a combo's
> > recordsource, for example, just displays an empty list.
> >
> >
> >
> > Glenn
> >
> > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Jane
> > Sent: Tuesday, July 30, 2013 6:47 AM
> > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: [MS_AccessPros] Runtime 2007 with Access 2003 db
> >
> >
> >
> >
> >
> > Hi
> > I have developed an extensive database in access 2003, with user-level
> > security.
> > I've just been asked if it will run under the runtime 2007. It runs fine
> > with Access 2007. From what I've read, I might have issues with menus and
> > the default shortcut menu won't work.
> >
> > I have code that changes the recordsource of forms and reports and a
> couple
> > of labels/captions (the reports are opened in design view, changed &
> saved).
> > It also changes the default printer (there is a table of reports, users
> and
> > the printer that the report should come out on). I'm guessing that these
> > won't work as it design view. So how do others change reports design
> items?
> >
> > Also is there anything else anyone has come across, that I don't know
> about?
> > Many thanks
> > Jane
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
