Search:

Can you elaborate on what you mean with the "push (publish) the install to a network drive"? I'm wondering if the way I had this originally working was just a fluke.

From my recollection, I placed...

6 to one, half a dozen to another. No need to sound so condescending, apparently you knew what I meant.

Im not sure if this is a universal issue with installing software to a network drive, but...

I'm currently using VS 2015 and my codes all vb.net. A little backstory - I installed the software on a network drive for use on 2 virtual computers a while back, and everything has been working...

Looks like that solved my issue. The computers that were effected were the ones that had 64 bit OS with 64 bit Office. With the configuration set as "ANY", the program ran flawlessly on 64 bit...

I will try that this morning and will post back with the results. Hopefully it is an easy fix like this.

Looking in the settings now, I am setup to run as "ANY CPU". Is that not a good practice to...

How do I determine which ACE is installed? The computer has 64 bit office but both tablets have 32 bit office.

As the title states, I'm getting the error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" in an application that I created in VB.net for use on several different...

I could never find out why, but the original code would only query once without reloading the entire form.

By adding that line to clear the table each time, that allowed the query to be done as...

I got it to work by adding dt.Rows.Clear() to the beginning of the code for the search button. All squared away now

Looking for an opinion - I am only able to "filter" the results once since the parameters.add is in the Load event of the form. What would you recommend as an event to use that I could add that same...

That was it! Funny, when I was looking earlier, I thought I did see an extra + sign, and then I couldn't find it again, so I thought I was just seeing things (it's been a hectic morning so far).
...

Neither one of these worked for me either, I am still getting an error : An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information:...

Sounds good, I do appreciate the input. I haven't got this working 100% yet, as I'm stuck at one small part after adding the parameters in there. I can't figure out how to properly write my SQL...

As the title states, I am having an issue updating my Access table via Datagridview. I Have the select clause "filtering" the results based on values from a combobox, and then would like to update...

That sounds good, thanks for pointing that out. I will definitely add that in there to play it safe.

Removing the "- 1" and changing it to "- 2" gets rid of the error message popping up. I assume this is from the fact that as soon as you start typing the first bit of data in, a new blank line is...

Only one row of data was there at that time

UPDATE:

I moved back to the original full code and values are being entered into the database as they should, but I am still getting the error for whatever reason.

While technically it *is...

If I am checking this properly, it appears as if it is:

DataGridView1.Rows(x).Cells(Item).Value = Nothing
DataGridView1.RowCount = 2
x = 1


If I leave the try catch in there and add a...

Unless you're talking about hovering over it in the code?

If so, DefaultNewRowValue = Nothing and Value = Nothing

It closes the whole app down when it gives the error once I remove the try/catch.

I did do some console.writelines earlier and it was pulling the proper values out of those 2 locations just as I...

When simplifying this code down even more (to now only use the DGV) to try to rule out where the issue is, I get a different error now - "Parameter @Item has no default value"

The code now is :
...

If I use the same code on a different form, which only allows one record to be entered at a time, the code runs flawlessly and adds records to the database as it should (the only other difference...

Even after pulling those add parameters out of the loop, I still get the "Data type mismatch in criteria expression". It doesn't point to a specific line, but I must assume it is due to those two...

Sorry to keep asking so many questions, but I just cant seem to get this to work right.

If I run the code:



For x = 0 To DataGridView1.RowCount - 1

...

I've had the chance to try this out, and am getting a couple errors.

First of all -
For Each dr As DataRow In DataGridView1

Im getting an error pointing towards DataGridView1 which states...

The only reason I thought I needed it within the loop was so that it would apply that same bit of data to every row that was added from the datagridview. If I do it separate, would it still add the...

All data in the datagridview will be manually entered by hand, so it sounds to me as if the first example is the one that I want - it is an unbound datagridview.

Would it work for me to add the...

Sounds good, I should be able to figure out the looping of the textbox items, but the datagridview is something that's relatively new to me. Is there an example you could provide for pulling the data...

I've got an issue that I can't seem to work out the best way to do this. I've got a form with textboxes along with a datagridview for users to enter data into - I need to enter multiple rows of data...

Perfect, that worked like a charm and it's now doing exactly as I hoped. Being that I had been messing with the EditMode's prior to posting this thread, and then you said that it can be edited...

Can you provide an example of what the validate code should look like? I tried browsing through the link you supplied but not sure what to do; Ive never used the validate statement before in this...

So it sounds to me as if this is just how the system is built then? And no way to actually update the row solely by pressing my "Update" button (without leaving the row first)?

I also tried...

I originally had some issues trying to get my code to work, but got it "working" and am now running into another issue. In a gist, I'm using datagridview to display results from an Access table which...

Everythings working like a charm now. Thanks for the input and advice from everyone.

I changed the way the data was being pulled, from using an access bult query to actually querying the data from within the code, and have gotten it to work now.

Being that I am not using a query...

I am getting the error "An unhandled exception of type 'System.InvalidOperationException' occurred in System.Data.dll

Additional information: Update requires a valid UpdateCommand when passed...

As the title states, I am trying to edit my table in Access via DataGridView in the application that I am creating and seem to be having issues.

I have established the connection and can view my...

Sounds good, I overlooked your post previously. I will try to change my DPI to 100% and make the necessary changes, along with following the tips in the link you posted. Hopefully switching to 100%...

My computer is set to 125%, and the computer with the issue was at 100%, but changing the computer with the issue to 125% did not correct the issue. Both computers indeed do have the same resolution