Search:

Type: Posts; User: Mark@SF

Page 1 of 11 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    0
    Views
    479

    VS 2019 ReportViewer and Microsoft PDF printing

    I'm having trouble with margins when using the "Microsoft Print to PDF" printer to create a PDF document via the Microsoft ReportViewer.

    Even though I am setting the margins for my reports (see...
  2. Re: RC6 - New encrypt option for Sqlite DB: SqlCipher

    @schmidt -

    I've converted several of my older MS Access database applications to SQLite. These applications have all used un-encrypted MS Access databases. I'm also using VS Community 2019...
  3. Replies
    4
    Views
    366

    VS 2019 Re: Cast to DataTable

    @paul -

    Thank you for your help with my question, including the extension method.

    Yes, I know that the indexDetails has the schema details. I was looking for how to work with columnsIWant data...
  4. Replies
    8
    Views
    664

    VS 2019 Re: Need help converting VBA to VB.Net

    @ChrisE -

    Thank you for following up with a DAO solution. I really appreciate your help!

    I see in your solution that Option Strict must be Off for it to work and with this compiler directive,...
  5. Replies
    4
    Views
    366

    VS 2019 Cast to DataTable

    I came across this code example and would like use it, but need to get the result into a DataTable.


    Dim restrictions() As String = {Nothing, Nothing, Nothing, Nothing, tdf.Name}
    Dim...
  6. Replies
    8
    Views
    664

    VS 2019 Re: Need help converting VBA to VB.Net

    @ChrisE -

    Thank you. Your suggestion works.

    Since my question was for how to use DAO to get the fields of an index, I'm going to leave this thread open to see if there's solution for the...
  7. Replies
    8
    Views
    664

    VS 2019 Re: Need help converting VBA to VB.Net

    @paul -

    Thank you for your help.

    When I tried your suggestion, Intellisense shows the following error:

    Error BC30002 Type 'TableDef.Fields' is not defined.


    For Each idx As Index In...
  8. Replies
    8
    Views
    664

    VS 2019 Re: Need help converting VBA to VB.Net

    @wes4dbt -

    Thanks for taking a look at this with me.

    I'm declaring idx as a Microsoft.Office.Interop.Access.Dao.Index object. Here's the explicit declaration in my For...Next loop.



    For...
  9. Replies
    8
    Views
    664

    VS 2019 Need help converting VBA to VB.Net

    I need some help to convert some VBA code to VB.Net code.

    Here is the VBA code...



    Function DescribeIndexField(tdf As DAO.TableDef, strField As String) As String
    'Purpose: Indicate if the...
  10. Replies
    4
    Views
    531

    Re: SQLite database and password protection?

    jmc -

    Thanks for weighing in on this topic.

    I installed the package you referred to and now when the SQLiteConnection.SetPassword is called, the following error is raised.


    Date: 8/22/2021...
  11. Replies
    4
    Views
    531

    SQLite database and password protection?

    Is is possible to encrypt (password protect) an SQLite database? If so, can someone please point me in the right direction?

    I have installed the "System.Data.SQLite.Core" NuGet package...
  12. Replies
    3
    Views
    372

    VS 2019 Re: Need help deleting a record

    @OptionBase1 -

    Thanks, that fixed it.

    This is my first foray into SQLite. I have been using MS Access as a back-end database on all my other projects. With MS Access, the following code has...
  13. Replies
    3
    Views
    372

    VS 2019 [RESOLVED] Need help deleting a record

    I cannot figure out why my code is failing when I attempt to delete a row. Here's the code:


    If dsMain.Tables("Fuel").GetChanges IsNot Nothing Then
    iAdd =...
  14. VS 2019 Re: [RESOLVED] Upgrading Framework 4.8 to 5.0 -- x64 or x86 version?

    @Liwis -

    Do you know if MS has published a "FAQ" or tip sheet for end-users that discusses how to go about the upgrade process?

    Thanks for your input!
  15. Replies
    6
    Views
    567

    Re: MS Access Database Engine 2010 problem

    Another related question...if this problem is something that I cannot control, then should I consider migrating away from MS Access for my back-end database and instead transition my applications to...
  16. Replies
    6
    Views
    567

    MS Access Database Engine 2010 problem

    I have developed a few applications over the years that I use frequently. These applications use MS Access as the back-end database and the MS Access Database Engine 2020.

    Beginning sometime in...
  17. VS 2019 Re: [RESOLVED] Upgrading Framework 4.8 to 5.0 -- x64 or x86 version?

    @peter -



    Yes sir...

    Thanks for your input!
  18. VS 2019 Re: Upgrading Framework 4.8 to 5.0 -- x64 or x86 version?

    @Shaggy -

    Thanks!
  19. VS 2019 Re: Upgrading Framework 4.8 to 5.0 -- x64 or x86 version?

    I can see where I'm getting confused. The link in my post #3 shows .Net 5.0 and Framework 4.8. I don't think there is a more recent version of the Framework other than v4.8.
  20. VS 2019 Re: Upgrading Framework 4.8 to 5.0 -- x64 or x86 version?

    @Shaggy -



    Do you mean the 64-bit version of the Framework?

    https://dotnet.microsoft.com/download
  21. VS 2019 [RESOLVED] Upgrading Framework 4.8 to 5.0 -- x64 or x86 version?

    I would like to upgrade from the Framework 4.8 to 5.0 and would like to know how to find out which platform I should download (32-bit or 64-bit).

    I have a Windows 10 Pro O/S (64-bit). I am...
  22. Replies
    8
    Views
    511

    VS 2019 Re: Excel chart line weight format error

    @frabuator -

    Is your "chartPage" an embedded chart in a WorkSheet or is in its own ChartSheet (my chart is in a ChartSheet).

    Are you using early or late binding (I am using early binding)?
  23. Replies
    8
    Views
    511

    VS 2019 Re: Excel chart line weight format error

    @frabulator -

    I am using Excel 2019.

    Here is the result from the Excel Macro Recorder.


    ActiveChart.FullSeriesCollection(1).Select
    ActiveChart.PlotArea.Select
    With Selection.Format.Line
  24. Replies
    8
    Views
    511

    VS 2019 Re: Excel chart line weight format error

    @frabulator -

    Yes, single stepping through the code shows that it is just the highlighted line that raises the error.

    When I comment out the highlighted line, then the code runs without any...
  25. Replies
    8
    Views
    511

    VS 2019 Excel chart line weight format error

    I am trying to set the line weight in an Excel chart. Here is my code.


    With CType(xlsApp.ActiveChart.SeriesCollection(1), Excel.Series)
    .Border.Weight = Excel.XlBorderWeight.xlThin
    ...
  26. VS 2019 Re: DataGridView DataError with DataGridViewComboBox

    @jmc -

    Thank you for your response. I'll try to address your suggestions below.



    I generally try to avoid using the designer for multi-step configuration of controls. I think it is easier...
  27. VS 2019 Re: DataGridView DataError with DataGridViewComboBox

    @frabulator -

    Thanks for your help with this issue.

    I don't think unbind/bind the DataSource will be useful to debug this issue. That is essentially explicitly doing what is happening...
  28. VS 2019 Re: DataGridView DataError with DataGridViewComboBox

    @wes4dbt -

    Yes, the code for doing that is in post #2.


    i = daProviders.Update(dsMain.Tables("Providers"))

    I'm really stumped about this :(
  29. VS 2019 Re: DataGridView DataError with DataGridViewComboBox

    I noticed that after adding a new Provider, the DataSource property of the DataGridViewComboBoxColumn for the dgvFuel DataGridView has been changed to Nothing and the ValueMember has been changed to...
  30. VS 2019 DataGridView DataError with DataGridViewComboBox

    I need some help to understand why my application is raising DataError errors for a DataGridViewComboBoxColumn of a DataGridView. The error does not always occur, it seems to only happen in a...
  31. Re: SQLite date field as String to DateTime in DataGridView TextBox

    zvoni -

    Thanks for your help with this question.

    I am storing dates as ISO 8601 formatted strings so that they are more human-readable. I realized that for the date field in question, I didn't...
  32. Re: SQLite date field as String to DateTime in DataGridView TextBox

    zvoni -



    Not sure that I understand how to do this. For example, this Select query returns a String data type as the RecDate.


    Dim selectData As New SQLite.SQLiteCommand("SELECT AddDate,...
  33. [RESOLVED] SQLite date field as String to DateTime in DataGridView TextBox

    I have a SQLite database and I store dates as ISO 8601 formatted strings ("yyyy-MM-dd HH:mm:ss").

    I have bound one of the tables from this database to a DataGridView control (dgvFuel) using a...
  34. Re: Converting application from MS Access to SQLite database

    Olaf, et.al. -

    Thank you (everyone) for your help and suggestions. I have gotten the SQLiteDataAdapter.Update method to work. I can now claim to have “crossed the Rubicon” from MS Access to...
  35. Re: Converting application from MS Access to SQLite database

    Here's how I think I should create a DataAdapter.


    Sub InitializeCategoriesDataAdapter()

    'https://support.microsoft.com/en-us/kb/320435

    '...SQLite database table "Categories" field...
  36. Re: Converting application from MS Access to SQLite database

    Olaf -

    Thanks for all you're trying to help me with. I think maybe I'm missing something more fundamental here.



    The reference to PeterST's post #21 seems to indicate that the way forward...
  37. Re: Converting application from MS Access to SQLite database

    Here is something from Microsoft.

    https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqldataadapter.updatecommand?view=dotnet-plat-ext-5.0


    // Create the UpdateCommand.
    ...
  38. Re: Converting application from MS Access to SQLite database

    Olaf -

    You wrote...



    As you can see from my posts in this thread, I'm on the learning curve here and have a lot to learn. Is there an example or link you can share with me that might help...
  39. Re: Converting application from MS Access to SQLite database

    Here is a working example for how to use a SQLiteCommand object and ExecuteNonQuery method to update a single record in the SQLite database.


    Dim strSQL As String = String.Empty
    Dim format As...
  40. Re: Converting application from MS Access to SQLite database

    peterst -

    Thanks for jumping into this discussion. You wrote...



    In post #4 of this thread, I show that I am using parameters. and also that I am formatting the dates in ISO format (as was...
Results 1 to 40 of 420
Page 1 of 11 1 2 3 4



Click Here to Expand Forum to Full Width