Search results

I have a basic report that shows sales figures for a number of years. What I would like to do is show the percentage movement up or down for a year when compared to the previous one. For example Year1 £5000 Year2 £7000 40.00% Year3 £7000 0.0% Year4 £5800 -17.1% Year5 £7000 20.68% Any...

Update queries and memo fields seems to be a common problem but despite searching I can't find a solution to my particular scenario so, here goes. In a one to many database I have a memo field in the many table. To enter data or edit data in this field, rather than let the users have direct...

I am trying to create a fixed format datafile which contains currency amounts. The problem is that the format the values have to be in "drops" the decimal point and also has to be paddded out to 11 characters. Example 102.56 978.56 126.70 should be in the file as follows 00000010256...

My report has a group header on it (ot_seq) within which is a sub report called "rpt_ot_timeandpager". This sub report gives a sum value called [sumofmoney] and I can get this to appear within my group header OK using the following in an unbound control called "reptotal". ="Total amount for...

My users have runtime only so are restricted by what they can do (the import option is not open to them). They regularly receive a lot of .csv files that have only one field in them but usually about 2,000 records and they need to be able to append the data from these to one table in access...

Not very well up on VBA but I have found in one of the many books on Access a routine that would be handy for my users whereby they can double click on a memo field ina form and bring up a bigger entry form, spell check it and then pass the data back (better than the built on zoom option). The...

I have a table with every invoice I have raised to my customers on it (160,000 records so far). Every record identifies the customer and the date of the invoice. I would like a query that returns details of the last 4 invoices raised to each customer based on the date of the invoice. So, if I...

I am enabling/making visible certain fields on a form dependant on what is input in the first field on the form. This works fine on a single form but ideally I want it to work on a continuous form and be specific to each record. At present, when I enter a value on a new record it takes the...

I have a form which records whether a customer has rendered a return to me for a specific month. On this form is a sub form where I record the details of any orders. So, for example there is a one record for customer A for month 6 with many details. I need to store on the sub form the month...

We are a small Division of about 50 users of a much larger organisation. We have been happily using Access across our network by splitting the database, having the tables in a shared network area and installing the front end on every users PC on the C drive. None of our users have the full...

I am writing a database to record the number of Health and Safety checks made in our building. There is a list of the checks to be done held in a table and at the beginning of each financial year the frequency of these checks is set. So, for example, for year 04/05 I may decide to do 5 emergency...

I have a large report of a couple of hundred pages. What I want is the first page to print on headed paper, next page on plain, next page on headed etc. etc. As an old DataEase hand I could do this by embedding a print command in the actual document layout that the printer would recognise as a...

I am trying to write a simple system where staff can apply for leave. On the table where the dates are recorded is a field to record the approval that is initially blank. The staff manager has a continuous form built around a query that looks for all the records where the approved field is null...

I might be asking too much here, but here goes. I have staff who use Access to record details about clients' accounting systems. They also often draw flowcharts of the system using Microsft visio. I would like to have a "CREATE DRAWING" button on the input form that would allow them to open a...

I have a table with client details, each client having a unique number. I want my users to be presented with a simple input form where they type a client number in (probably use a combo box). If the number already exists then I want the user to be taken to a form to modify the details, if it...

I am trying to work out the number of years since a client was contacted using the expression below in a query where [lastcontact] is a date field. contact: ((Date()-[lastcontact])/365) This works fine until I try to put a criteria on it. If I want to see all those that it has been 3 years or...

I have a form that includes a yes/no tick box (field is called [dm_wo_ind] in the code below) that is completed when a case has been finished (this is done via an update query). If the tick box is completed, then I do not want some of the fields on the record to be subsequently enabled. I have...

I have a table of orders placed by customers, each customer having their own code. A customer may have placed just one order with me or many orders. From this table I would like to produce a list that shows my customers code just once. This must be simple but so am I it would appear as I can't...

I have a continuous subform which has 2 fields on it bound to a table . These fields are [volume] and [rate] where rate is a percentage. I have a third calculated field (unbound) on the subform that mutliplies the volume by rate to give me an amount due. I have called this unbound field [due]...

I am trying to write a system to control debts my company have. There are lots of case records that may form the debt and I have these listed in a subform which has a calculating unbound box in the subform footer that shows the total debt for the customer. When we have decided to write off these...