Topic awaiting preservation: Access headache. (Page 1 of 1)

Having a bit of a nightmare trying to use access for a computing project. Hopefully someone here will know how to do this. I have a table with four fields and two columns. I want to select the field corresponding to the value of a textbox, and update the other column in this row with a value that I will calculate. This is what I have so far:

Dim dbsSportsDay As Database

    Dim rstHouses As Recordset

    Set dbsSportsDay = CurrentDb

    Set rstHouses = dbsSportsDay.OpenRecordset("Houses")

    With rsthouses

        'huh?

    End With

    Me.Refresh

    rstHouses.Close

    Set dbsSportsDay = Nothing

I am really sorry, but I can't be of much help because Access is not on my radar. Especially now that I see a proprietary language for doing the database access. Does access support SQL? I think it should. If it allows for SQL queries I am sure I can help, but I don't know what the heck is up with the code you have there?

Access is not much of a web design forcused database from what I have been told. I am only familiar with those such as SQLServer, MySQL, or Sybase. If you have a more SQL related question I am sure it can be feilded. But I don't think you are going to get much luck here with Access based questions...

Hopefully this will bump the thread and someone might come in with some knowledge.

That code there is the horrors of Visual Basic for applications. I know it's not at all a web-based question, but maybe someone else will have gone through the pains of having to do something similar for another project... Worse is that on this A-Level (that will only mean something to people in the UK) course I've never learnt anything about SQL.

Ok Acces supports sql
so try something like this
"
SELECT * from Table where collum1 = textfield

colum2 = new data

update
"

visite my Blackbrain