Search results

Hi Thanks for tips. Done a report and put 12 months MonthNames as Text on report and added data as a subreport. Worked out how to total data but want to do Avg as well. Problem some months are blank so access does not include them in average. Can do a calculation of total/number of months. Can...

Hi theDBguy Thanks for your reply it made me realise that I print single forms as pdf's if I link then to multiple records it will print a multiple record pdf. One query is the record card shows Jan to Dec. As records are only recorded so far to June it only displays Jan-Jun. Is there any way...

Hi Please can you point me in the right direction? I have a access database of 130 record cards each with several years of data attached (but only the past year is shown on a form). A heading with user details and then below a continuous form displaying then data. With a query I can send 1...

Hi Bob FOUND A SOLUTION!!!!! Followed your link thanks. Found another site on ribbons: accessribbon.de/en/[/url] Has some downloadable demos and they did not JUMP. Found reason 1ST FORM MUST BE POP UP and they do no jump on hiding ribbons. Great and it looks better as 1st form. Many thanks for...

Hi Bob Really appreciate your advice and it looks like a blank ribbon and QAT seems the only way. As coming from Access 2000 I have no knowledge of ribbons or QAT. Can you direct me to where I can learn how to: 1. Create blank ribbon and QAT. 2. Insert blank ribbon and delete/hide other ribbons...

Hi Bob Thanks for you input. Looks like I have to put up with a jump unless microsoft make a change. With Access 2000 you could replace the men bar with a blank bar so you didn't get a jump. Could the ribbon be replaced with a blank ribbon and stop the jump. thanks Michael

Hi Bob Thanks for the thought. Tried that but the function code does not go into effect until a form loads and the jump as it looses the ribbon bar. Have you used: Office Button > Access Options > Current Database > Navigation. It seems that a new ribbon can be created to load but can it...

Hi Bob Attached mdb file. Welcome your comments. Michael

Hi Perhaps I'm a perfectionist but an application that I have does not display the ribbon bar, status bar, navigation etc. just the form on startup form. It seems that the deletion of the bars does not take effect until after the form loads so it jumps ( AND I DON'T THINK THAT LOOKS RIGHT!)...

Hi ghudson Thought your SQL code 11-14-2005, 04:48 AM "LINKED TABLES" is the best solution I've found to finding the path of backend tables. Thanks !!! However can you put me right. It works great in a query but when I put it in VBA get a runtime error 13. Here's code: Dim IDx Dim SQLText As...