Need direction - Return filtered report from MS Access query

[par]

I have a drawing that is linked to an access database. Each room displays
summary info regarding that room and all is fine. Now the functionality I
need to get built in… For the end user, I need a control for each room that
will send a variable (room #) to the database and return (in a new window) a
filtered, sortable data from a query.

I don’t have a lot of programming experience but will dig in where I need
to. Any direction would be appreciated… Thanks!

 

[Al Edlund]

I'd start by building a query in access that gathers the data that you want
and then use a page event (selected shape, whatever) to call the stored
procedure(query). this requires skills in events (in the developing visio
solutions document in msdn) and database calls (ado, oledb, whatever).
results from the query can be put into a form using standard vb controls.
al

 

[Bernhard Marx]

Hello par,

First of all you have to get some experiances with VBA. There you can create
form (window) that's called "UserForm". There you can work with "controls".
There are also control for e.g. the ADODB-Connection... that's all in short
version.

Therefor you can contact me here or via mail ([email protected]). I'll
try to help you best I can.

Bernhard

 

[par]

OK so I've finally been able to work my way back onto this project. I
appreciate the response and the queries are ready. Now working on the
database calls, I'm having proplems working with the ADO Data Control ...
When I try to use the control, I get an error saying that the control is not
properly licensed. What do I need to do to get this working? or is the
another/better way to do this?

thanks!