Search results

Many thanks. So where would you put this code and when would it be executed? Would it be a calculated field within the table or an expression within a query? I defined a count field in the table and created a form to capture the data. On each click on the yes/no box i either added or...

I have 11 yes/no fields in a record, with about 600 records in the table. I have a form with all 11 fields on a single line for each record, togther with a numeric field on the form that has to hold the count of yes/no fields set to a yes status. This is also recorded on each record. I have no...

I have a report that I wish to email a different page to individual recipients, whose email address is contained with the report. I firstly placed an 'email' button on the report, and using a DoCmd VBA function managed to email the whole report to each person. I then used the filter menu...

I have a need to print a set of names and addresses on Avery L2160 (3 across, 7 down) labels using Access 2010. These are currently printed using mail merge via Word, which has Avery C2160 as a predefined template. Access does not. I contacted Avery and was given the exact dimensions of the...

I think my last reply got lost in the ether since it hasn't come up on this thread. An example of the calculation I do is for alpha grouping: (IIf(Left([SurName],1)<"E","A - D",IIf(Left([SurName],1)<"L","E - K",IIf(Left([SurName],1)<"S","L - R","S - Z")))) I am convinced it is...

The storing of calculated fields is to ease the repetition of calculating these very time they are needed. It's mainly string manipulation to extract certain data. These reason for copy databases is that two members of the organisation need to add new members for a limited period of time. No...

I have designed a database (ACCESS 2010) running on a standalone computer. It is not hosted on a network and is not written for multiple users. However, for a short period each year two users need to update the same table. I hoped to achieve this by duplicating the database after tagging all of...

There have been many postings regarding this subject, but being relatively new to Access 2010 and not being familiar with Visual Basic (I came from the COBOL/Fortran era!) I have not been able to follow the approaches used. I have a database that contains lists of members belonging to an...

When I make a table from your 3rd query I expected to get a similar layout, but instead of 624 entries I get 6240. I have now run out of ideas on how to create a table in the same form as the query output. My problem is that when I release my system for live running it will be used by people...

Dear plog I repeated my approach again this morning i.e. taking your 3rd query and linking the output to my members table, adding the two extra fields to make a fourth query. This produced the results I wanted in datasheet layout, taking about 1 minute. I then created a report based on the...

This what I did but the table created from the crosstab query ( your final query) I expected to resemble the output of the query I.e. One row per member, but it produced a table 10 times that size! I have been suffering from painful sciatica today and have been ordered off the PC by she who...

I am away from the PC now using an iPad. I created a new query using your last query and the Members table, linking on member number and extracting the member's full name and surname. The query runs, producing exactly what I want, sorted on surname. It's when I design a report using the new...

plog - wonder if you can throw some light on a problem. I tried to extend your work by adding two extra fields from the members table, FullName and SurName, the idea being to include the members name. sorted by surname. I couldn't get it to work! So I added a further query to the three you...

Not sure how I do this. Do you mean the form populated with data or in design mode?

Copied it over and worked first time! Absolutely brilliant. Very many thanks. Harold Reglar

Wow! That will take me some time to absorb and my youngest grandson arrives to spend a couple of days with us in an hour! So it may be some time before I get back to you if I have any queries. Many thanks.

Table 1 name : Members Relevant field is MemberNumber, numeric There are another 30 fields but none of the relevant to the problem. Table 2 name: Groups Relevant filed is GroupCode, Text field, 6 characters long e.g. His01, Sci061 etc. Table 3 name: GroupMembers Relevant...

I have a form with subform that uses colour as background colour for all fields on the form, and also a very light background for the whole form. This outputs very well to PDF, retaining all of the layout etc. However, consisting of over 100 pages I do not want any colour at all in the printed...

Sorry for the slow response but I have been away for a few days. The only database I now have has personal information in it so I can't really post it, but I can describe very easily the requirement. I have three tables: Members (of an organisation) - 600 approx Groups (within the...

Not sure that the title is correct but here goes...... As part of a bigger database, I have a table consisting of two main fields, a member ID and a interest code. A member will have, in practice, from 0 to 10 interest codes, although there are up to 100 interest codes in total. I need to...