convert report created in design mode to editable vba

J

joanaww

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
 
A

Allen Browne

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.
 
J

joanaww

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?
 
D

Douglas J. Steele

Not sure what you mean by "salvaged".

Nothing stops you from opening the report manually in Design view and
continuing to work on it.
 
J

joanaww

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