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

1289 Views 8 Replies 3 Participants Last post by alter_ego1981, Sep 29, 2008

alter_ego1981

Discussion Starter · Sep 26, 2008

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.

Save

Status: Not open for further replies.

1 - 9 of 9 Posts

computerman29642

· #2 · Sep 26, 2008

Could you attach a sample databse?

Save

alter_ego1981

Discussion Starter · #3 · Sep 26, 2008

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

See less See more

Save

computerman29642

· #4 · Sep 26, 2008

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.

What form?

Save

alter_ego1981

Discussion Starter · #5 · Sep 26, 2008

Sorry, my mistake for not saying its the frmClientSub, which is part of frmClient.

Thanks

Save

OBP

· #6 · Sep 26, 2008

Like this?

Save

alter_ego1981

Discussion Starter · #7 · Sep 26, 2008

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

Save