Search results

I tried it with and without the * . Thank you again !

Thank you for replying . I have * in there.

it is ID.

error 3131 - syntax error in from clause Also attached a screen shot. Thank you so much for helping

Thank you once again .

Yes I did .

Thank you so much for taking the time to reply . However it gives me an error on the last statement CurrentDb.Execute strSQL, dbFailOnError . I wonder if I have to do some kind of variable declaration.

Did you mean the total number of columns in the lisbox ? If yes it is 22

The ID column

No ...

I am trying to write a piece of code that works on button click and deletes a selected row from the Table . Not sure how I can reference the entire row. ID is the primary key in the table . Any ideas ?

you sir are a genuis !

here it is

Also changing bound column to 2 fixed it . Thanks .

rs!EffortType = cmbEffortType This one. Also on the click event of the combox box I have a another text box being updated. Me.txtEffortCost.Value = Round((cmbEffortType.Column(1) / 220), 2)

Can i share my database with you privately ?

This is the code I am using Private Sub cmdAddRow_Click() MsgBox "Adding new row to database..." 'CurrentDb.Execute "INSERT into BR_Master([BRID], [Analyst], [Branch])VALUES (1, 'Kelly', 'PSPC');" On Error GoTo trap Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb() Set rs =...

I am assuming you are saying the keys then should be referenced in a query to pull the data ?