Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: basbrian
  • Content: Threads
  • Order by date
  1. basbrian

    word 2010 run-time error '91' but works on windows 7

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

    scrunched up text

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

    field value displays different

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

    deploying project that uses PDFCreator

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

    sqlexception error on executenonquery

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

    Change font color in a checkedlistbox

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

    Print Word Doc without openning it

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

    How do I get formatted text from VB box into sql field

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

    Problem openning and closing word documents

    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 =...
  10. basbrian

    tick items in checkedlistbox from items in listbox

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

    Happy New Year to those who help the confused

    and those like me that are the confused :) I am very grateful for those who take the time to help others with their coding problems. THANKYOU.
  12. basbrian

    How do you clear (repopulate) a checkedlistbox

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

    Is checkedlistbox the way to go

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

    navigation between forms

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

    open a word document using a template

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

    constant in a .formula statement

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

    sum a &quot;variable&quot;??? field

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

    deleting formulas from a varible no of rows spreadsheet

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

    print outline of table on report

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

    finding all the latest records

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

Part and Inventory Search

Back
Top