Recent content by usr123

  1. U

    Sql query not showing all the values

    Hello, i am working with Access forms, and on the form i am adding record in the sql server. Problem: Sql query doesnt show all the values for the columns. My query has got 32 columns where as values it shows are up to 4-5 columns. Is there any limit on ho wmany columns you could use in Sql...
  2. U

    How to create updatable query

    Thanks for ur reply. Error i was gettin not because of PK(i did set PK in the sql table and reconnected it to the Access), it was because i wasn't using 'dbseechanges' while i was pulling the data from Sql and was tring to do 'db.execute' rather than doing docmd.runsql. Anyways its working fine...
  3. U

    How to create updatable query

    Here is something else, My identity key in the table wasn't a primary key.I changed it to Primary key,now its giving me the error '3622': You must use the dbSeeChangesoption with Openrecordset when accessing a sql server table that has an identity column.
  4. U

    How to create updatable query

    I am using ODBC connection.I have set ODBC through system DSN.
  5. U

    How to create updatable query

    I did,deleted the old link and created a new one.Error is still there.
  6. U

    How to create updatable query

    Hello, I have changed the permission of the account to 'Read,write,dbowner.' But error is still there. What else should i check?
  7. U

    How to create updatable query

    In datasheet view,it says recordset is not updatable.
  8. U

    How to create updatable query

    You are right, i cant edit a table whne i open it in access. How can i do that?
  9. U

    How to create updatable query

    My new query: "Update dbo_fin_ldg set ldg_Year = 2010, Month_Name = 'Feb',ldg_Month = 02,Product = '',Category = 'Gear',Customer = '',Actual_Volume = 12,Budget_Volume = 1245 Where ID = 2488;" Any ideas plz....
  10. U

    How to create updatable query

    Thanks for your reply. Year and Month are the column fileds in the database(Sql). Do you want me to chnage these names in the sql table? Also removed the quotes from ID, same error. Error 3073, Operation must use an updatable query.
  11. U

    How to create updatable query

    How can i make a query updatable? "Update dbo_fin_ldg set Year = 2010, Month_Name = 'Feb',Month = 02,Product = '',Category = 'Gear',Customer = '',Actual_Volume = 12,Budget_Volume = 1245 Where ID = '2488';"
  12. U

    Go to previous record

    figured it out, it was my database connection which was not reflecting the current database. Above code works just fine.
  13. U

    Go to previous record

    Here is another problem or apart of the previous one: Filed value i am trying to select is identity. It works fine if i say "Select * from table." But i want to select the last record in the table and for that i need Max(ID), if i get Max(ID) then i can pull the whole record. Can anybody...
  14. U

    Go to previous record

    This is what i am doing. When pointer reaches to the highlighted line, it comes up with the error: Run tim error:3061. Too few parameters, expected '1' Any ideas on how to resolve it. Dim db As Database Dim rs As Recordset Dim strSQL As String Set db = CurrentDb()...
  15. U

    Go to previous record

    Hello, I am working with access front end. I have got a form connected to Sql,it saves data in the database. Now i would like to pull data back from the database. There are a few buttons on the form,like previous,next,first and last. If form is empty and user click on previous button,then it...
Back
Top Bottom