Search results

  1. V

    Table Edit

    As i have written before, i wish to open up the table and not create a form, i want to basically not allow the users to add new redords to the table but allow them to just edit the existing. Creating a form view is not really feasible in my case.
  2. V

    Table Edit

    Thank for the reply, but i dint really get u?
  3. V

    Table Edit

    Thanks for tat quick response.well i have thought about the form display and its sounds good.Well the problem is in my case the user experience would be much better if they get the table view as in the form view the user has to scroll through the various entries which may be time consuming at...
  4. V

    Table Edit

    Hello, I use the following code to open a table called Value_UAE that has three fields, ---------***CODE****-------------- Private Sub Command1_Click() stDocName = "Value_UAE" DoCmd.OpenTable stDocName, acViewNormal, acEdit End Sub ---------***CODE****-------------- I...
  5. V

    Previous Month

    Thanks a million times mate..U have saved enormous time and really greatful for the quick response... cheers Vineeth
  6. V

    Previous Month

    hello, I need to update a current field with the Previous Month.ie a query to update column with the name of the previous month Like Jan or January etc..Any help would be highly appreciated
  7. V

    Desktop Path

    Hello ter, I am using the following code to export tables to excel sheets..Well the problem is i have to define the path for my Database file, The database file will always be on the users Desktop. I need to know hw do u define desktop path for any user...THANK YOU Private Sub...
  8. V

    Export

    Thank u once agian for the previous help, well i would like to know how to name the sheets, other than email1 email2 etc..Say i want to name them as A , B , C etcI am newbie and any help would be appreciated Thank u once agn for the support
  9. V

    Export

    Thank u SO much for tat Info...It worked..U have saved me a lot of time.. CHEERS, Vineeth Vasudevan
  10. V

    Export

    Hi, Please can u give me a little insight on this
  11. V

    Help!!

    Thank u for ur suggestions, i have done a bit of editing BR, Vineeth
  12. V

    Export

    Greetings All I wanna know if i could export 5 Tables in Access to a single Excel Workbook with 5 Sheets each for one of the tables BR, Vineeth
  13. V

    Help!!

    So please can u modify..My problem is as follows I have 2 tables FINAL_TEST and TEMP FINAL_TEST has 12 fields TEMP has 2 Fields FINAL _TEST has 32 Records TEMP has also 32 Records I want to update the 2 fields of TEMP to the Column 2 and 3 of FINAL_TEST
  14. V

    How To Make A Field The Sum Of Several Other Fields

    Oops was just trying to get a quick reply..sry if it offended you BR, Vineeth Vausdevan
  15. V

    Help!!

    I have 2 tables and i want to run an Update statement in ACCESS: ........CODE............................... UPDATE FINAL_TEST SET FINAL_TEST.Sales_Jan = ( SELECT Temp.Sales FROM Temp WHERE Temp.RowID = FINAL_TEST.RowID ), FINAL_TEST.Units_Jan = ( SELECT Temp.Units FROM Temp WHERE...
  16. V

    How To Make A Field The Sum Of Several Other Fields

    In SQL you can use Sum(Field1 + Field2) function.
  17. V

    Output Query to a TABLE

    hello, I have a Query which gives me output as 2 fields - Sales for JAN -Units for JAN I also have a TABLE by the name FINAL TEST which has fields for Sales and Units for all the 12 months. I want to insert the query result to the TABLE FINAL...
View older results
Back
Top Bottom