Search results

Hi Mark Curtis See this link: http://www.smartaccessnewsletter.com/ Sophisticated Reports: Multiple Columns and Subreports Part of this article looks at this problem (and provides a solution). HTH Rich Gorvin

Hi Jayme27 I wonder whether your problem lies in having the control [DateOfEntry] having the same name as your control source[DateOfEntry]. It is always better to name the actual control with an L&R prefix, so that the two objects - the control and the field from your table - have different...

Hi Deepbreath Use UCase - see Help file for details. HTH Rich Gorvin

Hi Telepathetic I think it would be better not to use DSum, but Sum instead. In the Total field on the main form try: =(Sum(Me!Receipts!Amount))+(Sum(Me!Expenses!Amount)) HTH Rich Gorvin

Hi TBaxter Why not put: =forms!frmclient!ClientID in the Default and Validation Rule properties for the foreign key - ClientID - on the second form that is opened up by the command button. HTH Rich Gorvin

Hi Skollager I agree with Charityg but have a minor suggestion. This field is a text field (as it accepts both letters of the alphabet and numbers) and the sort order for such a datatype will follow the value of each character in turn - A, A, A, A, B, B, B, C, C, etc taking precedence...

Hi Chastst Here's an example form the Help file: TOP n [PERCENT] Returns a certain number of records that fall at the top or the bottom of a range specified by an ORDER BY clause. Suppose you want the names of the top 25 students from the class of 1994: SELECT TOP 25 FirstName, LastName FROM...

Hi BD Glad you got it fixed. It was one of those problems that had me baffled for ages until I eventually stumbled across the solution (i.e. I had got to the point of changing every setting one by one, often not believing that they could be in any way responsible for this technical hitch, just...

Hi Mike Nice one! Actually, unfortunately I don't think it wouldn't have met my needs as much of my development work is done off-site with different printers being installed at home and at work. However, it certainly is a lot, lot less complicated! Thanks Rich Gorvin

Hi Modex Presumably your dialogue box is a popup form (perhaps even a popup modal form). Assuming you want the form to completely disappear when you go to the Print Preview you would need to add some coding to the button you click on your dialogue form to open the report in Print preview...

Hi Everyone Actually I have found that code I mentioned above in one of my posting ... it came from Dev Ashish's excellent site. Unfortunately about six months ago I tried it out and couldn't get it to work (well that isn't strictly true - it did 90% of what I wanted but it wouldn't return the...

Hi Charity Don't think you can do that .. so your separate popup modal form may be the answer. Follow this link for a similar discussion: http://www.access-programmers.co.uk/ubb/Forum7/HTML/001035.html HTH Rich Gorvin [This message has been edited by Rich@ITTC (edited 04-19-2001).]

Hi Des and R Hicks Thank you both for providing your examples. They both do similar things, from what I can see, in that they bring up the Windows Print Common Dialoge Box and allow the user to change the printer. Des, your example works very well - thanks for that as I have tried it out just...

Hi Anthony Why the multiple exclamation marks!!!! Did you ever doubt that it would work? ... and what do you mean A beer? Surely a six-pack if not a firkin! Rich Gorvin

Hi Anthony No - it applies to the whole form and you put it in the CBF - "coding behind form". It is the Form_Error Event. This coding example has all the correct names etc - so you open the module window for coding (View->Code on the Menu Bar)when in design view for this form. Copy and...

Hi Anthony Try this: -------------------------------------------- Private Sub Form_Error(intDataErr As Integer, intResponse As Integer) Const FIELDSIZE_ERROR = 2113 On Error GoTo Err_Form_Error If intDataErr = FIELDSIZE_ERROR Then MsgBox "Your date has too many numbers. " _ & "Please use...

Hi Anthony As far as I know you can't alter that text - it is part of Access coding and you may find you need it elsewhere (it is a generic error statement - not specific to your particular database). You need to use the code I gave above replacing ------- On Error GoTo Err_Form_Error Const...

Hi Anthony Yes you are right it isn't in the error database. Oh heck! Try this error code number: 2113 HTH Rich Gorvin

Hi everyone I too would appreciate some code that did this. I would like to be able, on specific reports, to change from the default printer to a pdf writer and then back to the default printer (when the report closes). I have seen some code that goes someway to doing this ... but it does not...

Hi Anthony Try this site (competition for this one I know ... but it also is excellent!). http://www.accesswatch.co.uk/html/microsoft_access_downloads/access_watch_download _files.htm Scroll down to the end and download the "All Access Error Codes" demo database. - Download the self...