Recent content by vvasudev

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...

Hi all, has someone got any insights on this one?..any help would be appreciated regards, Vineeth

I have modified the query like this but it doesnt seem to work if i put 01.01.2009 and 01.01.2010

Do u have any thought on the other post i have Put??

The problem was that i had a query with 3 empty fields, 1 each for year, month and distributor. Later i convert this query to a table by means of make table query. And then i update the 3 empty fields using an update query. Well the problem was that the Year field was getting a data type...

Hi, thank you for ur reponse, i have managed to solve it, appreciate ur help

Hi, i have put in the following code, but the between operator doesnt seem to do the trick any thoughts? regards, Vineeth

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...

Many thanks Brian, i have managed to figure it out as per ur directions..Cheers

Hi Brian, Thank you for your quick reponse,Cdate function seems to work but, can u tell me how to incorporate it into the query that i have written. sory for the delayed reply, thank you also to namliam

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...

hello all, I am using this but it doesnot seem to HELP..any thoughts??

Many thanks for the quick reponses..really appreciate the 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...

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...