Search results

Absolutely Brilliant thanks

Hi I am a completley new to VBA so may be well out of my depth but here goes. I am wanting to send a report as a text file by email to a recipient that has been selected from a combo box on a form, the report is called "prtGroupContactsbyWard" The command I have used from scouring the...

I am trying to put a macro that emails a report to a recipient selected from a combo box, is this possible? I can get it to email a report by either leaving the To: box empty and letting the person sending the email to put the email address in but i thought i might be able to run a query from...

sorry never dealt with syntax's where do i find this? I have attached a screen shot of the problem.

I have a form which runs specific queries and opens a report using combo boxes, these work perfectly fine if I just try to run them in the form. I have put the form into a navigation form and if I try to run the same query I get parameter queries popping up instead of just running the query and...

Sorted! Many Thanks CJ_London That is fantastic your help and patience has been great.

I have 2 queries to run this report qryGroupType1 and qryGroupType. GroupType1 is the first query and GroupType is the 2nd here is the SQL code to GroupType1 SELECT tblGroups.[Ward ID], tblType.TypeID, tblType.Type, tblGroups.[Community Group] FROM tblGroups INNER JOIN tblType ON...

SELECT qryGroupType1.[Community Group], qryGroupType1.[Ward ID], tblWards.Ward, qryGroupType1.Type, qryGroupType1.TypeID FROM tblWards INNER JOIN qryGroupType1 ON tblWards.WardID = qryGroupType1.[Ward ID];

qryGroupType That is what is in the Record Source under the data tab wanted to post a screen shot but unable to link to screenshot: tlal dot webs dot com/screenshot

Sorry I am being really thick on this how do I do that?

Well that seems to be the problem. I am not doing it at the moment, the record source for the Report says qryGroupType only

The short answer to that is no. the next question is where should this go?

I have a form that contains 2 combo boxes, one that lists the Wards in the Area and the other contains the types of groups. I can generate a report listing a specific group in the Ward but need to be able to list a specific group in every Ward. I have added "All" to the Ward combo box along with...

Hi My name is Stuart and I am a research and Consultation Officer for Barnsley MBC. I have not used access much in the past and have been thrown in at the deep end with constructing a Community Database. I am working my way through slowly and have overcome a few problems but know there will be...