GhostWolf

cmd = "select sum(StockQuantity) as Qty from inventory where MedicineName='" & selectionVariable & "'" open recordset with cmd with recordset txtField.text = CStr(!Qty) .close end with

The add-on card is the trick that solved that problem for me. Looks like your MB has a PCIe x16 slot, which is pretty much what you'll need for video cards these days, (PCI cards are getting harder to find).

This looks like a viable solution to your problem: [Click Here](http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/156548/linking-two-combo-boxes)

I've never used FreeFile but, if I understand it correctly, it's supposed to return the number of the next file available for FileOpen. You might try using FileSystemObject.FileExists(strEmpFileName).

I'm assuming that you're using Excel 2003. If so, you might check the size of your workbook against the size limits at [Click Here](http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx) That would be my first suspicion for the slow-down, but I'm lost on the "saving twice" problem.

Although I've never opened a recordset they way you're doing, I do see a problem in your Select statement: there's no white-space between LIKE and the opening delimiter, (i.e. LIKE' instead of LIKE ').

A programmatic solution to this would be handy; my desire is to have the background image change periodically. Using VS2010, I've tried Me.BackgroundImage = System.Drawing.Image.FromFile("[filename]") but all I get is a FileNotFoundException, even though I've added the file to the project.

I'm trying to learn, and have run into a little difficulty. Trying to add a class to my program, passing a structure as the parameter to the class, and get "The best overload method match...has some invalid arguments" error message - and I just plain don't understand it! // in …

I've created my first WPF form, and the ImageBrush XAML is giving me trouble. The XAML I have is: <Grid.BackGround> <ImageBrush ImageSource="ImageFile.png" TileMode="Tile" /> </Grid.Background> It displays the correct image - but it's stretched instead of tiled! The image is 127x127; the window is 660x808; a single instance of the …

I'm new at looking at this kind of stuff, but could it be that you're missing *})* after line 14?

Do you need to .ToString() the User fields? Does the database you're writing to accept single-quote delimiters for dates?

I'm brand-new to C#. Among the samples I've seen is the use of the @ symbol in front of quoted text. What's its purpose? For my first program, I wrote one that opens Excel workbooks for retrieval and update. In the on-line samples I found, that symbol preceded the filename …

> cant i just get user-id from cart. than look at id from user table and see the username? Yep, that's exactly how a foreign key is used! "Foreign key" is just a fancy way of saying it, that's all.

I may be old-school, but I like global variables for things like this. I think what I'd do is something like: [frm1] gblVar = "" [frm2] @ KeyPress event: gblVar &= e.keychar then, when frm2.close txtFld.text = gblVar

How are you building the string before submitting it as the parameter value?

Howdy, folks. Yeah, I'm new here - but the back-side of my ears dried out a long time ago! I work for the local Board of Elections as a programmer/analyst full-time, (with a little contract work on the side), using RPG, COBOL and VB. Don't know a whole heckuva lot …