Search results

Thank you very much for your reply. I want to display both data and chart on same report because the chart is based on same data.

I have a report which is based on a crosstab query. On the same report there is a chart based on a select query. Both displays a date field monthwise like Apr-03, May-03 etc. Chart updates the data automatically but the data based on crosstab query does not update automatically. I have to...

Try this Try this on your report Add an unbound text box set control source in properties to =1 set Running Sum to overall

query explained Thank you for your reply. I try to explain my question here. I have got a main table with a field name REF NO whose property is set to hyperlink. Then there is a form based on this table. Whenever a customer sends us some feedback through email, it is sometimes as an attached...

In a table I have got a hyperlink field. I want to search data related to data in hyperlink field. For example I have put 3456w in hyperlin field and when I run query by putting the same number in criteria, it does not fetch anything. Is there a different way to retreive data from hyperlink...

Thank you Thank you very much for your reply. There is a lot of information following the link you provided in your reply. I hope I would be able to find the solution of my problem from there. Thanks again.

I have set user level security on my database. There are three more users and everyone uses their password to open the database. The problem I noticed the other day is that if you know the location of the actual databse on network. You can click on it directly and it would open, no need for...

Thanks Casey Thank you very much for your reply. When I looked at the fileds again there was a field that could be used as a reference to change coulours of that field. I wasn't sure how to use Expression in condition sentence, but with your help I have managed to do it now. Thank you...

On a report there is a text box customers. I want certain customers to be printed in one colour and otheres in a different colour. Say I have 4 customers A,B,C,D to show in red and the rest in blue. I have tried to set in conditional formating but it only works for one customer at a time and...

Thanks Thank you very much guys. I really appreciate. The links on your replies took me right on the spot. This is what I am looking for. I am not good with VB codes, but am sure I can manage it. Thanks again.

In my database users download certain text files stored in a separate folder on a network drive. I have managed it to work so that by clicking a command button, it prompts with concerned folder location path and you have to type in the exact name of file with extension .txt at the end and it...

Dear All On one of my reports I have got column charts based on a query. Report is also based on the same query. On the chart there is field ‘Faults’ on x-axis and ‘Qty’ on y-axis. The Qty field in underlying table is set to ‘1’ as default. So in chart it sums up Qty values. At the moment...

Thank you for your reply. I was away for some days that is why it took that long to respond. I could not workout how you group by month and year in one column but anyway the problem has been solved. I thought I should let you know as well. When I was changing the date format in already...

Dear All I have a crosstab query. In it there is one field for Analysis date that has been set to group by months. The query is linked to a report. Analysis date ranges over 2-3 years. But when I get data of report, it presents the dates as Jan, Feb, Mar etc. and presents all data say for...

Thank you very much Jack Thank you very much for your help. I have tried it and it worked just like the way I wanted. You were right ID field was not there on form. Thank you very much for your time and valuable help. Mansoor ;) :)

I think a little more help needed Thank you very much for you help again. It is still not working as I wanted. I cannot understand where I am doing wrong? I have created a report (Report1) base on the same query on which the form is based on. On OnClick event procedure of a command button I...

I have a MS database with user lever security in place. There are two users in users group and two in Admin group. But there seems to be something wrong with it. If two users (one admin and other user) are entering data at the same time at different machines, after some time when user go to new...

A little more help Thank you very much for your help. I have tried to do it as you suggested but because I am not very good in using codes so actually could not exactly work it out. I used this code in OneClick event of command button. It did print the report but just column headings, no data...

Dear All On my form I want to add a button that when clicked would print the current record on form in a report format not in form view format. So that I can choose which fields to print for that record. How can I do it? Thanks

In my database, there is user lever security in place. There are two other users belonging to users group with restricted permissions. We have starting using our database on trial and are having problems. When a user is inputing data as well, after some time database form where the usere is...