Search results

Hi Warren Please don't do duplicate postings within this Forum. It's confusing for the poor people who are trying to offer help and advice. Rich Gorvin

Hi Casey You have almost answered your own question. You have found that the totals work in other sections of your report and that is the answer. Usually the total would be expected at the end of the report, so most of the time this is where calculated fields are put - in the Report Footer...

Hi Mcg I think you will find that "making do" by lumping everything together in one table is a recipe for disaster in the long term. To really get anywhere with Access you must get to grips with the basic idea of dividing information into tables that are linked through relationships. Without...

Hi Tcaprice Perhaps the criteria is within the query that the report is based upon. Rich Gorvin

Hi Rosebud Have you thought of using a tab control - a series of tabbed pages that can allow more controls to be displayed without needing to scroll across or down? You can have tabs with subforms as well - so they can make quite complicated forms look neat tidy and accessible. HTH Rich Gorvin

Hi JJT In Design View for Reports go to View on the Menu Bar and select Page Header/Footer. Either cut and paste or drag the fields from Report Header (which only appears at the top of the Report) to Page Header (which appears at the top of each page). HTH Rich Gorvin

Hi Socko139 Please avoid posting the same question to more than one forum with Access World Forums. It gets confusing for anyone trying to help you (and others). Rich Gorvin

Hi Socko139 Do you want to add a line break to existing data or do you want the Memo field to respect end of sentences/line breaks for data that users will be entering. Have a look at this link - some of the suggestions may help. http://www.access-programmers.co.uk/ubb/Forum4/HTML/002415.html...

Hi Trumanst and KevinM Just a little adjustment to the coding KevinM has provided. I think when both Husband and Wife details are available Trumanst wants "Mr John & Jane Smith" so there needs to be another ampersand. ... Else MyText=[Prefix] & " " & [Husband] & " & " & [Wife] & " " &...

Hi Rachel1 Try the following: =IIf(IsError([LastName]),"0",Count([LastName])) Please note that my field name has no spaces - LastName instead of Last Name. Another thing to try: If your text box on your report is also called Last Name (or even LastName) this can create a problem as the...

Hi Timberwolf Looks like you have a duplicate piece of coding. I would be inclined to delete your button AND delete the coding that goes with it (by using View and Coding on the Menu Bar). Then re-create your Close button using the Wizard, but call it: cmdClose This should then give you...

Hi Timberwolf Please to read that it did the trick. Rich Gorvin [This message has been edited by Rich@ITTC (edited 03-23-2001).]

Hi Andy101 This is a fairly basic area of database design. Have you tried looking in the Help File, in the sample databases provided with Access or in any decent Access Book (Developer's Handbook, Bible, Running Access, etc). You really need to "get your hands dirty" and have a go! If you...

Hi crhodus Yes. Set the CanShrink Property for the text box address_2 (which ought to be called txtAddress2 really) to Yes. HTH Rich Gorvin

Hi Sue Could you send me the details that you have on this issue. richgorvin@freeuk.com Thanks Rich Gorvin [This message has been edited by Rich@ITTC (edited 03-23-2001).]

Hi Timberwolf Keith's should work, but here's an alternative. =[LastName]&(", "+[FirstName]) If my memory serves me right the ampersand - & - only links if the following field has data. The comma and space are therefore attached to the FirstName - only appearing when it does - and the...

Hi Michelle I am not too sure what the problem is. Are you sure the area of the detail section (and possibly other group headers/footers) aren't too wide? Have you tried re-creating the report using the Label Wizard - then tinkering around with Groupings afterwards. HTH Rich Gorvin

Hi Tracy Farmer I would suspect that your field is the data type Number (naturally) and that the Field Size (lower half of the screen in Design View for the table - first property) is set to Integer or Long Integer (so it will save whole numbers - integers). Change the setting to Single or...

Hi fmm Is the subform - Forms![frmPurchaseSubform]![SerialNumber] - open at the time you open the second form? Also check that the actual text box isn't also called SerialNumber (the field from your query should be called SerialNumber, the text box displaying it should be called...

Hi Michelle You can make a report that has columns - for example the Labels Wizard does this very successfully (so you can have 2 columns of 8 labels, or 3 columns of 10 labels etc). You need to make sure your fields only go less than half way across the detail section of your report (for 2...