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 Chriss Miller 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: rennis
  • Content: Threads
  • Order by date
  1. rennis

    barcode printing + 2 columns of labels

    Currently working with a datamax printer and Jewelery style labels or barbell shaped labels. Labels are similar to this: http://www.kassoy.com/images/kas/labels/zu102.gif Have used bartender, labelview etc, but none of these programs seem to have a option to preview the two columns..Has anyone...
  2. rennis

    VB^ + MS Word Mail Merge

    Has anyone ever come across the following error when trying to complete a mail merge in ms word, using data from vb6? "String is Longer then 255 characters" It occurs on the .opendatasource line with the Select statement. Select * from table where primary_key in ("& the_primary_key_var &")...
  3. rennis

    Winsock Control: SMTP authentication

    Is it possible to add smtp authenication to a winsock control/winsock.control method, as its required by the mail server Im using? I've tried winsock.connect "user:pass@email.domain.com" but that doesn't work. Anyone have any the suggestions?
  4. rennis

    Control: Expand on click of + sign

    In microsoft access, I believe with relationships between tables,there is a "listview" type control that when you click the plus sign it expands the data, and when you click the minus sign it compresses the data. Is this possible with a listview control or another control within vb6 where by i...
  5. rennis

    Php + mysql: 2 database connections open

    I currently am able to open one connection to a mysql database. However, I have been unsuccessful in my attempts to get 2 connections open at the same time. Reason for this is that i need to connect to a second database on a second host, select data from a table in database 1 and insert it into...
  6. rennis

    Newbie + Php login: Passing host name

    I currently have a login form, and the login form will ask for the host name of the database. I would like to pass this host/server to the connection string and then open the database. the form action is to post another php document and in that php document it loads the information from the...
  7. rennis

    ShellExecute: Executing a batch file and passing parameters + Waiting

    Currently, I am using shellexecute to execute a batch file. The batch file gets passed parameters, and executes mysql.exe, which allows me to execute script files on a database. For example: result = ShellExecute(hwnd, "open", "theBatch.bat", parameter1 & " " & parameter2 & " " & parameter3 &...
  8. rennis

    Crystal Reports: Grouping Programmatically

    Using a adodb recordset, I am able to pull all the information required, however, I need to group this information on the crystal report by a field in the select statement. Is there anyway to do this without using any of the Wizards such as database expert, group expert etc? Thanks
  9. rennis

    HotKey: If certain key was pressed, open form

    Is it possible to open a form if alt + any letter or shift + any letter was pressed? so for example, if alt + e = true then frmForm1.show Any assistance would be greatly appreciated.
  10. rennis

    ListView: Determine if Item was Selected

    How is it possible to determine if a item in a listview was selected? If no item was selected then a procedure would not occur, however, if there was one then proceed.
  11. rennis

    Listview: Weird Occurance on Set itmx = lstViewQuery.ListItems.Add

    On one of my forms i have a listview and items get added to the listview when the "add" button is clicked. Heres the basic idea of the code Dim itmx as listview set itmx = listview1.listitems.add itmx.text = cbo1.text itmx.subitems(1) = cbo2.text itmx.subitems(2) = cbo3.text cbo1.text = ""...
  12. rennis

    ListView: Move Row Up/Down on Button Click

    Is it possible to take a selected item/row in a listview and move it up/down in the listview based on a button click? For example, in the listview if the rows were The First Row The Second Row (selected Item) The third Row Move up button click: The Second Row The First Row The Third Row OR...
  13. rennis

    Listview Subitem: Combobox

    Is it possible to add a combo box/drop down to each cell in column 1 of a listview? I did try the method of repositioning of the width, left and top, however i was unable to adjust the height of the combo. Also, this combo was restricted to just the first cell in the first column. What i need to...
  14. rennis

    Automatically fill listview/datagrid with recordset results

    Is there any way to automatically fill a listview or datagrid with the information retrieved from a ado recordset? Basically, after the recordset.open " select......" the information that this recordset retrieves, should automatically fill the listview or datagrid without specifying...
  15. rennis

    Listboxes: Vertical Scroll and Drop Down Boxes

    First Question: How is it possible to add a vertical scroll bar to a listbox if it is needed? I've tried EnsureVisible method, but this did not seem to resolve the issue, whether Its the wrong method to use or I was using it incorrectly. Second Question: Is it possible to add a drop down box as...
  16. rennis

    Shell Execute + Multiple Parameters

    Hopefully someone here may be able to help. Is it possible to pass a second parameter into a batch file? As you can see by the code below, 'theFirstParam' is a parameter with a string value that is being passed into a batch file. However, I would like to pass a second parameter into the...
  17. rennis

    Operation not allowed in this context

    I get the following error on the following line of code the second time of a for loop. IF .state = 1 then .close (basically, if the ado connection is open, then close it.) Anyone have any idea why this happens? This line of code is used numerous times through the code but its only here that...
  18. rennis

    MySql: Select database and perform mysql dump

    I currently have a batch file created using shell which runs mysqldump and saves the information to a file. However, I was wondering if there would be a way to use a recordset instead to select the database and initiate the mysql dump. Ideally this is what i would like to have: rs.Open "Use...
  19. rennis

    MySql + VB6: Pass keyword as fieldname within Insert Statement

    I successfully migrated from access to mysql. The original database had a column name "group"..When i try to pass/insert the value from the form into this field, in the table, i get an error. I believe group is also a keyword/part of mysql and its causing the error. Is there a way to pass this...
  20. rennis

    VB6 + MySql: Update Error on Recordset

    After researching, i have been unsuccessful in finding the correct syntax for updating a record set within vb6 to an mysql database. the current syntax is just saveRec.update, and each field is saved to the record set as saveRec.fields("fname") (as this is the syntax for vb6 and access. Can...

Part and Inventory Search

Back
Top