Changing recordset?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Hi!

I have created a recordset via code that I wold like to bind to a report but
I can't get it to work. any ideas?

'not working
Set Reports("myreport").Recordset = rs

/e
 
I am not aware that this would work. You can bind a form to a recordset but
not a report.

Is there a reason why you don't set the Record Source property to a SQL
statement?
 
I'm not satisfied with that solution either but today I have 2 querys (that
are almost impossible to make to 1), create a table from the first query and
append to that table from the second query and finally create a report based
on that table (or actually on a simple query based on the table, but that's
not a problem).

It works great BUT my problem is that I need to create a table in the db and
I want to have ONE db and shortcut it to the users because it's so much
easier to update and make changes to it that way. So therefore I'm trying to
base the report on some sort of recordset created on the fly...

Any ideas welcome!!

/e
 
I can't figure out what you mean by "ONE db". Does this mean your
application is only a single MDB that is shared by more than one user? I
can't imagine this would be easier to update.
 
Today I have separated logic and data (have a linked db (db with data and an
interface with logic)). Every time I make a change in the interface I have
to distribute it to all the users, if I save it all in the same db I won't
have to do that.

/e
 
There are lots of solutions for making this quite effortless. I have even
had good luck with a short cut that copies the latest version of the
Front-End to the local workstation and then running it.

Tony Toews has a solution at http://www.granite.ab.ca/access/autofe.htm
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to clone a reports recordset? 9
OBJECTIVE: Print PDF to file, each record should be a file name =PID (field) - have code issue belo 2
Golf Score Reporting 2
Report Recordset 1
recordset's current position 2
Import File Information 0
Regarding setting a Report's recordset 1
Printing a series of reports 3

Back
Top