Search results

  1. E

    MS Access export to Excel and Total columns in Excel

    Hi there I have exported a recordset to Excel from Access. What is the easiest way to write vba coding that will sum the columns Lets say I have 15 columns and 300 rows I pick up the amount of rows with: totalrows = rs.recordcount in a nested FOR loop how to I refer to i.e...
  2. E

    excel.olb for Office 2013 missing

    Hi there I had Office 365 ver 2016 installed on my system, but too many of my clients are still on Office 2013. I uninstalled Office 365 by using the tools available on the Internet to do a FULL removal of the software. I then installed Office 2013. In MS Access 2013, when I go to the VBA...
  3. E

    Insert a blank row in Excel from MS Access

    Hi there I insert data into Excel and create subtotals without a problem I now want to search for the word 'Total' which I do successfully and it goes to that line item. Now I need to insert a blank row. How do you reference the activecell from Access and insert a blank row below the entry...
  4. E

    PDF issue

    We load Embedded documents into an Access database, using the command: DoCmd.RunCommand acCmdInsertObject We are inserting these docuents into a SQL back end. These have to be embedded files as sone of these are then exported to another database. We have been using this system for YEARS now...
  5. E

    Access Runtime 2013 Spell Check

    This is a possible solution to make sure that the spell checker works on Access Runtime 2013: Office 2010 and earlier installed the Proofing tools which included the spell checker automatically if selected. Office 2013 runs its proofing tools through SharePoint. Thus if no SharePoint...
  6. E

    Pivot charts in Access 2013

    Has anyone got a solution for Pivot charts in Access 2013? I have so many pivot charts in many of my databases. How are we going to get round this? It is ridiculous that Access 2013 just stops such an important analysing tool!!:banghead:
    • epiek
    • Thread
    • Replies: 4
    • Forum: Forms
  7. E

    Purpose of the Heading over the controls

    Hi All When using the Forms wizard for a tabular form, is there ANY purpose for the Heading of the Forms to be OVER the Field headings? I find it annoying, but maybe it is because I don't understand WHY I have to resize it every time, before I can use my field headings on the form:banghead:
    • epiek
    • Thread
    • Replies: 5
    • Forum: Forms
  8. E

    Office 2013 and Access runtime and spell check

    We have several users, working with a desktop copy of a database. The users run the database through Access runtime 2010. On some of the PCs MS Office Home and Business ver 2013 is installed, and others MS Office Home and Business ver 2010. The PCs where Office version 2010 is installed runs...
  9. E

    Font will not change on Memo field

    I have an URGENT issue to solve, please... I have a form where several Rich text memo fields are being used The users often copy and paste from Word into these fields. I want to change the font with coding so that all the font on all the fields look similar. I have used specifc reference...
  10. E

    Export a report as RTF with images

    Is there any good tool/coding that you can recommend that will export a report with formatting and images to a Word document
  11. E

    Grammer check in Access 2010

    I used the code below effectively to check spelling in a specific control. How do I check grammar. Need this urgently:) Private Sub ReviewComment_LostFocus() Rem If the textbox contains data run the Rem Spell Checker after data is entered. DoCmd.SetWarnings False With Me!ReviewComment...
  12. E

    Hi I am Elsa

    Hi there Live in Johannesburg, SA. Have been programming with Access VBA for years and loving it!
Top Bottom