Opening reports from a URL.

[McNulty]

Hi,



I am developing a small aplication, that can be used via Web, with PHP.

Actually, I have used MySQL to design the database, and I am using Access because it is very easy to generate forms and reports. So I have linked the MySQL tables into Access. Also I have created most of the app with Access forms. I will use the app also through a PHP interface that I have designed.

But I would like not to create new reports for PHP. Is there any way to get an URL that open a concrete report from the website?

Thank you

[CJ_London]

you need access installed locally to open an access report - however if these are static you can save the report as a pdf and store the pdf on the website.

[McNulty]

you need access installed locally to open an access report - however if these are static you can save the report as a pdf and store the pdf on the website.

As I am linking the tables from MySQL, Access file is installed locally in each PC, as a client application. But I don't know how to link a single report from inside Access file from an URL.

Unfortunately, as reports, they are not static: they always show data dinamically.

I remember it was possibly to link some parts from an Access file frpom shortcuts. Something like this:

"location of MSAccess.EXE" "location of accdb"

But it seems that it is not possible with modern versions. And I don't know the complete syntax to open forms, reports, queries, etc.

[McNulty]

I have just found this:

"Each Office product has a different set of command-line switches.

/x


macro


Opens the Access database that was specified before the /x switch, and then runs the specified macro. Another way to run a macro when you open a database is to create a macro named AutoExec.


Macros can contain viruses, so you must be careful about running them. Take the following precautions: run up-to-date antivirus software on your computer; use the Trust Center to disable all macros except those that are digitally signed; maintain a list of trusted sources of macros.


/ cmd


None


Specifies that what follows on the command line is the value that will be returned by the Command function. This option must be the last switch on the command line. You can use a semicolon ( as an alternative to /cmd.


Use this switch to specify a command-line argument that can be used in Visual Basic for Applications (VBA) code."

It seems that I can send a command to be executed by VBA in Access. I'm not sure how to do this, but it may be very useful.

Anyone that know about this?

[CJ_London]

I was going to suggest that - but seem to recall you can open a form in a similar way - not using a macro - but otherwise create the macro to open what is required

[McNulty]

I was going to suggest that - but seem to recall you can open a form in a similar way - not using a macro - but otherwise create the macro to open what is required

Thank you.

I also have thought about duplicate parts of the Access file. For example, to create each report in a separate Acces file, so I may open each report individually.

But, even if possible, it would be necessary being able to pass parameters.

[CJ_London]

It’s not something I’ve tried since I don’t use macros but can’t you set a parameter to a macro? Otherwise save the parameter to a temporary text file (i.e. the reportname) and have the macro open the text file and read the name

[McNulty]

It’s not something I’ve tried since I don’t use macros but can’t you set a parameter to a macro? Otherwise save the parameter to a temporary text file (i.e. the reportname) and have the macro open the text file and read the name

Good idea

Not easy for my knowledge, but not impossible. Thank you. I will try it.

Anyway, I will continue looking for a more direct solution.

[CJ_London]

found this link which may be of help - it opens a form - but don't see why it couldn't open a report - or perhaps the form opens the report

https://www.pcreview.co.uk/threads/c...ecord.3395824/