Search results

I am trying to create chart based on a query. Query is a parameter query. Parameters are set on two fields, Customer and Analysis date fields. I have set the parameters as follows [Type the name of customer] in customer field criteria and Between [Analysis date from] And [to] in Analysis date...

Dear All I am trying to create chart based on a query. Query is a parameter query. Parameters are set on two fields, Customer and Analysis date fields. I have set the parameters as follows [Type the name of customer] in customer field criteria and Between [Analysis date from] And [to] in...

You are great. It worked very well. This is very easy now because now I can make this batch file available as short cut to other users as well. Thanks a lot.

Autoeng Thank you for your reply. Follwing is the path that I am trying to put in the Target cell but the end part which is the file name doesn't display in it and when I try to put cursor to add the name it beeps, wouldn't allow. "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"...

I have understood it now but there is a little related problem. When I create short cut on desktop, the file locaiton path is too long to fit into the Target window so cannot open the databse security workgroup information file. Is there any other way aroung? Or I will have to change to...

Short cut file path too long I have understood it now but there is a little related problem. When I create short cut on desktop, the file locaiton path is too long to fit into the Target window so cannot open the databse security workgroup information file. Is there any other way aroung? Or I...

Short cut file path too long I have understood it now but there is a little related problem. When I create short cut on desktop, the file locaiton path is too long to fit into the Target window so cannot open the databse security workgroup information file. Is there any other way aroung? Or I...

Short cut file path too long I have understood it now but there is a little related problem. When I create short cut on desktop, the file locaiton path is too long to fit into the Target window so cannot open the databse security workgroup information file. Is there any other way aroung? Or I...

Colin and Fuga You are life savers. Thank you very much for your help. Following your advice I have now put all customers in one table and is easy to compare different customers. Life is much easier and my databse is less messy now. Thanks again.

I have set user lever security on my database. At the end of the wizard it automatically created a shortcut on my desktop. By clicking on this short cut it prompts for the user name and password. My question is when other users would want to use the database on there computers on the network...

Thank you for your reply. I did find the cause at last. The table where I was appending the data had a field whose 'Required' property was set to 'Yes' and the table which was being appended did not have any values in that field. It did take time but sorted at last. Thank you for your time.

Dear All I am trying to append data from one table to another. It should be simple enough. But when I run the query it says that due to 'validation rule violation' no data has been appended. I have not set any validation rules for any field and I have compared both tables for their data...

Colin and Fuga Thank you very much. You have a good point. I will try to do as you advised and let you know. Thank you

Thank you very much for your reply. I still have a little confusion Let me explain my problem in a bit detail. Three tables, each for one customer and have following fields Part No, analysis date, qty, comments. I want to run a query such a way that I can produce a report on the following...

Dear All In my database I have three main tables for three different customers, say customer 1, customer 2 and customer 3. Each table contains similar fields like part no, qty, analysis date etc. These tables at the moment are not linked together in any relationship. I want to search data for...

Confusion Hi there Thank you very much for your reply. But I am still a bit confused. Actually I am a beginner in Access. I would really appreciate if you can explain it in a bit more detail. Following your advice I created a memo field in the underlying table and put it on the form...

Dear All I am stuck at a serious problem. In my case customer sends information as text files that is accessible for us on internet. I want to get that data in my databse table. That infomation will be then used on a form to add comments. What I could think of it till now is that if I download...

Wayne Thank you for your reply again. I really appreciate your help. I may sound very thick for you here but actually I am not very good in the advanced features of MS access like writing expression and codes etc. The solution of my problem you suggested must be the right one but I am a bit...

Wayne Thank you very much for your reply. But can you please explain DMax function in a bit more detail. I will be grateful. Thank you

In my database form I have to enter data for certain number of parts in a lot. When that lot is finished I have to start again from number 1. I have to assign a serial number to each part. I want in a field the next higher number to appear as default when I move to new record. I already have...