Search:

Type: Posts; User: jazFunk

Page 1 of 11 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    0
    Views
    1,309

    Connect with Local Developers

    Are there any software developers and/or database architects/administrators in this group, currently living or working in the Clearwater/Tampa area?

    I'm looking to connect with local developers.
  2. Google Sheets Script, copy row to new sheets, modify specific cells in one of them

    I'm less familiar with javascript than VB.Net struggling with the basics.

    In this script, I'm copying a row of data to two other sheets, based upon the selection of combo box, and always a copy...
  3. Re: Split MS Access Database (MDB), Runtime for Users

    No, sir. I'm talking about deploying the database, not a VB.Net app. From the little I understand, you can set it up where the user doesn't see the ribbon, or the object list. I've read about it,...
  4. Re: Split MS Access Database (MDB), Runtime for Users

    I get all of this, very well. My question is not about writing an app to use as the front-end, but rather, using the front end mdb of the split database, and my users not needing access installed to...
  5. Re: Split MS Access Database (MDB), Runtime for Users

    Just to be clear, you're stating that I can give a copy of the Front-End .mdb file to any Windows user and they can use it without having to install Access?
  6. Split MS Access Database (MDB), Runtime for Users

    I have a split Access Database, which I've created in Access 2016, but saved it as version 2002, with an .mdb file extension. I'm still in the early phases of the development for this database, so...
  7. Re: [RESOLVED] Error when removing some columns from a datatable

    Wow! What is this wizardry? Watching this YouTube video about it now, but, I've never heard of this, nor anything like it. Doesn't IntelliSense do what this does, at least as far as what I've...
  8. VS 2010 Re: [RESOLVED] Fill two DataTables with one DataReader

    Edit to the OP, in case anyone would ever use this post in the future. There was an error in the DataBindings code where I referred to the same control twice. I must be more careful when copying...
  9. VS 2010 Re: Fill two DataTables with one DataReader

    I definitely didn't confirm that DataTable had rows, and should have. Using your suggestion solved my problems. I also changed the reader code. Thank you!
  10. VS 2010 [RESOLVED] Fill two DataTables with one DataReader

    I'm displaying related data using DataBinding. Each record has two fields that relate to the same table/field. I created two DataTables, filled with one DataReader. When I bind the controls, I get...
  11. Re: Access reports that databases are in an 'inconsistent state'

    Just informing anyone who is attempting to help that we have users who are accessing the database via that method, as well.

    So far, I think I've learned that I'm going to need to split my...
  12. Re: Access reports that databases are in an 'inconsistent state'

    No, sir. The database resides on the server. Each user has Access installed on their computer and opens the same database from the same network location. RDP users, who also have Access installed,...
  13. Re: Access reports that databases are in an 'inconsistent state'

    Posted twice, not sure how.
  14. Re: Access reports that databases are in an 'inconsistent state'

    I'll make this easier and post the part I'm concerned with:

    STATUS: WORKAROUND

    The engineering team is aware of and working to fix this issue. In the meantime, disable the leasing on the file...
  15. Access reports that databases are in an 'inconsistent state'

    All of a sudden we keep getting this 'inconsistent state' error when opening our database. Access does it's thing, makes a backup, and repairs the database.

    So far, it always seems to repair...
  16. Re: MS Access 2016 Report "WhereCondition" not being applied

    Appreciate the input, as always. Wish it was that simple. That kind of error still gets me occasionally, to this day.
  17. Re: MS Access 2016 Report "WhereCondition" not being applied

    Deleted Text
  18. Re: MS Access 2016 Report "WhereCondition" not being applied

    I see. But the value for ShipperID in the database is an integer. I've also tried converting the combobox value to an integer, but still nothing gets applied.

    I've found this link which states...
  19. Re: MS Access 2016 Report "WhereCondition" not being applied

    Is this link to suggest that I should use OpenArgs or to show me proper formatting syntax? I'm not currently using OpenArgs and do not completely understand them. Although, I could easily search on...
  20. MS Access 2016 Report "WhereCondition" not being applied

    I have the following code, yet, the report is never filtered; I get all records in the database. While I've tried various syntax options, nothing seems to work. This leads me to believe I'm looking...
  21. Re: Table has two different fields, related to the same table

    Indeed, it did. Outstanding and simple. I actually get it. Haha. Thank you very much!
  22. Re: Table has two different fields, related to the same table

    So, if I'm applying my object names to your SQL, tell me if this looks correct..?

    SELECT tblStationStatus.*, Legend.lot, Legend.drum, Covered.lot, Covered.drum, ...

    FROM (tblStationStatus...
  23. Re: Table has two different fields, related to the same table

    Yes, that is seemingly a perfect analogy. Here's a screenshot of each table, the highlighted fields from the table on the left both correspond to a record in the table on the right. I'll give your...
  24. [RESOLVED] Table has two different fields, related to the same table

    This is an MS Access database

    I know, the title is vague as I'm really struggling with how to word this question.. Here goes..

    I have a table with two fields, pointing to different records, in...
  25. VS 2010 Re: DataGridView SelectionChanged Event when Current Row Index = 0

    Done. Thought I had already. Thanks for the reminder.
  26. VS 2010 Re: DataGridView SelectionChanged Event when Current Row Index = 0

    I'm an idiot. Problem solved. I'm literally telling the code to not include RowIndex 0. With this line:

    If itemFound > 0 Then
  27. VS 2010 [RESOLVED] DataGridView SelectionChanged Event when Current Row Index = 0

    The DataGridView.SelectionChanged event is not firing when the current DataGridView.RowIndex = 0.

    This is the code in the event... It selects a matching record in a different DataGridView which...
  28. VS 2015 Re: Sending an email for a bug report feature [LOOKING FOR ALTERNATIVE SOLUTION]

    I'm having virtually the exact problem. Would love to solve it. I'm researching Web Services now, but I'm not familiar with this at all. I have a site to run the service on, just need to know...
  29. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    Yes, even when those two values match, and the selected row is also a checked row, the update does not apply. Clearly, it's related to the SelectionChanged event firing at the wrong time.
  30. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    Eureka!! I took out the filtering from the SelectionChanged Event and put it in a button to test manually. It is updating properly. Now I just need to figure out where to put the filtering so this...
  31. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    The checkbox column is added manually when I create the DataTable via code.

    I'm already using EndEdit on the BindingSource, but, I tried to reset the filter right after, like you had, but I yield...
  32. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    Yes, the ApplyUpdate() Method gets called for each row where the checkbox column is true, or "checked".

    I've done a lot of breakpoint testing and "If CType(row.Cells.Item(3).Value, Integer) = i"...
  33. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    Screenshot #1 shows that the first row is Selected/Highlighted in DataGridView2, with rows 2 and 3 "Checked" (CheckBox Column). Important to note that it is a non-checked row that is the currently...
  34. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    I don't think so... key word is "think".

    i just made a post with a little further clarification.
  35. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    Yep, I have set breakpoints and checked out values to attempt to see where the problem is. It didn't provide any insight to the problem, so far. I'm not really concerned whether the current row is...
  36. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    A button click event .
  37. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    Excuse my lack of proofreading . I'm replying on my phone while at the Dr office.
  38. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    I am building an interface to do single and batch updating of complicated tables relations.

    I'm fine with simple updating and have no problems. But in order to work with existing infrastructure,...
  39. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    VB6?? I'm using VB.Net

    Here's my loop:


    For Each row As DataGridViewRow In Me.DataGridView2.Rows
    If CType(row.Cells.Item(6).Value, Boolean) Then
    ' Current...
  40. VS 2010 Re: Loop rows and update fields of one DataGridView to Update another DataGridView

    DataGridView2 is populated with this code, with a DataView that represents filtered records of the main DataTable:


    Private Sub BindDTControls(ByVal ssDV As DataView)


    ' Clear DataBindings...
Results 1 to 40 of 409
Page 1 of 11 1 2 3 4



Click Here to Expand Forum to Full Width