Search results

Hi there. My concerns were ill-founded. I have deleted all but 6 of the records from the Main Table of a copy of the database, and these were automatically deleted from the related tables, at least partially. a small amount of selective deletion was also requtred. I have run each of the...

Good Morning, With the generous assistance of Forum Members I have created a fairly complex Membership Database using Access 2010 and incorporating 5 Tables, 4 Forms, about 10 Queries & Reports and a couple of Macros. Other societies within our UK National network are interested in using the...

Many thanks Gina, I had investigated the macro possibility, but the problem didn't lie there. However, your alternative suggestion was correct. 'Main' was selected for form & web display under options. I deselected those and all is now fine. Your prompt and accurate analysis was much...

Good evening, I used the Contacts Database Template to import a comma delimited txt file of contacts data. The template included a number of tables, queries, forms & reports which I did not require. I deleted them leaving only a Table entitled 'Addressbk'. I added an Entry Form using the...

Thanks for your comment which prompted me to look again. As you suggest adding a field to the secondary table is no problem unless one carelessly neglects to select 'Design View'. jcbhdro

Good Morning Folks, With the help of this forum I built an Append Query to take records of 'Leavers' from my Primary Table and add them to a Secondary Table named 'Leavers. This worked perfectly, but on reflection I determined that I needed to append a further column 'Notes' which exists in the...

Thank you Bob, That is a very neat solution and works perfectly. Regards, jcbhydro

Good Morning Folks, I have a very simple query to determine the gender ratio of an associations membership. My SQL code neatly calculates the number of females, viz SELECT [Mail List].[GENDER], Count([Mail List].[GENDER]) AS TOTAL FROM [Mail List] WHERE ((([Mail List].[GENDER])="F")) GROUP BY...

After further examination of my SQL code, I realize that I was incorrectly defining an 'Is Null' criteria for a Yes/No field. I had intended to search for Null records in an email field. All is now working well. jcbhydro

Hi Folks, With the help of this forum I have produced a label printing query which eliminates duplicate addresses from a mail list. It works beautifully. However, when I try to replicate with a different field criteria the new query fails to produce any output at all. The SQL code I am using...

Good Evening, I have noted somewhere that conditional formatting is not possible in tables, but is there an alternative method of achieving a conditional background colour depending on data. I have conditional formatting in Entry Forms and Reports associated with a table and I wish to display...

I have a simple table named [Groups] containing a Primary key ID, a Group name, a Group Leaders name and a date field. The date field merely lists the date of a particular Group related occurrence. I need to know how many records have dates entered and assumed a simple total would achieve this...

I actually built 2 macros, each with about 27 /open, export & close' routines, the 2nd macro simply being an edited copy of the first. So that confirms that Access can handle about 80 actions in a single macro. As you suggested, i could have nested them but 2 separate macros are no problem...

Eureka, I eventually found a 'Close' Command under the RunMacrCommand action and that does the trick. It closes the current selection and facilitates a new ID selection. It will be a painful typing job to incorporate all 52 selections, but at least the method is now clear. Is there a limit to...

I was reluctantly prepared to build an action based macro, repeating the actions for each ;filter' of [Group ID] in turn. This would have been a laborious process, but only necessary once. This is the process which required the Report Print Preview to be closed after each export. I have only...

Thanks again, Hopefully that should do the trick, but I can't find a suitable action in the action catalogue which will accept such a line of code. Are you perhaps assuming that the routine I have so far written is in VBA, something in which I have virtually no experience, but which I am happy...

Many thanks for the comments on the above. I recognized that a page identifier is required and I have been using the filter expression as where [Groups].[Group ID] = "A1". Groups is the table and the Group ID is unique for each page. The Groups are all identified by A1,A2, B1,B2.B3, w1,w2...

Hi Folks, I have a 50 page Report from which I need to export the pages separately to individual pdf files for multiple recipients. I have built a macro which works to export the whole report to a pdf file, but I cannot fathom how to make the macro select each page in turn from the report. Any...

Thanks for that. The solution works well for most of my aliases, but some of my needs create problems. For instance, a couple of my upload demands involve a full stop, ie Book Ref.:BOOKREF. Is it possible to achieve such an alias? I also have a couple of instances in my query which also cause...

Please excuse my ignorance, but where exactly does one insert the alias? jcbhydro