Search:

Type: Posts; User: e34m5

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    524

    Re: How to lock "relationships" in MS Access

    Nope. Users are working on the tables in the MDB. If I make the whole DB read-only then they cannot work in it.
  2. Replies
    9
    Views
    1,317

    Re: Embedding "bold" characters in a string

    How can I make listview show 2 and only 2 columns. Even though I have defined 2 columns, at runtime it shows 3.
  3. Replies
    9
    Views
    1,317

    Re: Embedding "bold" characters in a string

    The strings will be in a list box. They will look like this.

    Drawing No: 1234
    Drawing No: 5678
    Drawing No: 9012
  4. Replies
    9
    Views
    1,317

    Re: Embedding "bold" characters in a string

    As far as I can tell the string class does not have a font property.
  5. Replies
    9
    Views
    1,317

    Embedding "bold" characters in a string

    I need to make part of a string bold. Something like this:

    This part of the string is bold

    So if the code is this:


    Dim sStr as String

    sStr = "This part of the string is bold"
  6. Thread: SQL Translate

    by e34m5
    Replies
    1
    Views
    330

    SQL Translate

    It appears that MSAccess does not support this type of SQL:


    select TRANSLATE ( [Instruments].[I/O_TAG_NAME], [Instruments].[functionID],"A","S")
    FROM INSTRUMENTS
    WHERE Instruments.Loop="159"...
  7. Thread: Translate Sql

    by e34m5
    Replies
    3
    Views
    603

    Re: Translate Sql

    Running SQL from within VB.net
  8. Thread: Translate Sql

    by e34m5
    Replies
    3
    Views
    603

    Translate Sql

    It appears that MSAccess does not support this type of SQL:


    select TRANSLATE ( [Instruments].[I/O_TAG_NAME], [Instruments].[functionID],"A","S")
    FROM INSTRUMENTS
    WHERE Instruments.Loop="159"...
  9. Replies
    2
    Views
    603

    RecordCount in w/ADODB and spreadsheet

    connstr = "provider=microsoft.jet.oledb.4.0;data source=" & sFile & ";extended properties=Excel 8.0;"

    cn = New ADODB.Connection
    cn.Open(connstr)

    rs = New...
  10. Replies
    1
    Views
    4,343

    How to set item in checkedlistbox to read only

    I need to programatically set a particular item in the collection to read only.
  11. Replies
    2
    Views
    512

    Halting code execution.

    I need to temporarily halt execution of code to allow users to enter data.

    Something like this:

    CODE
    CODE
    SHOW PANEL FOR USER DATA
    WAIT FOR USER TO CLOSE ENTRY PANEL
    CONTINUE WITH CODE...
  12. Replies
    1
    Views
    779

    Renaming table is ACCESS

    I need to rename a table in an mdb. I thought I could use DAO (I added the reference to my project) using the following code I found in my search:


    Dim dbSS As DAO.Database

    ...
  13. Replies
    0
    Views
    508

    Current owner of file

    I need to read the value of this attribute. How do I do this.
  14. Replies
    18
    Views
    1,342

    Re: Try..Catch Behavior

    For k As Integer = 0 To HandleGrid.RowCount - 1
    If Not (HandleGrid.Item(0, k).Value = "") Then

    Try
    sMsg = oDM.OpenDrawing(Label3.Text...
  15. Replies
    18
    Views
    1,342

    Re: Try..Catch Behavior

    Here you go. It's and execption from a DLL we have. Basically if some one has a drawing open it raises and exception. Within the IDE if I select continue it simply goes on to the next drawing....
  16. Replies
    18
    Views
    1,342

    Re: Try..Catch Behavior

    The issue is not what the exception is. The issue I am having is that when running in the IDE, when an exception is raised, I can select continue on the display catalog and the code continues...
  17. Replies
    18
    Views
    1,342

    Re: Try..Catch Behavior

    from above
  18. Replies
    18
    Views
    1,342

    Re: Try..Catch Behavior

    See OP.
  19. Replies
    18
    Views
    1,342

    Re: Try..Catch Behavior

    Ok fine...Inside the IDE it catches fine with out stepping (just having the IDE open). Outside the IDE it doesn't.
  20. Replies
    18
    Views
    1,342

    Re: Try..Catch Behavior

    Debug = Running within the IDE.

    Runtime = Using compiled exe.
  21. Replies
    18
    Views
    1,342

    Try..Catch Behavior

    I have the following code:


    Try
    sMsg = oDM.OpenDrawing(Label3.Text & DrawingListBox.GetItemText(SelectedListBox.Items(i)))
    ...
  22. Replies
    8
    Views
    8,176

    Re: Multiple column select in DataGridView

    Ok. The issue was that the second time around the SelectionMode was left at FullColumnSelect.

    So what I did is set the SelectionMode to CellSelect prior to assigning theDatsource. This did the...
  23. Replies
    8
    Views
    8,176

    Re: Multiple column select in DataGridView

    Ok. Here is the issue. It works the first time you fill the data grid. When FillDataGrid() is called the second time (to load a different table) thats when it barfs....
  24. Replies
    8
    Views
    8,176

    Re: Multiple column select in DataGridView

    I did exaclty as your sample. Still no joy. Here is the entire code for loading the DatGridView. Maybe you'll notice something.


    Dim connection As New...
  25. Replies
    8
    Views
    8,176

    Re: Multiple column select in DataGridView

    I keep getting the following error:

    Message="Column's SortMode cannot be set to Automatic while the DataGridView control's SelectionMode is set to FullColumnSelect."

    This is what led me to...
  26. Replies
    8
    Views
    8,176

    Multiple column select in DataGridView

    What I am trying to accomplish:

    Allow users to select multiple columns (CTRL + Click) so that they can hide them. (the hide will be done programatically of course)

    The problem: Can't find a...
  27. Re: Problem with OleDbCommandBuilder SQL it creates for updates

    I'd love to but my employers are too stupid to see that VB sucks and it's not a real programming language.
  28. Re: Problem with OleDbCommandBuilder SQL it creates for updates

    Putting brackets in the SELECT statement did not have any effect on the statemetn built by the CommandBuilder?????
  29. Re: Problem with OleDbCommandBuilder SQL it creates for updates

    Why not bump. This is common in all forums. Second I know all about proper field names but I did not create the database. I am left with it.



    I can't do that because each table is different.
    ...
  30. Re: Problem with OleDbCommandBuilder SQL it creates for updates

    Bump
  31. Problem with OleDbCommandBuilder SQL it creates for updates

    Database = MSAccess
    Field Name = 120 XXX

    Problem - The SQL statement generated by the builder does not enclose the field names in brackets. This then raises an exception with "error in update...
  32. Replies
    1
    Views
    463

    MSAccess "groups"

    I want to use the "groups" in the mdb like a subdirectory. Is there a way to properly reference this in a connection string or some other way to do it.
  33. Re: How to modify DataGridView column to ComboBox at runtime

    You don't get it. Never mind. This is typical of the whole VB stuff.

    I cannot bind at design because there isn't just one table. The user selects the table at runtime.
  34. Re: How to modify DataGridView column to ComboBox at runtime

    Let me see if I can explain. The DGV is set to a OleDbCommand at runtime. There are no fields or anyhing else to work with until after the DGV is bound. The field in the underlying MSAccess table is...
  35. Re: How to modify DataGridView column to ComboBox at runtime

    I was able to do it like this:


    With extractDataGrid
    Dim ColumnCB As New DataGridViewComboBoxColumn

    With ColumnCB
    .HeaderText =...
  36. How to modify DataGridView column to ComboBox at runtime

    I've been searching but can't quite find the answer.

    I have an unbound DataGridView. The datasource is set at runtime from a query.

    I want one of the columns to be a ComboBox. So I need to...
  37. Replies
    18
    Views
    712

    [RESOLVED] AlloZeroLength in ALTER SQL

    Figured it out
  38. Replies
    18
    Views
    712

    Re: AlloZeroLength in ALTER SQL

    Yep. FIgured it out. Tx.
  39. Replies
    18
    Views
    712

    Re: AllowZeroLength in ALTER SQL

    It chokes on the ZeroLentgh code. Works ok without that line.


    Dim tbl As Object
    tbl = New ADOX.Table
    Dim col As New ADOX.Column
    Dim cat As New ADOX.Catalog
    ...
  40. Replies
    18
    Views
    712

    Re: AlloZeroLength in ALTER SQL

    Adox
Results 1 to 40 of 86
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width