Search results

The colour is being set in the 'Back Color' field of the Format tab on the combobox property sheet. The 'Backstyle' property is set to 'Normal'.

Hi I have a number of textboxes and a combobox on a form where I have set the background colour to indicate to the user that they should complete these boxes. I have a slight problem in that once the combobox has been completed and loses focus the background becomes transparent and shows the...

Hi I have been tasked with putting together a db for my place of work. I am using Access 2007 but the majority of users are using Access 2003. This has not been a major problem to date as I developed and saved the db in Access 2003 format. Everything seems to work as designed except for a...

Hi everyone I am having a bit of fun (headaches) with an addition problem on a form. At the bottom of the form there is a group of textboxes used for calculating values as follows: Group A - totals the values in one of the two subforms Group B - totals the values in the other subform Sub Tot...

Doh - I knew it !! Hi Again I just knew as soon as I posted the question I would work out the answer. I have now replaced the DoCmd.OpenReport staement with DoCmd.Printout , , , , 2 and everything works fine :) Thanks for taking the time to read the question. Until next time. Cheers Awes

Hi Everyone I'm sure I've seen the answer to my question on the Forum but I haven't been a able to find it using the search facility so I'm turning to you guys/gals for help. I have a command button on a form that allows the user to print a copy of the selected report. The user has asked if I...

Hi Paul Thanks for the pointer. The Title Screen properties were already set to No, but setting the popup property on the other form to Yes solved the problem. Cheers Awes

Hi This problem probably has a very simple solution but is now starting to drive me nuts, to the point that I must be missing the obvious. When my database opens the user is presented with a Title Screen and the option to continue or exit. When this title screen opens it checks the day of the...

Hi ghudson Thanks for the info I will have to study it to understand what it is all doing but if it covers all eventualities that would be excellent. Thanks also for the pointer to the other forum, I will have to pay it a visit. Mile-O-Phile Tried your suggestion and it almost worked first...

Hi Mile-O-Phile Many thanks for the quick reply. I'll give that a try. I'll also have a look on the Modules forum. You also picked up on my next thought which was handling other oddities with surnames, the Mc and Mac being the ones that sprang to mind. If every eventuality was to be covered...

Hi Everyone In a database that I have been working on the user is required to enter names and addresses. To overcome finger trouble by the user a short piece of code using the StrConv(string, conversion) command was inserted into the 'After Update' property as an event procedure to ensure that...

Hi All I am working on a database where one of the operations to be recorded is Work Done. This falls into two categories: 1. Predefined tasks 2. Ad Hoc Tasks Both task types have the same characteristics e.g. Id Value, Description of task, Category and Type. The Predefined tasks (which...

Hi Claire To get it to display only on the bottom of the last page I would use the Report Footer rather than the Page Footer. When you are in the report design view click on the View drop down menu and click on Report Header/Footer to display it and then you should be able to put what you want...

Rich Everything now working as required, thanks for the pointer. Cheers AWES

Hi All I have a report being used as an Invoice that contains two sub-reports, Parts Used and Sundries Used. These sub-reports have a text box in their report footer containing a SUM equation, which gives the total cost of items used. This text box is not visible when seen on the main...

Cheers Both I knew it had to be SUMthing simple!! It's always the simple things that trip you up and the hardest to see. Many thanks, I'll now go in search for the next simple problem. Cheers AWES.

Hi Everyone I am having trouble trying to SUM some values in a report. I have a table called 'tblPartsUsed' which contains the following fields: intPartNo strPartDesc intQtyUsed intPriceEach intInvoiceNo I then have a query which is based on the value 'intInvoiceNo' from the table above so...

Hi Rich Thanks for the info. I have used your function and it is just what I was looking for. It works perfectly and it has opened up a whole new area for me to explore and experiment, as I haven't used the approach taken by the function before. Thanks again. Cheers Awes.

Hi Everyone For those that don't read the Forms forum, I have started a thread there about referring to a sub-form from a module. Rather than repeat it all here I would be grateful if you could read the thread titled "Forms / sub-forms and modules. Any guidance you can give would be greatly...

Update I have done a bit more experimenting with this problem, so thought I would add my results in case it assists the problem solving. I replaced the variable name, strFormName, with the actual name of one of the forms that will use the module and ran the code without a problem. So the...