Search results

Hi Anthony Yes this is possible in Access. You need to identify which error message you get that you want to replace - they all have code numbers. Below is an example that I prepared earlier: -------------------------------------------------- Private Sub Form_Error(intDataErr As Integer...

Hi Ali Edwards I don't know if what you want to do is possible using a Macro ... my instinct tells me that it almost certainly isn't. I think you need to convert this Macro to Coding/VBA. You can then use BOF/EOF (beginning and end of recordsets) to programmitically find when you are at the...

Hi BD Have you checked whether the Property "Fast Laser Printing" (which applies to the whole report) is set to "Yes". Changing this to "No" can, in some circumstances, resolve the problem of lines appearing on a report when in Print Preview but not appearing when actually printed out. HTH...

Hi Modex It's always nice to hear that something has worked and to receive some thanks. Usually it is better to continue on the same message/posting thread by using the Post Reply button (lower left hand side). HTH Rich Gorvin

Hi Modex Try this: =Sum(IIf((Left([title],1)="a"),1,0)) For Null values use the Nz function (see Help files for details). HTH Rich Gorvin [This message has been edited by Rich@ITTC (edited 04-18-2001).]

Hi Jane I agree with R.Hicks and Mike Gurman (as so often). You could also look at this link: http://www.access-programmers.co.uk/ubb/Forum5/HTML/001226.html HTH Rich Gorvin

Hi Timberwolf Better to use coding for this rather than a Macro. ------------------------------------------- Sub cmdClaimantReport_Click(): On Error GoTo Err_cmdClaimantReport_Click Dim strDocName As String Dim strLinkCriteria As String strDocName = "rptClaimantReport"...

Hi Tuck Try this; =[LastName]&", "&[FirstName]&(" & "+[SpouseName]) HTH Rich Gorvin

Hi Robert Try this one - for me it works. Truck: (IIf(([Passenger]=0),0,(IIf([Passenger] Mod 100=0 Or [Passenger] Mod 100>=50,([Passenger]/100),([Passenger]/100)+1)))) This gives: Passenger   Truck    0             0    1             1   50            1   99            1  100            1...

Hi Robert You need to use the Mod function to see what the remainder is. Try this below ... I think it ought to work, but I haven't actually tested this exact example (though I do use similar calculations). =IIf(([Forms]![Wheels Up]![Passengers]=0),0,IIf(([Forms]![Wheels Up]![Passengers] Mod...

Hi J Blackman What is the Format setting for the text box on the form? If it is ShortDate then it will show 04/01/01. Depending on where you are you can choose one of these alternatives that you type into the Format property for the text box that displays this date. mm/dd/yyyy (for USA)...

Hi John Hobbis Please do not do multiple postings in different areas of the forum. It makes life difficult for the people trying to advise/help. Rich Gorvin

Hi Amy I think you may be limited to 0,1,2,3 as superscript characters within a normal font. If you need others for a particular table (and it would have to apply across the whole table - to all the fields) you would need to change the font to something mathematical. I think this could be...

Hi Skelley You could re-design your forms!! Unfortunately there is a possibility that this might be the only answer. Normal development practice is to design to the lowest resolution that any user may have on their screen (the actual monitor size isn't the issue - but the range of resolutions...

Hi Skelley You are not looking in the right place. You are within the subreport to get the values you have described - close the subreport and view it as a control (a box) on your main report. You have to go in through the main report, but without opening up the subreport (hence the...

Hi Skelley You need to be in the Main Report - Design View. Your subreport is therefore one of many controla on the design page. Select the subform by clicking on it only once and go to the Properties. On the Format tab Can Grow is the second choice - on the All tab it is the 6th choice...

Hi J Blackman My understanding is that the ! (bang) is used before items the User/Developer has named and the . (dot/period) is used before MS Access names. So Me.Requery would be Ok as "Requery" is a term named by Access. Me!Requery wouldn't be OK. Likewise Me!cboNamedMyMe would give...

Hi awolf Use the Alt key and the following codes: Alt+0153 ™ (for Trade Mark) Alt+0169 © (for copyright) Alt+0174 ® (for registered) The Alt+NumberCode works across all Windows programmes. HTH Rich Gorvin

Hi Maria It sounds like you have two Sub Procedures using the same name - so when you click the Command button Access doesn't know which to run (and it could even be that the Sub Procedure is a different one to the one you are trying to run). I would hazard a guess that you might have created...

Hi Lee and Mike Sorry to be digging up an old posting like this ... but it was a posting last year that made me realise that others were struggling, in the same way that I was, with this area and so I set about trying to discover a solution. Only now have the results of that head-scratching...