Solved: Access 2003- Report/Query (guessing VBA) Help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

alter_ego1981

Thread Starter
Joined
Jun 26, 2008
Messages
49
Hi All,

I have a DB which has two reports which can be run depending on whether it is a single site or multisite.

I have added a yes/no tick box to show if a multisite, but what i need to do now, is to get access to run the correct report.

If Multisite not ticked to run Report A
If Multisite ticked to run Report B

I dont know enough about VBA to do this so any and all help would be helpful.

:)
 

alter_ego1981

Thread Starter
Joined
Jun 26, 2008
Messages
49
Hi,

Attched is the db, with all data removed, except 2 fake sites.

example

as the client has 2 sites we want to click the notice letter button which would then open up report Electricity_MultiSite_Notice_To_Client_Letter.

However there is a twist as always with my boss, he basically wants the report to run for that client only, so say im on client 1 out of 100, he would want it to run the report on that client only, this should be acheived from the 381 Company Ref field.

Hope you understand cos im finding it difficult lol
 

Attachments

alter_ego1981

Thread Starter
Joined
Jun 26, 2008
Messages
49
Bingo thats part one Tony, thanks very much :)


The 2nd part is more tricky, or so i think, he wants the report to run for that client only so it would mean some sort of VBA to change the 381 Company Ref query to include the client ref and it would then need to know if it was single or multi site queries

qryE_SingleSite_Notice_Letter for single site or qryE_MultiSite_Notice_Letter for the multi sites
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top