Search results

I have tried to use Shell comand nad successfully achieve my targets. Now I want to add "Select Case" statements as either the file is in pdf form or jpg form. But I dont know how to extract the extension of file (from path of text box) but error is there. I have used the following code: How...

Thanks for your response. I also was in favor of not storing image into DB. In Access 2007, I found a control of inserting hyperlink. Should I use this type of thing?? I could not see any OLE controll in Form Design View! I want to add functionality into DB such that link is to be stored into...

Hello, I have got a problem and need guidance. I have developed a database for maintaining the records of invoices. I want to save the scanned copy of actual invoice along with database record. How should I do that? There can be two options; either I store the image into database directly or...

hello. I want to add you as my friend

Hi all, Thanks for valueable replies. Perhaps I did not make my requirement clear. I want that I put some buttons into tool bar, for example, when I click one of them new data entry form open. And when I pressother button, report of certain type opens. I have attatched picture of samples how it...

Hello all, I am trying to shift from access 2003 to access 2007. I want to create customized toolbar in access 2007 but can't find the way to do that. In access 2003, I usualy go to View>Toolbars>Customize options and create/modify my tool bar. But how to do it in access 2007. I have tried...

Hi all, I have got a problem in Access. I am using Access 2003 and have developed a Database for my company. Now some other user will be using this Database for data entry. I want that other users should be allowed to Insert-Update-Delete records and should not modify/alter database structure or...

Thanks BOB, I have found the way. Have a nice day...

Hi all, I have got some problem is query. I have a table "Expenses" which has many fields like ID, Code, Date, InvoiceNo, Amount, etc. Now I want a query that will take Code from user and add the amounts of that code from "Expenses" table and show it up. Taking input from user is easy but...

Your last reply has some imbiguity. It is better if you explain your problem little bit. I have supposed that you want to import one sheet into acces. As far as I know, you can import 1 sheet at a time into access. You can import any sheet from an excel file. But if you want to access fields...

Thanks a lot to both of you. I have tried both methods and they work pretty well. Thank you so much.

The best way is to link you excell sheet with your access as mentioned by llkhoutx. In this way you make changes into excel and can see them into access.:D

Hi all, I need some help in making a check on a form. The situation is that a company get invoices and these need to be maintained into a database. For that I have made a table with fields: On the bases of this table, I have designed a form having all the above fields. Now I want that if a...

Firstly I would like to thanks JohnLee for his so much valueable time and so much detailed response. All of the suggestions are worthwhile and I think it will do the trick. :) Again, thanks a lot to Lee. Now the problem is of Department wise report. I have presented very simple scenario...

Hi all, I am working on a database and want to generate reports of different types. I have a table Expenses having different fields. The requirement is that I want to generate reports Year wise, Month wise, Week wise and Department wise. This is the requirement of project. What I understand is...

Thanks Khawar I have used this method into my project. Have a nice day

Hi all, I have got a problem in subtraction of two fields. I have two tables Department & Expense. Department has Name , Budget, etc fields and Expense has all the expenses of these departments. I a query, I have joined these two tables and sum up all the expenses of Departments. Now I want...

Thanks Khawar, I have used this method and it gives me solution. Thanks again...

Hi all, Again bothering you for a very simple thing. I have a table Expenses having fields ID, InvoiceNo, Date, Expense, Approved Where Approved is a check box. I want to build a query (from Queries) such that along with other things, my query shows Total Expenses off all invoices and Total...

Thanks for Valuable guidance. I ll try to normalize my database and shall bother you again if I face some problem. Thanks again