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
 
Back
Top