Search results for query: *

I wrote a VB.NET 2010 application that writes to a MS Access DB via an ODBC connection. This application is intended to take the place of the paper based Non Product PO system. The functionality in question works as follows: A user opens the program to a blank PO form. They can search for an...

This is how I ended up getting it to work Dim ds As New DataSet Dim o As Object o = ds.Tables.Item("mytable").Rows.Item(0).Item("PONumber") txtPONumber.Text = o

What I did was create a few text boxes that (when told to) will add a row of data to the datagridview. I defined several unbound columns and the data goes right in. The problem I have now is I want to use the same datagrid to display queries from the database. I wrote a simple select...

I'm trying to code a small application that basically manages non product PO's. In other words a front end to a access database that can create/edit/print/email...purchase orders. PO's essentially have some standard info on each such as a PO number, vendor name, date and so forth. They will...

I figured it out. It turns out I was using MS VB PowerPacks 1.2 in my app. I think I added a PrintScreen function that is part of the PowerPack. I’m guessing this occurred in-between trial runs on different systems. I added PowerPacks 1.2 as a PreReq in the publisher and it works. I...

I developed an application in VB.NET 2008 express that connects to a MS Access DB over the network. Throughout the process I tested this app on other computers to make sure that it would work. Everything was fine until today. When I copy the debug folder with the exe and all (as I...

I figured it out. If you set the DB fields to dates you need to insert a NULL if you want to leave them blank. So what I did was put a few if statements before the db insert to test for an empty text box. If it is empty if made the text box text = to NULL.

Hey thanks for the info. The #date# solved one of my problems. I still have the issue that the database is treating my date feilds as required even though they are not. If I turn all feilds to text I can insert empty rows. If I make one ore more a date it will not let me insert a row unless...

I am using VB.NET 2008 Express edition with a connection to MS Access 2007 saved as an .mdb not .accdb. If I set the database to create the primary key and all the fields are text there is no issue. However if I set several fields as a simple date mm/dd/yyyy i run into problems. When I...

I’m not sure what I am doing wrong. I tried your code but I think I used it incorrectly because I just got a ton of pages with the same stuff. So essentially what I have is a list box that can have any number of items in it. When the user clicks print I get a count of the number of items and...

Ok I have a dynamically allocated “For loop” that will print something to the screen and increment and continue to print until all the stuff in the list box is printed. I know how many items I can fit on a page (about 13). What I need to do is have the loop go through 13 times then set...

I added my database and all the pictures are resources to the project. When I publish the project it includes all the files. However when I run the application and it tries to access the database it says it cannot be found. I used + Application.StartupPath + and it works but the database it...

Cool If I use that connection string and place my database in the bin folder that seems to work. With the pictures I created a sub folder in the bin folder called images and put my images there. However in the access database I used this format .\images\image.jpg (I need the “.” First). That...

I was wondering how you can set a relative DB location in vb 2005. Right now I have an exact location of MyCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\UNH\CS 623\projects\ASAP.mdb" I would like to be able to trasport this aplication to other computers...

I'm new to VB.NET and I think I screwed something up. As of yesterday any changes I made to my forms displayed when I ran the project. However today if I add a text box or move a button (save) and run the form it is as if I am viewing what I did yesterday. I closed the application and the...

I have a textbox on my form that is initialized to a value on load. The string is declared globally. I also have a public procedure that is an event timer. When the event timer is fired I want to set that text box value to something different. However when the timer event fires I get an...

I have been playing around with Access connections using ado.net. I have successfully made a connection and passed info from the database to a form. Recently I started using modules which I have the form call. I am able to pass string variables back but I ‘m a little confused what to pass...

...As System.Object, ByVal e As System.EventArgs) Handles btnConnect.Click Dim sqlString As SqlTypes.SqlString sqlString = "SELECT * FROM user;" Dim MyCon As OleDb.OleDbConnection MyCon = New OleDbConnection() MyCon.ConnectionString =...

...= txtX2.Text sngY1 = txtY1.Text sngX1 = txtX1.Text 'objPicBox = Me.PictureBox1 strEANCode = Me.txtEAN.Text '* '* Convert the code on its binary representation '* strEANBin = EAN2Bin(strEANCode) '* '* Define the...

This is the code from the module that prints to the picturebox '* '* Draw the BarCode '* For K = 1 To Len(strEANBin) If Mid(strEANBin, K, 1) = "1" Then objPicBox.CreateGraphics.FillRectangle(New...