Search results

Thanks to Cronk with this coding. rst.movelast k = rst.recordcount xlApp.cells(k + 1, j) = "=sum(" & chr(64 + j) & "1:" & chr(64 + j) & k & ")" that did the trick!!:)

Thanks I have already got all the coding. The data has been transferred already via coding When the sum function is recording from within Excel, i.e. =Sum(A2:A300), I need to put that formula within the coding of MS Access, to automate it for any number of rows. I tried changing the...

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...

Thanks for all your help! I am not quite there, but you answered my question about what to use for the Excel Library.

Thanks for replying If I click on Excel.exe, it allows me to select if but as soon as I click the OK in the reference box, it displays dll error. I have now tried it again and now it has excepted the library. So the reference now show excel 15, but when I try to export data to Excel from...

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...

I managed to solve it, probably very long winded . The activecell works,but you have to reference the application! flag = False j = objWkb.Sheets(1).Range("A6").CurrentRegion.Rows.Count i = 6 While flag = False And i < j On Error GoTo stoploop...

I tried that. In Access, the word selection must be replaced with the cell reference. In Access, activecell does not work...

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...

Thanks for guiding me in the right direction. I build a label with a colon in it and only when I saw your answer, about the apostrophe, I realized my mistake:)

Re: PDF issue - Adobe Acrobat I found a solution after MANY wasted hours . I had installed Office 365 and it automatically installed Adobe DC Reader, which is a Cloud application. I uninstalled Adobe DC completely and then installed Adobe 10 reader, which is still Freeware. Everything...

Unfortunately the documents have to be Embedded, as we are exporting the records with proof of documentation to another MS Access database. Does the code with shell, apply to embedded objects as well? If so, could you direct me?

I did, but it is a very old article and reference Word documents. My issue is only with PDF documents. I wonder if it has anything to do with the version of Acrobat Adobe that I am running. The DC version? Only happens on a few laptops, especially the newer laptops. It also...

I have created a complete new database and imported all the items into the new database. This did not help. I have followed the decompile steps as you suggested; still will not load PDF files. Each person has the Front end of the database copied onto their desktops. Not all of them...

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...

I must mention that I am not using the Spell Check icon on the toolbar, but rather the ON LOST FOCUS event on my control to check spelling when moving from one field to another. If you press F7 for the spell check it will not work, but this coding works if you use the sharepoint designer...

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...

Thanks a lot for this!

Thanks for the reply. How do I go about this?

I would also like to know!!