VB and Access

[Al]

How to de-activate the menubars and tools bars from MS-Access while printing
from VB using the

MSAsObj.DoCmd.OpenReport "RptName", acPreview

I don't want the users to modify the report or database.

is this possible?
to Disable All other options and just let the user to view and print the
report from Access.
or is there better way of doing it.

Thanks
Al.

 

[Emilia Maxim]

How to de-activate the menubars and tools bars from MS-Access while printing
from VB using the

MSAsObj.DoCmd.OpenReport "RptName", acPreview

I don't want the users to modify the report or database.

is this possible?
to Disable All other options and just let the user to view and print the
report from Access.

Al,

in the database window, take a look under Extras, Start... You'll an
option for the menu bar and several other options.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de

 

[Tim Ferguson]

The most efficient way is to create a MDE-version of your database and
distribute this one instead of the MDB. No one will be able to make any
changes to your forms, reports or code.

I just had this feeling that it's not a natural way to do things.

The last time I used VB, it came with a version of Crystal Reports,
although I tended to use VSView for reports because the early version of CR
were so buggy. It seems to me that there are so many ways to get a report
onto paper using VB itself, that launching a whole copy of Access into
memory and using OLE automation just for that is topsy-turvy. This is a
whole different bucket from using DAO or ADO to access the Jet data.

But then, I don't know how complex this report is or whether there is any
other compelling reason to use an Access form.

B Wishes


Tim F

 

[Al]

Thanks all for reply
this is my first time using MS-Access for reporting and Backend. I always
use VB with SQL server as backend and crystal report for reporting but in
this case the company does not want to purchase license of crystal so
I have to deal with access.

any way thanks much again.

 

[Tim Ferguson]

this is my first time using MS-Access for reporting and Backend. I always
use VB with SQL server as backend and crystal report for reporting but in
this case the company does not want to purchase license of crystal so
I have to deal with access.

It might make your life easier if you simply create a mdb just for
Reporting functions. Even a manager who won't buy Crystal might have enough
arm strength left to double-click an icon on the desktop (or pay his
secretary too...)

Set it up with all the tables imported by Linking from the original Jet
database (or SQLS data source or whatever) and build the reports all in one
separate file, and set it up for the managers to use as they want.

Hope that helps.

Tim F