Search:

Did some research on this error and came across with this little article. Thread solved on my behalf. :)


The unbelievably cryptic Operation Must Use An Updateable Query error is the bane of...

Hi!

Reporting back the "ex.Message" : Operation must use an updateable query.

Weird that it doesn't give that message when I run the program directly from my local computer.

Good point!

I'll do just that.

Ok, I misunderstood you. Design time = with wizard and dynamically=programmatically. Yes, I have studied these tutorials already.
Unfortunately these tutorials didn't answer my question that I...

What is the difference between them?

Let's say I want to add tables etc. at design time...

Sorry, I am still learning the secrets of databases and vb.

I have a fairly simple question (I guess): If I have one project that connects to only one database(Access) with one table, but in my project I have 3 forms. One for displaying and filtering...

Ok, I try to clarify things a little bit. I have one computer where my program is installed. The database that is used by my program is in the same directory as my program.

Then I shared this...

Hi!

I have made a program that is able to filter, edit, add and delete rows to a database. On my local computer all works fine. But when I share the folder and open the program in another computer...

Few fields are numeric fields so it gives me an error: Conversion from string "" to type Double is not valid.

Hi!

I have a code that saves data to access database. But I can't figure out how to make it work when a field is left blank.


MainForm.RihmatabelTableAdapter.Insert(Me.ComboProfiil.Text,...

Hi again!

Did some rethinking and came up with this solution:


Private Sub RihmatabelDataGridView_CellMouseDown(ByVal sender As Object, ByVal e As...

Hi!

I am struggling with this question: How should I set up a database in my project when I want to connect it to multiple forms.

Do I have to set up a new dataadapter, dataset,...

This is when the cell is leftclicked(notice that the little arrow is on the same line as the highlighted row).

96369

Now the right click. As you see the cell that I clicked highlights the row,...

I have tried with different selection modes. They select the row but the arrow on the rowheader remains its position(when I use right click).
With left click the arrow on row header comes along.

Hi!

On my Form there is a DataGridView that has a ContextMenuStrip bound to.
ContextMenuStrip has one button "Delete".

When I Right click on DataGridView then it displays the ContextMenuStrip,...

I found a solution to my first question. Missing data was caused by the order of my IF statements inside the code. I changed the order as I was coding and that messed around with the data that was...

Thank you, it did it. Something new to learn.

Another quick question. How can I modify this code to close database connection and does it refresh the data(in the gridview) when the code has...

Yes, I know it isn't very good explanation. Been coding for....20 hours in a row - can't understand even my own thoughts.

I am starting to think that there is something wrong with my sql...

Hi!

I have a code that uses SQL query to filter data in gridview. Using MS Access 2003 database. The query is running fine and filters data well. But sometimes when I execute the code one row goes...

Answer to my own question is that when I changed the setting name from ForgardenUser to User then it started to work. Go figure!

Flaming hell...that was a braincracker...

I tried all the tricks and tips I could get my hands on...

Ended up with only one solution(that works):


Private Sub...

In a new browser? Does it have to be users default browser?

In this case the easiest way to navigate the user's default Internet browser to a specified URL is to call...

For example:

http://www.youtube.com/watch?v=VmacM9QPqp8

For example:

http://www.youtube.com/watch?v=VmacM9QPqp8

It still gives the error like in the first post.

How could I write a code that fills the fields and clicks login button with HttpWebRequest POST Method? Never used it, maybe it'll work?

Hi!

Here is my code that should fill in "user" and "password" fields on a webpage ("http://forgarden.ee/tellimus") and then click the button "submit" in webbrowser. But it doesn't work!
It gives...

I mean that if I am using textboxes in my VB program (one is Amount1 and the other Amount2) and I am trying to make a query that will filter all numbers between Amount1 and Amount2.

WHERE Bedrooms...

Thanks dunfiddlin!

It works now! But when I leave the fields blank and execute the code it will give me an error.
Also when I try to use numbers like 3,5 and 4.5 It gives me an error.....

What...

Solved my previous question like so:

Dim County, SQLString As String
Dim Bedrooms As String
Dim NonSmoking as string
Dim dtProperties As New DataTable()
...

Thanks!
Way too advanced for me to understand using parameters. :(


But what if I use SQL LIKE operator?

For example:

County = lstCounties.Text
Bedrooms = lstCounties.Text

Thank you Ian, helped me alot understanding SQL basics!

Yes, I meant optional parameters. So it will filter the data even if some of the so called search fields are left empty. And even then if...

Thank you! Good advice!

How should I write the syntax when I have 3 criterias. So it would work if all 3 fields are filled and also when some of them are leaved blank.

County = lstCounties.Text...

I have a database "holiday.mdb" and there is a table "Properties" that contains columns "County" , "Bedrooms".
The following code shows how to filter data by one criteria( by the county OR by the...

Hi again!

New problem has come up. I have 2 tables that are related to each other: Client table and Product table. They are related to each other with Client ID.
I have designed my application to...

Thanks alot!

I think your advice has pointed me to the right direction. I'll start testing and if some further questions come up I'll post them here.
Cheers!

Hello!

I am developing an application for my employer. I am not a programmer but I do it as a hobby.
The story is as follows: we have a store that sells lawn tractors and riders. Every lawn...

Used 4x2y code: works fine on both platforms (win XP and win 7).
Thank you all for helping.

Hello!

Here is a code that shows my local (LAN) IP in a textbox.

'To get local IP address
Dim h As System.Net.IPHostEntry = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName)
...

Hello again!
Changed the form autosize to true and anchored all controls properly.
Everything is displayed correctly(labels, pictureboxes), but the button(designed to be in the bottom center of the...

I have tried different form settings and seems that the issue is solved when:
form AutoSize = True
Contents(labels, pictures, buttons) are anchored top, left (haven't used this setting yet, but it...