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, "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@yahoogroups.com] On Behalf Of Jane
> Sent: Tuesday, July 30, 2013 6:47 AM
> To: MS_Access_Professionals@yahoogroups.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]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar