Search results

It's OK, I've had a Eureka moment and solved it using a global variable to hold the previous year's figures. I created a global variable as follows Public BetVar As Currency For every customer (group) I reset the variable to zero Private Sub GroupHeader0_Format(Cancel As Integer...

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...

Create your main form with the sub form on it in datasheet view in the normal manner. On the main form put a text box that references the sub forms unique id field in the data source so that when you select a record in the sub form, this ID appears in the text box. for example...

This article may be of some help http://www.databasejournal.com/features/msaccess/article.php/3437731/Make-Access-Command-Buttons-Work-Harder.htm

Many thanks for the suggestion .. in the end though I retired a beaten man!

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...

Because that is far too obvious! switch on the obscenity filter. Time to retire! Many thanks, I seem to have been immune to the bl**dy obvious

Well, after 2 days banging my head just had a EUREKA moment! It may not seem elegant but this works (where [grand] is the currency value) The problem has been where the last digit was a zero, so I thought lets change this. In my queery I add 0.001 to the currency value so every value ends...

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...

Thanks for the prompt reply Rich, I did see this one when trawling through but it doesn't address my problem. I have sort of got an answer by calculating a running total as follows (where grandtotal is my subreport total) Option Compare Database Dim mdblBalance As Double Private Sub...

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...

Too late!! Got drunk and the wife was not impressed with my new excuse..blame Access. But many many thanks, your solution was just the job and I would never have got there on my own.

Sorry folks, I must be out of my depth here. I have tried using TOP as per the Microsoft help and can only get 4 records... those invoices that have the top 4 invoice dates. I have 12,214 customers so am looking to get a query that gives me 48,856 records, 4 for every customer. This is the sort...

Hi Neil, sorry, this only returns any record who's date is within the top 4, ie is quite recent. I want the last 4 records for EVERY customer that I have whether the invoice date was this year, last year or 10 years ago

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...

Many thanks for the help, will try suggested route

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...