Re: [MS_AccessPros] Report based on Crosstab query

 

Khalid-

You're going to have to give him the front end to be able to use the new report, so yes, you should create a new .mde to give to him - that includes the ztbl for the report.  If you hide the Database Window, you have to give him a way in the app to open the form that drives the report.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Feb 27, 2015, at 1:36 PM, khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

As i mentioned you earlier after updation / new entries particularly in Collection table i give PCTL_be to my boss to view updated fresh reports, PCTL.mde file is already on his computer. If there is any change in program i create new .mde and overwrite on my boss's computer.

Now as you are insisting me to keep "That table must remain in the front end - it is not sharable."   Would i have to give him front end. Also after making .mde from Tools->Start up-> Display Database Window i un-check this box.

Then i future when i give front end to my boss do i uncheck Display Database Window for his copy ?

OR there is some other way/rule?

Please guide this is a new situation for me.

Note: now the report is perfect and OK i have no problems.

Regards,

Khalid

 

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Khalid-

That table must remain in the front end - it is not sharable.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Feb 27, 2015, at 6:12 AM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

Thank you for writing down the list. I had already imported these items in PCTL.mdb

One thing may be i am wrong, should the ztblKhalidReport  be imported in PCTL_be and then from PCTL.mdb it should be linked?

Regards,

Khalid

 

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Here's the list again:

ztblKhalidReport

qryKhalid

qryKhalid_DH

frmRunCrosstab

frmRunCrosstabJV

rptConsignmentCrosstab

rptKhalidMT

srptConsignmentNumberHeadings

Module1

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Feb 26, 2015, at 8:08 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

I did as you said.

(By the way where are the items listed "and import the 9 objects I listed below from the database you downloaded from our group.")

It's late night here i will do my necessary formatting tomorrow morning and let you know the progress.

In the mean while take care & thanks.

Regards,

Khalid

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (61)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___