We have an add-in that lists names of bookmarks that the user selects and it pastes the bookmark into the current document. this has been working fine on a windows 7 pc running word 2010. when we run it on a windows 10 pc with word 2010 we get a runtime error '91' object variable or with block...
thread149-1611991
I am having the same problem as reported in the closed thread above. I had to do a report very similar to an existing report, so I did a save as and started working on the new report. When I added a new text box and typed in the text and then clicked outside the box the text...
I am working on a laboratory database and I am having trouble with a field displaying differently. when I run a select with "result to grid" the field displays as an arrow pointing north, an "o", a vertical line with a small hypen out the middle on the right side and a "C". in result to text...
I am at the last stages of my first Visual Studio 2008 vb.net project. I use within the project PDFCreator to create a pdf file. All working fine. I am now trying to "setup and deploy" my project using the setup wizard.
On my test pc, it installs without error. However, when I run the program...
hi, still trying to figure out vb :). this code was working and then I added an insert trigger on the table in this qyuery. now I get an Sqlexception was unhandled error - subquery returned more than 1 row. how do I fix this???
Thanks
Dim cninsert As New SqlConnection(connectionString)
Dim...
Hi, I am trying to change the color of some lines in a checkedlistbox(CLB). I have included the code that I use to load the CLB and some code that I have found that changes the color in a list view box. Is it possible to change the color of the font in a CLB? I am very new with VB.net and still...
From a Visual Studio 2008 form I create and save a word 2003 word document for an employee selected from a dropdown list. I am trying to add a button to my form that will allow the user to view (printpreview) the document and print it if required. I am trying to work out how to printpreview the...
I have a richtext box(on a visual studio 2008 form) that I copy & paste formatted text from a word doc in to. I want to be able to save this to a sql server 2005 DB field. I then want to read this field and put it into a word doc with its formatting.
Problem 1 - How do I get a formatting...
I am trying to create a word document from a template. I am getting the word file save as screen when I thought the save as line would do this for me.
'Start Word and open the document template.
oWord = CreateObject("Word.Application")
oWord.Visible = True
oDoc =...
I have a checkedlistbox that contains a list of all codes and a listbox that contains the codes that have been assigned to an employee. when the listbox is loaded I want to put a tick in the checkbox of the corrosponding code in the checkedlistbox.How can I do this?
Thanks in advance
Brian
I have a form that has 2 combo boxes and a checkedlistbox. Combo1 contains a position number,combo 2 contains positions. When the user selects a pos no it populates combo2 with the pos desc and then lists responsibilites for that position in the checkedlistbox. When I select another pos no or...
Doing my first project in Visual Studio 2008 and very new to vb. To simplify things, I have 3 tables in a DB, employee, delegations and emp-delegates. I have a drop down list to select the emp no. I was then going to use a checkedlist box to display all the delegations and have the delegations...
Hi, I am very new at vb.net. I am using 2008. I am creating a project that consists of a menu form and several sub menus. i have been able to set up a button on the menu form that will open up the subform and set up an exit button on the subform button to go back to the menu form. however, now...
I am trying to create and save a .doc file by using a .dot, but my code is saving the insert of the bookmark into both documents. how do I close the .dot file without saving any changes? please ignore the roughness of this code as I am just learning vb and I am trying to see if I can get the...
I am currently using the following code to populate cells with a formula
Dest.Cells(sRow, 10).Select
ActiveCell.FormulaR1C1 = "=if(RC[-2]<>""-"",(RC[-2]-RC[-1]),"""")"
I am now going to have a variable number of columns that this formula has to go in and also the RC[-1] col is going be always...
Hi, This my first attempt at a report. Firstly I have written a fairly complicated stored procedure to extract the data I want and this is held on the SQL server. Secondly in the report I am executing the SP to get the data.
In this data I have a field called status that I have placed onto a...
this is my first attempt at programming with VBA in Excel.
I am trying to automate a spreadsheet for our lab technician. Simply, he imports a number of records each week into sheet 1 then copies 2 columns to col A and B on sheet 2. he has a formula in col C. Row 1 has Headers. Depending on how...
I am trying to print the following
print a page header then print the detail lines and then a page footer. if there are only 2 detail lines I still need to print 3 lines with the "column" lines before the footer prints. I have put the column lines between the fields in the detail line, then...
I have a table that(in short) has a document no field and a version no field ie
document no version no
1 1
1 2
2 1
3 1
3 2
3 3
how do I get the following returned
document no...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.