Skip to main content

All Questions

0 votes
1 answer
411 views

'Index 1 is either negative or above rows count.' error

I have a form with a datagridview that is connected to a access database. I am having issues to get my update button and my delete button to function properly. I can click a row in the datagridview ...
Simeon EM's user avatar
0 votes
2 answers
2k views

Update multiple hyperlinks at once in Microsoft Access

I have thousands of rows in my Microsoft Access DB and I would like to update all values in the column "Documento_Digitalizado". Values in this column are raw text that must be updated to be an ...
Adrian Danlos's user avatar
0 votes
0 answers
35 views

Issues with Access Database 2000 using Access 2016

First of all, I'm really a begginer to Access. I have basic knowledge about databases ( running on SQL mostly ), so thanks for dumbing down the answers a bit. The company I work for created a ...
A.Desert's user avatar
0 votes
2 answers
1k views

Excel VBA to Access database: Decimal number issue

I am working on a small Access DB where I add row values as 1.1, 2.1, 3.1 from an Excel file. When I update, this is getting updated as 1.0999999999, 2.0999999999,3.1000000000000001 in the Access DB. ...
Manish's user avatar
  • 213
0 votes
1 answer
1k views

SQL Update a column dependent on other two columns

I need help finding out how to properly execute an Update query that will update a column depending whether another column has the newest information. My Table looks like so: Document# | Revison# | ...
M_Varga's user avatar
  • 15