Search results

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

Hi Guys Thanks for all the input. I tried deleting one of the forms and typing form name directly into a new tab rather than drag & drop but when form was re-opened in form view it opened in random position. Macro yp control the form is as below:- <?xml version="1.0" encoding="UTF-16"...

Hi Minty Thanks for reponding. That's what I thought to start with but I checked and both Pop-up and Modal are set to No. Strange thing is that when the forms are opened in Design view all six open beneath the tabs but then clicking a tab after switching to Form view results in the misbehaving...

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 Mike I didn't know you could do that - you learn something new every day. Thanks for your help.

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

A big thank you to JHB, sonic8, isladogs, Minty, Ranman 256, and June 7. You've all been very helpful. Thanks again. PeteB

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 Gasman - thanks for your response - my Personal Workbook file has the suffix xlsb. Does that make sense?

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

Thanks very much, I'll give it a try.

Thanks. I partly understand. The look-up table resides in database A but the report resides in database B so I wish to look-up from B to A. Apologies if I didn't explain very well previously. PeteB

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

Thanks Pat.

Hi Arne Thanks for that. I will try and absorb the information you posted and I'm certain will be able to go with one of your options.

Hi Arn Thanks very much for that - what do you mean by 'Input Box'? (you are dealing with an amateur here).

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.

Great to see that my problem provoked some argument. Thanks to all who pitched in with suggested solutions. I'll come back again soon.

Hi Doc_Man Thanks for your interest. I understand what you say about the sizing of the component parts of a form and how they influence the overall size but Form.Height is not available as a property in either design or layout views so how do you set it? Remember, I am an amateur not an expert.

Hi Mark It has taken me this long to find out how to resize the form vertically but have now done that (in datasheet view) and thanks to your suggestion have succeeded in resizing -it's often the simple solution that works. Many thanks.