i try to get the coordinates of a autocad blockreference. with the code below i can pick a block-reference in autocad, but it always display (0,0,0) as insertionpoint... isnt the insertionpoint the actual coords of a block? Sub GetInsertpoint() Dim oEnt As AcadEntity Dim varPick As Variant Dim brBref As AcadBlockReference ...
VBA is a programming language so I'll assume this question is ok on SO. What API calls and other techniques can I use, to extract specific tables from an MS-Word document? I need to write a program which will open several Word documents, and look inside for tables which have a certain text in Row 1 Column 1, and output those tables to ...
can someone please help me with the following query i need to update a datasheet (table) in access through a form: i will have something like this SQLtext = "update table1 set column1="sometext" where column2=textbox1.value" DoCmd.RunSQL SQLtext is this possible to do? i have a textbox on a form and when i click a button on that fo...
what happens to identical items in a sort? (sorting algorithm) for example what would the following list look like after it has been sorted in ascending order: (f, g, a, r, s, g, a, x) ...
Hi, I have created a addin for excel, where there is a ribbon and a button on it. I have handled the event of button click with the following code Private Sub test_button_Click(ByVal sender As System.Object, ByVal e As Microsoft.Office.Tools.Ribbon.RibbonControlEventArgs) Handles test_button.Click Dim activeWorksheet As Excel.Work...
In Excel 2003, I need to copy a Graphics object (sheet.PageSetup.LeftFooterPicture) to the Clipboard. How can I do that? ...
Using Excel 2007 VBA Have a sheet "Dashboard", have other sheets but some special task sheets that can be anywhere in the book, but will always be found between Sheets "TaskNew" and "TaskEnd". These special task sheets will vary in count. Upon dashboard activation, want to populate the listbox with the names of all special task sheets,...
I'm writing some VBA and would love to use Listbox.BeginUpdate and ListBox.EndUpdate to speed up the loading of userforms however VBA doesn't seem to support these, only vb. Anyone got any handy suggestions? ...
i have an access database on a server. it is split up into front end and back end. people are accessing the database's front end using a shortcut from their desktop computers. i know for a fact that multiple people are using it at the same time. for some reason, when i created a shortcut on my computer to access the front end of this ...
How can I execute FCIV and obtain a hash for a file using VBA? ...
does anyone know how to add a TEXTBOX onto a word 2007 document. i need to gather user input and after the form is filled out, the data will be added into an access database thank you! ...
i have a file like this: strPath = "S:\HR\Forms\forms_database.accdb" i am connecting to it through an WORD adodb.connection should my database be a different extension ? MDB or something? i am getting this error when it tries to connect: unrecognized database format 's:...............accdb' what's going on here? here's the enti...
what is the difference between these two extensions? i need to write to an access database from a WORD file using an ADODB connection when i create a new access database it gives me the option to make only an ACCDB file and for some reason i cannot make an MDB file can someone please help me create an MDB file so that i am able to ma...
anyone have examples of sophisticated WORD 2007 forms that posts to access DB using ADODB connection? ...
i am filling out a form on a word document which posts to access database,. does anyone know if there a way to suppress the message "do you want to insert this record"??? raj mentioned that this is possible to do manually, uncheck ACTION QUERIES, but can i do this programmatically/???? ...
i am getting OBJECT REQUIRED on error on this anyone know whats going on ? Private Sub CommandButton1_Click() DoCmd.SetWarnings False Module1.TransferShipper End Sub ...
i have an excel spreadsheet that is about 300,000 rows and about 100 columns i need to perform various functions on this spreadsheet and out of this spreadsheet i need to create about 3000 other spreadsheets which are SIGNIFICANTLY smaller for every created spreadsheet i will need to have a separate powerpoint file that will have an au...
I have been using every version of Kill routines to delete xls files in the current directory with no success. Here is my code. I want to delete every xls file except wbCntl. Stepping through this code shows that everything works with the exception of the Kill swb command. (swb is public defined as a string) 'Close all files exce...
I am using rs.update to change some values. something like rs("SomeField") = frmSomeOptionGroup.value where I want the actual option value to be stored in the table. however this just simply seems to return true or false values to the table instead of 0-2.... so what should I do to make this concept work? thanks justin ...
Hello there! I have an object and within it I wanna check if some properties is set to false, like: If (not objresult.EOF) Then 'Some code End if but somehow, sometimes objresult.EOF is Empty, and how can I check it? IsEmpty function is for excel cells only objresult.EOF Is Nothing - return Empty objresult.EOF <> null - return Empt...