Search results

Hi Jatfill Just some re-assurance ... I struggled with doing an invoice with the invoice items being based on a crosstab query that fed into a subreport. Result? Couldn't get it to work. However, once I made the crosstab the query underlying the main report (and brought in other invoice...

Hi SaM--- Perhaps you need to save the new record first - try adding: DoCmd.RunCommand acCmdSaveRecord after DoCmd.SetWarnings True This will save the record before you go into the other fields to add data. HTH Rich Gorvin

Hi MTC67 Your command button is only available in single form view - as a datasheet you only get columns/rows of data and a heading for each column. The answer lies in what you have already hinted at - make a form (viewed in single form view) and add the datasheet as a subform. HTH Rich...

Hi Peters Let's say you field is called "Status". In the Control Source row in properties for that field on your report you could use a nested immediate if expression (IIf). =IIf([Status]="A","Assets",IIf([Status]="L", "Liabilities","Revenue")) HTH Rich Gorvin

Hi Aziz Rasul Hope That Helps HTH Rich Gorvin

Hi Johan Do you mean the "name of the form" or the name of a customer/client/supplier? Is it the case that you want to move onto a different form dependent on a list of forms available - or always the same form, but opening at a specified record (the name of the customer). Rich Gorvin

Hi Johan Please don't do multiple postings - it gets confusing when trying to follow the advice given in three different threads simultaneously. Rich Gorvin

Hi Johan Please don't do multiple postings - it gets confusing when trying to follow the advice given in three different threads simultaneously. Rich Gorvin

Hi Brian You are 75% there to fix the problem. After unchecking the MISSING reference (Microsoft DAO 3.51 Library) scroll down the list to find a similar reference that you do have installed - Microsoft DAO 3.6 or Microsoft DAO 3.0). Put a tick alongside this one and then close the refernces...

Hi Peaslet Better to do it through coding. ----------------------------------------- Sub cmdButtonName_Click(): On Error GoTo Err_cmdButtonName_Click Dim strDocName As String Dim strLinkCriteria As String strDocName = "rptYourReportName" strLinkCriteria = "[CustomerID] =...

Hi cawillwe As far as I know you are following the correct procedure ... disappointing, isn't it! The CBF code is a separate entity to the objects/controls on the form ... so it means copying the control/button/whatever, copying the code and then linking the two in the new form. If anyone...

Hi David I can't offer any advice ... but I can tell you where you got this code from originally and you may be able to contact the authors from there. The original coding comes from the Access Developers' Handbook - Ken Getz, Paul Litwin etc and an explanation of how to utilise it is available...

Hi David Please see my response under Modules and VBA Section. Rich Gorvin [This message has been edited by Rich@ITTC (edited 05-14-2001).]

Hi Graham Please refrain from multiple postings on different sections of the site - it gets confusing for people trying to help with advice and difficult for others to follow who want to learn. If there is only one posting everyone can instantly see what advice has been given, any subsequent...

Hi GMT (Greenwich Mean Time??) Is it Trim that is causing you a problem? Or perhaps your data for the postcode is actually stored without the space being stored (I am sure there's an option somewhere to do this). Have you tried: =(Trim([City]&", "&[Province]))&" "& StrConv([Postal Code],1)...

Hi Rob The Long Date format is dependent on the Windows settings within Control Panel->Regional Settings->Date. You could therefore make changes at this level, though it would also affect other programmes (such as any date fields you have in Word). Also if you use your database on another pc...

Hi deepbreath I don't think you can make a text box on a report wider, but you can certainly make it increase in size as far as height is concerned by setting the CanGrow property to Yes. HTH Rich Gorvin

Hi Peter Perhaps your Reports are set to Fast laser printing. Follow this previous posting: http://www.access-programmers.co.uk/ubb/Forum5/HTML/001267.html HTH Rich Gorvin [This message has been edited by Rich@ITTC (edited 05-01-2001).]

Nice one Des! Rich Gorvin

Hi Des Can you send me a copy too. Thanks! richgorvin@freeuk.com Rich Gorvin