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...

All I am trying to do here is make a connection to an access database to retrieve a few records and populate a list box. Below you will see the code I am using. When I run the program and hit connect it says the connection is still open and cannot be closed. Then it jumps to this statement...

I'm new to VB.NET and I'm not the best programmer so please don’t be too hard on me. The following is the code which is declared in the Public Class. Private Sub PrintMe_PrintPage is basically what is called when I want to print something in VB.NET. What I would like to do is move this code to...

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...