Recent content by Stuart Green

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