Search results

Hi, I have a field in a form linked to a table called "Chase", I would like to click a button and the field would increase by 1, however I cannot work out how to do something as simple as this. I am looking for something like: Me.Chase = Me.Chase + 1 Malcolm

Hi, thanks again for that - the second one worked. I did try the first one but it seemed to struggle with the decimal place and pennies.

I've tried this for format but I just don't seem to be working out the right code for it just now, not sure what I am missing, please can you have a look? Thank you =[NewName] & ": " & Sum(Format([Total],"£#,###.##"))

Hi, Please can you help me to change the following on my report to show the total as currency. It is in the control source and I am trying to make it show as part of a sentence. =[NewName] & " (£" & Sum(([Total])) & ")" Also, if possible the following as ddd d mmm yyyy, h:mm am/pm =Date() &...

Hey June7, This is true, however the problem I have with reports is that I run my front ends with the background hidden so my option was only ever to print reports, until tonight - I have found the idea and code to maximise the background whilst I view a report then hide it again when the...

As I can't use headings on a form, can you (or anyone) think of a way that I could show my data on a form where I have only 1 date 'heading' in the left column and then the other parts of the data listed in the other columns, similar to my picture example below? Thank you

Hi, Thanks for that, that will be why I have been trying all day and cannot work it out!! Malcolm

Hi, I have a form which I would like to add sub headings to, so I suppose it would maybe be a continuous form? I would like to lay it out in the same way I can do this with a report, I have attached an example with sample data, on the report I have made dates as a sub heading in this example...

Hi, I cannot find your example using the download link on your link, I'm assuming that it is somewhere on the Microsoft website?

Hi theDBguy, I think I may have done it with a staging query before. Do you have any example of how I would do this using VBA please?

Hi, I have a database which I am looking to use a crosstab query which will populate the data for a report. The report data (column headings) will be products and dates which the user can select from a form, so the column headings will change depending upon the date range selected (max 7). I...

Thank you for all your help, this has helped my problem, I didn't know that Desc was a reserved word - every day is a school day! Malcolm

Hi, I keep looking at this an cannot work it out, I have used code which I use in another database to do something similar, however I cannot get it to work, please could someone be so kind to look at this for me and put me out of my misery. Many thanks, Malcolm

Hi, I have a table called PLUs, I need to update the value of the field called Desc from an unbound field on a form. I am trying the following line of code and cannot see what is wrong with it, please can you help? <DoCmd.RunSQL "UPDATE PLUs SET Desc = Forms.EPOSControl.Starter1Description...

Hi, Thank you all for your suggestions, I have cracked it now

It would be 2 different strings really, so something like For Field 1 =LEFT(13),DLookUp("Caption","PLUCaption","Code='1318'") For Field 1 =RIGHT(13),DLookUp("Caption","PLUCaption","Code='1318'") If it helps I have 1 field (always 26 characters) which says "Pint of Lager ", I want...

Hi, Please can you help me find a way to display the left (or first) 13 characters of a field and also the right 13 characters in the same field as I need to display them separately in 2 different fields on a form. Below is what I have but cannot work out how to integrate left and right in to...

Thank you all for your suggestions, but thank you Arnelgp for your answer, this is what I was looking for. Very much appreciated!! Malcolm

Hi All, Thank you for your suggestions, but I am still struggling with this one, I have uploaded a demo database, could someone please be kind enough to have a look at this for me and put me out of my misery!! On the demo database, I have tried all sorts of formula's and still cannot get it to...

Hi, I'm trying to calculate the VAT Value and Net Value from Gross Value and VAT Rate in a query, however I cannot work out how to do this. I have a query which is going to update and transfer a table from MS Access 2007 to MS Access 2016 once I have worked out the VAT and Net Totals. I have...