i'm writing a visual basic front end with ms access as the database. I'm using the OleDb type as the connection. All the other sql commands are working, but I'm having a problem with one.
I'm trying to update, using:
"update <table> set [column1] = [parameter1] where [column2] = [parameter2]"
it's just not doing anything. What is going on?
Thanks for any and all help.
eddyman592
Last Activity: Mar 31 '08, 03:59 PM
Joined: Apr 22 '07
Location:
-
Issues with update sql command on OleDb Database
-
Advanced Tab Controls
Ok, you know the My Project part of a vb project where you can go in and change your project settings? How does one go about creating tabs on the left like that?
Thanks -
PHP variable passing
I have a javascript applet I obtained that uses php as the back end to tell the files where to upload. It works great when the file paths are hard coded. The problem is is that they need to be variable because it's gonna be a different folder for every upload. The php page is never actually visited in the browser, but I need to pass a variable to it... how is this done? -
Reading from users computer
I know it is possible to read all the files from a folder on the server. Is it possible to do the same on the users computer? Say if they select a folder on their system, can you read in all the files from it. Say this is for a file upload. -
Ok, it worked and it didn't. I did exactly what your post said and it didn't work. The things aren't up in the menu. However, after finding out about that whole command line thing, I looked into and i can now rebuild through the command prompt. It's not perfect, but i'll take it for now. Thanks for your help. Any more ideas about actually getting the things in the menu though? -
I have built it a dozen times. I really need the rebuild option cause right now i'm having problems with the program not realizing i've changed some code. I can't really get anymore work done on this thing until I can rebuild it. please help!!Leave a comment:
-
i checked that...it is the solution, the .sln file.Leave a comment:
-
Ok, I checked. .sln is the file type that i'm opening, yet i only have the two options to build or publish. Any ideas?Leave a comment:
-
It is the professional version, not the express. I heard somthing about opening the solution instead of the project, but i'm not sure what thats means....Leave a comment:
-
Rebuild Solution
Ok, i'm not sure if this is the right place to ask this, and if it's not i'm sorry. I recently had to reformat my C drive, and i had to reinstall Visual Studio 2005. Before I reinstalled it, the build menu had all kinds of options like build, rebuild, clean and several more. Now all it has is build Project and Publish Project. How do I get rebuild and clean back?
Thanks. -
Question about rebuilding solution
Ok, i'm not sure if this is the right place to ask this, and if it's not i'm sorry. I recently had to reformat my C drive, and i had to reinstall Visual Studio 2005. Before I reinstalled it, the build menu had all kinds of options like build, rebuild, clean and several more. Now all it has is build Project and Publish Project. How do I get rebuild and clean back?
Thanks. -
Printing in VB
Hey, I have a document i need to print. it's not text, it's an image with some controls over it. I have no idea how to get it to print. A screenshot won't work because it needs to fit on a page.
Please help. Thanks. -
Generating PDF from Form
I have a form and I need to be able to convert it to a PDF.
By this I mean the form basically looks like what i need the PDF to look like.
How does one go about doing this? -
Figured it out. Before all the sql stuff starts, just add Me.refresh. That does it.Leave a comment:
-
Progress Bar for sql statements in VB
Ok, my problem is not how to do a progress bar.
Here is my problem:
I have a window that opens, and the on load function loads a 14x24 table with data retrieved from a sql server. The problem is is that the window isn't fully drawn until after the table is populated.
How do you force the window to be drawn so my progress bar can be seen? -
DateTimePicker in DataGridView Msdn2 example
Ok, I'm trying to make a column in my data grid be a DateTimePicker column.
I copied and pasted all the code from the msdn website. Now, the difference in my code and the microsoft code is that my datagrid is not in the startup form. Also, the form it's in is an MdiChild.
So I get errors when the form containing the datagrid is opened.
Next, when i go and take out the whole mdichild thing, the form with the datagrid... -
Dynamic Table
I'm new to VB, so I have no idea how to do this...
You know that table in the settings tab of the My Project panel in VB? You know how if you start typing in a row, i automatically makes a new row beneath it? How does one do that?
For those who don't know what I'm talking about, What I want to do is have the user type something in a row with multiple columns, and when they start typing, a new row appear beneath it so... -
oh. I'm using VB 2005, the newest one. And i've heard that they are pretty differentLeave a comment:
-
I'm trying to show the message in the form1.disposed event. Basically, what i'm trying to do is like the "There are unsaved documents, do you wish to save?" box that pops up when you try to close Microsoft word. Except the program just keeps on closing.
I don't see a function called QueryUnload in the function list of the form. Like I said, I'm quite new to this.Leave a comment:
-
Issue with disposed event of MDI Parent
I'm writing an application using an MDI Parent and 2 children. When the user closes the parent, I would like to have the program check something in one of the children, and then ask whether or not the user wishes to continue.
I have tried testing the Disposed event by having a MessageBox.Show show a window that simply said "Closing!", but when you close the parent, all you hear is the ding that a message box makes, but then...
No activity results to display
Leave a comment: