Search results

Responding to JHB and returning to my original question; It should be apparent from the SQL coding posted that the output file includes the parameters Name1, 2 & 3 which are simply Column Headings and that Firstname, Surname, [Address 1],Postcode and Subdate are fields of the Table [Mail List]...

Thank you CJ_London, JHB & Gemma, I believe that I have followed CJ's suggestionn exactly, but although the Query runs, as it always has done, I still get the 'Enter Parameter Value' message. Here is the amended code: SELECT DISTINCTROW [Name1] AS Title, [Mail List].[First Name], [Mail...

Hi JHN, I have amended code as you suggest, but I'm obviously still not geting right because I conyine to get the 'Parameter Error#message. Here is the amended code, I am obviously still getting it wrong SELECT DISTINCTROW [Name1] AS Title, Null AS Name1, [Mail List].[First Name], [Mail...

Many thanks for comment. I have modified the code in design view as follows, but I susspect that I have not correctlly interpreted your suggestion. Modified code is; SELECT DISTINCTROW [Name1] AS Title, [Mail List].[First Name], [Mail List].Surname, [Mail List].[Address 1], [Mail...

Good Morning, I have 2 or 3 Queries which are run specifically export data to an Excel file required by external agencies. The queries contain column headings, required by the agencies, which are not derived from Table fields. Obviosly, no record data is produced for these columns. When the...

Paul, You have been extremely patient in your assistance to me. I'm afraid that an attempt to 'Save as' an mdb fail produces a not possible message, due to 2010 features. However, I have decided that i can live with the 'Parameter dialogue' boxes. Pressing <OK> a few times isn't an elegant...

Thank you Paul, With your guidance I believe that I have at last got some valid coding in place to achieve what I require in the way of new & modified column titles. The SQL Code now reads; SELECT [Name1] AS Title, [Name2] AS Initial, [Mail List].[First Name] AS Forename, [Mail List].Surname...

Dear HtH, Many thanks for your further suggestions. With my limited experience of SQL coding I am still rather confused as to how to turn an <Expr> into a label. SELECT [Name]="Title" AS Expr1, [Name]="Initial" AS Expr2, [Mail List].[Member ID], [Mail List].[First Name], [Mail List].[Address...

Many thanks for the suggestions. I would certainly not be very keen to build yet another table for this purpose. I could of course include the 6 labels as dummy fields in the existing table, but that would be a rather inelegant solution. I confess that I don't understand your 2nd option. My...

Good Morning, I have a Query derived from a single Table in Access 2010 which I routinely export in spreadsheet format. I have now built a report from the Query in which has labels have been added to suit an external agency. I wish to export this Report in Excel format, but the resulting file...

Many thanks for the extremely rapid response to my query. My query arose from a question posed by an 'Open Office' user who is keen to take advantage of a fairly complex membership database I have built in Acces 2010. I have gained the impression from your comments and others, that although one...

Good Morning, I have been asked the question 'is it possible to import the structure of an Access 2010 database incorporating multiple Tables, Forms & Queries into Open Office. If it is possible what degree of functionality would survive.' I have no experience of Open Office but I am sure that...

Thank you CJ & Paul, It seems that I shall have to do the necessary the tedious way - 26 times. Regards, jcbhydro

Good Evening, I have a couple of Macros which produce a lengthy sequence of pdf files from a Report. I now want to pull these files from a Report with a different name. I wish to change multiple occurrences of the Report name using Find & Replace, but I haven't found such a facility. Surely it...

Hi, I obviously didn't make myself clear. When I said that I had examined all elements of the Report, I meant that I had examined the property sheets for each & every field of the Report and I did the same for each field of the relevant Table. I found no evidence of 'Lookups' in any of the...

Many thanks for your comments. I recognize precisely what you are advocating, but as I said, I have no wish to clutter up the main table of the database with records, many of which will never have significance. Even if I abandon the proposal to transfer data into a 3rd table, I am still of the...

I have followd your advice but the only reference to 'Mail List' in the Report property sheet is the Record Source. I have examined the property sheet for all elements of the Table Design View with the same negative result. The only other reference was in the Order Statement [Mail List].Surname...

Thank you for your comment, but you are missing the point. I have no intention of cluttering up the main table with prospective members most of whom will probably never become real members. I will continue to manipulate the data manually, although I cannot believe that it is impossible to...

Good Evening, In my Membership Database (Access 2010), I have a Table entitled [Foreigners] in which are stored the names of prospective members of the organisation and the name and ID of the Interest Group they are proposing to join. When a formal Application to join is received their personal...

Gina, Your perseverance is admirable. The Report in question is simplicity itself and is derived directly from the [Mail List] Table. It is there merely to produce a pdf file for Committee Members without Access 2010. The Report title is 'Mail List Basic'. When you talk about an 'underlying...