convert report created in design mode to editable vba

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to do this with Access 2000? I will need to add to my report
at a later date, and my client will want to change the criteria.
Joan
 
You can modify a report programmatically, by opening it in design view,
e.g.:
DoCmd.OpenReport "Report1", acViewDesign, WindowMode:=acHidden
You can then use CreateReportControl or whatever to modify it.

However, that is not something you want to do in a production database, as
you lose the option to create an MDE. It is probably better (and simpler) to
just change the report in your copy of the database, and release a new front
end to send to your client, assuming the database is split:
http://allenbrowne.com/ser-01.html

You can change the criteria without having to modify the report. The
simplest approach is to use the WhereCondition of OpenReport:
http://allenbrowne.com/casu-08.html
http://allenbrowne.com/casu-15.html
At worst, you can assign the RecordSource of the report in its Open event.
For a subreport, you could change the SQL property of the QueryDef that
feeds it before you OpenReport.
 
This sounds very technical to me. I learned to create in design view by
dragging fields, etc. onto the report, not writing any code. I assumed that
when you clicked on view code you would see the actions you made converted to
vba code. I guess I was mistaken. I didn't see any option for setting a
window mode anywhere. Can my report be salvaged?
 
Not sure what you mean by "salvaged".

Nothing stops you from opening the report manually in Design view and
continuing to work on it.
 
OKI, so I guess the report is ok as is, but I don't understand where you
write the command. I have used R:Base for so many years, that I am
preconditioned to having access to a command prompt where I can just type in
the statement for what I want to see or create a report and use a Run
'report' 'where' 'conditions' statement. I don't know where to do this in
Access. Is there actually some instruction available for this? It certainly
wasn't covered in the advanced Access module I took. I hope my questions
don't sound too stupid. This is a big changover for me.
 
Back
Top