Search results

Good Afternoon, I have several Entry Forms for inputting data into an Access 2010 Database. On opening each of the forms, the cursor defaults to the first field in the Tab sequence. This is fine for a new record, but can lead to inadvertent inputting errors in existing records. Is it feasible...

Good evening, I have an Append Query which appends personal details from a Mail List Table to a Leavers Table when members Leave the organisation. The coding used to achieve this is as follows; INSERT INTO Leavers ( [Member ID], Surname, [First Name], [Address 1], [Address 2], Town, PostCode...

Good Evening, I have several reports which use Conditional Formatting to highlight certain limited conditions in various fields, eg where a subscription is outstanding. The highlight feature functions as expected when the file is printed from a Print Preview selection. However, if I select Word...

Good Evening, I have two macros which produce multiple file outputs of database group data, one file for the data from each of about 30 groups. Currently the output is configured to produce files in pdf format. I wish to modify this to produce files in rtf format. However, the traditional...

Good afternoon, I have a number of Active Queries in my membership database which operate to modify multiple records in the database, eg resetting subscription data for a new financial year.Other examples include multiple deletions of records from several tables under certain circumstances. My...

Goos Afternoon, The following piece off SQL code is used in a Query to ensure that only a single hard copy document is mailed to 2 recipients at one address where an electronic copy is not required(Hence the False statement). The need has now arisen to add an 'OR' function to cause a copy to be...

Good Evening, One of the Tables in my membership database is named [WaitList] and has a linked Form. The Form is configured to pull data from another Table named [Groups]. The fields are [Group ID], [Group name] and [Leader].plus others from a second Table. When the [Group name] is selected...

Good Morning, I have been unable to find a simple way to copy a text entry from a Table Field and paste it to multiple records in Datasheet view. The Toolbar 'Paste' procedure copies to the selected record only and I am unaware of how to select multiple records, as per a spreadsheet procedure...

Good Afternoon, I have had much valuable advice from many Forum members in building a very comprehensive Membership Management Database with extremely useful facilities initiated by some 20 or 25 Queries.. The database includes 5 Tables which store data relevant to members, another which stores...

Good Afternoon, I have some Conditional Formatting of a Currency Field in an Entry Form. The cell is conditionally formatted with a yellow background when the value is zero. I now wish to add an additional condition to the expression such that even if the value is zero it will not be formatted...

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...

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...

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...

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...

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...

Good Evening, I have noted several instances of the dreaded 'Enter Parameter' message occurring on Queries and Reports of my Database. I have been able to resolve all but one of these by examination of the relevant Property Sheet.Record sources to correct anomalies. One of the instances has...

Good Morning, I have trawled through the help files to find a means of saving a database as a read only version to distribute to interested users. I would eventually make it available to selected parties as a read/write version in a controlled manner. Is such a facility available for Access...

Good Morning, On 9th Oct. I initiated a thread on the Reports Forum concerning the use of Access in-built Access routines. Carelessly, my the title of my post included a typographical error! My post raised a general query on the subject of extracting 'Totals' data from a Table. I received 2...

Good Evening, I routinely produce a report for regular Committee Meetings which includes statistical date derived from the total rows for various fields in 1 or more Tables. It should be possible to extract such data automatically, probably using a query. So far, my endeavors in this direction...

Good Morning, My Membership Database includes 3 fields in the main Table which I need to clear prior to the new subscription year, but on a selective basis. The fields are R/N for (Renewal or New), a subscription date and an amount field (Currency). At the due date I need to clear all 3 fields...