Search results

  1. O

    DatagridVIEW - set background for individual rows

    Okay, I got it figured out - use the CellFormatting event: If Me.dgvOpen.Columns(e.ColumnIndex).Name _ = "TicketPriority" Then If e.Value IsNot Nothing Then ' Check for the string "Critical" in the cell. Dim stringValue As String = _...
  2. O

    DatagridVIEW - set background for individual rows

    I have a DataGridView on one of my forms. I populate the contents of that DGV with the following code: con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = maintenance.mdb" con.Open() sql = "Select ID AS TicketNumber, shortDesc AS TicketDescription, techName...
  3. O

    Report SharpShooter Express

    Thanks for the replies. I'll give those a shot and see how it works. Again, thanks for your time on this.
  4. O

    Report SharpShooter Express

    Also, it has me set the RenderCompleted even for the inlineReportSlot1 with the following C# code: using (perpetuumSoft.Reporting.View.PreviewForm previewForm = new PerpetuumSoft.Reporting.View.PreviewForm(inlineReportSlot1)) { previewForm.WindowState = FormWindowState.Maximized...
  5. O

    Report SharpShooter Express

    Hopefully this is the correct forum. I am trying to use Perpetuumsoft's ShartShooter Express with VB.NET Express to create reports. However, I'm running into a problem. Their website's walk through has me create a Preview button on a form. It says to set the click even to: if...
  6. O

    good-looking Ui

    I've learned a tremendous amount of information on developing applications, but I still have a lot to learn about designed good/professional looking user interfaces. Is there a website anyone can provide that gives help on making the "look" of the forms more user friendly? Thanks.
  7. O

    Display two fields in combobox

    Thanks again. This forum is awesome. I really do appreciate all of the help I've gotten from you guys.
  8. O

    Display two fields in combobox

    Hmmmm...just tried it and got: Syntax error (missing operator) in query expression 'FirstName + N' ' + LastName'.
  9. O

    Display two fields in combobox

    Awesome. That's the information I was needing. I appreciate it man!
  10. O

    Display two fields in combobox

    Hey everyone. I have a combox that I want to display two fields in. For instance, I have the following: con.Open() sql = "Select * From Tech" da = New OleDb.OleDbDataAdapter(sql, con) da.Fill(ds, "Tech") con.Close() cboTech.DataSource =...
  11. O

    Have datagrid update after 60 seconds

    Hey everyone. I have a form that has a datagrid on it. I want it to, however, refresh the data in the datagrid after 60 seconds. I'm not sure how to do that though. I'm setting up the data in the grid like this: If ds.Tables("Problem").Rows.Count > 0 Then With dgvOpen...
  12. O

    Syntax error in INSERT INTO statement - am I using a reserved word?

    Hey everyone. I'm having problems with this form. I'm gettin Syntax error in INSERT INTO statement. Last time I had this problem was because of a reserved word I was using. Can someone take a look at this code and let me know if that's the case as well? con.Open() sql =...
  13. O

    Syntax error in INSERT INTO statement.

    I figured out the problem. I was using reserved words for my field names.
  14. O

    Syntax error in INSERT INTO statement.

    I cannot figure where I'm messing up at on this one. I'm not sure why I'm running into this error. The code is bugging out at: da.Update(ds, "Employee")That table only has 3 fields, and ID field (which is autonumber), First (character) and Last (character). Here is my code. Can someone...
  15. O

    Help with editing a selecting row in datagrid

    What would I declare the dsEditRows as? If I declare it as DataRow, then on: dsEditRows = ds3.Tables("Changes").Select("ID = " & txtTransID.Text) I get: Value of type '1-dimensional arry of System.Data.DataRow' cannot be converted to 'System.Data.DataRow'.
  16. O

    Help with editing a selecting row in datagrid

    I'm not familiar with how that works to be honest. I'm still very much in a learning phase. I did a google search to see what I could find to explain how the "key" works, but really didn't come up with anything. Can you break down the code for me on that a bit more? I'm going to continue...
  17. O

    Help with editing a selecting row in datagrid

    Hey everyone. I'm trying to get this form setup to where a user can edit a selected row in a datagrid. I have it setup where the user can double click on the row, and it populates the information for them to edit, but it is adding a new row. I'm not sure how to get it to just edit the...
  18. O

    Permissions error

    That worked perfectly!! Thank you! Thank you!
  19. O

    Permissions error

    I'm using an Access DB for my app. It runs fine locally, but if I upload it to one of the network drives, I run into an error. I'm not sure how to even begin to approach fixing this. When first running the exe off of the network drive, I get this following warning: "Microsoft .NET Security...
  20. O

    How do I share a variable between forms?

    I figured it out. :o) I had it setup as a Shared variable, but in the new form, when I assigned the value, I needed to say: txtAccount.text = frmTrans.intAccount So, it's working. Yah! lol
Top Bottom