Search results

  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

    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';"
  3. 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...
  4. U

    Access form not accepting values.

    Hello, I am new to access. I have designed a little form, attached to sql database. When i open the form in form view, it shows the last record value of the fields but doesnt allow me to enter new values in the form. Form's recordset is set to the query,data entry is 'Yes', allow aditions is...
Back
Top Bottom