Search results

Dear Experts I have just created a new query in Access (copied & pasted an existing query, renamed & set different criteria) with the intention of using it as a Word mail merge data source but, when selecting the recipients > ‘use existing list’, the new query does not show in the list of...

This might be a crazy question but, Sub-form within a sub-form - is this possible? If so, how?

I've created a single page Word form using Developer text controls which is to be put on to our website and serve as a membership application form but, not being code-savvy, I'm finding picking through the different sets of VB code offered to get the job done to be a nightmare. The code will be...

Hi All I have an Access database within which two of its forms, apart from the fields you would expect to see, each have a multitude of hyperlinks, some linked to items within the database and some to either Word documents or templates. Two of the Word templates contain fill-in fields, and...

Hi Guys Can anyone help with my mail merge headache? I had planned to do a mail merge starting with a Word main document and an Access database query as the data source, then moving into Outlook as the mail handler. In preparation, I created the Access query which filtered out all but the...

High Guys, I'm hoping you can help. I've created a report and on that a pie chart which is showing exactly what I want except for the colours of the pie chart sectors. There is no option to select the format tab in the chart settings pane (as suggested in the Help section) and although I can...

High Guys I’ve created a Navigation form with 2 levels of horizontal tabs (currently 6 tabs). Each tab calls a ‘Search Form’ with fields devised to extract data from one of 5 different tables/queries. Clicking on a tab should open the form within the constraints of the area below the tabs (as...

Hi Guys If, after having created a tabbed form with one horizontal row of tabs (along the top) and a column of vertical tabs (to the left), you decide you would prefer a double row of horiizontal tabs along the top, how can this changed be made without rebuilding from scratch? Any...

Hi Guys I am currently building front ends to various databases for a local charity, on a voluntary basis. The databases are in Access and I have used both macros and VBA in the construction of the front ends. Part of the exercise involves convincing a couple on the committee that the...

Hi Guys Can anyone help with an Excel problem? Macros that I create in Excel must be saved to the Personal Workbook as they are used in conjunction with Reports which are created in and exported from Access. The problem is that when I now attempt to run a macro in Excel or in fact create a...

Hi Guys I use the DLookUp function as follows =DLookUp("[MarrRecUnitPrice]","SearchCharges","ID=1") as a function in a field on a report where the field displays the record-unit-rate for records retrieved from a large dstabase (first database) where unit rates are stored in a small table in...

I have an inventory database within which I have created a grouped report to return records for all items based (grouped) on 'Location'. I need to print the records returned for a particular location at any one time. How would I do this? Help from the experts would be much apprceiated.

I have an 'Alert' form (continuous form) set to pop up in front of the navigation form when the database opens with two hyperlinks set at the bottom edge of the form. Currently the length (vertical height) of the form is full height of the window which means that the hyperlinks are not visible...

I am using a modified Northwind database as one of my databases. This is set up so that when opened, an ‘Alert’ (a form) opens automatically. But another form also opens behind the alert form so that when you close the alert form the other form remains open. I am trying to replicate this in...

Can anyone help please with a conditional formatting problem? I have a form where two adjacent fields are 'Requested Date' and 'Response Recd Date', as follows I want the background colour of the 'Requested Date' field to change where the value of the 'Response Recd' field 'Is Null' and the...

Although I have been working with Access for a while, am still finding it challenging. Not sure what happened to my last post, but am still struggling with the following: I need to calculate a 'Test Due' date which is one year later than a 'Date Tested' date but as there are multiple 'Date...

I need to find the most recent date in a 'Date Tested' field in a table of records relating to test history, then add one year to arrive at a 'Test Due Date' and display this on the 'Testing' page (subform) of an 'Asset Details' form (whilst there are multiple past test dates, there can be only...

I am trying to make changes to the sample Northwind database, specifically to change the colour of form headers from the standard orange to something else but the facility to edit the colour reference in the propery pane seems to somehow have been disabled. I would appreciate help with this.

Hi All I have created a 'Find Duplicates' query where all of three fields in any record must match for records to be duplicates. I now want to create a 'Delete Duplicate' query to delete the 'unwanted' duplicates. I have tried following the Microsoft Help but the query I end up with wants to...

I have been trying unsuccessfully to re-size the boxes which contain data labels in an Access chart. I need the data labels to show value followed by %, separated by comma and space, with all characters side-by-side (not value above or below %). Pre-edit, some of the labels have characters...