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 strongm 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: BasicBoy
  • Content: Threads
  • Order by date
  1. BasicBoy

    Setting a control

    I wish to set a control of which I only have its name stored in a database in a string field 'cboList' like in: Set MyControl="cboList" It gives an error because the string "cboList" is not a control object. Thanks for help
  2. BasicBoy

    Open any document file from VB6

    My VB6 program has a link to a document file (like a .txt, .pdf or .jpg) on a label (say lblDoc.caption) on the form which points to a file on his C drive. I need to open the file for the user using the default program on his computer for that type of document in order for him to display it in...
  3. BasicBoy

    .NET version

    I am developing with Visual Studio Express 2012 for Web. My web hosting company says that my solution/project is compiled in .NET 3.5 and they want it to be .NET 4.0. How can I change that. Thanks
  4. BasicBoy

    Duplicate entries from Access query

    I have this query: ListQuery(35) = "Select transactions.id, transactions.transdate, journaltranstypes.transtype, transactions.description, transactions.refno, paidforvotes.votename as paidforvotename, amountdt, vatondt, format(vatamountdt,'currency'), paidbyvotes.votename as paidbyvotename...
  5. BasicBoy

    Currency field type

    A table in my Access database has a few fields which are formatted as currency. This field type is only called Currency in Access. However, when I do a query of this table, the field type returned with DAO is the number 4 (dbLong) and not the number 5 (dbCurrency) How could that be? Thanks
  6. BasicBoy

    Task or in process

    I have a Diary program (written by myself in VB6)which we use to send messages to each other at the office. It checks every two minutes whether there is a new message for a user and then warns him/her. I use Access as a database. The problem is that when the user has not opened the program, he...
  7. BasicBoy

    Button column in Datagridview

    I want to have a delete button column in my datagridview as the last column. If I add the column after I bind it to data, it creates another button column each time I rebind the datagridview and replicates it ad infinitum each time I refresh the list. If I add the button column when I load the...
  8. BasicBoy

    Flexgrid in VB.NET

    I have been using the flexgrid control in VB6 and editing data by placing another control like a text box over the relevant cell, which is quite easy. Now that I am trying to convert to VB.NET, I find that the flexgrid COM object does not easily fit into the .NET framework. I do not wish to go...
  9. BasicBoy

    Draw polygon

    I have difficulty drawing a polygon to the right scale. I use the Polygon API. However, my scales might be the problem. I have intervals of 1 to 25 as the X (horizontal axis) and Dollars from 300000 to 3000000 on the Y (vertical) axis. Can I use the selfsame coordinates to draw the polygon or do...
  10. BasicBoy

    Finding a button created during runtime

    I have made about 100 buttons during runtime, each with a different name and all with tags - some with similar tags, and I have made them all invisible. On the click event of another button (controlling) I wish to make some of these 100 buttons visible depending on their tag. When I click the...
  11. BasicBoy

    Syntax for Excel formatting

    I wish to colour the background of cell in an Excel sheet a certain colour and I am using the following syntax : Set moApp = New Excel.Application Set moWB = moApp.Workbooks.Add i=10:j=10 moWB.Sheets("Sheet1").Cells(i, j).FormatConditions(1).Interior.ColorIndex = 35 What could be wrong? Thanks
  12. BasicBoy

    Count columns in AxMSHflexgird

    I cannot get myflexgrid.columns.count to give the number of columns in the grid. It does not recognize the word columns, although I can get the row count with myflexgrid.rows.count. Do I miss something Thanks
  13. BasicBoy

    Datediff in query

    I have a table with a reminderdate field, a reminderdescription field, a recurinterval field (1 for the reminderdate, 2 for one year after reminderdate, 3 for one month after reminderdate and so on ... and a lastintervalclosed. I need to calculate when this reminder will be like in : If the...
  14. BasicBoy

    Access query error

    Can someone please tell me where the error is in this query. SELECT incomeforecast.id, mydate, incomevotes.votename as incomevotename, origin, incomeforecast.refno, amount, bankvotes.votename as bankvotename FROM incomeforecast LEFT JOIN (votes as incomevotes on...
  15. BasicBoy

    Extracting table name from fields in a query

    I am joining a few tables of which some have similar field names like say ID. When I open the DAO recordset, I have field names, but I wish to know from which tables those fields were extracted. Is there a way to establish that from the fields or other collection. For instance I would like to...
  16. BasicBoy

    Getting to know the names or tags of all the controls in a frame

    I have an application where I need to identify all the controls which have been placed in a certain frame control, and then iterate through them and see which are visible. Thanks
  17. BasicBoy

    Notify icon not calling back

    I have used the Mictrosoft procedure to put an icon in the system tray : http://support.microsoft.com/kb/176085 However, when I minimise the form, the popup menu does not appear when I move my mouse over the tray icon. Also it does not restore the form when I click the icon - the mousemove...
  18. BasicBoy

    Order by (number)

    Why does this not work? Select * from mytable order by 0 Where 0 is the number of the field in the query. Thanks
  19. BasicBoy

    Calendar rendering

    I have bought an EO.Web.calendar control, but those guys are not into support. I wonder if anyone has worked with this and can give me some guidance on how to render selected day ranges from a database table. Thanks
  20. BasicBoy

    extract values to update gridview

    I have this edit template in a gridview which shows when I go into edit mode : <EditItemTemplate> <asp:TextBox ID="txtEditMessage" runat="server" width="340px" Text='<%# Eval("Message") %>'></asp:TextBox> </EditItemTemplate> I now need to update the row. How do I extract the value from...

Part and Inventory Search

Back
Top