Search results

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

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

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

Hi Everyone Starting to tie myself up in knots here so it's time to call on the experts for help again. As usual I apologies for the length of the message but hopefully it is detailed enough to get the answer first ime round. I am developing a database where a sub-form is used within several...

This question isn't directly related to Access and I apologise if this is the wrong forum to aks my question. I am after a book that covers Database Design from the beginning rather than one on how to use a particular database application. I have short listed a number of titles down to two...

I am developing a form where eventually the user enters a surname into a combobox 'FindSurname' on the form, which is based on a query, and then clicks on a button 'Select'. This will then run some code and the, display all occurences of the selected surname in a subform 'subCustDets', which is...

Hello Access Gurus I am currently working on a database for a friend and would like some advice with a problem that I have. I’ll start by setting the scene: I have an unbound form that has a tab control with two pages. The first page contains a sub-form that allows the user to input details...

Hi Everyone I am trying, not very succesfully, to write a sub-procedure that can be called from a number of forms. Having read a number of Access Help pages on writing and calling a sub-procedure I can't get it to work, so it is now time to throw it over to you helpful people to point me in...

I am using a Tab Control on a Form which consists of two pages. The form has a 'Green' Back Colour (customer requirement) and the Pages of the Tab Control should also be 'Green' (customer requirement). If I set the Back Style property of the Tab Control to 'Transparent' this makes the Page...

Customising Msgboxes Hello everyone Is it possible to control the colour of a Msgbox? If so, how do you do it? Cheers Awes