Recent content by aurosunil

Dear Bridge Player, Yes, there was a statement in the code for the button used for opening the report which i put there while i trying some other way for the report. when i removed that it worked. Thank you very much for the help. sunil

Report is based on three tables and a querry based on two tables. I have not written any code. there is nothing in the code window. sunil

I am trying to generate a report based on two tables and a query based on these two tables. When I preview the report this query is also run and result is shown. There is no need of displaying the query results, can it be done? can any one help? sunil

Wayne, Thanks a lot. it did work. sunil

Wayne, Report heading will indicate whether it is Capital gain or Loss. Any way, thank you for the idea i will work on it and let you know. sunil

Hi every one this is very simple but i could not find the solution. There are two tables: Assets and SoldAssets I am trying to generate a report using these tables which contains two Calculating field namely Capital Gain & Capital Loss. For a particular record if CapitalGain is +ve then...

Thanks a lot Pat. Ir did work. You see i have tried it before posting my problem but some how it was not working. Any way your support has given me a moral boost as it is my first program in access. Thank You again. sunil:)

Here is the query: SELECT [Asset Categories].AssetCategory, Assets.AssetDescription, Assets.DateAcquired, Assets.AcquiredQuantity, Assets.AcquiredPrice, Departments.Department, Assets.SoldQuantity, Assets.SoldValue FROM Departments RIGHT JOIN ([Asset Categories] RIGHT JOIN Assets ON [Asset...

Hi Rob, I tried but it gives #error instead of data. however when the fields it uses are shown, it worked well. I am using MS access 2000. sunil

Hi everyone, i am facing a simple problem but too difficult for me. i am trying to devlop a assets maintenance application. i have a table named assets consisting of fields named acquiredquantity, acquiredprice, salequantity and salevalue. assets table also contains one field departmentID which...

Hi everybody, i am developing a multiuser application, i want that user must be able to update and add records to the server database but at the same time all the updated as well as newly added records be maintained in a file on the user's computer so that user can take the print out. Can any...

I am developing a postal addresses database for multiusers with MSDE on MS access 2000. i have created a access project and a table in it. Table consists of dataId(uniqueId, primary key), name, address, city, pincode, date as fields at present. Requirement: In order to avoid typing...

yes, there is one unique field. I thought making a field unique means it is set as primary key but by declaring it explicitly primary it is functioning now. Thanks a lot. It is really encouraging for a beginner like me.:)

I am a beginner in access. iam developping a multiuser application for managing postal address. i am working in ms access 2000. i created a new access project and created a simple table. but i cannot enter data into it. i created a form based on this table but there is nothing in the form in...