ACCESS FEED: RE: [MS_AccessPros] Runtime 2007 with Access 2003 db

Rabu, 31 Juli 2013

RE: [MS_AccessPros] Runtime 2007 with Access 2003 db

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]