Search results

  1. 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...
  2. 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...
  3. 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.
  4. 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 =...
  5. 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...
  6. 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 =...
  7. 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...
  8. 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...
  9. 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...
  10. O

    How do I share a variable between forms?

    I have a variable called intAccount. In one form, frmTrans, the intAccount is assigned its value based on a text book. A qry is run to see if that value is in a database, and if not, I show a new form, frmPatientEntry, without closeing the other form. I want to be able to fill in the value...
  11. O

    Problem with simple query

    For some reason, this query isn't returning any records: sql = "Select * from tblTrans where tblTrans.DOS BETWEEN " & dtpStart.Value.ToShortDateString & " AND " & dtpEnd.Value.ToShortDateString The tblTrans has a field called DOS. That field is updated in another part of the application using...
  12. O

    Problems with spacing in RichTextBox

    Hey everyone, I've got a question. I have a form that has a RichTextBox on it. In that RTB, I populate it with a query. However, what I am wanting to do is make equal spacing between each field returned, so that everything lines up. I'm not real sure how to fix it. I tried equaling out the...
  13. O


    Can someone take a look at this code for me and tell me how to correct it? I found this example on a website for priting text out of a RichTextBox, however, at the very end, the webpage's example didn't have the condition setup right to check and see if there is another page. The webpage I got...
  14. O

    How can I write a simple report?

    I have Visual Basic Express 2005, and need to write a simple report. I am using an Access database. I've been searching on the net trying to find a tutorial that walks me through using the built in PrintPreviewDialog and PrintDocument controls to just print out a table, but can't find anything...
  15. O

    Bind DataGrid to textbox

    Hey everyone. I'm working on an application that uses an Access database. On one of my forms, I am wanting to set up a textbox to where when the user enters in a charge number, that the datagrid below it will highlight the matching record. The textbox that I am using is named txtCharge. The...
  16. O

    Free Report Writer for VS Express?

    Is there a free report writer that can be used with VS Basic 2005 Express?
  17. O

    Connecting to an access database

    Hello. I have an access database named profees.mdb. Inside of it is a table named tblInsurance. However, whenever I tried to fill the dataset in my code, I get an error saying, "The Microsoft Jet database engine cannot find the input table or query 'tblInsurance'. Make sure it exists and...
  18. O

    Rookie needing some help

    Hey everyone. I'm very new to the world of programming. I just finished up a course on VB.NET (Intro course), but we never worked with databases during that course. So, that leads up to this problem I'm having. I'm trying to write an application for my work using VB Express, and working with...
Top Bottom