Search results

Hi I have a database in which I have number of queries/tables. Some of these queries/tables are related to each other & some of them are totally independent of each other. I am able to make individual report for every queries/tables. What I want is to combine the individual report into one...

I have an Access & Excel linked files. I have my data in Access & do some calculation in excel. The system works fine till I change the location of both the file. Whenever I shift the files to another location or another computer the linking failed. I have tried to change the path from within...

I have an Access & Excel linked files. I want to open the excel file & then close the same using macro. Actually this will refresh the data in excel sheet & return the result to Access. I have tried to use the "RunApplication" command but unable to do it. Can someone explain the procedure to do...

I have an table in MS Access in which I have got date wise sales figure for different product in three different columns (one column for date, one for the product code & the third for sales figure). I want the program to find the last "sales figure" for a particular product in the sales column...

I have an Excel sheet in which I have got date wise sales figure in ascending order(oldest to newest) in two different columns (one column for date & the second for sales figure). I want the program to find the last "sales figure" in the sales column (by going backward) which was less than...

Hi everybody I have a problem in access & am really stuck with it. I want to do some basic calculation (addition, subtraction etc..) between fields involving more than one rows. At present I am pretty comfortable writing expression in queries involving two or more columns. what I want is...

Hi I have been using MS-Access for last few months. Although it is a wonderful application, I found you need to have the knowledge of VBA to extract the full potential of the application. I tried the help file but it seems that it is written for the advanced user & not for beginners like me...

Hi I have a database in which I have one table for master_order_no & another table for sub_order_no & other details. Both the tables are linked by one-to-many relationship from master_order table to sub_order table through the master_order_no. One master_order_no can have nos of different...

Is there any way to use charts/graphs in Access-2007. I want to make some charts/graphs for my database as I used to do in Excel, but I am unable to do so. I have tried with Access help but unable to find the chart option. Any help please......?

I want to use an expression in one of my table field to limit the value that can be entered in the field. Actually I want an expression which compares the data in the mentioned field with another field in some other table & should allow only value less than or equal to the compared field & shows...

I have a database with different tables linked with each other. I have to collect data periodically from an external source. Every time I collect data I have to update/append records in each & every table which is very time consuming & invite error in the process. Is there a way so that I can...