Search results for query: *

Is there any vba code to convert PDF files into txt file - without using acrobat reader? I have searched the net but have, so far, come up empty handed, all seem to need adope acrobar. Thank you all in advance.

This will not show the msg on screen - VB.net file called from vb code behind screen Try SMTP.Send(Mail) Retry = True Catch ex As Exception If Not Retry Then MsgBox("Failed to send email reply to _ " & Mail.To.ToString() & "."c, vbOKOnly, "Title")...

I would like to use messagebox in my code but get the above error msg. I use MsgBox but think that messagebox is more flexable and have more features. Do I need a messagebox function to get this to work or what do I have to "import"? Herman Say no to macros

When showing the screentip of the selected button I see a ref to the current open form and a small text "Press F1 for added help" can one get rid of this disturbing mesage that has nothing to do with the program/base as such. Herman Say no to macros

I am trying to run the belov code and the Ribbon is created but will not load or show if selected on a given form Sub LetItRip() Dim RibbonXml As String, A, B, RibName, Rib As Office.IRibbonUI RibName = "MenuMainRib" A = Array("&Adgang", "&Skift bruger", "Skift database", "Afslut program", _...

I have a ribbon created in ms-project VBA and the ribbon as such works just fine, but I can get no return values from dropdown boxes, buttons etc. works as they should. I have made a Option Explicit Public SRibbon As IRibbonUI But when calling the ribbon via the Onload sub the ribbon fails so I...

I have a ribbon created in project VBA and the ribbon as such works just fine, but I can get no return values from dropdown boxes, buttons etc. works as they should. I have made a Option Explicit Public SRibbon As IRibbonUI But when calling the ribbon via the Onload sub the ribbon fails so I...

I have tryed: Application.Run UserFormName & "." & "Private Sub Cmd_Save_Click" But get the error msg: Unable to run the specified macro I know that the Sub is there and Application.Run should do the trick. So what am I doing wrong or cat this be done owing to the fact that this is a private sub...

Caon one not use an array to load or view a user form. And if so what is the trick. Thank you. Herman Say no to macros

Is there a way to loop thru the forms in word?. It should be simple ie. For I = 0 To Doc.Forms.Count code Next However Forms can not be fnd under ThosDocument ... or anywhere else.... smile Can anyone help? Thanks Herman Say no to macros

I need to refer / set Frm=Forms(FormName) to a sub form I use the following function it works fine when I "set" to a main form however when setting to a mainforms subform I get an error "can't find the form 'MainForm!SubForm.Form' referred to in a macro expression or Visual Basic code. Sub...

Senario - on a datasheet-form the combo box is open, nothing is selected, one can see x-amount of rows, as the mouse moves a cursor is highlighting the row the mouse is pointing at (black) is there a way to: 1. Find out where the cursor is in the combo box. 2. Retrive the information from this...

I have a function that loops thru a recordset, however as it moves thru the records it gradually becomes slower and slower. I have tryed to close a recordset that I use for a FindFirst along the way and also closing the DB (CurrentDatabase) all to no evail. Below I deliver 2 dates a start and...

I am looking to convert my access app. to VB this could be VB6 or later. I find, after using Access since ver. 1.0, that Access is an unstable and ever changing platform. One is being faced with endless "fixes" with the newer ending stream of non-backward compatible Access versions. So I am...

I want to "import" a file such as a doc, xls or pdf file info a field (OLE) in a table. I can open a pathfinder and select the file but I only get, at best, the filepath. However when paisting in i.e. a mail I see the file selected via pathfinder. Has anyone the solution to this problem -...

I want to "import" a file such as a doc, xls or pdf file info a field (OLE) in a table. I can open a pathfinder and select the file but I only get, at best, the filepath. However when paisting in i.e. a mail I see the file selected via pathfinder. Has anyone the solution to this problem -...

I have had a look around but have not been able to find anything that will open the office clipboard window. How to manipulate in all sorts of ways, but not how to just open and show it, to the user. Anyone have a clue ? Herman Say no to macros

Normally when opening a combo box, it's list will drop down to either the right or left side, however would it be poss to choose/control the side and not have it "dictated" , via vba. Also would it be poss to detach the list from the combo box itself ? Thanks for any reply in advance. Herman...

Normally when opening a combo box, it's list will drop down to either the right or left side, however would it be poss to choose/control the side and not have it "dictated" , via vba. Also would it be poss to detach the list from the combo box itself ? Thanks for any reply in advance. Herman...

I have an ADP front that is used i vaious countryes, however when used in finland it comes up with all kinds of errors on dates. I.E. when creating a recordset it will give an error although the format looks correct. The finish date format is dd.mm.yyyy so I figured that it might be the date...