Search results

  1. V

    Store Videos?

    Hello, I am developing a Online Video Purchase System using Microsoft.Net(VB). The backend database is MS Access. The application has the abilty to store and retrieve video files. I am very knew to the Access databases and would like to know on how to go around this. Any thoughts...
  2. V

    Update Records

    Hello All, i have a form which has a ComboBox for years(Integer), the user gets to select a year and the selected year gets updated on to a table. The problem is however that the year appears as small square boxes in the records. I am new to Ms Access environment and any help would be...
  3. V

    Period to Period

    Hello All, I have a table called Central_Currency which has got the following fields Product: Text Price : Number Currency : Text Dollar_Equal: Number Region : Text Month : Text Year : Number I have designed a form with combo boxes for the Product, Region, Month and Year. I have...
  4. V

    Help

    Hello, I have got a table called Central_Currency which has around 10 fields. Now among the 10 fields 2 are the Month and the Year. I want to know how i would be able to display all the 10 fields from a particualr year and month to another particular year and month. The users get to...
  5. V

    Open Workbook

    Hi all, well i am tryin to write 6 reports into 1 excel workbook with 6 different tabs, i have written this particualr code to function at a button click Dim strExcelFile As String Dim strWorksheet, strWorksheet1, strWorksheet2, strWorksheet3, strWorksheet4, strWorsheet5 As String Dim...
  6. V

    Frames

    hai, i have a form which has a Microsot Forms 2.0 Frame called Frame3. The Frame3 has got a textbox. I am new to the Access enviroment. Well my question is simple. i want to reference the textbox in the VB Editor. For eg when i call the TextBox say textBox1 like "TextBox1.Text" its not...
  7. V

    Open Workbook

    Hello, i would like to know the VBA code for opening the following excel workbook. C:\Book.xls Any help would be appreciated Cheers, Vineeth
  8. V

    Access VBA Help

    Hello, i am new to working in access enviroment, well i wanted to get aquainted with the controls. Well i have a from which has 1 Combobox, 1 Button and 1 Textbox Well i want to write a select statement in the VBA editor and would like to display the answer in a textbox. A sample of the...
  9. 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...
  10. 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
  11. 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...
  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!!

    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...
  14. 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...
Top Bottom